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