Re: reading database

[Alison Iddings]

Try this...
SELECT order_id
FROM pxyv_wc_orders_meta AS meta1
WHERE meta1.meta_key = "_billing_collection_date"
AND meta1.meta_value = "08/04/2024"
AND EXISTS (
SELECT 1
FROM pxyv_wc_orders_meta AS meta2
WHERE meta2.order_id = meta1.order_id
AND meta2.meta_key = "_billing_collection_time"
AND meta2.meta_value = "Afternoon 13:00 - 17:00"
)

- Alison Iddings
https://cityofoaksmarketing.com/