31 - desc
| 14. |
| orderBy |
date_cr
|
| sorting |
desc
|
|
| 25. |
| orderBy |
date_cr
|
| sorting |
desc
|
|
| 27. |
| orderBy |
date_cr
|
| sorting |
desc
|
|
| 29. |
| orderBy |
date_cr
|
| sorting |
desc
|
|
| 31. |
| orderBy |
date_cr
|
| sorting |
desc
|
|
select distinct d.* FROM tx_dam d , tx_dam_mm_cat c WHERE c.uid_local=d.uid AND c.uid_foreign = 31 AND d.sys_language_uid=0 AND (d.language='' OR d.language='DE') AND d.media_type IN (2,0) AND d.hidden=0 AND d.deleted=0 AND sys_language_uid = 0 ORDER BY d.date_cr desc LIMIT 30,6
