SELECT order_id, lunch_orders.user_id, lunch_orders.cat_id, lunch_order, price, paid, first_name, last_name, office, lunch_catering.name AS cat_name FROM lunch_orders LEFT JOIN user_data USING (user_id) LEFT JOIN lunch_catering ON lunch_catering.cat_id = lunch_orders.cat_id WHERE (user_data.office = 1 OR user_data.office = 2) GROUP BY cat_id