Search / Filter posts on Title/Content OR Tags

I worked it out myself..

The query I was looking goes like this:

SELECT *
FROM $wpdb->posts, $wpdb->term_relationships, $wpdb->term_taxonomy, $wpdb->terms
WHERE ($wpdb->terms.name LIKE '%$s%'
OR $wpdb->terms.slug LIKE '%$s%'
OR $wpdb->posts.post_content LIKE '%$s%'
OR $wpdb->posts.post_title LIKE '%$s%')
AND $wpdb->posts.ID = $wpdb->term_relationships.object_id
AND $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id
AND $wpdb->term_taxonomy.term_id = $wpdb->terms.term_id
AND $wpdb->posts.post_status="publish"
AND $wpdb->posts.post_type="products"
ORDER BY $wpdb->posts.post_date DESC

Cheers,
– M