The White Chrysanthemum 1905

-------

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

-------