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 = 430
ORDER BY ordering ASC
ND5_9857
ND5_9884
ND5_9885
ND5_9887
ND5_9888
ND5_9889
ND5_9890
ND5_9892
ND5_9897
ND5_9901
ND5_9902
ND5_9911
ND5_9914
ND5_9915
ND5_9918
ND5_9919
ND5_9920
ND5_9925
ND5_9926
ND5_9927
ND5_9934
ND5_9936
ND5_9940
ND5_9945
ND5_9946
ND5_9947
ND5_9948