SELECT CONCAT( LPAD( fe_users.uid, 4, '0' ), LPAD( tx_rtgcreator_pages.uid, 6, '0' ) ),
	tx_rtgcreator_pages.uid AS p_uid, fe_users.uid AS u_uid
FROM tx_rtgcreator_pages
LEFT JOIN tx_rtgcreator_templates ON tx_rtgcreator_pages.uid_template = tx_rtgcreator_templates.uid
LEFT JOIN fe_users ON tx_rtgcreator_pages.uid_feuser = fe_users.uid
WHERE tx_rtgcreator_pages.deleted =0
AND tx_rtgcreator_pages.hidden =0
ORDER BY tx_rtgcreator_pages.date_from DESC

Výsledok

0001000049 49 1
0001000048 48 1
0015000047 47 15
0015000046 46 15

SQL kód vystrihne názov súboru z URL:

SELECT pn_url, 
	REVERSE( pn_url ) AS rev, 
	LOCATE('/', REVERSE( pn_url )) As loc, 
	REVERSE(SUBSTRING(REVERSE( pn_url ), 1, (LOCATE('/', REVERSE( pn_url ))) - 1)) AS file
FROM `nuke_downloads_downloads`

Výsledok