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(8630625,8630626,8630629,8630630,8630631,8630632,8630633,8630634,8630636,8630638,8630639,8630640,8630641,8630642,8630643,8630644,8630645,8630646,8630647,8630648,8630649,8630650,8630651,8630652,8630653,8630654,8630655,8630656,8630657,7076128,8630810,8630811,8630852,8630862,8630886,8630899,8630900,10861935,10861940,10861942,3229130,3229131,3229285,8631593,8631594,8631599,8583434,10862257,8631630,10950747,10950748,8575733,8575734,8575735,8632395,8632396,8632397,8632398,8632399,3230230,8632518,10863168,10863169,8629581,8629582,8629583,8629584,8629617,8629618,8629619,8629620,3227401,10860325,10860327,10869337,10860404,10860408,10860466,10860468,10860597,8629987,7067586,8630246,10939439,10930095,7201259,7201260,7201262,7201263,7201266,7201319,7201415,8627821,10866538,7201631,8595057,7201727,7201728,7201729,10858780,10858782,10858784,10858786,10858788,8628229,8628240,8628257,8628261,8628263,8628264,8628265,7201901,10858945,10858946,8628351,8628352,7201959,7201974,7202133,10859192,10859193,10859194,10859195,10859196,10859197,10859198,10859199,10859200,7202165,8628590,8628591,8628592,8628593,8628594,8628595,8628596,8628597,8628598,8628599,8628600,8628601,8628602,8628603,8628604,8628605,8628606,8628607,8628608,8628609,8628610,8628611,8628612,8628613,8628614,8628615,8628617,8628618,8628619,8628620,8628673,8628676,8628679,8628686,8628688,8628689,8628691,8628692,8628693,8628694,8628696,8628698,8628700,8628701,8628702,8628703,8628705,8628706,8628707,8628708,8628709,8628710,8628711,8628712,8628716,8628717,7202319,7202329,8628752,5654606,5654627,7202680,7202683,7202684,7202685,7202686,7202687,7202696,9794578,9794579,9794580,9794588,8629164,8629166,9794592,9794594,8629173,8629174,8629177,8629178,8629188,3227094,8629429,10860087,8629578,8629579,8629580,7200231,7200232,7200233,7200234,8626807,8626808,8626809,8626810,8626828,10958953,10958954,8834762,8834763,8626934,8626935,8626936,8626937,8626939,8626940,8626943,8626944,8626945,8626946,8626947,8626948,8626949,8626950,8626951,8626952,8626955,8626957,8626960,8626961,8626962,7200603,7200609,7200612,7200614,10857688,10857693,10857694,8910465,7200753,7200763,7200765,7200778,7200779,7200780,8627228,8627242,8627246,10857893,8627251,8627286,8627288,8627293,7200901,7200904,10865953,10866198,8624749,8624750,8624751,8624752,8624753,8624754,8624755,8624756,8624757,7198391,7198392,7198393,10855626,7198679,7198681,7198695,7198696,7198700,7198701,7198712,7198717,7198722,7198730,7198731,7198744,7198745,7198747,7198751,7198752,7198759,7198760,7198763,7198764,7198765,10855809,8625170,7198770,10855813,8625243,8625244,8625245,8625246,8625247,10864025,8625627,8625694,8625695,8625774,8625775,8625776,8625779,8625783,8625784,8625786,8625787,8625788,8625789,8625868,8625871,8625877,8625878,8625880,8625893,8625897,8625970,8626021,8626089,8626090,8626091,8626092,10864741,8626139,8626140,8626141,8626142,8626143,8626144,8626205,10857146,10857147,10857148,10857149,10857150,10857151,10857152,10857153,10857154,10857155,10857156,10857157,10857158,10857159,10857160,10857161,10857163,10857164,10853232,10853233,10853409,10853410,10853479,10853481,10853486,10853510,7196890,7196891,8613583,8554717,8554718,8906890,7197103,10854320,10854367,7197816,8624370,8624401,8624439,10855096,10855106,10855109,10855115,10855136,10619875,10619891,10619892,10619901,10619902,8624522,10619905,10619906,10852365,10852504,10622258,10622264,10622265,10622266,10622267,10622268,10852548,10617323,10617324,10622360,10617377,10852643,10617383,10622402,10622405,10622408,10617426,10617427,10622431,10622447,10617449,10617450,10622460,10622514,10622516,3232910,10622523,10853133,8632626,8632627,8632628,8632629,8632630,8632631,8632722,10425577,10425582,10620301,10620302,10850616,10850617,10850618,10850620,10850716,8633103,8633158,8633159,8633160,3581910,10425910,10425911,10425937,8633276,8633277,10851035,10426193,8540418,10616044,10616045,10851968,8634448,3232238,10616888,10616905,10610965,7059524,10614048,10614054,8853216,8853227,8853313,8853315,8853316,8853317,8853318,8853319,8853320,8853321,8853322,8853323,8853324,8853325,8853326,8853327,8853329,8853332,8853333,8853334,8853335,8853336,8853337,8853339,8853342,8853343,8853344,8853345,8853346,8853347,8853348,8853351,8853352,8853353,8853354,8853355,8853357,8853359,8853360,8853361,8853363,8853364,8853369,8853375,8853376,8853377,8853378,8853381,8853382,10614220,8853383,8853384,8853385,8853386,8853387,8853388,8853389,8853390,8853391,8853392,8853393,8853394,8853395,8853396,8853397,8853399,10614376,10611396,10611407,10611422,10611426,10611434,10611442,10611449,10611499,10611514,10611517,10614565,10611605,10611623,10611647,10611648,6666259,8549450,9913611,9913612,10612104,10612105,10612106,10612107,10612191,10612192,10612194,10612201,10612292,10612293,10612294,10612295,10609313,10609355,8566654,8566655,8566656,10609844,10612935,10612936,10612937,10612938,10612939,10612941,10612942,10612943,10610097,10613135,10613136,10613137,8567072,8567073,9172924,9172925,9172926,6673523,6673524,10117516,10117517,10117529,6673552,6673563,9169378,10117580,6673636,9169453,8849323,8849327,6673738,7055722,9911802,9169748,10118016,9169935,9912227,10118247,10118248,9912271,6674308,6674309,6674310,6674311,6674312,6674313,6674326,10118369,10118370,10118371,9912423,9912457,9912458,9912459,9912460,9912461,9912462,9912463,9912464,10118678,9912888,9913278,9913362,9913363,9913364,10419307,9168394,9168453,10417424,10416718,10416719,9168816,9168818,6673081,8848775,8848776,8848783,8848796,8848797,8848820,8848823,8848828,8848830,8848831,8848849,8848876,8848877,10418048,9169233,6670729,8550023,8550063,8550064,8550065,8550097,8550155,10467918,10467919,10467920,10467921,10467922,10467923,10467924,10467925,10467926,10468323,8848027,10893983,10889019,10889020,10889021,10884075,10884078,10884089,10894377,10884596,10884698,10884738,10884799,10884800,10885001,10885060,10890105,10890106,10890107,10890108,10890109,10890110,10890111,10890112,10890113,10890114,10890115,10890116,10890117,10890118,10890119,10890120,10890121,10890122,10890123,10890124,10890125,10890146,10890147,10890161,10890162,10885167,10890173,10890174,10890175,10885349,10887472,10887557,10627319,10883045,10883067,10883143,10883421,10885763,10886878,10886910,10167992,10887052,10887072,10877124,10887263,10602177,10602180,10608607,10602695,10602697,10602699,10602704,10602705,10602706,10602732,10582561,10601437,10601694,10533104,10508242,10508243,10421543,10506819,10506821,10506824,10507922,10413341,10413343,10413345,10413347,10413349,10413460,10413461,10409564,10409565,10409620,10409622,10409643,10413675,10413676,10413677,10413678,10413679,10413680,10411964,10411965,10411966,10411967,10411968,10411969,10411970,10407971,10411971,10411972,10411973,10411974,10411975,10411976,10411977,10411978,10411979,10411980,10410064,10408152,10410297,10410308,10410311,10410317,10410336,10412476,10414477,10414662,10414665,10414705,10414709,10414749,10414750,10410788,10414844,10410952,10410960,10410962,10410965,10409008) 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'