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 = 431
ORDER BY ordering ASC
ND5_1409
ND5_1411
ND5_1412
ND5_1417
ND5_1422
ND5_1425
ND5_1430
ND5_1437
ND5_1438
ND5_1440
ND5_1443