Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM ( SELECT TOP 2 * FROM [sosco].[dbo].[contents]
- WHERE Visible=1 AND CategoryID=13 AND ContentType=2
- UNION
- SELECT TOP 2 * FROM [sosco].[dbo].[contents]
- WHERE Visible=1 AND CategoryID=13 AND ContentType=1
- UNION SELECT * FROM [sosco].[dbo].[contents] WHERE ID=0)
- a WHERE a.ID NOT IN(0) ORDER BY a.CreationDate DESC
Advertisement
Add Comment
Please, Sign In to add comment