I have searched for all answers, but nothing works. Somehow this query gives me the ambiguity error or 'ID':
SELECT wpp.ID AS theid, s.ID AS supplierid, post_title, wp_terms.name AS category FROM wp_posts AS wpp LEFT JOIN wp_term_relationships ON wpp.ID = object_id LEFT JOIN wp_terms ON term_taxonomy_id = term_id LEFT JOIN wp_teleapo_supplier AS s ON wpp.post_author = s.ID WHERE post_type = 'post' AND (post_title LIKE '%bag%' OR wp_terms.name LIKE '%bag%' OR post_content LIKE '%bag%') GROUP BY ID
the problem lies when I added this line:
LEFT JOIN wp_teleapo_supplier AS s ON wpp.post_author = s.ID
But I don't see what I'm doing wrong... Any hints?