編集の要約なし |
編集の要約なし |
||
| 45行目: | 45行目: | ||
tables=FestivalStallMenuOfferings=O,StallMenuItems=M | tables=FestivalStallMenuOfferings=O,StallMenuItems=M | ||
|join on=O.menu_item_id=M.menu_item_id | |join on=O.menu_item_id=M.menu_item_id | ||
|fields=M.name=menu_name,M.item_category=item_category,O.price=price,O.serving_quantity=serving_quantity,O.serving_unit=serving_unit | |fields=M.name=menu_name,M.item_category=item_category,O.price=price,O.serving_quantity=serving_quantity,O.serving_unit=serving_unit,O.price_note=price_note,O.availability=availability,O.verification_status=verification_status | ||
|where=O.placement_id={{{placement_id|0}}} | |where=O.placement_id={{{placement_id|0}}} | ||
|order by=O.sort_order ASC | |order by=O.sort_order ASC | ||