SELECT c.* FROM cms_module_products c WHERE c.status = 'published' ORDER BY ph.sort_order asc LIMIT 0, 100000
Unknown column 'ph.sort_order' in 'order clause'