SQL Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay at /storage/home/srv22185/htdocs/staff/component/Articles/Show.php line 47
Array ( [code] => 1104 [message] => The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay [query] => SELECT (IF(t0.articles_c_c_id IS NOT NULL,1,0)+IF(t1.articles_c_c_id IS NOT NULL,1,0)+IF(t2.articles_c_c_id IS NOT NULL,1,0)+IF(t3.articles_c_c_id IS NOT NULL,1,0)) as level, tcRoot.articles_c_id, tcRoot.articles_c_name , tc0.articles_c_id as `0.id`, tc1.articles_c_id as `1.id`, tc2.articles_c_id as `2.id`, tc3.articles_c_id as `3.id` FROM articles_c_table tcRoot LEFT JOIN articles_c_c_table tRoot ON tcRoot.articles_c_id=tRoot.articles_c_c_id_child LEFT JOIN articles_c_c_table t0 ON tcRoot.articles_c_id=t0.articles_c_c_id_parent LEFT JOIN articles_c_table tc0 ON t0.articles_c_c_id_child=tc0.articles_c_id LEFT JOIN articles_c_c_table t1 ON t0.articles_c_c_id_child=t1.articles_c_c_id_parent LEFT JOIN articles_c_table tc1 ON t1.articles_c_c_id_child=tc1.articles_c_id LEFT JOIN articles_c_c_table t2 ON t1.articles_c_c_id_child=t2.articles_c_c_id_parent LEFT JOIN articles_c_table tc2 ON t2.articles_c_c_id_child=tc2.articles_c_id LEFT JOIN articles_c_c_table t3 ON t2.articles_c_c_id_child=t3.articles_c_c_id_parent LEFT JOIN articles_c_table tc3 ON t3.articles_c_c_id_child=tc3.articles_c_id WHERE tRoot.articles_c_c_id IS NULL ORDER BY tcRoot.articles_c_sort, tcRoot.articles_c_name, tc0.articles_c_id, tc1.articles_c_id, tc2.articles_c_id, tc3.articles_c_id [context] => /storage/home/srv22185/htdocs/staff/component/Articles/Show.php line 47 )