SELECT product_id FROM relation_master where `type`='subcat' and `type_id`='129'rteselect * from product_master where product_status = 'publish' and product_id IN (289642,289624,289878,289877,289879,290596,293128,293101,293100,293099,293098,293097,293096,293095,293093,293085,293073,293040,293029,292997,292982,285213,292949,292935,292885,292854,292853,290636,290635,292813,292804,292798,292797,292760,292666,292665,292655,292649,292599,292524,292523,292489,292455,292439,292414,292397,292387,292371,292352,292351,292328,292317,292238,292237,292187,292157,292156,292155,292141,290820,290809,290804,290798,290743,290720,290717,292122,292108,292096,292089,292057,292013,292012,292003,292002,291978,291969,290875,290869,291380,291392,291388,291381,292530,291141,291125,290730,291078,291061,290974,290963,290946,290941,290940,290899,290888,291260,291248,291247,291235,291224,291223,291321,291950,291313,291286,291285,291591,291568,290703,291497,291408,291405,291404,291284,291465,291448,291920,291877,291606,291636,291620,291797,291761,291689,291688,311962,311937,311911,311813,311862,311836,311856,311854,311850,311802,312249,312355,312292,312304,312299,312389,312632,312651,312685,312431,313172,313071,313092,313051,313214,312746,312997,312411,314841,313127,313418,313401,314252,313314,313794,312545,314578,314886,313305,313304,313217,313167,313209,314836,314805,313445,314676,314683,314716,314692,314124,312709,314496,313788,313768,313763,313762,313847,313836,313830,313696,312509,313678,313659,314112,313652,313647,313644,313640,314521,313615,313603,314465,314516,314670,313460,313555,313518,313517,313507,313494,313478,313475,312443,314420,314668,312484,314377,312436,314508,314506,314505,314357,314170,314157,313957,313881,313880,314039,313909,313894,314249,314290,314317,303408,314096,314193,314531,314296,312604,313990,312481,313989,324199,278106,278119,278134,278175,278176,278178,278207,278342,278344,278350,278378,278510,278515,278519,278520,278521,278522,278592,278677,278613,278615,278621,278622,278623,278673,278679,278688,278718,278737,278749,278757,278852,278853,278891,278893,278894,278908,278951,278995,279098,279100,279166,279168,279176,279204,279205,279223,279237,279241,279247,279289,279313,279325,279335,279336,279337,279338,279339,279340,279341,279343,279345,279346,279347,279349,300693,279391,279200,279099,279418,279453,279474,279475,279482,279499,279597,279598,279599,279609,279614,279710,279715,279716,279779,279784,279798,279802,279803,279804,279806,279816,279817,279818,279826,279941,279956,280001,280014,280015,280016,280017,280018,280019,280020,280021,280022,280078,280079,280082,280110,280226,280228,280308,280309,280310,280311,280401,280409,280475,280476,280477,280478,280479,280480,280487,280506,280521,280535,280604,280605,280678,280683,280684,280693,280739,280754,280755,280789,280863,280898,280929,280930,280931,280932,280964,280988,280993,281097,281105,281119,281126,281129,281178,281179,281180,281181,281182,281183,281184,281185,281186,281188,281199,281202,281203,281243,281244,281245,281246,281247,281248,281314,281315,281325,281370,281385,281493,281494,281497,281498,281501,281503,281504,281505,281514,281526,281571,281604,281612,281615,281616,281688,281711,281712,281716,281723,281763,281765,281766,281767,281838,281841,281853,281944,281955,281956,281957,281958,281989,281990,282020,282083,282084,282091,282092,282139,282187,282188,282568,282228,282292,282315,282326,282403,282404,282405,282406,282410,282463,282528,282583,282584,282585,282612,282614,282718,282767,282777,282789,282849,282861,282862,282863,282864,282865,282867,282890,282912,282934,282935,282936,282937,282938,282939,282950,283005,283007,283008,283010,283053,283056,283158,283163,283165,283186,283191,283340,283385,283403,283418,283469,283471,283483,283546,283564,283567,283568,283570,283600,283632,283678,283698,283712,283714,283719,283731,283736,283741,283767,283798,283812,283815,283838,283850,283860,283915,283924,283953,283973,283975,284056,284091,284094,284095,284158,284185,284212,284222,284230,284232,284241,284253,284255,284259,284261,284263,284272,284313,284334,284358,284364,284414,284415,284416,284455,284461,284488,284545,284559,284580,284581,284582,284616,284643,284654,284660,284840,284853,284855,284874,284912,284913,284914,284915,284925,284927,284929,284932,284934,284935,284948,284963,284966,285062,285072,285089,285090,285091,285092,285093,285094,285095,285096,285097,285098,285100,285103,285104,285106,285107,285109,285111,285113,285116,285120,285159,285160,285163,285164,285178,285226,285242,285244,285294,285309,285319,285345,285347,285349,285350,285351,285400,285423,285424,285432,285459,285490,285491,285561,285562,285563,285565,285566,285567,285591,285653,285661,285662,285663,285690,285691,285708,285750,285783,285797,285807,285808,285809,285810,285811,285831,285841,285842,285848,285849,285887,285920,285933,285949,285954,285955,285974,285990,285993,286022,286055,286056,286066,286141,286142,286144,286167,286210,286212,286224,286246,286289,286290,286291,286292,286293,286294,286295,286296,286297,286312,286370,286371,286406,286407,286443,286509,286512,286516,286525,286526,286527,286528,286529,286530,286531,286532,286565,286571,286592,286593,286594,286595,286596,286635,286636,286637,286638,286639,286640,286641,286642,286643,286689,286710,286726,286746,286747,286748,286749,286750,286751,286752,286754,286755,286791,286792,286797,286798,286799,286800,286801,286802,286803,286804,286805,286806,286807,286825,286832,286853,286854,286954,286958,286959,286960,286964,286965,286990,287013,287021,287028,287029,287030,287034,287061,287062,287084,287107,287108,287109,287110,287160,287179,287180,287181,287182,287183,287184,287185,287189,287193,287194,287204,287205,287206,287207,287208,287212,287213,287219,287239,287240,287252,287253,287256,287264,287269,287270,287286,287291,287292,287293,287294,287314,287316,287327,287359,287360,287361,287369,287374,287375,287376,287377,287378,287379,287380,287381,287382,287383,287384,287385,287386,287387,287388,287389,287390,287391,287392,287400,287401,287403,287414,287439,287460,287461,287462,287464,287466,287474,287476,287515,287539,287559,287592,287593,287594,287595,287613,287614,287632,287633,287634,287635,287646,287663,287664,287665,287666,287667,287668,287669,287670,287671,287693,287699,287728,287738,287746,287756,287757,287759,287760,287795,287808,287809,287822,287840,287841,287883,287894,287920,287938,287952,287965,288004,288005,288008,288009,288025,288026,288027,288028,288094,288096,288097,288098,288099,288105,288108,288109,288113,288114,288116,288148,288167,288170,288171,288173,288189,288190,288205,288217,288219,288220,288221,288222,288254,288282,288296,288297,288298,288299,288300,288301,288302,288303,288304,288310,288356,288385,288396,288413,288419,288420,288421,288422,288432,288476,288481,288482,288493,288509,296827,288537,288538,288539,288540,288541,288542,288543,288566,288602,288621,288661,288662,288663,288664,288665,288666,288667,288668,288669,288673,288674,288684,288685,288686,288687,323728,288696,288716,288767,288785,288786,288787,288788,288789,288790,288791,288801,288856,288857,288858,288874,288875,288886,288902,288903,288905,288949,288950,288988,288990,289012,289018,289019,289020,289021,289026,289040,289041,289057,289062,289112,289116,289133,289134,289144,289175,289176,289177,289178,289179,289180,289182,289219,289221,289239,289274,289275,289300,289313,289323,289328,289329,289351,289354,289355,289377,289420,289445,289467,289481,289495,289502,289525,289529,289577,289582,289583,289587,289598,289707,289708,289719,289720,289721,289733,289781,289789,289799,289800,289810,289813,289814,289815,289816,289837,289847,289928,289929,289930,289970,289991,289999,290000,290001,290002,290003,290013,290014,290015,290039,290074,290088,290125,290127,290130,290136,290137,290164,290165,290172,290204,290251,290260,290288,290290,290303,290306,290312,290314,290383,290384,290420,290438,290439,290440,290468,290475,290487,290488,290550,290562,290564,290595,290599,290614,294342,293240,293250,293255,293267,293276,293320,293322,293351,293352,293353,293354,293358,293396,293397,293402,293433,293440,293449,293477,293480,293486,293494,293496,293501,293520,293529,293547,293548,293579,293601,293623,293632,293653,293654,293684,293691,293699,293700,293704,293760,293769,293780,293782,293784,293785,293811,293813,293828,293852,293853,293856,293860,293886,293892,293906,293918,293972,293974,293976,294012,294052,294053,294062,294063,294067,294081,294091,294108,294109,294248,294249,294252,294259,294300,294305,294344,294355,294361,294399,294404,294409,294425,294426,294451,294460,294462,294471,294472,294475,294486,294489,294508,294522,313961,294545,294546,294554,294580,294585,294609,294672,294678,294683,294747,294758,294770,294805,294807,294815,294816,294852,294859,294860,294872,294941,294942,294949,294977,294980,294991,294992,295035,295037,295071,295089,295097,295138,295149,295150,295152,295200,295245,295267,295297,295300,295322,295324,295336,295337,295357,295367,295402,295450,295496,295513,295561,295583,295592,295595,295604,295611,295630,295668,295762,295768,295769,295808,295809,295853,295854,295855,295866,295875,295884,295943,295948,295975,295976,296048,296049,296073,296074,296105,296137,296155,296156,296165,296170,296172,296176,296244,296279,296285,296300,296312,296318,296354,296355,296377,296384,296415,296428,296450,296455,296470,296472,296476,296526,296545,296604,296616,296623,296691,296705,291471,296790,296800,296822,296830,296851,296910,296916,296926,296933,296992,296995,296996,296998,297010,297066,297072,297073,297104,297113,297136,317427,297138,297139,297196,297197,297227,297293,297385,297386,297391,297425,297477,297500,297510,297513,297554,297555,297586,297593,297620,297634,297637,297720,297729,297788,297860,297861,297862,297990,298051,298062,298063,298111,298153,298170,298185,298186,298222,298237,298253,298254,298255,298256,298319,298360,298398,298421,298444,298480,298481,298551,298557,298587,298616,298622,298631,298632,298710,298797,298798,298826,298913,298924,298930,298936,298943,298951,298952,298953,299006,299013,299047,299079,299084,299090,299219,299229,299230,299316,299346,279344,299402,299410,299429,299448,299478,299492,299497,299519,299547,299549,299574,299609,299617,299682,299687,299707,299737,299743,299744,299802,299810,299846,299883,299884,299902,299925,299934,299935,299996,300011,300015,300021,300030,300040,300044,300045,300050,300058,300059,300061,300063,300066,300135,300152,300179,300241,300264,300285,300424,300434,300438,300441,300448,300460,300461,300536,300539,300546,300548,300555,300579,286828,300587,300592,300606,300649,300666,300717,300720,300721,300724,300725,300781,300836,300849,300861,300908,300917,300971,300989,300991,300992,301009,301055,301115,301129,301150,301192,301196,301199,301213,301241,301258,301314,301332,301334,301337,301371,301388,301398,301457,301479,301649,301709,301719,301721,301758,301769,301771,301778,301780,301787,301803,301846,301855,301907,301996,302005,302054,302058,302060,300296,302133,302140,302150,302250,302259,302286,302328,302333,302337,302342,302382,302383,302416,302429,302453,302498,302499,302514,302517,302518,302539,302553,302559,302578,302631,302651,302652,302653,302665,302685,302709,302710,302719,302727,302732,302750,302788,302833,302834,302842,302888,302889,302904,302933,302958,302963,302964,302988,303037,303045,303046,303060,303144,303171,303185,303198,303231,303249,303262,303304,303325,303354,303378,303381,303417,303418,303425,303430,303436,303481,303525,303609,303614,303663,303686,303687,303699,303707,303727,303729,303731,303737,303740,303747,303748,303808,303816,303821,303859,303871,303879,303880,303897,303905,303954,303957,304001,304002,304016,304017,304039,304048,304058,304070,304071,304084,304121,304125,304126,304129,304130,304148,304192,304195,304222,304246,304247,304258,304262,304331,304332,304369,304402,304420,304544,304552,304566,304653,304654,304658,304662,304711,304723,304820,304826,304870,304922,304935,304957,304961,304974,305069,305118,305119,305120,305123,305196,305199,305243,305244,305305,305307,305329,305335,305341,305343,305344,305360,305388,305389,305391,305394,305441,305445,305449,305468,305487,305510,305518,305526,305550,305569,305600,305607,305636,305638,305643,305648,305651,305652,305670,305684,305697,305701,305702,305709,305747,305755,305768,305780,305794,305828,305829,305836,305845,305849,305854,305880,305883,305917,305918,305919,305927,305967,306012,306014,306093,306111,306126,306129,306154,306166,306180,306188,306190,306212,306222,306223,306239,306240,306247,306275,306298,306320,306331,306336,306352,306368,306416,306432,306442,306446,306447,306463,306477,306478,306481,306503,306541,306567,306569,306570,306579,306580,306627,306631,306632,306635,306639,306664,306674,306675,306695,306697,306698,306707,306708,306723,306733,306745,306746,306747,306753,306764,306820,306830,306832,306833,306836,306839,306843,306855,306864,306905,306923,306929,306943,306944,306963,306971,306973,306985,306986,306991,307013,307014,307015,307027,307059,307061,307064,307067,307070,307085,307092,307105,307132,307133,307134,307164,307181,307220,307278,307279,307280,307288,307290,307293,307301,307306,307307,307308,307325,307326,307357,307363,307367,307368,307400,307402,307406,307419,307422,307438,307439,307446,307456,307457,307458,307462,307479,307524,307528,307538,307544,307557,307564,307572,307589,307595,307601,307627,307655,315327,307665,307668,307673,307675,307684,307692,307699,307701,307720,307727,307751,307752,307756,307767,307777,307783,307795,307815,307837,307839,307840,307844,307848,307851,307852,307866,307870,307878,307879,307903,307915,307916,307928,307933,307942,307964,307966,307969,307970,307994,308004,308015,308019,308031,308042,308063,308066,315326,308070,308101,308115,308122,308131,308136,308169,308178,308199,308201,308218,308225,308228,308257,308279,308290,308291,308292,308293,308294,308295,308299,308325,308328,308364,308370,308377,308379,308380,308388,308405,308449,308453,308457,308479,308481,308489,308504,308512,308513,308536,308547,308559,308565,308572,308574,308583,308608,308614,308619,308621,308655,308687,308692,308722,308726,308727,308730,308736,308737,308738,308779,308797,308798,308801,308808,308809,308810,308829,308838,308849,308892,308895,308910,308912,308929,308947,308960,308961,308977,308982,309085,309104,309141,309148,309149,309167,309202,309217,309227,309290,309293,309351,309372,309435,309450,309467,309483,309606,309607,309618,309619,309630,309699,309710,309718,309746,309755,309777,309785,309812,309823,309916,309954,309983,309993,310043,310052,310065,310100,310112,310114,310133,310157,310174,310176,310227,310304,310412,310480,310482,310532,310540,310673,310680,318891,310740,310741,310767,310826,310858,310863,310994,311004,311010,311037,311074,311075,311156,311160,311197,311215,311229,311313,311318,311381,311400,311429,311477,311490,311517,311524,311544,311552,311555,311573,311593,311660,311703,311758,311777,311788,311798,312019,312044,312046,312159,312165,312187,312222,312225,312806,312843,312866,312872,312904,312909,312910,312911,312933,314898,314960,314980,315011,315125,315143,315154,315195,321345,315223,315231,315257,315272,315382,315419,315478,315479,315522,315536,315565,315567,315636,315637,315659,315661,315705,315755,315759,315818,315821,315823,315883,315929,316043,316046,316176,316236,316355,316364,316366,316395,316459,316477,316504,316517,316528,316557,316564,316637,316709,316745,316746,316787,316789,316836,316907,316913,316975,317015,317033,317053,317084,317235,317238,317239,317241,317243,317245,317247,323733,317405,317425,317429,317529,317530,317537,317639,317703,317706,317950,324432,318095,318139,318227,318240,318287,318302,318341,318375,318383,318409,318454,318459,318469,318488,318511,318538,318564,318586,318610,318614,318677,318684,318692,318730,318757,318831,318838,318840,318915,318921,318993,319018,319054,319064,319101,319108,319111,319157,319205,319232,319243,319253,319273,319280,323731,323730,319305,319334,319344,319358,319390,319455,319462,319469,319510,319511,319556,319557,319569,319584,319609,319610,319683,319713,319716,319723,319745,319779,319783,319795,319818,319835,319841,319879,319939,320010,320021,320028,320128,320139,320223,320285,320294,320345,320350,320359,320395,320409,320419,320479,320495,320520,320627,320628,320629,320630,320631,320632,320633,320634,320635,320636,320637,320638,320639,320641,320642,320644,320645,320646,320647,320649,320669,320670,320673,320697,320746,320751,320765,320785,320790,320804,320820,320914,320938,320945,320960,320985,320990,321057,321061,321140,321152,321199,321236,321240,321241,321244,321301,321336,321338,302519,321362,321367,321385,321412,321413,321420,321466,321472,321488,321491,321510,321511,321524,321538,321543,321553,321558,321619,321622,321640,321673,321682,321699,321724,321763,321772,321781,321822,321826,321830,321871,321888,321892,321896,321899,321900,321923,321926,321951,321952,321963,321976,321978,321979,322022,322034,322049,322052,322069,322080,322082,322111,322148,322162,322164,322201,322203,322252,322256,322257,322328,322348,322350,322387,322413,322441,322456,322508,322545,322549,322582,322583,322590,322596,322624,324398,322664,322666,322667,322668,322685,322701,322725,322726,322745,322778,322783,322793,322842,322855,322857,322859,322861,322882,322894,322931,322947,322978,322987,323018,323047,323049,323068,323076,323085,323104,323117,323131,323144,323145,323147,323184,323187,323209,323229,323232,323235,323239,323258,323260,323331,323332,323394,323405,323426,323431,323439,323463,323467,323472,323494,323510,323512,323514,323516,323517,323518,323519,323579,323594,323650,323687,323692,323723,323736,323737,323738,323739,323740,323741,323749,323758,323759,323787,323829,323848,323885,323915,323929,323931,323946,323963,323967,323979,323986,323996,324011,324024,324046,324061,324062,324077,324122,324127,324158,324177,324182,324212,324231,324269,324275,324281,324295,324342,324344,324351,324360,324366,324374,324377,324392,324401,324475,324497,324503,324521,324539,324545,324550,324561,324568,324575,324579,324580,324604,324606,324607,324613,324681,324683,324684,324702,324706) order by product_push_to_top_date DESC LIMIT 1100, 20jhgjg