Simple INNER JOIN not returning results

[mc12345678]

Ya, I'd test by removing the "where" clause first. If that returns results then you'll know it's date-related.

Thinking a little further on it (and to help with the above test), might want to (temporarily) add the pd.products_date_added field on the return set just so it shows in you results so you can confirm your "suspicion" of having those at least 6 product.


.