SQL Statement: SELECT as content_taxonomy_id,
content_taxonomy.taxonomy_id as id,taxonomy.slug as
slug,taxonomy.child_of as child_of,taxonomy.ignore_flag as
ignore_flag,up3.tag as up3_tag,up2.tag as up2_tag,up1.tag as
up1_tag,taxonomy.tag as taxonomy_tag, as up3_id, as up2_id, as
up1_id, as taxonomy_id FROM taxonomy JOIN content_taxonomy on
AND content_taxonomy.content_id= LEFT JOIN taxonomy AS up1 ON
LEFT JOIN taxonomy AS up2 ON LEFT JOIN taxonomy AS up3 ON WHERE
taxonomy.magazine_id=5 AND (up1.slug='knowledge-center' OR
up2.slug='knowledge-center' OR up3.slug='knowledge-center')