SELECT STRAIGHT_JOIN  u.*, u.externalOptions as userExternalOptions, v.*, c.iconClass, c.name as category, c.clean_name as clean_category,c.description as category_description, v.created as videoCreation, v.modified as videoModified  FROM videos as v  LEFT JOIN categories c ON categories_id = c.id  LEFT JOIN users u ON v.users_id = u.id  WHERE 2=2  AND u.status = 'a'  AND  ((SELECT count(id) FROM videos_group_view as gv WHERE gv.videos_id = v.id ) = 0 AND (SELECT count(id) FROM categories_has_users_groups as cug WHERE cug.categories_id = v.categories_id ) = 0)  AND v.status IN ('a','k','f') ORDER BY likes DESC  LIMIT 0, 10 \nError : (2014) Commands out of sync; you can't run this command now