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(8068817,8068818,8068819,8068821,10939611,10939612,10939616,8068885,8068886,8068887,10943433,10943622,10943625,10939895,10943775,10939979,10943859,10943933,10944083,10940334,8066949,8066965,8066966,8066976,8067157,10437244,8067425,8067431,8067447,8067448,8067451,8067452,8067453,8067461,8067477,8067479,10437556,10437626,10437627,10437628,10437629,10938479,4969252,4969253,4969254,4969255,4969256,4969257,4969258,4969259,4969260,4969261,4969262,4969263,4969264,4969265,4969266,4969267,4969268,4969269,8067931,10938722,4969547,4969570,10939098,10939099,8068597,8065174,8065175,8065176,8075324,8065765,8065766,4967055,8065959,8065960,8065961,8065962,8065963,8065964,8065965,8065966,8065971,8065972,8065973,8065974,8065975,8065992,8065993,8065994,8065995,8065996,8065997,8065998,8066004,8066005,8066033,8066034,8066035,8066036,8066037,8066038,8066039,8066095,8066101,10932729,10932949,8066589,8066626,4968029,4968030,4968031,4968032,8066861,3655525,3655792,3655810,3655811,3655812,3655813,3655971,3655972,3655973,3655974,3655975,3655988,3655989,3655990,3656087,3656088,3656089,3656094,3656144,3656151,3656187,3656201,8072644,8072649,8072654,8072659,8072664,8072669,8072674,8072679,8072684,8072689,8072694,8072699,8072704,8072709,8072714,8072719,8072724,8072729,8072734,8072739,8072744,8072749,8072754,8072759,8072764,8072769,8072774,8072779,8072784,8072789,8072797,8072805,8072813,8072821,8072829,8072837,8072849,8072857,8072869,8072877,3656716,8072887,8072893,8072905,8072913,8072921,8072928,8072939,8072946,8072954,8072962,8072970,8072978,3656951,8073473,8073482,8073484,8073486,10623102,10623103,10623198,10623502,10623582,10621990,10621991,10917508,10917509,10622016,10622017,10917529,10622021,10622022,10622027,10917538,10917549,10917560,10917561,10917562,10622053,10622058,10917591,10917592,10622098,10917610,10917613,10622103,10917629,10917691,10917727,10917752,10917818,10917855,10917976,10917990,10622881,10622882,10622883,10622884,10622902,10622903,10622904,10622905,10915472,10915477,10915478,10915479,10915480,10915481,10915482,10915498,10915499,10915502,10915508,10915519,10915520,10915521,10915523,10915524,10915525,10915526,10915531,10915532,10915533,10915534,10915537,10915538,10915539,10915546,10915547,10915548,10915549,10915550,10915557,10915559,10915560,10915565,10915566,10915567,10915568,10915569,10915570,10915577,10915578,10915579,10915580,10915581,10915585,10915586,10915587,10915588,10915592,10915593,10915594,10915595,10915596,10915597,10915600,10915601,10915602,10915606,10915607,10915608,10915609,10915620,10915621,10915622,10915623,10915626,10915627,10915628,10915629,10915630,10915631,10915634,10915635,10915636,10915637,10915638,10915639,10915640,10915641,10915642,10915652,10915653,10915654,10915655,10915656,10915663,10915664,10915665,10915671,10915672,10915673,10915678,10915679,10915681,10915682,10915689,10915690,10915691,10915692,10915693,10915701,10915702,10915703,10915706,10915712,10915713,10915714,10915721,10915722,10915723,10915734,10915735,10915736,10915737,10915738,10620237,10915751,10915756,10915757,10915758,10915759,10915760,10915770,10915772,10915773,10915778,10915779,10915781,10915782,10915783,10915786,10915787,10915788,10915793,10915794,10915795,10915796,10915797,10915798,10915804,10915805,10915806,10915807,10915808,10915809,10915816,10915817,10915818,10915824,10915826,10915827,10915828,10915829,10915833,10915838,10915839,10915840,10915842,10915843,10915844,10915845,10915860,10915861,10915862,10915863,10915868,10915869,10915875,10915878,10915879,10915880,10915881,10915883,10915888,10915889,10915890,10915891,10915892,10915898,10915901,10915902,10915903,10915904,10620395,10620396,10915907,10915908,10915909,10915910,10915911,10915912,10915913,10915919,10915920,10915921,10915922,10915926,10915927,10915928,10915934,10915935,10915936,10915940,10915941,10915942,10915943,10915944,10915945,10915951,10915952,10915973,10915974,10915975,10915976,10915980,10915984,10915985,10915986,10915987,10915990,10915991,10915996,10916000,10916007,10916008,10916009,10916010,10916011,10916012,10916014,10916017,10916018,10916021,10916024,10916025,10916026,10916027,10916028,10916029,10916039,10916065,10916067,10916068,10916073,10916074,10916075,10916085,10916086,10916102,10916103,10916114,10916115,10916116,10916117,10916121,10916122,10916123,10916124,10916142,10916149,10916152,10916153,10916160,10916161,10916162,10916163,10916169,10916170,10916176,10916177,10916181,10916182,10916183,10916184,10916185,10916187,10916194,10916195,10916196,10916197,10916198,10916205,10916206,10916209,10916215,10916222,10916223,10916224,10916225,10916228,10916229,10916230,10916231,10916234,10916235,10916236,10916237,10916238,10916239,10916242,10916243,10916244,10916245,10916253,10916254,10916255,10916256,10916257,10916261,10916262,10916263,10916264,10916265,10916272,10916273,10916274,10916279,10916280,10916283,10916284,10916285,10916286,10916287,10916288,10916289,10916290,10916291,10916299,10916300,10916305,10916310,10916311,10916312,10916318,10916319,10916320,10916321,10916322,10916323,10916332,10916333,10916338,10916339,10916344,10916345,10916346,10916347,10916348,10916352,10916353,10916354,10916355,10916361,10916362,10916365,10916366,10916368,10916369,10916370,10916371,10916372,10916373,10916374,10916375,10916378,10916379,10916380,10916381,10916393,10916394,10916395,10916396,10916397,10916403,10916404,10916405,10916414,10916421,10916423,10916425,10916426,10916429,10916440,10916441,10916445,10916446,10916447,10916448,10916454,10916455,10916471,10916472,10916473,10916474,10916479,10916480,10916488,10916489,10916490,10916491,10916492,10916493,10916494,10916518,10916519,10916524,10916525,10916526,10916527,10916528,10916529,10916532,10916539,10916540,10916541,10916542,10916543,10916549,10916550,10916551,10916552,10916557,10916558,10916559,10916560,10916561,10916565,10916569,10916570,10916571,10916578,10916579,10916580,10916581,10916582,10916583,10916584,10916585,10916586,10916593,10916594,10916599,10916600,10916601,10916602,10916603,10916604,10916605,10916614,10916615,10916616,10916617,10916618,10916622,10916623,10916624,10916625,10916627,10916628,10916629,10916630,10916631,10916641,10916642,10916643,10916644,10916645,10916646,10916647,10916650,10916660,10916661,10916662,10916670,10916672,10916674,10916676,10916677,10916678,10916687,10916688,10916689,10916691,10916692,10916693,10916694,10916695,10916696,10916699,10916700,10916701,10916702,10916707,10916711,10916712,10916713,10916714,10916724,10916726,10916728,10916729,10916730,10916731,10916736,10916737,10916738,10916747,10916748,10916750,10916751,10916752,10916753,10916757,10916770,10916771,10916772,10916774,10916775,10916780,10916781,10916782,10916783,10916794,10916799,10916806,10916807,10916808,10916809,10916810,10916816,10916817,10916818,10916819,10916820,10916828,10916829,10916830,10916844,10916845,10916848,10916851,10916862,10916863,10916864,10916865,10916871,10916872,10916873,10916878,10916883,10916884,10916885,10916889,10916890,10916900,10916904,10916905,10916908,10916909,10916910,10916911,10916912,10916913,10916915,10916931,10916932,10916938,10916939,10916940,10916941,10916942,10916943,10916944,10916950,10916956,10916957,10916958,10916959,10916960,10916961,10916962,10916971,10916976,10916977,10916980,10916981,10916982,10916983,10916988,10916989,10916996,10916997,10917003,10917004,10917012,10917015,10917017,10917018,10917019,10621510,10917020,10917026,10621535,10917046,10621536,10917047,10917051,10917053,10917057,10917060,10917066,10917071,10917099,10917117,10917135,10917136,10917137,10917147,10917148,10917153,10917158,10917165,10917172,10917175,10917180,10917181,10917182,10917183,10917184,10917196,10917220,10917221,10917238,10917249,10917250,10917251,10917252,10917256,10917264,10917265,10917268,10917275,10917286,10917287,10917299,10917303,10917310,10917318,10917323,10917324,10917325,10917326,10917332,10917334,10917348,10917359,10917362,10917388,10917389,10917390,10917406,10917441,10565129,10565130,10565171,10565329,10611179,10565330,10611224,10611225,10611242,10611245,10611699,10611700,10611701,10611702,10611703,10611705,10611706,10611707,10566100,10566101,10563450,10563452,10563453,10563454,10563457,10609307,10563459,10563460,10563461,10563462,10563463,10563464,10563465,10563466,10563467,10609327,10609375,10563542,10609717,10610001,10610002,10610003,10610004,10610005,10610075,10610175,10610176,10610177,10610178,10610180,10610181,10610182,10610272,10610274,10610280,10610343,10610344,10610361,10610415,10610478,10564991,10610842,10564995,10517287,10517288,10517552,10517650,10517651,10517652,10517653,10517656,10517660,10517661,10517662,10517663,10517664,10517665,10517666,10517667,10517668,10415410,10415429,10415471,10471229,10471460,10463679,10463680,10463681,10463682,10463683,10463684,10463685,10462295,10462296,10462297,10462298,10462299,10462300,10462301,10462368) 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'