Do you know how can I do this query with join? PHQL doesn't support subqueries wich is a big pain.
SELECT * FROM location WHERE id NOT IN (SELECT locationid FROM userlocation WHERE user_id=1000);
I have two tables: one with locations and one with likes and dislikes from user to those locations. I want to retrive all the locations that the user didn't voted yet. I don't want to appear locations that the user allready voted.
Thank you so much!