「Sandbox」を編集中

{{#cargo_query:
tables=Festivals
|fields=name,start_date
}}

{{#cargo_query:
tables=_pageData
|fields=_pageName
|limit=5
}}

== FestivalAreas JOINテスト ==

{{#cargo_query:
tables=FestivalAreas=FA,Festivals=F
|join on=FA.festival_id=F.festival_id
|fields=FA.area_id,F._pageName,F.name,F.start_date,F.end_date,F.festival_type,FA.relation_type
|where=FA.area_id=27100
|format=table
}}

{{#cargo_query:
tables=FestivalAreas=FA,Festivals=F
|join on=FA.festival_id=F.festival_id
|fields=FA.area_id,F._pageName,F.name,F.start_date,F.end_date,F.festival_type,FA.relation_type
|where=FA.area_id=27
|format=table
}}

== FestivalArea → Area JOINテスト ==

{{#cargo_query:
tables=FestivalAreas=FA,Areas=A
|join on=FA.area_id=A.area_id
|fields=FA.festival_id,A._pageName,A.name,A.area_type,FA.relation_type,FA.sort_order
|where=FA.festival_id=1
|order by=FA.sort_order ASC
|format=table
}}

{{#cargo_query:
tables=FestivalVenues=FV,Venues=V,Areas=A
|join on=FV.venue_id=V.venue_id,V.area_id=A.area_id
|fields=FV.relation_type=relation_type,V._pageName=venue_page,V.name=venue_name,A.name=area_name
|where=FV.festival_id=1
|format=table
}}

== 天神祭2026 屋台マップテスト ==

{{#display_map:
{{#cargo_query:
tables=FestivalStallPlacements=P,Stalls=S,Venues=V
|join on=P.stall_id=S.stall_id,P.venue_id=V.venue_id
|fields=P.latitude=latitude,P.longitude=longitude,S._pageName=stall_page,S.name=stall_name,S.category=category,S.price_range=price_range,V._pageName=venue_page,V.name=venue_name,P.location_note=location_note
|where=P.festival_id=1 AND P.year=2026
|order by=P.sort_order ASC
|format=template
|template=FestivalStallMapMarker
|named args=yes
|delimiter=;
|more results text=
}}
|service=leaflet
|zoom=18
|height=500px
|width=100%
}}

{{#cargo_query:
tables=FestivalStallPlacements=P,Stalls=S,Venues=V,Areas=A
|join on=P.stall_id=S.stall_id,P.venue_id=V.venue_id,V.area_id=A.area_id
|fields=P.placement_id,S.name,P.festival_id,P.venue_id,P.year,P.latitude,P.longitude,V.name,A.name
|where=P.festival_id=1 AND P.year=2026
|order by=P.sort_order ASC
|format=table
}}

{{#cargo_query:
tables=Stalls=S
|fields=S._pageName=ページ名,S.stall_id=stall_id,S.name=屋台名,S.category=カテゴリ,S.festival_id=旧festival_id,S.venue_id=旧venue_id
|order by=S.stall_id ASC
|format=table
}}

== stall_id=1 / Stalls ==

{{#cargo_query:
tables=Stalls=S
|fields=S._pageName=ページ名,S.stall_id=stall_id,S.name=屋台名,S.category=カテゴリ,S.festival_id=旧festival_id,S.venue_id=旧venue_id,S.area=旧area,S.opening_time=旧開始時間,S.closing_time=旧終了時間,S.price_range=旧価格帯,S.latitude=旧緯度,S.longitude=旧経度
|where=S.stall_id=1
|format=table
}}

== stall_id=1 / FestivalStallPlacements ==

{{#cargo_query:
tables=FestivalStallPlacements=P
|fields=P._pageName=ページ名,P.placement_id=placement_id,P.stall_id=stall_id,P.festival_id=festival_id,P.venue_id=venue_id,P.year=年,P.latitude=緯度,P.longitude=経度,P.location_note=場所,P.position_status=位置状態,P.status=出店状態,P.verification_status=確認状態,P.last_confirmed=最終確認
|where=P.stall_id=1
|order by=P.placement_id ASC
|format=table
}}