advanced
search

Error performing query: Column 'SizeInMB' in order clause is ambiguous

SELECT * FROM `reviews` LEFT JOIN `app` ON `app`.`appleID` = `reviews`.`appleID` LEFT OUTER JOIN ( SELECT AVG( rating ) AS userRatig, reviewID AS mytemp1, COUNT( reviewID ) AS VoteCount FROM `user_ratings` GROUP BY reviewID ) AS userRate ON userRate.mytemp1 = reviews.id WHERE published=1 AND `reviews`.`DateOfReview` <= (NOW()) ORDER BY `SizeInMB` ASC LIMIT 0,6

error