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(7067887,4970678,4970679,8574534,4970725,3228965,3228966,10989238,10989391,3229191,3229192,3229193,3229194,3229195,3229196,3229197,3229198,7066016,8583526,10950696,7066258,7066260,3229974,3229975,8575741,8575742,8575743,10990261,10990262,8575939,8067938,8067939,3227423,8573239,8573240,10939442,7201192,7201209,7201210,7201273,7201274,7201366,7201367,7201455,7201529,7201547,7201576,7201629,7201631,7201654,7201661,7201662,7201663,7201664,8835964,7201741,7201769,7201770,7201771,7201772,7201773,7201774,7201959,7201975,7202125,7202126,7202130,7202138,7202139,7202140,8911955,8911963,7202159,7202171,7202197,7202199,7202200,7202204,7202206,7202208,7202245,7202246,7202251,7202255,7202269,7202272,7202277,7202279,7202282,7202293,7202297,7202308,7202318,7202654,7202685,7202686,7202687,7202688,7202689,7202690,7202692,7202693,7202694,7202696,7202697,7202698,10933036,7200139,7200150,7200271,7200499,7200501,8834750,10958971,7200586,7200587,7200625,7200669,7200686,7200687,7200699,7200705,7200707,7200708,7200753,7200754,7200757,7200781,7200925,7198073,7198074,8615017,7198683,7198693,7198719,7198720,7198727,7198729,7198731,7198741,7198757,7198767,7198773,7199109,7199111,7199176,7199416,7199507,7199546,8073547,10958379,7200030,7200041,8905973,8905974,8905975,8905976,7196252,8612892,10618277,10618281,10623491,10623492,10623499,8906829,8906833,7197045,8906862,7197125,7197230,7197264,7197275,10838795,10838796,10838797,10838884,10838964,7197832,7197837,7197848,10619895,10619896,10616978,8904947,8904948,8905071,10617166,10617180,10617181,10617182,10617189,10617190,10617191,10617192,10617197,10617204,10617205,10617206,10617207,10617221,10617222,10617228,10617229,10617230,10617231,10617232,10617233,10617234,10617235,10617236,10617237,10617238,10617239,10617240,10617242,10617243,10617246,10617247,10617248,10617250,10617251,10617255,10617261,10617311,10617312,10617313,10617316,10617317,10617318,10617332,8905267,8905353,8905380,8905555,8905556,10954226,10954227,10954259,10954311,10954312,10954313,10954314,8905859,10615019,10615090,10615092,10615161,10615162,10615163,10615183,10615184,10615185,10615186,10615187,10615188,10615189,10615190,10615191,10615192,10615193,10615194,10615195,10615196,10615197,10615198,10615199,10615200,10615201,10615228,10615287,10615307,10615327,10615405,10615406,10615407,10615408,10615409,10615434,10615442,10615576,10615703,10615738,10615739,10615740,10615758,10615759,10615760,10615765,10615771,10615772,10615773,10615775,10615776,10615788,10615789,10615799,10615800,10615801,10615802,10615803,10615804,10615805,10615806,10615807,10615808,10615809,10615810,10615822,10615916,10615962,10615993,10615998,10616003,10616004,10616092,10426341,10616175,10426453,10426467,10426468,10426469,10426470,10426471,10426472,10426473,8540625,8904181,8904182,8540793,8540794,10616641,10616642,10616643,10616644,10616645,10616863,10616866,10616888,10616904,10616913,10616928,10611050,10614050,10611051,10611053,10611054,9205439,10611106,10611108,10611109,10611114,10611115,10614171,10614172,9165541,10614282,6669828,6669832,6669833,6669834,6669835,6669836,6669837,6669838,6669839,6669840,6669841,6669842,6669843,6669844,6669845,6669846,6669847,6669848,6669849,6669850,6669851,6669852,6669853,6669854,6669855,6669856,6669857,6669858,6669859,6669860,6669861,6669862,6669863,6669864,6669865,6669866,6669867,6669868,6669869,6669870,10614327,6669871,10614328,6669872,10614329,6669873,6669874,6669875,6669876,6669877,6669878,10611371,10611424,10614445,10614476,10614502,10559703,10614555,10559712,10614637,9166043,10614760,10611764,10611799,10611856,10614864,10611979,10611989,10608990,10608998,10609008,10609010,10609011,10609022,10612069,10609072,10609079,10612082,10612083,10609085,10609087,10609090,10609091,10609101,10612108,10612206,10612233,10609285,10612290,10609313,10609332,10609356,10609457,10609615,10612723,10612731,10612732,10612733,10612735,10612757,10612769,10609770,10609772,10612803,10612805,10609824,10612884,10612907,10612912,10612914,10612958,10609983,10609984,10609985,10609986,10609987,10610025,10613079,10613080,10613090,10610098,10610105,10610106,10610162,10610163,10610183,10610184,10610185,10610186,10610187,10610188,10613193,10613212,10613230,10610233,10610268,10610271,10613341,10613342,10613349,9204761,10613453,7018447,7018448,7018449,7018450,10613547,10613562,10613646,10613656,10613657,10610678,10610684,10610685,10610687,10610688,10610694,10610704,10610705,10613736,10610836,10610854,10117511,7055498,9169492,7055659,10117695,7055670,9169505,9169530,9169628,9169692,9169716,9169717,9169718,9169868,9169887,9169920,9169923,9169926,9169927,9169928,10118163,10118177,10118386,9178397,10118650,10118657,10118659,10118660,10118662,10118663,10118664,10416237,10416258,10419268,10419272,10419276,10419279,10419280,10419282,10417287,10417289,10417291,10417292,10416305,10416306,10416307,10419407,10419408,10417427,10419437,10419438,10419439,10419440,10419441,10419446,10419447,10419448,10419449,10419458,10419459,10419460,10419461,10419462,10419464,10419465,10415481,10419493,10416498,9168594,9168597,9168606,10417531,10417532,10417533,10417534,9168614,9168615,10419546,10419550,9168639,9168640,9168645,9168650,9168651,10415581,10419606,10419609,10419613,10419617,10419626,10419628,10419631,10417633,10419636,10419645,10417646,10415648,10415649,10415650,10415651,10415654,10419655,10415657,10415658,10415660,10415661,10415662,9168741,10419665,10419667,10416709,10416710,10416711,10416712,10416713,10416714,10416715,10416716,10416717,9168815,10415743,10418880,9169033,10417966,10417993,10417995,10417996,10420014,10420015,10420016,10420017,10420018,10418022,10418035,10117378,10117379,10117464,10117481,10117485,10467067,8549953,8550030,8550031,8550050,8550051,8550052,10467532,8550158,8550160,8550161,8550238,8550261,9167536,10470159,10470166,9167717,8551009,8551010,8551011,9167859,8551014,9167860,9167861,8551017,8551025,9175965,10116195,10116196,10116197,10116198,9168125,9168142,9168172,10184490,10184491,10184492,10883492,10184514,10184539,10184540,10184544,10184545,10184546,10184556,10184571,10184574,10184575,10184589,10184593,10184604,10883956,10884167,10884168,10884169,10884170,10884175,10884176,10884177,10884368,10884369,10884462,10879911,10879920,10874948,10874950,10885196,10885368,10885379,10885403,10885404,10885416,10885417,10877606,7000827,10882673,10163717,10882879,10882894,10882943,10883175,10883238,10883239,10883240,10161713,10161756,10630287,10161838,10161839,10161931,10162082,10162096,10162167,10882000,10882001,10882011,10882012,10882017,10882018,10882020,10882021,10882025,10882026,10882035,10877048,10877049,10877050,10877051,10877053,10877054,10877055,10877056,10877057,10877058,10877059,10877060,10877061,10877062,10877063,10877064,10877065,10877066,10877069,10877070,10877111,10877112,10877113,10882146,10877187,10877200,10877201,10877202,10877203,10877204,10877205,10877206,10877212,10877223,10877224,10877229,10877230,10877231,10877232,10882239,10882244,10882245,10877273,10877276,10877277,10877278,10877279,10877280,10877281,10877289,10877290,10877291,10877292,10877293,10882303,10882304,10882312,10882313,10882314,10882315,10882316,10882317,10882318,10882319,10882320,10877330,10877331,10877334,10877335,10877336,10877337,10877338,10877339,10877340,10877341,10877342,10877343,10877344,10877345,10877346,10877347,10877348,10877349,10877350,10877351,10877352,10877353,10877354,10877355,10877356,10877357,10877358,10877359,10877360,10877361,10877362,10877363,10877364,10877365,10877366,10877367,10877368,10877369,10877370,10877371,10882434,10877439,10877440,10877441,10521186,10421516,10421517,10421518,10421519,10421520,10421521,10421522,10421523,10421524,10421533,10490279,10490280,10490289,10490304,10490305,10494354,10494355,10494356,10494357,10473658,10477679,10477680,10477681,10477682,10477683,10477684,10477685,10477686,10490864,10490878,10490884,10490885,10490906,10490909,10490912,10490918,10490924,10490937,10490938,10490951,10490965,10490978,10490979,10491003,10491004,10491017,10491030,10491031,10491056,10491062,10491063,10491071,10491072,10491073,10491089,10491107,10491108,10491114,10491119,10491120,10491121,10491129,10489191,10489202,10489203,10489221,10489224,10489227,10489228,10474255,10474258,10474266,10474267,10474268,10474269,10474270,10474286,10474294,10474297,10474308,10474309,10474310,10474315,10474332,10474333,10474334,10474348,10474353,10474361,10474362,10474383,10474384,10474406,10474407,10474422,10474438,10474443,10474444,10474454,10474455,10474456,10474464,10474465,10474487,10474504,10474505,10474512,10472519,10472525,10474526,10472526,10474527,10472527,10472543,10472549,10472550,10472551,10474552,10474556,10474564,10474572,10474573,10474574,10474591,10474595,10474596,10474597,10474598,10474607) 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'