iwantmychocolate
New Member
\[code\]SELECT upd.*, usr.username AS `username`, usr.profile_picture AS `profile_picture` ,( SELECT COUNT (like.id) FROM likes as like WHERE upd.update_id = like.item_id AND like.uid = 118697835834 ) as liked_updateFROM updates AS updLEFT JOIN users AS usr ON upd.uid = usr.uidWHERE upd.deleted=0 AND ( upd.uid=118697835834 OR EXISTS ( SELECT * FROM subscribers AS sub WHERE upd.uid = sub.suid AND sub.uid = 118697835834 ) )ORDER BY upd.date DESCLIMIT 0, 15\[/code\]the subquery in \[code\]SELECT\[/code\] returns the following error:\[code\]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'like WHERE upd.update_id = like.item_id AND l' at line 10\[/code\]