SELECT 
				itm.*, 
				gds.gds_code,
				gds.gds_name,
				concat(
				   IF(ctl_1.ctl_url IS NULL, '', concat(ctl_1.ctl_url, '/')),
				   IF(ctl_2.ctl_url IS NULL, '', concat(ctl_2.ctl_url, '/')),
				   gds.gds_id
				) as href
			FROM 
				item itm
				LEFT JOIN goods gds ON gds.gds_id = itm.gds_id
				LEFT JOIN catalog ctl_2 ON ctl_2.ctl_id = gds.ctl_id
				LEFT JOIN catalog ctl_1 ON ctl_1.ctl_id = ctl_2.ctl_parent
			WHERE 
				itm.ord_id = 383425746  
			ORDER BY 
				gds_code