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(10939568,10939614,10939615,10939637,10939642,10939644,10939649,4970282,4970283,4970284,4970285,4970313,4970316,4970323,10939731,4970326,4970347,4970354,4970355,4970356,4970361,4970367,4970371,4970372,4970373,4970374,4970375,4970377,4970395,10939844,4970643,4970655,4970682,10940114,4970724,4970737,4970741,4970742,4970745,4970771,4970772,10940258,4970927,10940440,4971047,10940471,10940518,4968161,4968162,4968163,8066950,8066951,8066952,8066953,8066963,8066964,8066965,4968234,8067197,8067269,8067356,8067357,8067358,8067367,4968704,8067472,8067591,8067592,8067593,8067594,8067650,8067731,8067735,8067740,8067748,8067801,8067829,8067830,10938658,10938659,10938660,10938661,10938663,10938668,4969306,4969311,4969317,4969325,10939059,10939107,10939303,10939306,10939322,10939323,10939324,10939334,10939339,10939367,10939388,10939549,8074716,8074717,8074718,8074719,8074720,8074721,8064970,8064994,8074758,8074759,8074760,8074761,8074762,8074763,8074764,8074765,8074766,8065034,8065035,8065079,8065080,8065081,8065082,8065083,8065084,8074946,8074947,8074948,8074949,8074950,8074951,8074952,8074953,8074954,8074955,8074956,8074957,8074958,8074959,8074960,8074961,8074962,8074963,8074964,8074965,8074966,8074967,8074968,8074969,8074970,8074971,8074972,8074973,8074974,8074975,8074976,8074977,8074978,8074979,8074980,8074981,8074982,8074983,8074984,8074985,8074986,8074987,8074988,8074989,8074990,8074991,8074992,8074993,8074994,8074995,8074996,8074997,8074998,8074999,8075000,8075001,8075002,8075003,8075004,8075005,8075006,8075007,8075008,8075009,8075010,8075011,8075012,8075013,8075014,8075015,8075016,8075017,8075018,8075019,8075020,8075021,8075022,8075023,8075024,8075025,8075026,8075027,8075028,8075029,8075030,8075031,8075032,8075033,8075264,8075306,8065556,8075324,8075325,8075326,8075327,8075328,8075329,8075330,8075331,8065575,8065578,8065579,8065584,8065587,8065591,8065592,8065624,8065636,8065641,8065642,8065643,8065644,8065645,8065646,8065647,8065648,8065649,8065652,8065667,8065672,8065673,8065674,8065675,8065676,8065677,8075524,8075525,8075526,8075527,8075528,8075529,8075530,8065774,8075531,8065775,8075532,8065776,8065777,8065778,8065813,8065907,8065977,8066080,8066125,8066206,8066207,8066208,8066215,8066253,8066285,4967527,4967528,8066302,8066305,8066323,8066324,8066325,8066326,8066327,8066349,8066350,8066351,8066352,8066403,8066410,8066438,8066485,8066486,8066542,8066543,8066544,8066556,8066557,8066573,8066574,4967845,4967855,4967858,8066621,8066622,8066623,8066624,8066625,8066656,8066657,8066658,8066679,8066736,8066743,8066744,8066745,8066746,8066747,8066748,8066749,8066750,8066751,8066752,8066753,8066754,4967996,8066767,8066768,8066798,8066799,8066807,8066815,8066816,8066817,8066832,8066833,8066834,8066881,8066884,8066886,8066890,8066897,4968140,11049784,8063958,8063959,8063960,8063968,8063969,8063975,8063976,8064359,8064529,8064530,8064533,8064705,8064706,8064707,8064764,8064765,8064766,8064768,3655673,3655674,3655675,3655677,8072342,8072343,8072344,8072345,8072346,8072347,8072348,8072349,8072350,8072351,8072352,8072353,3656198,3656303,8072773,8072774,8072775,8072776,8072777,3656622,3656623,3656626,3656658,3656659,3656660,3656687,3656689,8073013,8073014,3657271,3657274,11049772,11049774,10622990,10622991,10622992,10622993,10622994,10622995,10622996,10622997,10622998,10622999,10623000,10623001,10623002,10623063,10918692,10918713,10623244,10623245,10623246,10623308,10623373,10623464,10623491,10623492,10623493,10623503,10919111,10623606,10919126,10919127,10919153,10919165,10919893,10624582,10920371,10920372,10920373,10920374,10920378,10920379,10920380,10920381,10920382,10920383,10920400,10920404,10920405,10920406,10920407,10621977,10621978,10621979,10621980,10621983,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622008,10622009,10622010,10622011,10622042,10622045,10622091,10622097,10622098,10917614,10917617,10622168,10622169,10622170,10622171,10622281,10622299,10622309,10622310,10622332,10622333,10917854,10917858,10917859,10917860,10917861,10917862,10917867,10622363,10622368,10917909,10622465,10622472,10622477,10622483,10622485,10622486,10622487,10622496,10622497,10622498,10622503,10622506,10622512,10622513,10622514,10622515,10622516,10622532,10918095,10918096,10622819,10918446,10620147,10620343,10620344,10620345,10620412,10620413,10620476,10620477,10620487,10620488,10620660,10916575,10916576,10916577,10916578,10916579,10916580,10916581,10916582,10916590,10916591,10916592,10916593,10916594,10916595,10916596,10916597,10916598,10916601,10916602,10916665,10916666,10916667,10916668,10916676,10621166,10916680,10916681,10916690,10916691,10916692,10916693,10916694,10916695,10916696,10916697,10916698,10916699,10916700,10916701,10916702,10916703,10916704,10916705,10916706,10621253,10621255,10621256,10621257,10621260,10621261,10621278,10621315,10916850,10916851,10916852,10916853,10916854,10916855,10916856,10916857,10916858,10916859,10621396,10916910,10916911,10621438,10621473,10621505,10621506,10621509,10621545,10621571,10621586,10621593,10621605,10621626,10621636,10621644,10621645,10621657,10621658,10621659,10621660,10621661,10621662,10621663,10621664,10621665,10621666,10621675,10621683,10621684,10621685,10621686,10621687,10621688,10621689,10621692,10621693,10621694,10621696,10621698,10621699,10621700,10621701,10621704,10621705,10621706,10621707,10621708,10621709,10621710,10621711,10621712,10621713,10621714,10621715,10621716,10621718,10621719,10621720,10621721,10621726,10621735,10621736,10621737,10621738,10621739,10621740,10621741,10621744,10917337,10917338,10917339,10917340,10917346,10917380,10917381,10917382,10917383,10565195,10565319,10565347,10565673,10563195,10563196,10563197,10563198,10563199,10563200,10563201,10563202,10563203,10563204,10563205,10563206,10563207,10563208,10563209,10563210,10563211,10563212,10563213,10563214,10563215,10563568,10563629,10563630,10563631,10563632,10563633,10563634,10563635,10563636,10563637,10563638,10563639,10563640,10563641,10563642,10563643,10563644,10563750,10563752,10563777,10563778,10563779,10563780,10563781,10563782,10563783,10563784,10563785,10563786,10563787,10563790,10563837,10563839,10563840,10563841,10563903,10563904,10563905,10563906,10563907,10563908,10563909,10563914,10563915,10563993,10564000,10564001,10564004,10564005,10564006,10564007,10564042,10564043,10564061,10564062,10564084,10564085,10564086,10564087,10564088,10564089,10564090,10564091,10564092,10564093,10564094,10564095,10564096,10564097,10564098,10564099,10564100,10564101,10564102,10564103,10564104,10564105,10564106,10564107,10564108,10564109,10564125,10564126,10564127,10564128,10564129,10564271,10564272,10564273,10564274,10564316,10564317,10564318,10564319,10564320,10564321,10564322,10564323,10564324,10564325,10564326,10564327,10564328,10564329,10564330,10564331,10564332,10564333,10564334,10564335,10564336,10564337,10564338,10564339,10564340,10564341,10564342,10564343,10564344,10564345,10564346,10564347,10564348,10564349,10564350,10564351,10564352,10564353,10564354,10564355,10564356,10564357,10564358,10564359,10564360,10564361,10564362,10564363,10564364,10564365,10564366,10564367,10564368,10564369,10564370,10564371,10564372,10564373,10564374,10564375,10564376,10564377,10564378,10564379,10564380,10564381,10564382,10564383,10564384,10564385,10564391,10564400,10564401,10564422,10517142,10517143,10517144,10517149,10517150,10517151,10517152,10517153,10517154,10517155,10517156,10517157,10517158,10517159,10517160,10517161,10517162,10517163,10517164,10517165,10517166,10517167,10517168,10517169,10517179,10517180,10517181,10517182,10517183,10517184,10517185,10517186,10517187,10517188,10517189,10517190,10517191,10517192,10517193,10517194,10517195,10517196,10517197,10517198,10517199,10517200,10517201,10517284,10517495,10517496,10517497,10517552,10517569,10517570,10517812,10517998,10518117,10518132,10518136,10518149,10518370,10518373,10518374,10518394,10419417,10419587,10419588,10419723,10419741,10419746,10419842,10419905,10419906,10419917,10419918,10419919,10419920,10419921,10419922,10419923,10419924,10419926,10419927,10419928,10419929,10419930,10419931,10420033,10420036,10420084,10420085,10420086,10420087,10420088,10420089,10420090,10420091,10420092,10420093,10420094,10420095,10420096,10420097,10420098,10420108,10420110,10420200,10420201,10420202,10420204,10470880,10470881,10470894,10470910,10470911,10470912,10470920,10470921,10470922,10471132,10471422,10471423,10471477,10471540,10471566,10469880,10469891,10470033,10470034,10470035,10470036,10470037,10470038,10470039,10470040,10470688,10470689,10470701,10470702,10470757,10470792,10470812,10470856) 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'