Help with a sql query
Hi guys; I have a question about a query I made to select the items in my classifieds component.
Here’s an example
SELECT DISTINCT c.id AS classified3_id FROM wp_bp_classified3s c INNER JOIN wp_bp_classified3s_classified3meta cm ON cm.classified3_id = classified3_id INNER JOIN wp_usermeta um ON um.user_id = c.creator_id WHERE c.status = 'published'
First; do you think my query is OK ?
I have some problems understanding JOIN; so if you have things to correct in it, please tell !
Then, and this is why I’m writing here;
I would like to filter my query to exclude the items where the author (c.creator_id) is banned.
We can check if he is banned in the wp_usermeta table :
a user banned will have a usermeta key where meta_key=’classified3s_banned’.
Big thanks for help !
You must be logged in to reply to this topic.