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 = 424
ORDER BY ordering ASC
ND5_1524
ND5_1529
ND5_1531
ND5_1533
ND5_1541
ND5_1542
ND5_1543
ND5_1549
ND5_1498
ND5_1499
ND5_1501
ND5_1504
ND5_1506
ND5_1509
ND5_1510
ND5_1519