QUERY: SELECT
p.products_id,
p.products_model,
p.label_ids,
p.main_category,
p.products_ean,
p.products_fsk18,
p.products_quantity,
p.products_quantity_min,
p.products_quantity_step,
p.products_price,
p.products_price_small_opt,
p.products_price_opt,
p.products_purchase_price,
p.small_opt_purchase_price,
p.count_small_opt_purchase_price,
p.count_opt_purchase_price,
p.opt_purchase_price,
p.postavshik,
p.suplier_catalog_id,
p.postavshik_comment,
p.name_catalog_id,
p.products_tax_class_id,
p.products_image,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_currency,
p.products_page_url,
p.video,
p.show_video,
pd.products_short_description,
p.rev_total,
p.rev_rating,
pd.products_name,
p.products_ordered,
pd.products_short_description,
s.status,
IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
m.manufacturers_name,
m.manufacturers_id FROM products AS p
LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id)
LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN specials AS s on p.products_id = s.products_id
LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id)
LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '1' AND p.products_id IN(8838570,8838571,8838572,8838573,3228551,7068141,8621072,10939876,7068257,7068258,7068259,8621488,8621489,8621490,10950295,10940466,11041565,11041566,11041567,10963805,10847116,8622209,8575900,8575901,7074738,8576071,8576096,8576099,10974717,8067972,8067973,8067974,8067975,10929516,10929517,11039951,10929605,10498136,11040080,11040095,10988135,11040160,11040181,11040182,11040196,8068519,10930030,10930096,7075832,10998645,10998646,10998647,10998648,8835467,8835468,8835669,8835689,10843033,11037990,10843100,11038269,11038271,11038302,10973349,10973350,10973351,10973352,10973353,10932027,10973366,11038376,11038377,11038379,11038380,11038381,11038382,7202048,10932157,11038533,11038595,11038596,11038597,11038598,11038599,11038600,11038601,11038602,11038603,11038604,11038605,11038606,11038607,11038608,11038609,7202229,7202230,7202231,7202232,8618923,10843967,8066233,8066234,8066235,11039034,11039035,11000066,11000067,11000068,11000069,11000070,11000071,11000072,11039118,10497566,10497567,10497568,10497569,10497570,10497571,10497692,10984637,10984638,10984639,10984640,10984777,7200542,7200580,10842091,10102519,7200646,7200647,7200649,7200650,7200652,7200656,7200657,7200659,7200660,7200664,7200665,7200667,7200668,7200669,7200670,7200673,7200674,7200675,7200676,7200677,7200679,7200719,11049386,11049387,11049409,8910582,8910583,10943160,10959224,10842326,10102876,11037596,11037597,11037598,11037599,11009000,7069321,7198748,8615355,10957543,10957549,10957550,10957552,8072653,8072654,8072655,8072656,8072657,3236433,3236434,3236435,3236436,3236437,3236438,3236439,3236440,3236441,3236442,3236443,3236444,3236445,3236446,3236447,3236448,3236449,3236450,3236451,3236452,3236453,3236454,3236455,3236456,3236457,3236458,3236459,3236460,3236461,8615886,8564807,8616036,7199530,7199531,8565012,3236759,3236764,3236765,3236767,10101478,3236769,3236770,3236771,3236775,7070497,11036240,10841393,7200162,3237346,10993665,10993666,7196257,7196259,7196260,7196261,7196262,7196263,7196264,7196265,7196266,7196268,7196269,7196270,7196272,7196273,7196274,7196276,7196277,7196278,7196279,7196280,7196281,7196282,7196283,7196284,7196285,7196286,7196287,7196288,7196290,7196291,7196292,7196293,7196294,7196297,7196298,7196300,7196301,7196303,7196307,7196308,7196309,7196310,7196314,7196316,7196317,7196318,7196321,7196324,7196325,7196326,7196329,7196330,7196331,7196332,7196334,7196335,7196337,7196338,7196339,7196344,7196345,7196348,7196349,7196350,7196351,7196353,7196355,7196520,7196521,7196523,7196525,7196526,7196528,7196530,8906392,8906393,8906394,8906405,8906406,8906407,8906408,8906409,11046558,10838682,11046636,8907286,7197634,10839279,11008225,4938357,4938358,4938359,4938360,4938361,8614537,8614538,8614539,8614540,10617000,11005681,11005697,11005759,11005760,11005764,8611936,8905171,10836886,10836887,10622280,10622282,11045147,11045148,11045149,10993409,10993410,11006453,11006455,3233243,8612730,10620106,10951836,3230666,8570380,10952040,11004199,11004206,11004207,11004208,10620552,10620553,10620554,10926088,10926089,10926090,10926091,10926092,10926093,10425942,10425943,3230999,11004286,10926199,11004355,3231093,11004366,11004367,11004368,11004369,11004370,11004371,11004372,11004373,10926333,11004484,11004485,11004561,11004567,11004635,11004636,11004637,11004719,3231468,3231469,3231470,3231471,3231472,3231473,3231474,11004771,11004885,11004886,10621247,10621248,10621249,10621250,11004914,11004915,11004916,11004917,11004918,11004919,11004920,11004921,8904334,8904335,8904341,8904342,8904372,8904375,8904376,8904377,11005081,11005082,10426805,10426806,10426807,10426808,10426809,10616510,10979180,10616522,11005191,8611357,10426893,10426894,11005312,11005313,11005314,11005315,11005316,11005317,11005318,11005319,11005328,11005329,11005330,11005331,11005332,11005333,11005334,11005335,11005336,11005337,8541221,11005496,11005497,11005498,11005499,11005500,11005533,11005534,11005591,11005592,8541432,10922457,6677661,6677662,6677670,6677746,6677871,6677872,6677956,6677957,6677958,6677959,6677960,6677976,6677977,6677978,6677979,6677980,10611521,6678122,6678123,6678124,6678130,6678201,10614664,3962376,6678271,6678340,6678341,6678342,9166139,6678356,6678357,6678358,6678359,6678360,6678361,6678362,7019858,7019859,7019860,7019861,7019862,7019863,7019864,7019865,7019866,7019867,7019868,7019869,7019870,7019871,9198225,9198259,6678478,6678479,6678480,6678481,6678482,6678483,6678484,6678485,6678486,6678487,6678488,9214283,10612414,7058144,7058147,7058148,6676292,9196099,9172175,9172176,10612848,10120474,10120475,8862961,9172443,7026110,7026111,7026112,7026113,7026114,7026115,7026116,7026117,7026118,7026119,7026120,10613301,10613434,8863315,10121006,7018715,7018716,7018717,7018718,7018719,7018720,7018721,7018722,7018723,7018724,7018725,7018726,7018727,7018728,7018729,7018730,7018731,7018732,7018733,7018734,7018735,7018736,7018737,7018738,7018739,7018740,7018741,10610775,10515124,10117744,10117745,10117746,10117747,9170041,10118391,10118392,10118407,7023883,7023884,7023885,7023886,7023887,7023888,7023889,7023890,7023891,7023892,7023893,7023894,7023895,7023896,10118541,10118542,9170626,9210698,9186768,9186799,9186801,7024563,9178910,9178911,9171192,9171193,9171201,10418252,9192338,9192342,9192549,9192550,9168758,10418694,10420104,10125458,10125461,10125468,10125472,9198316,8864869,8864925,8864927,8864928,7020101,7020102,7020103,7020104,7020105,7020106,7020107,7020108,7020109,7020110,7020111,7020112,7020113,7020114,7020115,7020116,7020117,8865003,9206597,9206601,9206605,7020411,9190826,8916778,6667193,9175221,9175222,9175223,9175224,9175225,9175226,9175227,9175228,9175229,9175230,9175231,9175232,9175233,9175234,9175235,9175236,9175237,9175238,9175239,9175240,9175241,9175242,9175243,9175244,9175245,9175246,9175247,9175248,9175249,9175250,9175251,9175252,9207252,9175253,9175254,9175255,9175256,9175257,9175258,9175259,9175260,9175261,9175262,9175263,9175264,9175265,9175266,9175267,9175268,4972148,4972149,4972150,9191336,9191337,10123546,9183354,10115678,10115681,10115682,9207555,9191564,9207710,9207712,9207723,9207748,9191762,9191792,6667791,9191805,9191806,9191807,9191808,9191809,9191810,8550979,8550980,9175850,9207872,9207897,9168022,9208038,9208039,9208040,9208042,10470727,10462729,9192232,9192233,7013895,7013896,7013937,7013938,10888553,10628091,10628092,10883613,10888614,10888615,10883618,10883619,10883628,10883635,8593647,10883649,10883661,10174713,10174716,10174717,10174772,10174773,10174776,10174777,10174778,10174779,10174780,10174781,10174782,10628313,10628324,10174858,10628501,10884065,8594252,10628800,10884593,10186148,10156270,10885398,10882500,10158857,10158910,7001115,7001116,10153992,10153993,10878022,10883152,10888200,10888204,10888205,10888206,10888207,10888208,10630070,10885952,10949130,10891335,10631014,10626154,10173244,10168286,10168287,10168288,10945239,10580376,10601379,10601382,10601383,10583772,10583773,10583774,10583775,10583776,10583777,10583778,10583779,10583780,10583781,10583782,10583783,10583784,10583785,10583786,10583787,10583788,10583789,10583790,10583791,10583792,10583793,10583794,10583795,10583796,10583797,10583798,10583799,10583800,10583801,10583802,10583803,10583804,10583805,10583806,10583807,10583808,10583809,10583810,10583811,10567354,10567355,10645558,10529345,10529346,10529347,10529348,10529349,10529350,10529351,10543410,10543411,10527759,10544495,10544496,10544497,10544498,10544499,10544500,10544501,10544502,10544503,10544504,10544505,10544506,10544507,10536619,10544845,10544846,10544847,10544848,10544849,10544850,10544851,10544852,10544853,10544854,10544855,10544856,10544857,10544858,10544859,10544860,10544861,10544862,10544863,10544864,10544865,10544866,10544867,10544868,10544869,10544870,10544871,10544872,10544873,10544874,10544875,10544876,10544877,10544878,10544879,10544880,10544881,10544882,10544883,10544884,10544885,10544886,10544887,10544888,10544889,10545036,10545037,10545038,10545039,10545040,10545041,10545042,10545043,10545044,10545045,10545046,10545047,10545048,10545049,10545050,10545051,10545052,10545053,10545054,10545055,10545056,10545057,10545058,10545059,10545060,10545061,10545062,10545063,10545064,10545065,10545066,10545067,10545068,10545069,10545070,10545071,10545072,10545073,10545074,10545075,10545076,10545077,10545078,10545079,10545080,10545081,10545082,10420677,10423962,10421087,10479135,10494679,10481892,10481902,10481903,10481912,10481913,10481929,10497024,10497034,10497036,10497042,10497050,10497341,10497344,10497345,10497346,10478403,10478406) GROUP BY p.products_id ORDER BY CASE WHEN products_price = 0 THEN 99999999 WHEN products_price > 0 THEN products_price END asc ,p.products_specials desc
ERROR: Unknown column 'p.products_specials' in 'order clause'