編集の要約なし |
編集の要約なし |
||
| 59行目: | 59行目: | ||
{{#cargo_store: | {{#cargo_store: | ||
_table=Festivals | _table=Festivals | ||
|festival_id= | |festival_id={{PAGEID}} | ||
|name={{{name|}}} | |name={{{name|}}} | ||
|kana={{{kana|}}} | |kana={{{kana|}}} | ||
| 116行目: | 116行目: | ||
|join on=FA.area_id=A.area_id | |join on=FA.area_id=A.area_id | ||
|fields=A._pageName=page,A.name=name | |fields=A._pageName=page,A.name=name | ||
|where=FA.festival_id= | |where=FA.festival_id={{PAGEID}} AND FA.relation_type IN ('related','primary','venue') | ||
|order by=FA.sort_order ASC | |order by=FA.sort_order ASC | ||
|format=template | |format=template | ||
| 147行目: | 147行目: | ||
tables=FestivalCalendar | tables=FestivalCalendar | ||
|fields=start_date,end_date,status | |fields=start_date,end_date,status | ||
|where=festival_id= | |where=festival_id={{PAGEID}} AND year={{CURRENTYEAR}} | ||
|order by=start_date ASC | |order by=start_date ASC | ||
|limit=1 | |limit=1 | ||
| 280行目: | 280行目: | ||
|join on=FA.area_id=A.area_id | |join on=FA.area_id=A.area_id | ||
|fields=A._pageName=page,A.name=name,A.area_type=area_type,FA.relation_type=relation_type,FA.sort_order=sort_order | |fields=A._pageName=page,A.name=name,A.area_type=area_type,FA.relation_type=relation_type,FA.sort_order=sort_order | ||
|where=FA.festival_id= | |where=FA.festival_id={{PAGEID}} | ||
|order by=FA.sort_order ASC,A.area_id ASC | |order by=FA.sort_order ASC,A.area_id ASC | ||
|format=template | |format=template | ||
| 305行目: | 305行目: | ||
|join on=FV.venue_id=V.venue_id,V.area_id=A.area_id | |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,V.address=address,V.latitude=latitude,V.longitude=longitude,V.nearest_station=nearest_station,A._pageName=area_page,A.name=area_name,FV.note=note | |fields=FV.relation_type=relation_type,V._pageName=venue_page,V.name=venue_name,V.address=address,V.latitude=latitude,V.longitude=longitude,V.nearest_station=nearest_station,A._pageName=area_page,A.name=area_name,FV.note=note | ||
|where=FV.festival_id= | |where=FV.festival_id={{PAGEID}} | ||
|order by=FV.sort_order ASC,V.name ASC | |order by=FV.sort_order ASC,V.name ASC | ||
|format=template | |format=template | ||
| 390行目: | 390行目: | ||
|join on=P.stall_id=S.stall_id,P.venue_id=V.venue_id,V.area_id=A.area_id | |join on=P.stall_id=S.stall_id,P.venue_id=V.venue_id,V.area_id=A.area_id | ||
|fields=P.placement_id=placement_id,P.latitude=latitude,P.longitude=longitude,S._pageName=stall_page,S.name=stall_name,S.category=category,V._pageName=venue_page,V.name=venue_name,A._pageName=area_page,A.name=area_name,P.location_note=location_note,P.position_status=position_status,P.position_accuracy_m=position_accuracy_m,P.verification_status=verification_status | |fields=P.placement_id=placement_id,P.latitude=latitude,P.longitude=longitude,S._pageName=stall_page,S.name=stall_name,S.category=category,V._pageName=venue_page,V.name=venue_name,A._pageName=area_page,A.name=area_name,P.location_note=location_note,P.position_status=position_status,P.position_accuracy_m=position_accuracy_m,P.verification_status=verification_status | ||
|where=P.festival_id= | |where=P.festival_id={{PAGEID}} AND P.year={{{stall_year|{{CURRENTYEAR}}}}} | ||
|order by=P.sort_order ASC | |order by=P.sort_order ASC | ||
|format=template | |format=template | ||
| 430行目: | 430行目: | ||
|join on=P.stall_id=S.stall_id,P.venue_id=V.venue_id,V.area_id=A.area_id | |join on=P.stall_id=S.stall_id,P.venue_id=V.venue_id,V.area_id=A.area_id | ||
|fields=P.placement_id=placement_id,S._pageName=stall_page,S.name=stall_name,S.category=category,V._pageName=venue_page,V.name=venue_name,A._pageName=area_page,A.name=area_name,P.price_min=price_min,P.price_max=price_max,P.price_note=price_note,P.opening_time=opening_time,P.closing_time=closing_time,P.hours_note=hours_note,P.location_note=location_note,P.position_status=position_status,P.position_accuracy_m=position_accuracy_m,P.verification_status=verification_status,P.status=status,P.last_confirmed=last_confirmed | |fields=P.placement_id=placement_id,S._pageName=stall_page,S.name=stall_name,S.category=category,V._pageName=venue_page,V.name=venue_name,A._pageName=area_page,A.name=area_name,P.price_min=price_min,P.price_max=price_max,P.price_note=price_note,P.opening_time=opening_time,P.closing_time=closing_time,P.hours_note=hours_note,P.location_note=location_note,P.position_status=position_status,P.position_accuracy_m=position_accuracy_m,P.verification_status=verification_status,P.status=status,P.last_confirmed=last_confirmed | ||
|where=P.festival_id= | |where=P.festival_id={{PAGEID}} AND P.year={{{stall_year|{{CURRENTYEAR}}}}} | ||
|order by=P.sort_order ASC,S.name ASC | |order by=P.sort_order ASC,S.name ASC | ||
|format=template | |format=template | ||
| 454行目: | 454行目: | ||
tables=FestivalCalendar | tables=FestivalCalendar | ||
|fields=year,start_date,end_date,status | |fields=year,start_date,end_date,status | ||
|where=festival_id= | |where=festival_id={{PAGEID}} | ||
|order by=year DESC | |order by=year DESC | ||
|format=template | |format=template | ||
| 472行目: | 472行目: | ||
|join on=FTL.type_id=FT.type_id | |join on=FTL.type_id=FT.type_id | ||
|fields=FT.name | |fields=FT.name | ||
|where=FTL.festival_id= | |where=FTL.festival_id={{PAGEID}} | ||
|order by=FT.name ASC | |order by=FT.name ASC | ||
|format=list | |format=list | ||