怎么会这样呢搂住
SQL: (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='1' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='2' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='5' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='25' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='447' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='450' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='9' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='12' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid WHERE t.fid='452' ORDER BY t.dateline DESC LIMIT 5)
Error: You have an error in your SQL syntax near '(SELECT t.*, f.name FROM [Table]threads t LEFT JOIN [Table]forums f ON f.fid = t.fid W' at line 1
Errno.: 1064
Similar error report has beed dispatched to administrator before. |