SELECT SQL_CACHE DISTINCT p.*, 
		 b.name as building_name, 
		c.name as city_name, 
		b.short_name as building_address,
		h.name as hall_name,			
		month(p.eventdate) as mm,
		day(p.eventdate) as dd,
		ETicketEnabled,
		year(p.eventdate) as yy,	
		p.eventdate as date,
		OrganizerId,
		 pd.name AS name, p.image, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) 
		 inner join city c on p.cityid = c.city_id 
		left join hall h on p.hallid = h.hall_id
		inner join building b on b.building_id = p.buildingid
		 WHERE p.product_id = '100484751'