Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jocuriin/public_html/mmedia/links/classes/DirDb.php on line 114
SELECT t4.*, COUNT(DISTINCTROW t3.`id`) num_links FROM `dir_related` t1 LEFT JOIN `dir_flat_structure` t2 ON t1.`id_related` = t2.`id_parent` LEFT JOIN `dir_links` t3 ON t2.`id_category` = t3.`id_category` AND t3.`status` = 'active' LEFT JOIN `dir_categories` t4 ON t1.`id_related` = t4.`id` WHERE t1.`id_category` = '322' AND t4.`status` = 'active' GROUP BY t1.`id` ORDER BY `order`
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