Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- c.id,
- c.code,
- CONCAT(cd.excerpt, GROUP_CONCAT(cdb.content ORDER BY cdb.sort)) as description,
- REGEXP_SUBSTR(CONCAT(cd.excerpt, GROUP_CONCAT(cdb.content ORDER BY cdb.sort)), '(?s)<p[^\n]*Bildquelle[^\n]*<\/p>.?<ul>.*?<\/ul>') as bq
- FROM category c
- LEFT JOIN category_description cd ON c.id = cd.id
- LEFT JOIN category_description_block cdb ON cdb.category_description_id = cd.id AND cdb.status = 100 WHERE description REGEXP "img" OR description REGEXP "Bildquelle"
- GROUP BY c.id, cd.excerpt;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement