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
SELECT t1.*, COUNT(DISTINCTROW(t2.`id`)) `articles`, (COUNT(DISTINCTROW(t3.`id`)) + COUNT(DISTINCTROW(t4.`id`))) `comments`, COUNT(DISTINCTROW(t5.`id`)) `rate` FROM `v21_accounts` t1 LEFT JOIN `v21_articles` t2 ON t1.`id` = t2.`id_account` LEFT JOIN `v21_article_comments` t3 ON t1.`id` = t3.`id_account` LEFT JOIN `v21_subitem_comments` t4 ON t1.`id` = t4.`id_account` LEFT JOIN `v21_account_votes` t5 ON t1.`id` = t5.`id_account` WHERE `t1`.`id` = '48' GROUP BY t1.`id`