You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'hospitalId ASC  
                                                LIMIT 20' at line 8<br><b>Query: </b><i>SELECT hospitals.*,companies.name companyName,AVG(ratings.rating) hospitalRating
                                                FROM c4p_hospitals hospitals 
                                                JOIN c4p_companies companies USING(companyId) 
                                                LEFT JOIN `c4p_ratings` ratings USING(hospitalId)  
                                                WHERE  hospitals.status = 1 AND hospitals.companyId = 4 
                                                GROUP BY hospitalId 
                                                
                                                ORDER BY ,hospitalId ASC  
                                                LIMIT 20</i>