Не выводятся комментарии

SELECT c.id, c.guestname, c.content, c.pubdate AS fpubdate, c.target_title, c.target_link, c.ip, c.user_id, IFNULL( v.total_rating, 0 ) AS votes, IFNULL( u.nickname, 0 ) AS nickname, IFNULL( u.login, 0 ) AS login, IFNULL( u.is_deleted, 0 ) AS is_deleted, IFNULL( p.imageurl, 0 ) AS imageurl, IFNULL( p.gender, 0 ) AS gender
FROM cms_comments c
LEFT JOIN cms_ratings_total v ON v.item_id = c.id
AND v.target = 'comment'
LEFT JOIN cms_users u ON u.id = c.user_id
LEFT JOIN cms_user_profiles p ON p.user_id = u.id
WHERE c.published =1
ORDER BY c.id DESC 
LIMIT 0 , 20

#1104 - 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