Advertisement
Guest User

Untitled

a guest
Jul 24th, 2019
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. SELECT
  2. c.id,
  3. c.code,
  4. CONCAT(cd.excerpt, GROUP_CONCAT(cdb.content ORDER BY cdb.sort)) as description,
  5. REGEXP_SUBSTR(CONCAT(cd.excerpt, GROUP_CONCAT(cdb.content ORDER BY cdb.sort)), '(?s)<p[^\n]*Bildquelle[^\n]*<\/p>.?<ul>.*?<\/ul>') as bq
  6. FROM category c
  7. LEFT JOIN category_description cd ON c.id = cd.id
  8. 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"
  9. GROUP BY c.id, cd.excerpt;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement