0select ref, gamerid, cost, totalcost, g.name, namefra, typecode2, color, type from MAGIC as m, gamer as g where serie=0 && id=gamerid && m.split_side<>"2" order by number,version limit 0,100