SELECT pack.id as expack, pack.name as name, price.val as price, sklad.val as sklad, attrib.val as attr_val, sv.attrib_val as attrib_val, sv.attrib as main_attr FROM `mnv_expack` as pack 
			INNER JOIN `mnv_exprice_good` as price ON (price.expack = pack.id)
			INNER JOIN `mnv_exsklad_good` as sklad ON (sklad.expack = pack.id)
			INNER JOIN `mnv_expack_set_val` as sv ON (sv.attrib = main_attr(pack.id) AND pack_id = pack.id)
			INNER JOIN `mnv_expack_attrib_val` as attrib ON (attrib.id = sv.attrib_val)
			WHERE pack.parent = 127 AND price.parent = 1 AND price.val > 0 AND sklad.parent = 1 GROUP BY pack.id ORDER BY price.val ASC, sv.attrib_val, pack.name

/home/sibbear/web/boombearsport.ru/public_html/idb.php:496
/home/sibbear/web/boombearsport.ru/public_html/i24.php:131
/home/sibbear/web/boombearsport.ru/public_html/lib/catalog.php:546
/home/sibbear/web/boombearsport.ru/public_html/component/ex/ex_html.php:187
/home/sibbear/web/boombearsport.ru/public_html/component/ex/ex_html.php:15
/home/sibbear/web/boombearsport.ru/public_html/component/ex/ex.php:227
/home/sibbear/web/boombearsport.ru/public_html/component/ex/ex.php:68
/home/sibbear/web/boombearsport.ru/public_html/component/ex/ex.php:36
/home/sibbear/web/boombearsport.ru/public_html/icore.php:196
/home/sibbear/web/boombearsport.ru/public_html/theme/index/index.php:28
/home/sibbear/web/boombearsport.ru/public_html/index.php:188