CODE EXAMPLE FOR SQL

get item by composite primary key mysql

SELECT  *
FROM    games
WHERE   (platformid, genreid) = (1, 10)