Latest News: (loading..)

Nathek

Members
  • Content count

    1
  • Joined

  • Last visited

1 Follower

About Nathek

Profile Information

  • Real Name
    Jon
  1. Is there any better optimized way to achieve the WHERE IN query? c.categories_id in ('.$ids.') and It is super slow on sites with 1000s of products and makes ridiculously large queries. It also runs these queries many times per page load and just slows everything way down. Current Parse Time: 3.639 s with 46 queries And 16 of those queries are running the WHERE IN clause. Here is an example. select c.categories_id FROM products p, products_to_categories pc, categories c, categories_description cd WHERE p.products_id in (14967,14971,14965,13831,13851,13852,14959,8046,7519,14973,7277,7276,7275,7274,7972,7968,7970,7971,7116,7117,7119,7120,7121,7122,7123,7124,7125,7126,7687,7420,7419,11822,11821,10796,7333,7326,7295,9111,7172,12348,12351,12352,13806,13814,13815,13816,13817,13827,13835,13836,13854,13856,7900,7901,7909,7910,7911,7930,7967,7969,8055,8049,8048,8047,8032,8031,8015,8014,7978,7158,7132,7133,7134,7135,7140,7143,7144,7145,7146,7148,7149,7153,7154,7850,7740,7739,7738,7737,7736,7735,7717,7716,7715,7686,7633,7622,7621,7620,7619,7618,7617,7616,7615,7614,7610,7609,7608,7607,7606,7605,7583,7549,7550,7516,7512,7486,7487,7488,7471,7470,7467,7464,7465,7463,7460,7339,12053,11860,11664,7388,7387,7386,7385,7384,7383,7381,7382,7380,7364,7358,7357,7346,7347,7321,7311,7306,7305,7300,7296,7292,7288,7287,7286,7284,7285,7283,7281,7282,7280,7279,7263,7251,7252,7253,7254,7250,7249,7246,7245,7238,7239,7237,7231,7230,7226,7224,7222,7220,7219,7218,8392,7200,7198,7197,7196,7193,7192,7188,7187,7183,7182,7180,7179,7178,7177,7176,7173,7171,7170,7169,7168,7167,7166,7162,7161,7160,12345,12346,12347,12349,12350,12584,12585,12586,12587,12673,12674,12675,12676,12677,12902,13545,7958,13862,13863,13864,7189,7905,7904,7906,7902,7903,13891,13935,13936,13934,13998,14892,14893,14904,14905,14907,14908,14927,14926,14909,14903,14928,14925,13992,13993,14906,14886,14939,14940,14941,14942,14943,14945,14946,14948,14949,14951,14954,14955,15074,15082,15083,15076,7934,7150,7151,0,10070,9917,13628,12859,12644,11778,7129,7131,8365,8338,8145,7356,7355,7354,7353,7344,7345,13808,12337,12255,12338,7808,7580,7578,7581,7579,14891,7489,8060,8052,7931,13888,7137,13819,13820,7678,7567,7566,7564,7565,7569,7568,7329,7338,12679,15115,15116,15117,15123,15114,15113,15087,15088,15058,7477,7476,7475,7478,7634,12750,12739,12740,12166,12084,8485,8486,7096,7094,7093,7092,7087,7079,7082,7083,7084,7085,8483,8482,8481,8480,8479,8476,8468,8447,8446,8445,8431,8430,8429,8428,8425,8423,8420,8417,8412,8411,8410,8406,8407,8868,8867,8404,8400,8399,8387,8386,8385,15059,15050,15051,15052,15053,15055,15057,8235,15064,15060,8226,8225,8222,8221,8218,8217,8215,8214,15001,15002,15031,15032,15033,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,15013,15014,15015,15016,15017,15021,14999,15000,8170,15037,15038,15039,8156,8155,8153,8152,8151,8150,8147,8146,8144,8143,8141,8140,8139,8137,8138,8136,8134,8135,8132,8124,8118,8117,8112,8111,8110,8107,8105,8104,8103,8102,8101,8099,8100,8495,8098,8097,8096,8095,8094,8093,8092,8091,8090,8089,8088,8087,8086,8085,8084,8083,8082,8081,8075,8073,8059,8058,8057,8056,8001,7984,7982,7981,7974,7952,7925,7924,7919,7918,7917,7916,7915,7914,7913,7912,7907,7899,7898,7897,7896,7895,7894,7893,7892,7891,7890,7889,7888,7887,7886,7885,7884,7883,7882,7881,7880,7879,7878,7877,7876,7875,7874,7873,7872,7871,7870,7869,7868,7867,7866,7865,7864,7863,7862,7861,7860,7859,7858,7857,7856,7855,7854,7853,7852,7851,7849,7847,7846,7845,7844,7843,7842,7841,7840,7839,7838,7837,7836,7835,7834,7833,7832,7831,7830,7829,7828,7827,7826,15069,15070,15071,15072,15075,15041,15042,15043,15044,15045,7685,7659,7658,7657,7078,7076,7072,7073,7074,7613,7612,7064,7065,7595,7592,7062,7061,7060,7059,7057,7055,7054,7053,7052,7050,7048,7044,7040,7039,7038,7037,7036,7029,7028,7026,7025,7022,7017,7013,7011,7010,7004,7000,12851,12849,7582,7585,8862,8863,12847,12846,8896,12830,12829,12824,6992,6993,6995,6996,6997,7571,7570,7563,8860,8858,8857,8856,8855,8854,8851,8850,8849,8848,8846,8845,8842,8841,8839,8838,8834,8833,8832,8831,8830,8829,8828,8827,8825,8824,8823,8816,8815,8812,8811,8810,8808,8807,8806,8805,8800,8799,8798,8797,8796,8795,12812,12806,12798,12796,12795,12794,12793,12792,12789,12788,12784,7490,12771,12765,12760,12756,12755,12754,12753,12751,12749,12743,12742,12738,12737,12736,12735,12734,12733,12732,12731,12730,12729,12728,12727,12725,12724,12715,12713,12710,12708,12707,12706,12697,12695,12652,12651,12650,12649,12640,12638,12637,12634,12633,12632,12631,12630,12628,12626,12620,12619,12616,12615,12614,12612,12609,12608,12607,12606,12605,12604,12603,12602,12601,12600,12598,12597,12596,12595,12594,12593,12592,12591,12528,12519,12518,12517,12515,12514,12512,12511,12509,12508,12507,12506,12505,12502,12497,12496,12492,12491,12490,12489,12488,12487,12486,12483,12482,12481,12480,12479,12478,12477,12476,7458,7459,12474,12471,12467,12465,12460,12457,12434,7457,7454,7455,7456,12428,12427,12426,7451,7452,7453,7448,7449,7450,12328,12313,12305,12294,12293,12292,12291,12290,12276,12275,12262,12261,12257,12254,12252,12247,12246,12243,12242,12241,12240,12238,12237,12236,12235,12233,12228,12227,12226,12223,12222,12219,12218,12217,12216,12188,12182,12179,12178,12177,12176,12174,12173,12163,12162,12157,12156,12155,12154,12153,12149,12148,12147,12146,12145,12142,12139,12138,12137,12136,12133,12117,12116,12115,12110,12109,12102,12097,12096,12094,12092,12091,12090,12088,12085,12079,12078,12076,13978,12071,12070,12069,12058,12055,12054,12052,12050,12046,12044,12042,12037,12036,12035,12034,12033,12032,12031,12030,12028,12027,12026,12025,12024,12023,12022,12019,12017,12011,12010,12003,12001,12000,11998,11997,11996,11995,11989,11988,11982,11981,11978,11971,11970,11969,11967,11966,11965,11964,11963,11962,11961,11959,11958,11956,11955,11953,11952,11951,11950,11949,11948,11947,11944,11943,11942,11938,11935,11934,11929,11928,11927,11926,11925,11924,11923,11922,11921,11920,11919,11918,11917,11916,11915,11914,11913,11912,11911,11910,11907,11896,11894,11893,11892,11891,11890,11889,11885,11881,11880,11879,11878,11877,11873,11872,11870,11868,11859,11856,11854,11849,11847,11846,11845,11841,11840,11839,11838,11836,11835,11834,11833,11832,11831,11830,11829,11828,11827,11826,11825,11824,11823,11820,11819,11818,11817,11816,11815,11814,11813,11812,11811,11810,11809,11808,11807,11806,11805,11804,11803,11802,11801,11800,11799,11798,11797,11796,11794,11788,11787,11786,11785,11784,11777,11776,11775,11774,11773,11772,11771,11770,11769,11762,11761,11760,11759,11758,11757,11756,11755,11754,11753,11748,11747,11746,11745,11743,11742,11741,11740,11739,11738,11737,11736,11733,11732,11730,11729,11727,11723,11722,11721,11720,11714,11713,11712,11710,11708,11707,11705,11704,11703,11702,11701,11700,11699,11698,11697,11696,14985,11694,11693,11692,11691,11690,11689,11688,11687,11686,11683,11682,11680,11676,11675,11674,11673,11672,11671,11669,11668,11667,11658,11657,11656,11655,11654,11653,11652,11651,11650,11649,11648,11646,11644,11643,11642,11641,11639,11638,11637,11635,11634,7446,7447,11633,11632,11631,11630,11629,11628,11627,11626,11625,11624,11623,11622,11621,11620,11619,11618,11617,11616,11615,11614,11613,11612,11611,11610,11609,11608,11607,11606,11605,11604,11603,11602,11601,11600,11599,11598,11597,11596,11595,11594,11593,11592,11590,11589,11588,11587,11586,11585,11584,11583,11582,11581,11580,11579,11578,11577,11576,11575,11574,11573,11572,11571,11570,11548,11542,11539,11537,11534,11533,11531,11526,11522,11521,11520,11519,11518,11507,11506,11505,11503,11489,7445,7444,7443,7442,7441,7439,7440,7435,7436,7437,11475,11461,11451,11445,11444,11443,11442,11441,11440,11437,11436,11433,11430,11427,11426,11424,11422,11416,7422,7423,11414,11412,11411,11410,11409,11408,11407,11406,11405,7421,7416,7417,11404,11403,11402,7414,7415,11401,11400,11399,11397,11396,11395,11393,11392,11391,11390,11388,11363,11362,11361,11360,11357,11354,11350,11349,11348,11347,11346,11344,11338,11337,11336,11335,11334,11333,11331,11330,11322,11321,11320,11319,11306,11305,11303,11299,11298,11297,11296,11295,11292,11291,11290,11289,11288,11287,11286,11282,11281,11279,11278,11270,11267,11255,11254,11230,11198,11136,11124,11080,11057,11053,11049,11046,11045,11044,11043,11042,11041,11040,11038,11037,11036,11034,11033,11032,11031,11030,11028,11027,11023,11006,11005,11003,11002,11000,10999,10996,10995,10992,10990,10989,10988,10983,10981,10980,10979,10974,10973,10968,10967,10965,10962,10961,10960,10959,10955,10954,10952,10950,10949,10946,10943,10942,10934,10933,10927,10920,10915,10904,10903,10900,10899,10898,10897,10896,10894,10887,10886,10885,10884,10877,10876,10872,10871,10869,10868,10866,10865,8864,8866,10860,10852,10851,10849,10848,10837,10835,10825,10821,10818,10817,10814,10813,10792,10791,10786,10785,10763,10760,14997,14998,10753,10746,10745,10744,10742,10741,10740,10738,10731,10713,10708,10688,10687,10681,10680,10678,14996,10654,10653,10634,10633,10631,10628,10627,10626,10625,10624,10623,10622,10621,10620,10619,10618,10617,10616,10615,10614,10613,10612,10610,10609,10608,10606,10605,10604,10603,10602,10600,10598,10597,10596,10594,10592,10591,10588,10583,10582,10581,10580,10577,10576,10574,10573,10571,10570,10569,10568,10567,10566,10564,10560,10559,10558,7396,7393,10555,10554,10553,10548,10540,10533,10529,10528,10514,10513,10511,14993,10499,10493,10489,10488,7389,7378,7379,10463,10459,10452,10451,10450,10448,10447,10445,10444,10443,10442,10441,10440,10439,10438,10437,10435,10434,10433,10432,10431,10429,10427,10426,10425,10422,10421,10420,10419,10413,10411,10408,10407,10406,10405,10403,10398,10396,10395,10394,10393,10392,10391,7377,7374,7375,7376,10373,10371,10370,7371,10367,10366,10365,10357,10355,10354,10353,10352,10351,10350,10347,10346,10336,10335,10332,10330,10325,10323,10318,10315,10313,10312,10311,10310,10309,10308,10306,10305,10304,10303,10300,10299,10292,10291,10289,10287,10286,10285,10284,10283,10282,10281,10280,10279,10278,10277,10276,10275,10270,10269,10268,10267,10263,10250,10248,10247,10237,10236,10234,10231,10230,10229,10228,10220,10217,10216,10215,10214,10213,10212,10209,10206,10205,10204,10188,10184,10173,10168,10167,10166,10165,10164,10163,10162,10161,10160,10159,10158,10157,10156,10155,10154,10153,10152,10151,10150,10149,10147,10144,8791,8790,8789,8787,8778,8781,8782,8783,8892,8891,8890,8888,8889,10123,8776,8772,8771,8770,8768,8764,8763,8762,8758,8759,10110,10107,10087,8755,8754,8752,8751,6988,6987,6986,6985,8884,10082,10081,8744,8742,8741,8731,8729,8730,8728,8724,8723,8719,8720,8722,10069,10068,10054,10044,10037,10036,10035,10010,10009,10003,9994,9993,9986,9964,9961,9957,9955,9953,9950,9948,9934,9928,9926,9909,9908,9905,9904,9887,9880,9879,9873,8717,8718,8881,8882,8883,9869,9867,9866,9865,9857,9854,9853,9851,9850,9843,9839,9836,9835,9833,9831,9828,9825,9819,9817,9816,9815,9809,9808,9807,9791,9786,9783,9782,9781,9780,9779,9778,9777,9776,9775,9774,9773,9772,9771,9770,9769,9768,9767,9766,9765,9764,9763,9762,9761,9760,9759,9758,9757,7370,7369,7368,7366,7367,9750,9748,9743,14937,9726,9725,9724,9722,9721,7365,9715,9713,9712,9711,9710,9708,9706,9702,9700,9689,7330,9682,9681,9675,9674,9669,9655,9642,9639,9636,9634,9630,9623,9622,9621,9618,9617,9616,9611,9608,9605,9601,9600,9588,9585,9584,9583,9580,9579,9578,9576,9575,9574,9573,9572,9571,9570,9565,9561,9558,9557,9556,9555,9554,9553,9552,9551,9550,9549,9548,7272,7268,7256,7257,7258,7255,8716,8715,8714,8713,8712,8711,8710,8709,8704,8702,8701,9539,9530,9529,9528,9527,9526,9525,7244,9524,9523,9521,9519,9518,9515,9514,9513,9509,9508,9507,9506,9505,9504,9502,9501,9500,9487,9485,9484,9472,9471,9464,9463,7240,7235,7236,7234,7232,7228,7227,7217,7213,7212,7209,7210,7211,9457,9456,9455,9453,9452,7204,7205,7206,7207,9439,9437,9434,9433,9426,9425,9422,9420,9418,9412,9411,9410,9409,9408,9407,9406,7203,7201,7199,9405,9404,9403,9396,9395,9393,9388,9385,9384,9383,9382,9381,9380,9377,9371,7194,9370,9369,9368,9367,9366,9365,9362,9359,9352,9351,9350,9348,9347,9346,9345,9343,8887,9341,9340,9339,9338,9337,9336,9335,9332,9331,9330,9329,9326,9324,9323,9322,9321,9320,9318,9317,9316,9315,9314,9313,9312,9311,9310,9309,9308,9306,9305,9304,9303,9302,9299,9298,9297,9296,9295,9294,9293,9290,9289,9288,9285,9284,9283,9282,9281,9280,9279,9278,9277,9274,9273,9272,9271,9270,9267,9266,9265,9264,9263,9262,9261,9260,9258,9257,9256,9255,9254,9253,9252,9251,9250,9249,9248,9247,9246,9245,9243,9242,9239,9238,9237,9236,9226,9225,9224,9223,9222,9221,9219,9218,9217,9216,9214,9212,9211,9210,9208,9207,9204,9203,9202,9201,9200,9195,9194,9192,9191,9186,9177,9175,9172,9171,9169,9167,9164,9163,9162,9157,9152,9151,9150,9149,9147,9146,9145,9144,9143,9142,9141,9140,9139,9131,9130,9129,9126,9125,9123,9122,9121,9120,9113,9112,9108,9103,9101,9100,9099,9098,9097,9096,9095,9092,9088,9087,9086,9085,9082,9081,9080,6967,9073,9072,7181,8653,8651,8650,8648,8880,8642,8639,8638,8631,8628,8627,8622,8621,8617,8615,8613,13977,8608,8607,8606,8605,8604,8603,8602,8600,8599,8598,8596,8597,8594,8593,8592,8591,8588,8586,8587,7175,7165,8585,8584,8583,8582,8581,8580,8579,8578,8571,8570,8568,8567,8566,8559,8557,8548,8547,8546,8545,8544,8543,8542,8541,8540,8539,8538,8537,8536,8535,8532,8534,9058,9057,9056,9055,9054,9053,9049,9047,7164,9044,9040,9039,8528,8527,8526,7156,7157,9032,9031,9030,9028,9027,9026,8873,8875,8876,9024,9023,9022,9021,9020,9019,9016,9015,9014,9013,9012,9011,9010,7155,7147,7142,7141,9005,7130,7128,7115,7114,7113,7112,7106,9004,8999,8998,8996,8995,7104,8872,8992,8988,8987,8986,8985,8984,8983,8982,8981,8980,8979,8978,8975,8974,8971,8969,8967,8965,8964,8524,8522,8521,8519,8518,8517,8508,8509,8510,8511,8512,8513,8514,8957,8956,8955,8953,8952,8951,8949,8948,8947,8944,8942,8941,8940,8939,8938,8937,8499,8504,8934,8936,8933,8932,8931,8930,8926,8927,8928,12874,12873,12872,12871,12870,12869,12868,12867,12866,8922,8924,8917,8918,8919,8920,8921,8907,8897,8898,8899,8900,8908,12875,12876,12877,12878,12879,12880,12882,12890,12891,12892,12898,14966,12907,12908,12909,12910,12911,12912,12914,12915,12918,12922,12924,12927,12931,12941,12943,12944,12945,12954,12956,12969,12970,12983,12988,12989,12991,12993,12998,13005,13006,13008,13009,13010,13014,13087,13088,13090,13093,13102,13103,13104,13106,13108,13117,13118,13119,13122,13125,13132,13133,13134,13135,13136,13137,13139,13140,13141,13142,13143,13149,13150,13151,13152,13153,13154,13155,13156,13157,13158,13161,13162,13164,13165,13174,13175,13177,13178,13179,13180,13181,13182,13184,13185,13186,13187,13188,13189,13192,13193,13194,13195,13196,13197,13200,13201,13202,13203,13204,13205,13209,13210,13211,13212,13237,13238,13239,13240,13241,13242,13243,13244,13245,13246,13247,13248,13249,13250,13251,13252,13255,13256,13257,13258,13259,13260,13261,13262,13263,13264,13265,13266,13267,13268,13279,13290,13291,13292,13293,13302,13303,13308,13310,13315,13316,13317,13318,13320,13321,13323,13324,13325,13326,13327,13328,13329,13330,13331,13332,13975,13976,13974,13972,13973,13971,13969,13970,13968,13967,13965,13342,13344,13346,13348,13349,13351,13352,13353,13355,13357,13358,13359,13360,13361,13362,13363,13364,13365,13367,13368,13370,13371,13372,13373,13374,13375,13376,13377,13378,13379,13380,13381,13382,13383,13384,13385,13386,13387,13388,13389,13390,13391,13392,13393,13394,13395,13396,13397,13398,13399,13400,13401,13402,13403,13404,13405,15036,15035,13409,13410,13411,13412,13413,13414,13415,14880,13417,13418,13419,13420,15049,13964,13962,13961,13428,13429,13441,13442,13443,13444,13445,13446,13447,13448,13449,13450,13451,13453,13454,13456,13457,14879,13459,13460,13462,13463,13464,13465,13466,13467,13468,13469,13470,13471,13472,13473,13474,14960,13476,13477,13478,13479,13480,13482,13483,13484,13485,13486,13487,13488,13489,13490,13491,13492,13493,13494,13495,13496,13497,13498,13499,13500,13501,13502,13503,13504,13505,13506,13508,13509,13539,13540,13543,13544,13546,13547,14878,13560,13561,13562,13563,13571,13582,13583,13584,13585,13586,13587,13608,13609,13610,13611,13612,13613,13615,13616,13618,13626,13627,13640,13641,13671,13672,13959,13957,13958,13683,13684,13687,13688,13689,13690,13691,13692,14958,13695,13696,13697,13698,13699,13700,13701,13702,13703,13705,13707,13708,13709,13710,13711,13712,13713,13717,13721,13722,13723,13724,13725,13726,13727,13728,13732,13733,13792,13793,13795,13799,13800,13801,13802,13803,13804,13805,13812,13818,15077,13825,13828,13837,13839,13840,13841,13844,13845,13846,13847,13848,13853,13859,13860,13865,13866,13867,13956,13980,13981,13966,13963,13960,13979,13884,15066,15067,13982,13983,13984,13985,13986,13988,13989,13990,13991,13994,13995,13996,13997,13999,14000,14001,14002,14003,14004,14005,14006,14007,14008,14009,14010,14011,14012,14013,14015,14016,14017,14018,14019,14020,14021,14022,14023,14024,14025,14026,14027,14028,14029,14030,14031,14032,14033,14034,14035,14036,14037,14038,14039,14040,14041,14042,14043,14044,14045,14046,14047,14048,14049,14050,14051,14052,14053,14054,14055,14056,14057,14058,14059,14060,14061,14062,14063,14064,14065,14066,14071,14072,14073,14074,14075,14076,14077,14078,14079,14080,14081,14082,14083,14084,14085,14086,14087,14088,14089,14090,14091,14092,14093,14094,14095,14096,14097,14098,14099,14100,14101,14102,14103,14104,14105,14106,14107,14108,14109,14110,14111,14112,14113,14114,14115,14116,14117,14118,14119,14120,14121,14122,14123,14125,14126,14127,14128,14129,14130,14131,14132,14133,14134,14135,14136,14137,14138,14139,14140,14141,14142,14143,14144,14145,14146,14147,14148,14149,14150,14151,14152,14153,14154,14155,14156,14157,14158,14159,14160,14163,14164,14165,14168,14172,14177,14178,14179,14180,14181,14182,14184,14188,14189,14190,14191,14192,14193,14194,14195,14196,14197,14198,14199,14200,14201,14202,14203,14204,14205,14206,14207,14208,14209,14210,14211,14212,14213,14214,14215,14216,14217,14218,14219,14220,14221,14222,14223,14224,14225,14226,14227,14228,14229,14230,14231,14232,14233,14234,14235,14236,14237,14238,14239,14240,14241,14242,14243,14244,14245,14246,14247,14248,14249,14250,14251,14252,14253,14254,14255,14256,14257,14258,14259,14260,14261,14262,14263,14264,14265,14266,14267,14268,14269,14270,14271,14272,14273,14274,14275,14276,14277,14278,14279,14280,14281,14282,14283,14284,14285,14286,14287,14288,14289,14290,14291,14292,14293,14294,14295,14296,14297,14298,14299,14300,14301,14302,14303,14304,14305,14306,14307,14308,14309,14310,14311,14312,14313,14314,14315,14316,14317,14318,14319,14320,14321,14322,14323,14324,14325,14326,14327,14328,14329,14330,14331,14332,14333,14334,14335,14336,14337,14338,14339,14340,14341,14342,14343,14344,14345,14346,14347,14348,14349,14350,14351,14352,14353,14354,14355,14356,14357,14358,14359,14360,14361,14362,14363,14364,14365,14366,14367,14368,14369,14370,14371,14372,14373,14374,14375,14376,14377,14378,14379,14380,14381,14382,14383,14384,14385,14386,14387,14388,14389,14390,14391,14392,14393,14394,14395,14396,14397,14398,14399,14400,14401,14402,14403,14404,14405,14406,14407,14408,14409,14410,14411,14412,14413,14414,14415,14416,14417,14418,14419,14420,14421,14422,14423,14424,14425,14426,14427,14428,14429,14430,14431,14432,14433,14434,14435,14436,14437,14438,14439,14440,14441,14442,14443,14444,14445,14446,14447,14448,14449,14450,14451,14452,14453,14454,14455,14456,14457,14458,14459,14460,14461,14462,14463,14464,14465,14466,14467,14468,14469,14470,14471,14472,14473,14474,14475,14476,14477,14478,14479,14480,14481,14482,14483,14484,14485,14486,14487,14488,14489,14490,14491,14492,14493,14494,14495,14496,14497,14498,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,14510,14511,14512,14513,14514,14515,14516,14517,14518,14519,14520,14521,14522,14523,14524,14525,14526,14527,14528,14529,14530,14531,14532,14533,14534,14535,14536,14537,14538,14539,14540,14541,14542,14543,14544,14545,14546,14547,14548,14549,14550,14551,14552,14553,14554,14555,14556,14557,14558,14559,14560,14561,14562,14563,14564,14565,14566,14567,14568,14569,14570,14571,14572,14573,14574,14575,14576,14577,14578,14579,14580,14581,14582,14583,14584,14585,14586,14587,14588,14589,14590,14591,14592,14593,14594,14595,14596,14597,14598,14599,14600,14601,14602,14603,14604,14605,14606,14607,14608,14609,14610,14611,14612,14613,14614,14615,14616,14617,14618,14619,14620,14621,14622,14623,14624,14625,14626,14627,14628,14629,14630,14631,14632,14633,14634,14635,14636,14637,14638,14639,14640,14641,14642,14643,14644,14645,14646,14647,14648,14649,14650,14651,14652,14653,14654,14655,14656,14657,14658,14659,14660,14661,14662,14663,14664,14665,14666,14667,14668,14669,14670,14671,14672,14673,14674,14675,14676,14677,14678,14679,14680,14681,14682,14683,14684,14685,14686,14687,14688,14689,14690,14691,14692,14693,14694,14695,14696,14697,14698,14699,14700,14701,14702,14703,14704,14705,14706,14707,14708,14709,14710,14711,14712,14713,14714,14715,14716,14717,14718,14719,14720,14721,14722,14723,14724,14725,14726,14727,14728,14729,14730,14731,14732,14733,14734,14735,14736,14737,14738,14739,14740,14741,14742,14743,14744,14745,14746,14747,14748,14749,14750,14751,14752,14753,14754,14755,14756,14757,14758,14759,14760,14761,14762,14763,14764,14765,14766,14767,14768,14769,14770,14771,14772,14773,14774,14775,14776,14777,14778,14779,14780,14781,14782,14783,14784,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,14800,14801,14802,14803,14804,14805,14806,14807,14808,14809,14810,14811,14812,14813,14814,14815,14816,14817,14818,14819,14820,14821,14822,14823,14824,14825,14826,14827,14828,14829,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,14863,14864,14865,14866,14867,14868,14869,14870,14871,14872,14873,14874,14875,14876,14877,15048,14938,14944,15110,15121,15132,15137,15139,15141,15142,15143,15144,15145,15146,15147,15148,15149,15150) and p.products_id = pc.products_id AND c.categories_id = pc.categories_id AND p.products_status = '1' AND c.categories_id = 33 AND c.categories_id = cd.categories_id AND cd.language_id = '1' LIMIT 1