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