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,8630765,8630810,8630811,8630836,8630837,8630838,8630852,8630862,8630886,8630892,8630893,8630894,8630895,8630896,8630897,8630898,8630899,8630900,4970731,4970732,4970733,4970734,8631192,10861921,10861935,10861940,10861942,3229130,3229131,3229285,8631593,8631594,8631599,8583434,10862257,8631630,8583486,8575733,8575734,8575735,8632323,8632329,8632392,8632395,8632396,8632397,8632398,8632399,10863099,10863122,10863123,8632518,10863168,10863169,8629581,8629582,8629583,8629584,8629601,8629617,8629618,8629619,8629620,3227401,10860325,10860327,8067941,10869337,8629712,10860404,10860408,10860466,10860468,8629987,7067586,8630246,10930095,7201259,7201260,7201262,7201263,7201266,7201272,7201390,7201395,7201415,8627821,7201444,7201514,8595092,8595093,7201727,7201728,7201729,10858797,10858804,10858816,10858847,10858848,10858849,8628229,8595236,8628240,8628257,8628260,8628261,8628262,8628263,8628264,8628265,10858908,10858909,10858910,10858912,10858913,10858916,10866922,10866923,10866924,10866925,10866926,10866927,10866928,10866929,7201901,10858945,10858946,10858954,10858955,10858956,10858957,8628351,8628352,7201959,7201974,10859073,8065823,7202133,10859192,10859193,10859194,10859195,10859196,10859197,10859198,10859199,10859200,7202165,8628571,8628573,8628574,8628575,8628576,8628581,8628582,8628583,8628584,8628585,8628588,8628589,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,8628752,8628787,5654540,5654606,7202735,9794578,9794579,9794580,9794588,9794592,9794594,8629429,10860087,8629578,8629579,8629580,7200231,7200232,7200233,7200234,8626828,10958953,10958954,8626934,8626935,8626936,8626937,7200537,7200538,8626939,8626940,8626943,8626944,8626945,8626946,8626947,8626948,8626949,8626950,8626951,8626952,8626955,8626957,8626960,8626961,8626962,10857639,10857640,7200603,7200609,8627010,8627012,7200612,8627013,7200614,8627017,8627019,8627022,8627024,8627026,8627027,8627030,8627033,8627035,8627039,8627042,8627044,10857688,8627046,8627047,8627048,8627049,10857693,10857694,8910465,8627067,7200753,7200763,7200765,7200778,7200779,7200780,8627228,8627238,8627239,8627240,8627241,8627242,8627246,8627249,8627250,8627251,10857893,8627253,8627284,8627285,8627286,8627287,8627288,8627291,8627292,8627293,8627310,10865953,8627312,8627313,7201040,7201041,8627472,8627480,7201084,7201085,10866198,10855223,10855237,10855239,10855240,10855241,10855242,10855245,10855267,10855270,10855271,10855272,10855273,10855274,10855276,10855277,10855278,10855279,10855280,10855281,10855282,10855283,10855284,10855285,10855291,10855292,10855293,10855298,10855299,10855301,8624749,8624750,8624751,8624752,8624753,8624754,8624755,8624756,8624757,7198391,7198392,7198393,10855626,7198685,7198687,7198690,7198694,10855809,8625170,10855813,8625243,8625244,8625245,8625246,8625247,10864025,8625871,8625880,10101477,10101504,8626021,8626089,8626090,8626091,8626092,10864741,8626139,8626140,8626141,8626142,8626143,8626144,11048405,8626205,8612892,3923497,10618178,10618179,10618180,10618181,7196891,8613583,7197103,10854320,10838801,10838816,10854367,8624360,8624361,8624370,8624401,8624439,10855096,10855106,10855109,10855115,10855120,10855121,10855122,10855123,10855124,10855125,10855136,10619875,7198108,10619891,10619892,10619901,10619902,8624522,10619905,10619906,10855221,10855222,8634721,8634722,10852365,8634723,8634724,8634725,8634726,8634727,8634738,8634739,8634740,8634741,8634742,8634743,8634744,8634745,8634746,8634747,8634754,8634755,8634756,8634757,8634758,10617171,10622258,10622264,10622265,10622266,10622267,10622268,10852548,10622360,10622402,10622405,10622408,10622431,10622447,10617449,10617450,10622460,3922832,10622514,10622516,3232910,10622523,10853091,8632626,8632627,8632628,8632629,8632630,8632631,8632722,10850716,8633103,3581871,3581873,8633158,8633159,10425910,10425937,8633276,8633277,10851035,10426193,8540418,8540596,8540603,10616542,10616543,10616544,10616888,10616905,7059524,10614048,10614054,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,10614220,8853382,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,10611821,10614857,6666259,8549450,9913611,9913612,10612131,10612132,10612134,10612135,10612136,10612137,10612191,10612192,10612193,10612194,10612195,10612196,10612197,10612198,10612201,10612268,10612291,10612292,10612293,10612294,10612295,10609313,10609355,8851764,8851765,8851787,10609844,10612935,10612936,10610097,10613136,10610304,10613362,9172924,9172925,9172926,10613698,10613699,10610841,10117516,10117517,6673552,6673563,9169378,10117580,6673636,9169453,6673738,7055722,9911802,10117904,9169748,9912229,9912235,9912267,9912268,9912269,9912270,9912271,6674308,6674309,6674310,6674311,6674312,6674313,8850168,10118678,10118827,9912888,9913278,9913364,10419307,9168403,9168453,10417424,10416648,10416671,10416672,10416718,10416719,7014456,7014457,7014458,7014459,7014460,7014461,7014462,7014463,7014464,7014465,7014466,7014467,7014468,7014469,7014470,7014471,7014472,7014473,7014474,7014475,7014476,7014477,6673081,10419802,10419803,10419804,10419805,10419806,10419807,10419808,10419809,10419810,10418048,9169233,8550028,8550029,8550097,8550155,10467918,10467919,10467920,10467921,10467922,10467923,10467924,10467925,10467926,9168281,9168293,10888936,10893983,10889019,10889020,10889021,10884075,10894377,10884738,10884799,10884800,10889853,10889858,10889943,10884950,10885001,10885060,10885167,10627319,10883045,10883067,10883143,10883421,10630191,10885763,10949013,10886878,10167914,10886910,10167936,10167943,10167954,10167968,10167969,10167971,10167992,10168007,10168012,10168015,10168025,10168027,10168028,10168046,10168047,10168056,10887052,10168072,10887072,10877124,10887263,10608607,10582561,10533104,10508198,10508352,10508355,10508356,10508357,10508360,10508361,10508362,10508363,10508364,10508365,10508367,10508368,10508369,10508370,10508371,10421543,10507861,10507862,10507863,10507876,10507909,10507920,10507921,10507922,10413356,10413358,10413366,10413381,10413382,10413429,10413430,10413431,10413434,10413437,10413460,10413461,10413575,10413675,10413676,10413677,10413678,10413679,10413680,10407971,10410064,10408152,10410297,10410308,10410311,10410317,10410323,10410324,10410325,10410326,10410327,10410328,10410336,10495048,10410408,10410422,10410424,10410425,10410426,10410427,10410430,10410450,10410451,10410454,10410455,10410456,10410457,10410458,10410460,10410461,10410462,10410463,10410464,10410465,10410466,10410467,10410468,10410469,10410475,10412476,10410476,10414477,10410477,10410478,10410482,10410483,10410484,10414662,10414665,10414705,10414709,10414749,10414750,10410788,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'