183 0.0010991096496582 234 0.001121997833252 263 0.0011379718780518 321 0.0011389255523682 382 0.001147985458374 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 15390, 30 391 0.21151900291443 432 0.21152806282043 444 0.21153712272644 Люстри оптом та в роздріб - Магазин освітлення Діаша
