183 0.0013070106506348 234 0.0013260841369629 263 0.001338005065918 321 0.0013389587402344 382 0.0013449192047119 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`.`nalichie`,`gs_tovar`.`krozn`,`gs_tovar`.`cenaold`, `gs_tovar`.`nalichie` 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 15660, 30 391 0.21540594100952 432 0.21541500091553 444 0.21542596817017 Люстри оптом та в роздріб - Магазин освітлення Діаша
