Advertisement
Guest User

Untitled

a guest
May 23rd, 2019
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.54 KB | None | 0 0
  1. SELECT
  2. GTX.target_id,
  3. T.ext ,
  4. GTX.*,
  5. T.id,
  6. REPLACE (`GTX`.`description`,'\\"','"' ) as `description`
  7. FROM (
  8. (
  9. SELECT
  10. *
  11. FROM `gallery_targets_xref`
  12. WHERE
  13. target = 'news' AND
  14. target_id = '98039' AND
  15. visible = 1 AND
  16. deleted = 0
  17. ORDER BY position DESC
  18. LIMIT 0, 1
  19. )
  20. UNION (
  21. SELECT
  22. *
  23. FROM `gallery_targets_xref`
  24. WHERE
  25. target = 'news' AND
  26. target_id = '98038' AND
  27. visible = 1 AND
  28. deleted = 0
  29. ORDER BY position DESC
  30. LIMIT 0, 1
  31. )
  32. UNION (
  33. SELECT
  34. *
  35. FROM `gallery_targets_xref`
  36. WHERE
  37. target = 'news' AND
  38. target_id = '98036' AND
  39. visible = 1 AND
  40. deleted = 0
  41. ORDER BY position DESC
  42. LIMIT 0, 1
  43. )
  44. UNION (
  45. SELECT
  46. *
  47. FROM `gallery_targets_xref`
  48. WHERE
  49. target = 'news' AND
  50. target_id = '98035' AND
  51. visible = 1 AND
  52. deleted = 0
  53. ORDER BY position DESC
  54. LIMIT 0, 1
  55. )
  56. UNION (
  57. SELECT
  58. *
  59. FROM `gallery_targets_xref`
  60. WHERE
  61. target = 'news' AND
  62. target_id = '98034' AND
  63. visible = 1 AND
  64. deleted = 0
  65. ORDER BY position DESC
  66. LIMIT 0, 1
  67. )
  68. UNION (
  69. SELECT
  70. *
  71. FROM `gallery_targets_xref`
  72. WHERE
  73. target = 'news' AND
  74. target_id = '98033' AND
  75. visible = 1 AND
  76. deleted = 0
  77. ORDER BY position DESC
  78. LIMIT 0, 1
  79. )
  80. UNION (
  81. SELECT
  82. *
  83. FROM `gallery_targets_xref`
  84. WHERE
  85. target = 'news' AND
  86. target_id = '98032' AND
  87. visible = 1 AND
  88. deleted = 0
  89. ORDER BY position DESC
  90. LIMIT 0, 1
  91. )
  92. UNION (
  93. SELECT
  94. *
  95. FROM `gallery_targets_xref`
  96. WHERE
  97. target = 'news' AND
  98. target_id = '98030' AND
  99. visible = 1 AND
  100. deleted = 0
  101. ORDER BY position DESC
  102. LIMIT 0, 1
  103. )
  104. UNION (
  105. SELECT
  106. *
  107. FROM `gallery_targets_xref`
  108. WHERE
  109. target = 'news' AND
  110. target_id = '98028' AND
  111. visible = 1 AND
  112. deleted = 0
  113. ORDER BY position DESC
  114. LIMIT 0, 1
  115. )
  116. UNION (
  117. SELECT
  118. *
  119. FROM `gallery_targets_xref`
  120. WHERE
  121. target = 'news' AND
  122. target_id = '98029' AND
  123. visible = 1 AND
  124. deleted = 0
  125. ORDER BY position DESC
  126. LIMIT 0, 1
  127. )
  128.  
  129. ) as GTX
  130. INNER JOIN gallery as T ON T.id = GTX.gallery_id
  131. WHERE 1
  132. GROUP BY target_id | 0 | 0 |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement