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(4970241,4970257,4970258,4970265,4970266,4970267,4970268,4970269,4970646,4970647,4970648,4970649,4970667,4970668,4970687,4970692,4970707,4970737,4970738,4970910,4970916,4970925,4970929,4971082,4968226,4968227,4968608,4968609,4968610,4968611,4968612,4968801,4968846,4968847,4968848,4968859,4968860,4968861,4968862,4969103,4969104,4969274,4969275,4969276,4969277,4969548,4969551,4969554,4969555,4969556,4969557,4969558,4969559,4969560,4969561,4969563,4969564,4969565,4969566,4969567,4969569,4969582,4969583,4969584,4969585,8074670,8074711,8074712,8074713,8074714,8074715,8074753,8074754,8074755,8074756,8074757,8074797,8074798,8074799,8074800,8074801,8074839,8074840,8074841,8074842,8074843,8075220,8075221,8075222,8075395,8075396,4967342,4967343,4967346,4967347,4967393,4967394,4967395,4967396,4967397,4967398,4967399,4967400,4967453,4967510,4967514,4967764,4967765,4967766,4967776,4967798,4967872,4967918,4968112,4968113,4968114,4968115,4968116,4968117,8073883,8073884,8073885,8073886,8073887,8073928,8073929,8073930,8073931,8073932,8074242,8074243,8074244,8074245,8074246,8074289,8074290,8074291,8074292,8074293,8074499,8074500,8074501,8074502,8074503,8074504,8074505,8074506,8074507,8074508,8074509,8074510,8074511,8074512,8074513,8074514,8074515,8074516,8074517,8074518,8074519,8074520,8074521,8074522,8074523,8074524,8074525,8074526,8074527,8074528,8074529,8074530,8074531,8074532,8074533,8074534,8074535,8074536,8074537,8074538,8074539,8074540,8074541,8074542,8074543,8074544,8074545,8074546,8074547,8074548,8074549,8074550,8074551,8074552,8074553,8074554,8074555,8074556,8074557,8074558,8074559,8074560,8074561,8074562,8074563,8074564,8074565,8074566,8074567,8074568,8074569,8074570,8074571,8074572,8074573,8074574,8074575,8074576,8074577,8074578,8074579,8074580,8074581,8074582,8074583,8074584,8074585,8074586,8074587,8074588,8074589,8074590,8074591,8074592,8074593,8074594,8074595,8074624,8074625,8074626,8074627,8074628,8074666,8074667,8074668,8074669,8072033,8072034,8072035,8072036,8072037,8072038,8072039,8072040,8072041,8072042,8072043,8072044,8072045,8072046,8072047,8072048,8072049,8072050,8072051,8072052,8072053,8072054,8072055,8072056,8072057,8072058,8072059,8072060,8072061,8072062,8072063,8072064,8072065,8072066,8072067,8072068,8072069,8072070,8072071,8072072,8072073,8072074,8072075,8072076,8072077,8072078,8072079,8072080,8072081,8072082,8072083,8072084,8072085,8072086,8072087,8072088,8072089,8072090,8072091,8072092,8072093,8072094,8072095,8072096,8072097,8072098,8072099,8072100,8072101,8072102,8072103,8072104,8072105,8072106,8072107,8072108,8072109,8072110,8072111,8072112,8072113,8072114,8072115,8072116,8072117,8072118,8072119,8072120,8072121,8072122,8072123,8072124,8072125,8072126,8072127,8072128,8072129,8072130,8072131,8072132,8072133,8072134,8072135,8072136,8072137,8072138,8072139,8072140,8072141,8072142,8072143,8072144,8072145,8072146,8072147,8072148,8072149,8072150,8072151,8072152,8072153,8072154,8072155,8072156,8072157,8072158,8072159,8072160,8072161,8072162,8072527,8072767,8072890,8072896,8072995,8073007,8073008,8073011,8073012,8073547,8073548,8073549,10623045,10623195,10623344,10623345,10623346,10623347,10623348,10623349,10623350,10623351,10623352,10623353,10623354,10623438,10623439,10623440,10623441,10623442,10623443,10623444,10623445,10623446,10623447,10623448,10623499,10623613,10623614,10623615,10623736,10623784,10624091,10624092,10624093,10624094,10624095,10624096,10624097,10624098,10624099,10624100,10624101,10624102,10624103,10624104,10624105,10624106,10624107,10624108,10624109,10624110,10624111,10624112,10624113,10624114,10624115,10624116,10624117,10624118,10624341,10624342,10624393,10624394,10624395,10624396,10624397,10624398,10624399,10624400,10624401,10624402,10624403,10624554,10624762,10624763,10624764,10624765,10624766,10624767,10624768,10622026,10622027,10622028,10622029,10622030,10622031,10622067,10622069,10622079,10622095,10622096,10622097,10622098,10622099,10622100,10622111,10622112,10622121,10622197,10622243,10622244,10622245,10622246,10622366,10622370,10622388,10622389,10622399,10622400,10622413,10622415,10622420,10622422,10622423,10622432,10622433,10622434,10622435,10622436,10622437,10622438,10622439,10622440,10622441,10622442,10622443,10622444,10622446,10622447,10622448,10622449,10622450,10622451,10622452,10622453,10622454,10622455,10622456,10622512,10622535,10622538,10622895,10622896,10622918,10619968,10619969,10619970,10619971,10619972,10619973,10619995,10620051,10620052,10620079,10620080,10620176,10620183,10620259,10620302,10620320,10620322,10620325,10620555,10620556,10620557,10620558,10620624,10620625,10620626,10620627,10620628,10620639,10620640,10620641,10620642,10620645,10620646,10620653,10620750,10620754,10620755,10620759,10620791,10620792,10620793,10620895,10621034,10621079,10621080,10621081,10621084,10621085,10621086,10621087,10621088,10621089,10621090,10621091,10621092,10621093,10621094,10621095,10621096,10621097,10621098,10621099,10621103,10621108,10621136,10621420,10621452,10621458,10621459,10621461,10621462,10621478,10621490,10621580,10621620,10621635,10621641,10621670,10621687,10621697,10621702,10621730,10621734,10621740,10621750,10621751,10621780,10621781,10621782,10621783,10565147,10565197,10565199,10565200,10565201,10565202,10565203,10565204,10565205,10565206,10565207,10565209,10565210,10565211,10565212,10565213,10565214,10565215,10565216,10565217,10565218,10565219,10565220,10565224,10565225,10565230,10565231,10565232,10565233,10565234,10565235,10565236,10565237,10565238,10565239,10565240,10565241,10565242,10565245,10565246,10565247,10565248,10565250,10565251,10565252,10565253,10565254,10565255,10565256,10565258,10565259,10565673,10565918,10566009,10566043,10566080,10566081,10566082,10563176,10563177,10563178,10563179,10563180,10563181,10563182,10563183,10563184,10563185,10563186,10563271,10563272,10563273,10563356,10563417,10563418,10563419,10563446,10563447,10563448,10563449,10563468,10563469,10563470,10563471,10563472,10563473,10563474,10563475,10563476,10563477,10563478,10563479,10563480,10563481,10563482,10563483,10563484,10563485,10563486,10563487,10563488,10563489,10563490,10563491,10563492,10563493,10563494,10563495,10563496,10563497,10563498,10563499,10563500,10563501,10563502,10563503,10563504,10563505,10563506,10563507,10563508,10563509,10563510,10563511,10563512,10563513,10563514,10563515,10563516,10563517,10563518,10563519,10563520,10563521,10563522,10563523,10563524,10563525,10563526,10563527,10563528,10563529,10563530,10563531,10563532,10563533,10563534,10563535,10563536,10563537,10563538,10563539,10563540,10563568,10563570,10563583,10563590,10563591,10563592,10563593,10563594,10563595,10563596,10563597,10563598,10563599,10563600,10563601,10563602,10563657,10563658,10563659,10563660,10563661,10563662,10563663,10563664,10563665,10563666,10563775,10563776,10563826,10563901,10563902,10563955,10563956,10563957,10563958,10563959,10563960,10563961,10563962,10564074,10564075,10564076,10564077,10564078,10564079,10564080,10564081,10564082,10564083,10564155,10564156,10564157,10564158,10564159,10564160,10564161,10564162,10564163,10564261,10564262,10564263,10564264,10564265,10564266,10564267,10564268,10564269,10564270,10564271,10564272,10564273,10564274,10564275,10564276,10564277,10564278,10564279,10564280,10564281,10564282,10564283,10564284,10564285,10564286,10564287,10564288,10564289,10564290,10564291,10564292,10564293,10564294,10564295,10564296,10564297,10564298,10564299,10564300,10564301,10564302,10564303,10564304,10564305,10564306,10564307,10564308,10564309,10564310,10564311,10564312,10564313,10564314,10564315,10564415,10564444,10564445,10564446,10564448,10564449,10564450,10564451,10564452,10564453,10564469,10564470,10564990,10517202,10517203,10517204,10517205,10517206,10517207,10517208,10517209,10517210,10517211,10517212,10517213,10517214,10517215,10517216,10517217,10517218,10517219,10517220,10517221,10517222,10517223,10517224,10517225,10517607,10517608,10517620,10517621,10517670,10517693,10517779,10517984,10518110,10518269,10518314,10518321,10518467,10518539,10518540,10518541,10518542,10518543,10518544,10518545,10518546,10518547,10518631,10518632,10518633,10518634,10518635,10518664,10518665,10518666,10518667,10518668,10518675,10518682,10518683,10518684,10518685,10518686,10518687,10518688,10518689,10518690,10518691,10518692,10518693,10518694,10518695,10518696,10518697,10518698,10518699,10518700,10518701,10518702,10518703,10518704,10518705,10518706,10518707,10518708,10419413,10419414,10419468,10419474,10419475,10419493,10419572,10419573,10419579,10419584,10419610,10419612,10419616,10419632,10419633,10419634,10419635) 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'