Warning: Undefined variable $name in /sites/horeca.lighting/req/funcShopCat.req on line 42
Warning: Undefined array key "page_start" in /sites/horeca.lighting/req/funcShopCat.req on line 44
Array
(
[nav] => Array
(
[0] => 1
[1] => popz
[2] => vse
)
[url] => https://horeca.lighting/ugoda/
[mode] => cat
[filter_val] => Array
(
[1] => 80
[2] => Array
(
[st] => 200
[en] => 500
)
[3] => Array
(
[st] => 120
[en] => 240
)
[14] => Array
(
[0] => пульт
[1] => диммер
)
[49] => 1
)
)
SELECT SQL_CALC_FOUND_ROWS `gs_tovar`.`link1`,`gs_tovar`.`link2`,`gs_tovar`.`name`,`gs_tovar`.`group`, `gs_tovar_nal`.`kolvo` AS `nalichie`,`gs_tovar`.`code`,`gs_tovar`.`cenamin`,`gs_tovar`.`cenaold`,`gs_tovar`.`krozn`,`gs_tovar`.`nalichie` AS `minkolvo`, `gs_tovar`.`cena`, `gs_tovar`.`video`, REPLACE(`gs_tovar_nal`.`art`,'R-','') AS `art` FROM `gs_tovar`, `gs_tovar_nal` WHERE `gs_tovar`.`code`=`gs_tovar_nal`.`code` AND `show` IN (1,2,3,4,5) AND `group` LIKE '%ugoda%' GROUP BY `gs_tovar`.`code` ORDER BY `gs_tovar_nal`.`nal` DESC, `gs_tovar`.`pop` DESC LIMIT 0 , 30 Люстри оптом та в роздріб - Магазин освітлення Діаша 
cat