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 = 208
ORDER BY ordering ASC
DSC_6750
DSC_6618
DSC_6625
DSC_6639
DSC_6642
DSC_6643
DSC_6650
DSC_6656
DSC_6662
DSC_6668
DSC_6679
DSC_6680
DSC_6687
DSC_6688
DSC_6693
DSC_6695
DSC_6697
DSC_6700
DSC_6701
DSC_6708
DSC_6710
DSC_6714
DSC_6719
DSC_6734
DSC_6736
DSC_6744
DSC_6747
DSC_6861
DSC_6869
DSC_6907
DSC_7081
DSC_7087
DSC_7092
DSC_7095
DSC_7100
DSC_7104
DSC_7115
DSC_7118
DSC_7126
DSC_7129
DSC_6758
DSC_6761
DSC_6765
DSC_6768
DSC_6770
DSC_6774
DSC_6778
DSC_6791
DSC_6794
DSC_6820
DSC_6839