SELECT n.*, npr.name as parname, npr.small as parsmall, npr.mid as parmid, npr.org as parorg, npr.full as parfull from ins_names_parent as np
                                                     left join ins_names as n on np.nameid = n.id
                                                     left join ins_names_prop as npr on n.propid = npr.id
                                                     WHERE np.parent = 26587 AND type = 'exgood'
                                                     order by npr.ordering ASC, n.ordering asc

/var/www/ochag-shop.ru/lib/names.php:26
/var/www/ochag-shop.ru/component/ex/ex.php:315
/var/www/ochag-shop.ru/component/ex/ex.php:68
/var/www/ochag-shop.ru/component/ex/ex.php:36
/var/www/ochag-shop.ru/icore.php:209
/var/www/ochag-shop.ru/theme/index/index.php:75
/var/www/ochag-shop.ru/index.php:261

SELECT    exgood.id               	as exgood_id,
						exgood.name             	as exgood_name,
						exgood.sefname          	as exgood_sefname,
						exgood.sefnamefullcat   	as exgood_sefnamefullcat,
						exgood.sdesc            	as exgood_sdesc,
						exgood.fdesc            	as exgood_fdesc,
						exgood.small            	as exgood_small,
						exgood.mid	            	as exgood_mid,
						exgood.org              	as exgood_org,
						exgood.innerID              as exgood_innerID,

						exgood.expack_select_type   as exgood_expack_select_type,
						exgood.expack_set       	as exgood_expack_set,

						expack.id               	as expack_id,
						expack.name             	as expack_name,
						expack.sku              	as expack_sku,

						exprice.val        			as exprice_val,
						exprice.cy         			as exprice_cy
					 FROM ins_exgood as exgood
				  INNER JOIN ins_exrecommended as exrecommended ON ( exrecommended.parent = 26587 AND exrecommended.recommended=exgood.id  )
				  LEFT  JOIN ins_expack as expack ON (expack.parent = exgood.id)
				  LEFT  JOIN ins_exprice_good as exprice ON (  exprice.parent = 1  AND  expack.id = exprice.expack  )
				  GROUP BY(exgood.id)

/var/www/ochag-shop.ru/idb.php:496
/var/www/ochag-shop.ru/i24.php:131
/var/www/ochag-shop.ru/component/ex/ex.php:359
/var/www/ochag-shop.ru/component/ex/ex.php:68
/var/www/ochag-shop.ru/component/ex/ex.php:36
/var/www/ochag-shop.ru/icore.php:209
/var/www/ochag-shop.ru/theme/index/index.php:75
/var/www/ochag-shop.ru/index.php:261

SELECT a.id, a.name, a.sefname, a.sefnamefullcat, a.mid, a.innerID, b.id as expack_id, b.name as expack_name, c.val as price, d.val as sklad  FROM ins_exgood as a
			inner join ins_expack b ON (b.parent = a.id)
			inner join ins_exprice_good c ON (c.parent = 1 AND b.id = c.expack)
			inner join ins_exsklad_good d ON (d.parent = 1 AND b.id = d.expack)
			WHERE a.parent = 11933 AND a.publish = 1 ORDER BY rand() LIMIT 0, 6

/var/www/ochag-shop.ru/idb.php:496
/var/www/ochag-shop.ru/i24.php:131
/var/www/ochag-shop.ru/component/ex/ex_html.php:240
/var/www/ochag-shop.ru/component/ex/ex_html.php:15
/var/www/ochag-shop.ru/component/ex/ex.php:383
/var/www/ochag-shop.ru/component/ex/ex.php:68
/var/www/ochag-shop.ru/component/ex/ex.php:36
/var/www/ochag-shop.ru/icore.php:209
/var/www/ochag-shop.ru/theme/index/index.php:75
/var/www/ochag-shop.ru/index.php:261 Керосин осветительный 5,0л (1)