Nov 26 23:33:56 ||bass  the following query is wrong:
Nov 26 23:33:57 tunabot mreeeeow....
Nov 26 23:33:58 ||bass  SELECT p.*,text,headtext,signtext,edited,options,tagval,u.id uid,name,posts,sex,powerlevel,picture,title,useranks,location,lastposttime,lastactivity,imood,skype,regdate FROM posts p,posts_text LEFT JOIN users uON p.user=u.id WHERE thread=9277 AND p.id=pid ORDER BY p.id LIMIT 0,100
Nov 26 23:34:13 ||bass  SELECT p.*,text,headtext,signtext,edited,options,tagval,u.id uid,name,posts,sex,powerlevel,picture,title,useranks,location,lastposttime,lastactivity,imood,skype,regdate FROM posts_text, posts p LEFT JOIN users uON p.user=u.id WHERE thread=9277 AND p.id=pid ORDER BY p.id LIMIT 0,100
Nov 26 23:34:28 ||bass  notice the very subtle difference
Nov 26 23:34:33 ||bass  because
Nov 26 23:34:48 ||bass  since you are using p in the ON clause
Nov 26 23:34:58 ||bass  posts p has to be an immediate operand of the join
Nov 26 23:35:47 ||bass  that is actual standardized sql syntax
Nov 26 23:36:03 ||bass  i know mysql4 let you use any table from anywhere in the query in the join
Nov 26 23:36:12 ||bass  for the on clause
Nov 26 23:36:21 ||bass  but, at least if you read the standard
Nov 26 23:36:28 ||bass  it's explicitly supposed to fail
Nov 26 23:36:31 ||bass  which it does in php5