|
|
| (他の1人の利用者による、間の14版が非表示) |
| 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
| |
| }}
| |
| | |
| {{#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
| |
| }}
| |