MySQL Query Improvement

[Viry]

Hi,

 

Could someone please help me improve this query and try to cut down on the repeated "`id` != '*'" parts.

 

SELECT `id`, `user`, `usertwo`, `time` FROM `feeds` WHERE `user` = '1' AND `id` != '38000' AND `id` != '38007' OR `usertwo` = '1' AND `id` != '38000' AND `id` != '38007' OR `usertwo` IN ( SELECT `frdid` FROM `friends` WHERE `userid` = '1' ) AND `id` != '38000' AND `id` != '38007' OR `usertwo` IN ( SELECT `fb_uid` FROM `service_friends` WHERE `userid` = '1' ) AND `id` != '38000' AND `id` != '38007' ORDER BY `time` DESC LIMIT 1

[fenway]

You're mixing ANDs and ORs... that's not going to work.