[stejc123]

We're getting this error when I select closed events:

Database error in vBulletin 3.7.0:

Invalid SQL:

		SELECT item.item_id, item.item_title, item.threadid, grp.group_title, item.item_status, item.item_created, item.item_open_until, item.item_pay_after, thread.threadid, thread.forumid, thread.postuserid
		FROM vbookie_items AS item
		LEFT JOIN vbookie_groups AS grp ON grp.group_id = item.group_id
		LEFT JOIN thread AS thread ON thread.vbookie_item_id = item.item_id
		WHERE item.item_status='CLOSED'
		ORDER BY item.item_pay_after,  item.item_id DESC 
		LIMIT 0, 20;

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
Request Date  : Tuesday, May 20th 2008 @ 12:44:05 PM
Error Date    : Tuesday, May 20th 2008 @ 12:44:05 PM
Script        : http://www.planetcricket.net/forums/vbookie.php?type=CLOSED&selecttype=Go
Referrer      : http://www.planetcricket.net/forums/vbookie.php?
IP Address    : xxxxxxxxxxxx
Username      : xxxxxxxxxxx
Classname     : vb_database
MySQL Version : 4.1.22-standard

Haven't seen anyone else reporting the error and this is after reinstalling for 3.7.0.