SHOW:
|
|
- or go back to the newest paste.
| 1 | - | SELECT id, TIMESTAMP, 'kepek' as 'table' FROM `kepek` |
| 1 | + | SELECT id, 'kepek' as 'table' FROM `kepek` |
| 2 | - | WHERE `timestamp` LIKE '20120322%' |
| 2 | + | ORDER BY timestamp DESC |
| 3 | UNION ALL | |
| 4 | - | SELECT id, TIMESTAMP, 'links' as 'table' FROM `links` |
| 4 | + | SELECT id, 'links' as 'table' FROM `links` |
| 5 | - | WHERE `timestamp` LIKE '20120322%' |
| 5 | + | ORDER BY timestamp DESC |
| 6 | UNION ALL | |
| 7 | - | SELECT id, TIMESTAMP, 'quotes' as 'table' FROM `quotes` |
| 7 | + | SELECT id, 'quotes' as 'table' FROM `quotes` |
| 8 | - | WHERE `timestamp` LIKE '20120322%' |
| 8 | + | ORDER BY timestamp DESC |
| 9 | UNION ALL | |
| 10 | - | SELECT id, TIMESTAMP, 'youtube' as 'table' FROM `youtube` |
| 10 | + | SELECT id, 'youtube' as 'table' FROM `youtube` |
| 11 | - | WHERE `timestamp` LIKE '20120322%' |
| 11 | + | ORDER BY timestamp DESC |
| 12 | LIMIT 0, 15; |
