|
|
| (他の1人の利用者による、間の17版が非表示) |
| 1行目: |
1行目: |
| {{#cargo_query: | | {{FestivalStallStatusLabel|test}} |
| tables=Festivals
| |
| |fields=name,start_date | |
| }} | |
|
| |
|
| {{#cargo_query:
| | __NOINDEX__ |
| 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
| |
| }}
| |