8 - desc
| 6. |
| orderBy |
date_cr
|
| sorting |
desc
|
|
| 8. |
| orderBy |
date_cr
|
| sorting |
desc
|
|
| 10. |
| orderBy |
date_cr
|
| sorting |
desc
|
|
| 12. |
| 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 = 8 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 0,6
