SELECT c.*, p.Platform, p.Url from App c join AppPlatform p on c.AppId = p.AppId where 1=1 and p.platform = :platform and c.apptype = :apptype ORDER BY c.appid DESC limit 0, 100
Try our new game.
More info