The Meanest Man in the World

SELECT c.id AS k, c.id AS v FROM bway_bww.columntable c, bway_bww.columncat cc WHERE  c.showinfolink = 317150 AND c.status=1 AND cc.colid=c.id AND cc.catid=3 ORDER BY c.dateposted desc