編集の要約なし |
編集の要約なし |
||
| 25行目: | 25行目: | ||
|fields=FA.area_id,F._pageName,F.name,F.start_date,F.end_date,F.festival_type,FA.relation_type | |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 | |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 | |format=table | ||
}} | }} | ||