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 = 429
ORDER BY ordering ASC
ND5_1163
ND5_1167
ND5_1171
ND5_1184
ND5_1190
ND5_1192
ND5_1193
ND5_1195
ND5_1202
ND5_1203
ND5_1213
ND5_1275
ND5_1295
ND5_1303
ND5_1308
ND5_1309
ND5_1310