Hello, can you tell me the tourist attraction id for the photo name "game1"?
select t2.tourist_attraction_id from photos as t1 join tourist_attractions as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id where t1.name = "game1"
Can you tell me the name for this attraction as well?
select t2.name from photos as t1 join tourist_attractions as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id where t1.name = "game1"
How about how to get there?
select t2.how_to_get_there from photos as t1 join tourist_attractions as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id where t1.name = "game1"
I need the opening hours as well please.
select t2.opening_hours from photos as t1 join tourist_attractions as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id where t1.name = "game1"
What about the other details?
select t2.other_details from photos as t1 join tourist_attractions as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id where t1.name = "game1"