Main Menu

Home

Blog

Popular Links

Contact Us

Search

FAQs

Advertise with us!

grudd.com Webpages

Tell A Friend

grudd-Blog

File name: mod_joomblog.php

---

Line: 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-04 15:34:37\' or publish_up is null) AND ( publish_down = \'0000-00-00 00:00:00\' OR publish_down >= \'2010-09-04 15:34:37\' or publish_down is null) GROUP BY jbu.userid HAVING `numitems` >= 0 ORDER BY numitems desc

Bus. Profiles Login

Username Password Remember me

Lost Password?

No account yet? Register

Newest Users

Welcome our newest members:

• lniseyhfijsuoatc


• jaisiscerlera


• UnutspipseBes


• Parfume


• Air hockey table

Members Online

No Users Online