SELECT (select count(tf_threads.id) from tf_threads inner join tf_users on tf_threads.tuserid = tf_users.id where (tf_threads.id = 262846 or tf_threads.tthread = 262846) and ttext is not null) as counted_threads, tf_threads.id, ttopic, ttext, tuserid, tdate, u2.username AS editedby_username, editedon, editedby, tpoll, pollchoices, /* User stuff */ u1.username, u1.email, u1.admin, u1.registered, u1.banned, u1.tnewbie, u1.canaccesscp, u1.lastlogin, u1.last_session_id, u1.post_age, u1.postcount, u1.usertitle, u1.icq, u1.aim, u1.msn, u1.signature, u1.avatar, u1.bio, u1.tfAvatarsOn, u1.tfSigsOn, u1.bday, u1.bmonth, u1.byear, u1.lastonlineip, u1.location, u1.is_trader, u1.trader_expires FROM tf_threads INNER JOIN tf_users ON tf_threads.tuserid = tf_users.id INNER JOIN tf_users u1 ON u1.id = tf_threads.tuserid LEFT JOIN tf_users u2 ON u2.id = tf_threads.editedby WHERE ( tf_threads.id =262846 OR tf_threads.tthread =262846 ) and ttext is not null ORDER BY tdate LIMIT -20, 25
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 '-20, 25' at line 48
| Home > Technical Chat > The 500 and 731/800 kent cams | |||||||
| Home > Technical Chat > The 500 and 731/800 kent cams | |||||||
|
|||||||