Here is the error I get:
Any suggestions greatly appreciated.
Mike....
www.musclemayhem.com/forums
vBulletin Version 3.0.7
Invalid SQL:
SELECT threadid AS itemid, forumid,
IF(postuserid = 1, 'self', 'other') AS starter
FROM vb3_thread AS thread
LEFT JOIN vb3_deletionlog AS delthread ON(delthread.primaryid = thread.threadid AND delthread.type = 'thread')
WHERE threadid IN(29195, 28825, 29193, 23171, 18171, 23435, 29166, 29099, 28521, 29185, 29111, 29153, 29174, 28917, 29192, 29196, 29078, 29177, 29171, 25448, 29181, 29179, 29061, 29066, 29191, 29199, 29194, 29003, 29137, 29198, 29197, 28616, 29065, 29173, 29159, 18012, 29119, 29189, 29183, 28676, 28653, 29178, 29190, 29155, 29164, 29144, 29163, 29182, 28755, 28166, 29028, 28647, 10480, 27739, 29075, 28700, 29188, 29105, 29187, 29186, 29175, 29180, 29172, 29011)
AND delthread.primaryid IS NULL
AND thread.open <> 10
AND thread.visible = 1
AND thread.postuserid NOT IN (7818,14330,14571,14512,10883,11130,9876,14065,10105,11236,9647,11580,11153,8469,9973,3152 ,14734))
SELECT threadid AS itemid, forumid,
IF(postuserid = 1, 'self', 'other') AS starter
FROM vb3_thread AS thread
LEFT JOIN vb3_deletionlog AS delthread ON(delthread.primaryid = thread.threadid AND delthread.type = 'thread')
WHERE threadid IN(29195, 28825, 29193, 23171, 18171, 23435, 29166, 29099, 28521, 29185, 29111, 29153, 29174, 28917, 29192, 29196, 29078, 29177, 29171, 25448, 29181, 29179, 29061, 29066, 29191, 29199, 29194, 29003, 29137, 29198, 29197, 28616, 29065, 29173, 29159, 18012, 29119, 29189, 29183, 28676, 28653, 29178, 29190, 29155, 29164, 29144, 29163, 29182, 28755, 28166, 29028, 28647, 10480, 27739, 29075, 28700, 29188, 29105, 29187, 29186, 29175, 29180, 29172, 29011)
AND delthread.primaryid IS NULL
AND thread.open <> 10
AND thread.visible = 1
AND thread.postuserid NOT IN (7818,14330,14571,14512,10883,11130,9876,14065,10105,11236,9647,11580,11153,8469,9973,3152 ,14734))
Any suggestions greatly appreciated.
Mike....
www.musclemayhem.com/forums
vBulletin Version 3.0.7
Comment