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(10939564,10939593,10939650,10939712,10939713,10939714,10939715,10939716,10939724,10939748,10939875,10939947,10939950,10939970,10939971,10939981,10939982,10939993,10940000,10940039,10940040,10940041,10940042,10940043,10940044,10940069,4970666,10940106,10940107,4970706,4970741,10940168,10940169,10940170,10940174,10940193,10940194,10940197,10940200,4970835,10940259,10940260,10940261,10940262,10940263,10940269,10940270,10940271,10940276,4970872,10940279,10940283,10940287,10940289,10940290,10940348,4970960,4971060,10940472,10940493,10940516,4968341,4968616,4968654,4968655,4968656,4968657,4968658,4968659,4968660,4968661,4968662,4968663,4968859,4968860,4969192,4969509,4969510,4969511,4969512,4969615,8075128,8075129,8075130,8075131,8075132,8075133,8075134,8075135,8075136,8075137,8075138,8075139,8075140,8075141,8075142,8075143,8075144,8075145,8075146,8075147,8075148,8075171,8075172,8075173,8075174,8075175,8075176,8075177,8075178,8075179,8075180,8075181,8075182,8075183,8075184,8075185,8075186,8075187,8075188,8075189,8075190,8075191,8075217,4967030,4967031,4967112,4967113,4967114,4967115,4967116,4967117,4967118,4967119,4967120,4967121,4967122,4967123,4967124,4967125,4967126,4967127,4967128,4967129,4967130,4967131,4967132,4967133,4967134,4967135,4967136,4967137,4967138,4967139,4967140,4967599,4968060,4968061,4968062,4968064,4968065,4968066,4968070,4968072,4968073,8073670,8073671,8073672,8073673,8073674,8073675,8073676,8073677,8073678,8073679,8073680,8073681,8073682,8073683,8073684,8073685,8073686,8073687,8073688,8073689,8073690,8073691,8073692,8073693,8073694,8073695,8073696,8073697,8073698,8073699,8073700,8073701,8073702,8073703,8073704,8073705,8073706,8073707,8073708,8073709,8073710,8073711,8073712,8073713,8073714,8073715,8073716,8073717,8073718,8073719,8073720,8073721,8073722,8073723,8073724,8073725,8073726,8073727,8073728,8073729,8073730,8073731,8073732,8073733,8073734,8073735,8073736,8073737,8073738,8073739,8073740,8073741,8073742,8073743,8073744,8073745,8073746,8073747,8073748,8073749,8073750,8073751,8073752,8073753,8073754,8073755,8073756,8073757,8073758,8073759,8073760,8073761,8073762,8073763,8073764,8073765,8073766,8073767,8073768,8073769,8073770,8073771,8073772,8073773,8073774,8073775,8073776,8073777,8073778,8073779,8073780,8073781,8073782,8073783,8073784,8073785,8073786,8073787,8073788,8073789,8073790,8073791,8073792,8073793,8073794,8073795,8073796,8073797,8073798,8073799,8073800,8073801,8073802,8073803,8073804,8073805,8073806,8073807,8073808,8073809,8073810,8073811,8073812,8073813,8073814,8073815,8073816,8073817,8073818,8073819,8073820,8073821,8073822,8073823,8073824,8073825,8073826,8073827,8073828,8073829,8073830,8073831,8073832,8073833,8073834,8073835,8073836,8073837,8073838,8073839,8073840,8073841,8073842,8073843,8073844,8073845,8073846,8073847,8073848,8073849,8073850,8073851,8073852,8073853,8073854,8072368,8072369,8072370,8072371,8072372,8072373,8072374,8072432,8072708,8072709,8072710,8072711,8072712,8073547,8073548,8073549,8073550,8073551,8073648,8073649,8073650,8073651,8073652,8073653,8073654,8073655,8073656,8073657,8073658,8073659,8073660,8073661,8073662,8073663,8073664,8073665,8073666,8073667,8073668,8073669,10623190,10623405,10623567,10623569,10623636,10623656,10623658,10623835,10623867,10624238,10624434,10624832,10624833,10624834,10624835,10624836,10621997,10621998,10621999,10622004,10622005,10622006,10622024,10622025,10622028,10622040,10622041,10622044,10622047,10622054,10622059,10622067,10622072,10622073,10622077,10622083,10622090,10622104,10622105,10622123,10622125,10622127,10622196,10622228,10622229,10622230,10622231,10622232,10622274,10622399,10622450,10622645,10622646,10622647,10622648,10622649,10622650,10622651,10622652,10622653,10622654,10622655,10622750,10622888,10622900,10622903,10622924,10620010,10620073,10620218,10620237,10620247,10620301,10620323,10620339,10620375,10620379,10620388,10620389,10620393,10620404,10620405,10620420,10620425,10620426,10620453,10620454,10620455,10620456,10620490,10620492,10620501,10620505,10620506,10620509,10620531,10620539,10620540,10620655,10620688,10620689,10620690,10620876,10620877,10620878,10620881,10620882,10620883,10620884,10620885,10620886,10620887,10620888,10620893,10620894,10620897,10621121,10621122,10621129,10621150,10621243,10621262,10621268,10621278,10621286,10621297,10621307,10621308,10621309,10621335,10621336,10621357,10621358,10621362,10621363,10621364,10621365,10621366,10621384,10621385,10621389,10621397,10621411,10621414,10621415,10621417,10621418,10621442,10621449,10621455,10621457,10621466,10621467,10621468,10621474,10621476,10621485,10621486,10621487,10621488,10621493,10621507,10621512,10621515,10621534,10621544,10621567,10621656,10621657,10621659,10621660,10621673,10621690,10621707,10621708,10621709,10621719,10621725,10621733,10621744,10565189,10565193,10565194,10565195,10565331,10565332,10565333,10565338,10565339,10565340,10565341,10565342,10565608,10565609,10565610,10565611,10565612,10565613,10565614,10565615,10565616,10565617,10565618,10565619,10565620,10565621,10565622,10565623,10565624,10565625,10565626,10565627,10565628,10565629,10565630,10565631,10565632,10565633,10565634,10565635,10565636,10565637,10565638,10565639,10565640,10565641,10565642,10565643,10565644,10565645,10565646,10565647,10565648,10566037,10566038,10566087,10563427,10563584,10563585,10563603,10563604,10563685,10563686,10563687,10563688,10563689,10563690,10563691,10563692,10563700,10563793,10563806,10563807,10563808,10563809,10563810,10563811,10563812,10563813,10563814,10563815,10563816,10563817,10563818,10563819,10563820,10563821,10563924,10563925,10563926,10563927,10563928,10563929,10563930,10563931,10563932,10563933,10563934,10563935,10564011,10564012,10564028,10564130,10564131,10564132,10564133,10564134,10564135,10564136,10564137,10564138,10564139,10564140,10564141,10564142,10564143,10564144,10564145,10564153,10564414,10564433,10564447,10564507,10564508,10564509,10564510,10564511,10564512,10564513,10564514,10564515,10564516,10564517,10564518,10564519,10564520,10564521,10564522,10564523,10564524,10564525,10564526,10564527,10564528,10564529,10564530,10564531,10564532,10564533,10564534,10564535,10564536,10564537,10564538,10564539,10564540,10564541,10564542,10564543,10564544,10564545,10564546,10564547,10564548,10564549,10564550,10564551,10564552,10564553,10564554,10564555,10564556,10564557,10564558,10564559,10564560,10564561,10564562,10564563,10564564,10564565,10564566,10564567,10564568,10564569,10564570,10564571,10564572,10564573,10564574,10564575,10564576,10564577,10564578,10564579,10564580,10564581,10564582,10564583,10564584,10564585,10564586,10564587,10564588,10564589,10564590,10564591,10564592,10517248,10517249,10517272,10517276,10517284,10517683,10517684,10517950,10517951,10517952,10517953,10517954,10517955,10517956,10517957,10518046,10518047,10518048,10518049,10518050,10518051,10518052,10518053,10518054,10518055,10518056,10518057,10518058,10518059,10518060,10518061,10518062,10518063,10518064,10518065,10518066,10518067,10518068,10518069,10518070,10518071,10518072,10518073,10518074,10518914,10518915,10518916,10518917,10518918,10518919,10518920,10518921,10518922,10518923,10518924,10518925,10518926,10518927,10518928,10518929,10419246,10419247,10419272,10419320,10419339,10419341,10419347,10419370,10419378,10419381,10419385,10419436,10419500,10419535,10419545,10419580,10419668,10419669,10419670,10419673,10419674,10419675,10419676,10419677,10419678,10419680,10419681,10419683,10419686,10419690,10419691,10419692,10419699,10419700,10419703,10419731,10419778,10419796,10419813,10419824,10419827,10419828,10419901,10419902,10419917,10419921,10419923,10419925,10419936,10419937,10419942,10419944,10419998,10420036,10420099,10420105,10420106,10420109,10420110,10420136,10420150,10420151,10420152,10420153,10420154,10420155,10420156,10420157,10420158,10420159,10420160,10420161,10420162,10420163,10420164,10420165,10420166,10420167,10420168,10420169,10420170,10420171,10420172,10420173,10420174,10420175,10420176,10420177,10420178,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420192,10420200,10420202,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10471023,10471032,10471090,10471183,10471184,10471195,10471215,10471265,10471456,10471479,10471487,10471488,10471532,10471533,10471534,10471535,10471536,10471584,10471585,10471590,10471591,10471592,10471649,10471650,10471651,10471652,10471653,10471654,10471746,10471777,10471778,10471779,10471800,10471809,10471837,10471845,10471853,10471858,10471872,10469996,10469997,10469998,10469999,10470000,10470094,10470113,10470121,10470122,10470124,10470218,10470240,10470272,10470286,10470679,10470778) 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'