Advertisement
hellsgate

Duplicate arealayouts query

Dec 23rd, 2013
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.56 KB | None | 0 0
  1. SELECT `venue_arealayout`.`id`, `venue_arealayout`.`name`, `venue_arealayout`.`description`, `venue_arealayout`.`area_id`, `venue_arealayout`.`additional_notes`
  2. FROM `venue_arealayout`
  3. INNER JOIN `venue_area` ON (`venue_arealayout`.`area_id` = `venue_area`.`id`)
  4. INNER JOIN `venue_venue` ON (`venue_area`.`venue_id` = `venue_venue`.`id`)
  5. INNER JOIN `venue_venue_venue_type` ON (`venue_venue`.`id` = `venue_venue_venue_type`.`venue_id`)
  6. INNER JOIN `venue_venuetype` ON (`venue_venue_venue_type`.`venuetype_id` = `venue_venuetype`.`id`)
  7. WHERE (`venue_arealayout`.`id` = 66 )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement