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 = 421
ORDER BY ordering ASC
ND5_2093
ND5_1915
ND5_1920
ND5_1930
ND5_1935
ND5_1948
ND5_1963
ND5_1965
ND5_1968
ND5_1986
ND5_1999
ND5_2006
ND5_2010
ND5_2012
ND5_2015
ND5_2022
ND5_2024
ND5_2030
ND5_2038
ND5_2041
ND5_2050