set sql_mode=''; select contents.title, contents.customurl from contents left join categorycontent on categorycontent.contentgroupid = contents.groupid where contents.publish='1' and categorycontent.categorygroupid<>'' order by contents.queue asc, contents.title asc