SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,c.title AS parent_title
FROM mnss_djmt_albums AS a
LEFT JOIN mnss_djmt_albums AS c ON c.id = a.parent_id
WHERE a.published = 1 AND a.visible = 1 AND a.parent_id = 420
ORDER BY ordering ASC
ND5_0957
ND5_0809
ND5_0816
ND5_0818
ND5_0820
ND5_0822
ND5_0831
ND5_0835
ND5_0841
ND5_0848
ND5_0854
ND5_0867
ND5_0881
ND5_0885
ND5_0888
ND5_0903
ND5_0912
ND5_0917
ND5_0920
ND5_0921
ND5_0922
ND5_0950
ND5_0952
ND5_0955
ND5_0956