Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- DISTINCT c.id as cid,
- c.title,
- c.description,
- t.value as tags
- FROM
- connect_tag_com ctc
- JOIN tags t on t.id = ctc.tag_id
- JOIN components c on c.id = ctc.component_id
- WHERE
- ctc.tag_id IN ('9', '10', '1')
- ORDER BY
- FIELD (ctc.tag_id, "9", "10", "1") ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement