Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- GTX.target_id,
- T.ext ,
- GTX.*,
- T.id,
- REPLACE (`GTX`.`description`,'\\"','"' ) as `description`
- FROM (
- (
- SELECT
- *
- FROM `gallery_targets_xref`
- WHERE
- target = 'news' AND
- target_id = '98039' AND
- visible = 1 AND
- deleted = 0
- ORDER BY position DESC
- LIMIT 0, 1
- )
- UNION (
- SELECT
- *
- FROM `gallery_targets_xref`
- WHERE
- target = 'news' AND
- target_id = '98038' AND
- visible = 1 AND
- deleted = 0
- ORDER BY position DESC
- LIMIT 0, 1
- )
- UNION (
- SELECT
- *
- FROM `gallery_targets_xref`
- WHERE
- target = 'news' AND
- target_id = '98036' AND
- visible = 1 AND
- deleted = 0
- ORDER BY position DESC
- LIMIT 0, 1
- )
- UNION (
- SELECT
- *
- FROM `gallery_targets_xref`
- WHERE
- target = 'news' AND
- target_id = '98035' AND
- visible = 1 AND
- deleted = 0
- ORDER BY position DESC
- LIMIT 0, 1
- )
- UNION (
- SELECT
- *
- FROM `gallery_targets_xref`
- WHERE
- target = 'news' AND
- target_id = '98034' AND
- visible = 1 AND
- deleted = 0
- ORDER BY position DESC
- LIMIT 0, 1
- )
- UNION (
- SELECT
- *
- FROM `gallery_targets_xref`
- WHERE
- target = 'news' AND
- target_id = '98033' AND
- visible = 1 AND
- deleted = 0
- ORDER BY position DESC
- LIMIT 0, 1
- )
- UNION (
- SELECT
- *
- FROM `gallery_targets_xref`
- WHERE
- target = 'news' AND
- target_id = '98032' AND
- visible = 1 AND
- deleted = 0
- ORDER BY position DESC
- LIMIT 0, 1
- )
- UNION (
- SELECT
- *
- FROM `gallery_targets_xref`
- WHERE
- target = 'news' AND
- target_id = '98030' AND
- visible = 1 AND
- deleted = 0
- ORDER BY position DESC
- LIMIT 0, 1
- )
- UNION (
- SELECT
- *
- FROM `gallery_targets_xref`
- WHERE
- target = 'news' AND
- target_id = '98028' AND
- visible = 1 AND
- deleted = 0
- ORDER BY position DESC
- LIMIT 0, 1
- )
- UNION (
- SELECT
- *
- FROM `gallery_targets_xref`
- WHERE
- target = 'news' AND
- target_id = '98029' AND
- visible = 1 AND
- deleted = 0
- ORDER BY position DESC
- LIMIT 0, 1
- )
- ) as GTX
- INNER JOIN gallery as T ON T.id = GTX.gallery_id
- WHERE 1
- GROUP BY target_id | 0 | 0 |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement