New answers tagged

0

If that is the VIEW, let's see a SELECT (or whatever) using it. A common optimization is to avoid LEFT JOIN (SELECT..) thus: SELECT ... profile_tags ... ... LEFT JOIN ( SELECT profiles_tags.profile_id, GROUP_CONCAT(tags.tag) as profile_tags FROM profiles_tags JOIN tags ON(profiles_tags.tag_id = tags.id) ...


Top 50 recent answers are included