[bashy]

Just had this error

Database error in vBulletin 3.5.3:

Invalid SQL:

                        SELECT post.pagetext AS preview,
                                thread.threadid, thread.title AS threadtitle, lastpost, forumid, pollid, open, replycount, postusername, postuserid, lastposter,
                                thread.dateline, views, thread.iconid AS threadiconid, notes, thread.visible
                                

                        FROM thread AS thread
                        
                        LEFT JOIN recentlyviewed AS recentlyviewed ON(recentlyviewed.threadid = thread.threadid)
                        LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
                        WHERE thread.threadid IN(1701,1699,1698,1697,1693,1692,1691,1687,1703,1704,1705,1706,1708,1707,1712,1714,194,1732,1103,1729,1718,1725,1717,1736,1051,1741,1647,1625,1346,1579,1688,1742,1743,1744,184,1670,1754,1753,1758,1759,1577,1757,1546,1391,1760,1761,1762,1764,1766,1765,1749,1747,1748,1755,1767,1768,1769,1770,1771,1773,1774,1775,1776,1751,1678,1657,1640,1611,1607,1561,1540,1528,1777,1778,1779,132,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1791,1792,1685,1715,1772,1816,1621) 
                        ORDER BY recentlyviewed.dateline DESC
                        LIMIT 5;

MySQL Error  : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay Error Number : 1104
Date         : Sunday, February 19th 2006 @ 08:35:01 PM
Script       : http://www.bashys-place.com/forums/
Referrer     : http://www.bashys-place.com/forums/

I tried to run that sql ya gave me but didnt work this time...
Please advise as i have to keep this turned off now