hi brian,

creating a search function for new website I get these results after sending the search form:

SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'exp_channel_titles':
SELECT DISTINCT(exp_publisher_titles.entry_id), exp_publisher_titles.channel_id FROM exp_publisher_titles LEFT JOIN exp_channels ON exp_publisher_titles.channel_id = exp_channels.channel_id LEFT JOIN exp_channel_titles ON (exp_channel_titles.channel_id = exp_channels.channel_id AND exp_publisher_titles.entry_id = exp_channel_titles.entry_id) LEFT JOIN exp_publisher_data ON exp_publisher_titles.entry_id = exp_publisher_data.entry_id LEFT JOIN exp_channel_titles ON (exp_channel_titles.channel_id = exp_channels.channel_id AND exp_publisher_titles.entry_id = exp_channel_titles.entry_id) LEFT JOIN exp_publisher_data _field_50 ON exp_publisher_data_field_50.entry_id = exp_publisher_titles.entry_id LEFT JOIN exp_comments ON exp_publisher_titles.entry_id = exp_comments.entry_id LEFT JOIN exp_category_posts ON exp_publisher_titles.entry_id = exp_category_posts.entry_id LEFT JOIN exp_categories ON exp_category_posts.cat_id = exp_categories.cat_id WHERE exp_publisher_titles.lang_id = 1 AND exp_publisher_titles.status = "open" AND exp_channels.site_id IN ('1') AND exp_channel_titles.status = 'open' AND ( (((exp_publisher_titles.title LIKE '%test%' )) ) OR (((exp_publisher_data_field_50.field_id_50 LIKE '%test%' )) ) OR (((exp_comments.comment LIKE '%test%' )) ) ) AND ( exp_publisher_titles.channel_id = '1' OR exp_publisher_titles.channel_id = '2' OR exp_publisher_titles.channel_id = '3' OR exp_publisher_titles.channel_id = '4' OR exp_publisher_titles.channel_id = '5' OR exp_publisher_titles.channel_id = '6' OR exp_publisher_titles.channel_id = '8' OR exp_publisher_titles.channel_id = '9' OR exp_publisher_titles.channel_id = '10' OR exp_publisher_titles.channel_id = '11' OR exp_publisher_titles.channel_id = '12' OR exp_publisher_titles.channel_id = '13' OR exp_publisher_titles.channel_id = '14' OR exp_publisher_titles.channel_id = '15' OR exp_publisher_titles.channel_id = '16' OR exp_publisher_titles.channel_id = '17' OR exp_publisher_titles.channel_id = '18' OR exp_publisher_titles.channel_id = '19' OR exp_publisher_titles.channel_id = '20' OR exp_publisher_titles.channel_id = '21' OR exp_publisher_titles.channel_id = '26' OR exp_publisher_titles.channel_id = '28' OR exp_publisher_titles.channel_id = '29' OR exp_publisher_titles.channel_id = '33' OR exp_publisher_titles.channel_id = '34' OR exp_publisher_titles.channel_id = '35' OR exp_publisher_titles.channel_id = '36' OR exp_publisher_titles.channel_id = '37' OR exp_publisher_titles.channel_id = '38' OR exp_publisher_titles.channel_id = '39' OR exp_publisher_titles.channel_id = '40' OR exp_publisher_titles.channel_id = '43' OR exp_publisher_titles.channel_id = '44' OR exp_publisher_titles.channel_id = '45' OR exp_publisher_titles.channel_id = '46' OR exp_publisher_titles.channel_id = '48' OR exp_publisher_titles.channel_id = '49' OR exp_publisher_titles.channel_id = '50' OR exp_publisher_titles.channel_id = '51' OR exp_publisher_titles.channel_id = '52' OR exp_publisher_titles.channel_id = '53' OR exp_publisher_titles.channel_id = '54' OR exp_publisher_titles.channel_id = '55' OR exp_publisher_titles.channel_id = '56' OR exp_publisher_titles.channel_id = '57' OR exp_publisher_titles.channel_id = '58' OR exp_publisher_titles.channel_id = '61' )

mysqli_connection.php:116

any idea what that means?

kindest regards,
matthias