select p.id from jos_bk_goods_category c,jos_bk_product p where c.category_id in (148,133,167,168,169,170,132,374,375,376,377,378,379,380,159,368,369,370,371,372,373,160,161,162,164,165,166,344,349,130,145,146,230,231,232,234,351,233,352,353,354,355,360,147,149,141,142,201,206,225,226,227,228,229,296,322,347,381,143,144,210,238,239,240,241,297,242,243,244,245,246,212,247,248,331,131,151,152,213,214,215,216,217,223,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,300,302,323,153,154,155,156,157,158,235,207,288,289,290,291,292,293,294,236,150,249,250,251,252,237,253,254,275,276,277,278,279,280,281,282,283,284,285,286,287,305,129,134,135,136,137,138,139,140,211,295,175,218,219,220,221,222,224,298,299,313,345,176,338,364,365,366,177,315,316,317,318,319,320,321,343,185,205,208,209,306,362,363,367,303,304,324,325,326,327,328,329,333,334,341,348,314,332,335,336,339,346,361) and p.node_id=c.node_id and p.id=27688