Hi,

I'm following up on this error that appears to be connected to RS and I continue to experience. The error shows as "Not unique table/alias". It appears to  eventually cause a "PHP Fatal error:  Out of memory" error and crash my site.

I have upgraded to your new release of 1.3 but this has not solved the issue. I am currently running WP 3.0.1.

Here is what appears in my error log:

[03-Nov-2010 14:14:30] WordPress database error Not unique table/alias: 'wp_posts' for query SELECT DISTINCT * FROM wp_posts INNER JOIN wp_comments ON wp_posts.ID = wp_comments.comment_post_ID INNER JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID LEFT JOIN wp_posts as parent ON parent.ID = wp_posts.post_parent AND parent.post_type IN ('post','page') AND wp_posts.post_type = 'attachment' WHERE  ( wp_posts.post_type = 'post'  AND (   ( wp_posts.post_status = 'publish' AND (  (  (  (  (  (  (  (  ( ( wp_posts.ID IN ( SELECT tr.object_id FROM wp_term_relationships AS tr WHERE tr.term_taxonomy_id IN ('3', '4', '21', '6', '7', '9', '10', '168', '12', '20', '22', '23', '25', '30', '31', '33', '34', '35', '37', '39', '40', '42', '103', '107', '119', '120', '134', '135', '137', '138', '140', '141', '144', '145', '146', '147', '152', '153', '154', '155', '156', '167', '165', '166', '169', '174', '191', '232', '260', '261', '262', '270', '276', '287', '296', '301', '324', '325', '326', '327', '329', '369', '370', '379', '380', '381', '385', '386', '391', '401', '420', '423', '424', '430', '698', '820') )  )  AND wp_posts.ID NOT IN ('16317') )  )  )  )  )  )  )  )  ) ) ) ) OR ( wp_posts.post_type = 'attachment' AND parent.post_type = 'post'  AND (   ( parent.post_status = 'publish' AND (  (  (  (  (  (  (  (  ( ( parent.ID IN ( SELECT tr.object_id FROM wp_term_relationships AS tr WHERE tr.term_taxonomy_id IN ('3', '4', '21', '6', '7', '9', '10', '168', '12', '20', '22', '23', '25', '30', '31', '33', '34', '35', '37', '39', '40', '42', '103', '107', '119', '120', '134', '135', '137', '138', '140', '141', '144', '145', '146', '147', '152', '153', '154', '155', '156', '167', '165', '166', '169', '174', '191', '232', '260', '261', '262', '270', '276', '287', '296', '301', '324', '325', '326', '327', '329', '369', '370', '379', '380', '381', '385', '386', '391', '401', '420', '423', '424', '430', '698', '820') )  )  AND parent.ID NOT IN ('16317') )  )  )  )  )  )  )  )  ) ) ) ) OR ( wp_posts.post_type = 'page'  AND (   ( wp_posts.post_status = 'publish' AND (  (  (  (  (  (  ( 1=1  AND wp_posts.ID NOT IN ('216', '316', '1733', '2934') )  )  )  )  )  )  ) ) ) ) OR ( wp_posts.post_type = 'attachment' AND parent.post_type = 'page'  AND (   ( parent.post_status = 'publish' AND (  (  (  (  (  (  ( 1=1  AND parent.ID NOT IN ('216', '316', '1733', '2934') )  )  )  )  )  )  ) ) ) )  AND comment_approved = '1' AND comment_type = '' AND post_date < '2010-11-03 07:14:30' AND 1=1 AND wp_posts.post_status = 'publish' AND post_password = '' ORDER  BY comment_date DESC LIMIT 10 made by require, require_once, include, the_content, apply_filters, call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, stats_page_shortcode, stats_page, get_recentcomments
[03-Nov-2010 17:05:17] PHP Fatal error:  Out of memory (allocated 58195968) (tried to allocate 122141 bytes) in /home/planet23/public_html/wp-content/plugins/smart-youtube/smartyoutube.class.php on line 387

As this is causing my site to crash frequently, I would really appreciate any assistance you could provide.

Thanks!