ул.Маерчака, 65, строение 22
0.00 руб.
0
В корзине пусто
0.00 руб.
0
В корзине пусто
8 (391) 2-911-700
ул.Маерчака, 65, строение 22
SELECT a.*, b.name as expack_name, b.id as expack_id, b.sku as expack_sku, c.cy as exprice_cy, c.val as exprice_val, s.val as sklad_val, IF(c.val > 0, 1, 0) as exist_price FROM pik_exgood a
		inner join pik_expack b ON (b.parent = a.id)
		inner join pik_exprice_good c ON (c.parent = 1 AND b.id = c.expack)
		inner join pik_exsklad_good s ON (s.parent = 1 AND b.id = s.expack)
		
		where a.publish = 1 and (a.region = 'krs' or a.region = '') and a.parent in (71, 83, 90, 99, 109, 124, 131, 140, 147, 239, 72, 73, 74, 76, 77, 78, 79, 80, 81, 82, 240, 241, 242, 243, 84, 85, 86, 88, 89, 264, 265, 91, 92, 94, 95, 96, 97, 98, 266, 100, 102, 103, 104, 105, 106, 107, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 308, 310, 126, 127, 128, 129, 130, 267, 133, 134, 135, 136, 137, 138, 139, 238, 284, 141, 142, 143, 144, 145, 146, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 70) AND `publish1` = 1
		group by a.id order by exist_price DESC, s.val DESC, a.name asc
LIMIT -60, 60

/home/www/z86227/htdocs/idb.php:496
/home/www/z86227/htdocs/i24.php:131
/home/www/z86227/htdocs/component/ex/ex.php:395
/home/www/z86227/htdocs/component/ex/ex.php:72
/home/www/z86227/htdocs/component/ex/ex.php:36
/home/www/z86227/htdocs/icore.php:196
/home/www/z86227/htdocs/theme/index/index.php:173
/home/www/z86227/htdocs/index.php:443
Отображать по: