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 = 422
ORDER BY ordering ASC
ND5_0124
ND5_0001
ND5_0007
ND5_0011
ND5_0015
ND5_0023
ND5_0030
ND5_0040
ND5_0042
ND5_0049
ND5_0053
ND5_0062
ND5_0067
ND5_0072
ND5_0073
ND5_0076
ND5_0077
ND5_0115
ND5_0120
ND5_0121
ND5_0122