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 = 426
ORDER BY ordering ASC
ND5_0973
ND5_0986
ND5_0993
ND5_0996
ND5_0998
ND5_1007
ND5_1011
ND5_1015
ND5_1017
ND5_1018
ND5_1020
ND5_1029
ND5_1059
ND5_1062
ND5_1063
ND5_1065
ND5_1072
ND5_1076
ND5_1088
ND5_1090
ND5_1093
ND5_1100
ND5_1103
ND5_1119