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 = 425
ORDER BY ordering ASC
1
ND5_0548
ND5_0558
ND5_0563
ND5_0589
ND5_0594
ND5_0643
ND5_0644
ND5_0647
ND5_0649
ND5_0705
ND5_0712
ND5_0714
ND5_0731
ND5_0732
ND5_0733
ND5_0735
ND5_0739
ND5_0748
ND5_0772
ND5_0782