183 0.010232925415039 234 0.010280847549438 263 0.010313987731934 321 0.01031494140625 382 0.010323047637939 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 '%led%')
AND `gs_tovar`.`show` IN (1,2,3,4,5)
GROUP BY gs_tovar.code
ORDER BY `gs_tovar_nal`.`nal` DESC, gs_import.price_uah ASC
LIMIT 6840, 30 391 0.28653502464294 432 0.2865469455719 444 0.28655886650085 Led. Люстри оптом та в роздріб - Магазин освітлення Діаша
