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 = 427
ORDER BY ordering ASC
ND5_0403
ND5_0407
ND5_0410
ND5_0411
ND5_0413
ND5_0417
ND5_0422
ND5_0425
ND5_0429
ND5_0430
ND5_0434
ND5_0444
ND5_0445
ND5_0446
ND5_0454
ND5_0457
ND5_0461
ND5_0462
ND5_0463
ND5_0469
ND5_0474
ND5_0475
ND5_0476
ND5_0510
ND5_0521
ND5_0540