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 = 277
ORDER BY ordering ASC
20160706_092611
20160706_093404
20160706_103434
20160706_103444
20160706_123943
20160706_124928
20160706_124937
20160706_151911
20160706_151932
20160706_153346
20160706_154320
20160706_154349
20160706_160626
20160706_160702
20160706_163305
20160706_172854
20160706_172857