lugzer
public sql v1 · immutableSELECT lunch_orders.user_id, lunch_orders.cat_id, lunch_order, price, paid, first_name, last_name, office, name FROM lunch_orders LEFT JOIN user_data USING (user_id) LEFT JOIN lunch_catering USING (cat_id) WHERE (user_data.office = 1 OR user_data.office = 2) ORDER BY user_data.office AND user_data.last_name