38 - desc

10.	orderBy date_cr sorting desc
11.	orderBy date_cr sorting desc
12.	orderBy date_cr sorting desc
13.	orderBy date_cr sorting desc
38.	orderBy date_cr sorting desc
5.	orderBy date_cr sorting desc
6.	orderBy date_cr sorting desc
7.	orderBy date_cr sorting desc
8.	orderBy date_cr sorting desc
40.	orderBy date_cr sorting desc
4.	orderBy date_cr sorting desc
9.	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 = 38 AND d.sys_language_uid=0 AND (d.language='' OR d.language='DE') AND d.media_type IN (1,12) AND d.hidden=0 AND d.deleted=0 AND sys_language_uid = 0 ORDER BY d.date_cr desc LIMIT 0,8