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 = 103
ORDER BY ordering ASC
DSC01
_DSC02
_DSC03
_DSC04
_DSC05
_DSC06
_DSC07
_DSC08
_DSC09
_DSC10
_DSC11
_DSC12
_DSC13
_DSC14
_DSC15
_DSC16
_DSC17
_DSC18
_DSC19
_DSC20
_DSC21
_DSC22
_DSC23
_DSC24
_DSC25
_DSC26
_DSC27