183 0.00034594535827637 234 0.00036001205444336 263 0.00037312507629395 321 0.00037503242492676 382 0.0003819465637207 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 6900, 30 391 0.14903116226196 432 0.14903903007507 444 0.14904808998108 Люстри оптом та в роздріб - Магазин освітлення Діаша
