select ifh_location.*,ifh_location_translation.name,ifh_location_translation.description,ifh_location_translation.body,ifh_location_translation.id as dtranslationid from ifh_location inner join ifh_location_translation on ifh_location.id=ifh_location_translation.locationid where ispublished='1' AND langid='2' order by displayorder ASC