daniel4ing

Got the result, took me long enough…heh

SELECT DISTINCT wposts.*
FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta, $wpdb->postmeta wpostmeta2, $wpdb->postmeta wpostmeta3
WHERE wposts.ID = wpostmeta.post_id
AND wposts.ID = wpostmeta2.post_id
AND wposts.ID = wpostmeta3.post_id
AND wpostmeta.meta_key = 'product_featured'
AND wpostmeta.meta_value = '1'
AND wpostmeta2.meta_key = 'product_start_date'
AND wpostmeta2.meta_value <  '" . date("Y-m-d") . "'
AND wpostmeta3.meta_key = 'product_end_date'
AND wpostmeta3.meta_value > '" . date("Y-m-d") . "'
AND wposts.post_type = 'products'
AND wposts.post_status = 'publish'
GROUP BY ID

Thanks for the help Mac 🙂

I’ve adjusted the date format, but still the same result.

Aye, I might have not put it in the right section but I’m not sure this is the right section either… hehe