Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- s_relinks_logs.id,
- s_relinks.search_key AS relink_key,
- s_relinks.link AS link,
- (CASE
- WHEN
- s_relinks_logs.item_type = 'product'
- THEN
- (SELECT
- name
- FROM
- s_products
- WHERE
- id = s_relinks_logs.item_id)
- WHEN
- s_relinks_logs.item_type = 'blog'
- THEN
- (SELECT
- name
- FROM
- s_blog
- WHERE
- id = s_relinks_logs.item_id)
- END) AS name,
- s_relinks_logs.anchors,
- s_relinks_logs.date,
- s_relinks_logs.item_id,
- s_relinks_logs.item_type
- FROM
- s_relinks_logs
- LEFT JOIN
- s_relinks ON s_relinks_logs.relink_id = s_relinks.id
- ORDER BY date DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement