183 0.0014710426330566 234 0.0015051364898682 263 0.0015270709991455 321 0.0015280246734619 382 0.001539945602417 SELECT SQL_CALC_FOUND_ROWS gs_tovar.code AS `code_out`, gs_import.price_uah,`gs_tovar`.`name`,`gs_tovar`.`cenamin`,`gs_tovar`.`cena`,`gs_tovar_nal`.`nal` AS `nalichie`,`gs_tovar`.`krozn`,`gs_tovar`.`cenaold`, `gs_tovar_nal`.`nal` AS `minkolvo`
FROM gs_tovar
JOIN gs_import_sootvetstvie ON gs_tovar.code = gs_import_sootvetstvie.code AND gs_import_sootvetstvie.onphotonew = 1
JOIN gs_import ON gs_import_sootvetstvie.imcode = gs_import.imcode
JOIN `gs_tovar_nal` ON `gs_tovar`.`code`=`gs_tovar_nal`.`code`
WHERE gs_tovar.code IN (SELECT DISTINCT gs_import_sootvetstvie.code
FROM gs_import_sootvetstvie
JOIN gs_tovar ON gs_import_sootvetstvie.code = gs_tovar.code
JOIN gs_import ON gs_import_sootvetstvie.imcode = gs_import.imcode
WHERE gs_tovar.group LIKE '%Новинки%')
AND `gs_tovar`.`show` IN (1,2,3,4,5)
GROUP BY gs_tovar.code
ORDER BY `gs_tovar_nal`.`nal` DESC, gs_tovar.pop DESC
LIMIT 7890, 30 391 0.22734403610229 432 0.22735810279846 444 0.22737002372742 Люстри оптом та в роздріб - Магазин освітлення Діаша
