Website News
Main Menu
grudd-BlogFile name: mod_joomblog.phpLine: 127 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 SQL=SELECT jbu.userid as joomblog_blogger, u.username, u.name, sum(case when (sec.published=1 and cat.published=1 and jbs.listed=1 and jbc.listed=1 and jbco.listed=1) then 1 else 0 end) as numitems FROM jos_joomblog_users as jbu LEFT JOIN jos_users AS u ON u.id = jbu.userid LEFT JOIN jos_content AS a ON a.created_by=jbu.userid LEFT JOIN jos_categories AS cat ON cat.id = a.catid LEFT JOIN jos_sections AS sec ON sec.id = a.sectionid LEFT JOIN jos_groups AS grp ON grp.id = a.access LEFT JOIN jos_joomblog_sections AS jbs ON jbs.sectionid = a.sectionid LEFT JOIN jos_joomblog_categories AS jbc ON jbc.categoryid = a.catid LEFT JOIN jos_joomblog_content AS jbco ON jbco.contentid = a.id WHERE jbu.block=0 \n AND (a.access <= 0 or a.access is null) AND (cat.access <= 0 or cat.access is null) AND ( sec.access <= 0 or sec.access is null) AND ( publish_up = \'0000-00-00 00:00:00\' OR publish_up <= \'2010-09-09 01:47:43\' or publish_up is null) AND ( publish_down = \'0000-00-00 00:00:00\' OR publish_down >= \'2010-09-09 01:47:43\' or publish_down is null) GROUP BY jbu.userid HAVING `numitems` >= 0 ORDER BY numitems desc Bus. Profiles LoginNewest UsersWelcome our newest members:Members OnlineNo Users Online
|
||||||||||||||||||||||||||
Contact Us 
