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(4970154,4970155,4970319,4970320,4970321,4970322,4970348,4970361,4970362,4970363,4970388,4970389,4970390,4970391,4970392,4970642,4970643,4970644,4970669,4970679,4970703,4970723,4970724,4970766,4970780,4970781,4970795,4970796,4970797,4970819,4970820,4970821,4970822,4970823,4970873,4970898,4970913,4970914,4971007,4971008,4971009,4971059,4971074,4971145,4971146,4971147,4968154,4968155,4968234,4968254,4968328,4968363,4968364,4968365,4968826,4968849,4968940,4968941,4968942,4968943,4968944,4968989,4968990,4968991,4968992,4968993,4968994,4968995,4968996,4968997,4968998,4968999,4969000,4969001,4969002,4969003,4969004,4969005,4969006,4969096,4969097,4969177,4969298,4969299,4969316,4969326,4969327,4969328,4969329,4969330,4969331,4969332,4969333,4969334,4969335,4969336,4969337,4969415,4969416,4969417,4969418,4969419,4969420,4969471,4969472,4969473,4969474,4969475,4969476,4969477,4969478,4969479,4969480,4969481,4969482,4969483,4969484,4969485,4969486,4969487,4969488,4969489,4969490,4969491,4969492,4969534,4969535,4969536,4969537,4969538,4969871,4969872,4969873,4969894,4969895,4969896,4969922,4969923,4969924,4969925,4969926,4969927,4969928,4969936,4969937,4969938,4969939,4969940,4969941,4969942,4969943,4969944,4969962,4970081,4970082,4970083,4970084,4970108,4970109,4970110,4970111,8074684,8074685,8074686,8074687,8074688,8074689,8074690,8074691,8074692,8074693,8074694,8074695,8074696,8074697,8074698,8074699,8074700,8074701,8074702,8074703,8074704,8074705,8074706,8074707,8074708,8074709,8074710,8074711,8074712,8074713,8074714,8074715,8074716,8074717,8074718,8074719,8074720,8074721,8074722,8074723,8074724,8074725,8074726,8074727,8074728,8074729,8074730,8074731,8074732,8074733,8074734,8074735,8074736,8074737,8074738,8074739,8074740,8074741,8074742,8074743,8074744,8074745,8074746,8074747,8074748,8074749,8074750,8074751,8074752,8074753,8074754,8074755,8074756,8074757,8074758,8074759,8074760,8074761,8074762,8074763,8074764,8074765,8074766,8074767,8074768,8074769,8074770,8074771,8074890,8074891,8074892,8074893,8074894,8074895,8074896,8074934,8074935,8074936,8074937,8074938,8074939,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,8075235,8075236,8075276,8075277,8075281,8075377,8075380,8075423,8075441,8075488,8075489,4967034,4967196,4967197,4967260,4967261,4967262,4967263,4967424,4967425,4967426,4967427,4967428,4967429,4967430,4967431,4967432,4967433,4967434,4967435,4967436,4967571,4967572,4967573,4967593,4967594,4967595,4967850,4967852,4967853,4967856,4967860,4968140,4968141,4968142,4968143,8074349,8074445,8074446,8074447,8074448,8074449,8074488,8074489,8074490,8074491,8074492,8074493,8072345,8072348,8072352,8072360,8072366,8072377,8072381,8072388,8072394,8072399,8072403,8072409,8072415,8072419,8072425,8072440,8072445,8072452,8072457,8072773,8072774,8072775,8072776,8072777,8072923,8072925,8072926,8072927,8072928,8072929,8072930,8072931,8072934,8073517,8073518,8073519,8073520,8073521,8073522,8073523,8073524,8073525,8073526,10622962,10622963,10622964,10622965,10622972,10622991,10622996,10622997,10622998,10622999,10623002,10623055,10623063,10623252,10623289,10623290,10623340,10623370,10623434,10623461,10623491,10623492,10623493,10623499,10623503,10623582,10623605,10623606,10623729,10623770,10624105,10624106,10624107,10624193,10624206,10624208,10624266,10624267,10624268,10624269,10624270,10624271,10624575,10624586,10624632,10624633,10624654,10624722,10624874,10624956,10621977,10621978,10621979,10621980,10621985,10621987,10621988,10621989,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622008,10622009,10622010,10622011,10622037,10622038,10622039,10622040,10622041,10622042,10622043,10622044,10622045,10622046,10622047,10622048,10622049,10622050,10622051,10622052,10622053,10622054,10622055,10622070,10622081,10622082,10622084,10622085,10622086,10622087,10622091,10622092,10622093,10622094,10622096,10622097,10622098,10622122,10622123,10622124,10622125,10622126,10622168,10622169,10622170,10622171,10622186,10622265,10622340,10622341,10622344,10622363,10622366,10622368,10622405,10622408,10622420,10622421,10622422,10622423,10622424,10622430,10622443,10622444,10622475,10622476,10622477,10622478,10622479,10622480,10622481,10622482,10622483,10622484,10622485,10622506,10622508,10622513,10622514,10622516,10622523,10622525,10622539,10622545,10622811,10622812,10622813,10622814,10622815,10622816,10622817,10622818,10622819,10622820,10622821,10622822,10622823,10622824,10622825,10622826,10622959,10622960,10622961,10620006,10620007,10620008,10620098,10620122,10620124,10620125,10620235,10620236,10620253,10620344,10620365,10620368,10620470,10620477,10620504,10620565,10620599,10620600,10620601,10620602,10620603,10620604,10620605,10620606,10620607,10620608,10620609,10620610,10620611,10620612,10620613,10620614,10620615,10620616,10620617,10620618,10620619,10620656,10620657,10620658,10620659,10620669,10620770,10620787,10620788,10620814,10620815,10620816,10620864,10621024,10621025,10621026,10621027,10621028,10621044,10621049,10621117,10621118,10621125,10621130,10621131,10621133,10621134,10621135,10621145,10621155,10621156,10621157,10621158,10621159,10621160,10621164,10621166,10621258,10621259,10621260,10621261,10621278,10621279,10621300,10621301,10621302,10621320,10621322,10621352,10621353,10621354,10621355,10621356,10621411,10621412,10621413,10621414,10621415,10621416,10621417,10621418,10621419,10621420,10621436,10621437,10621450,10621451,10621464,10621465,10621466,10621467,10621468,10621469,10621470,10621471,10621472,10621473,10621474,10621475,10621486,10621487,10621488,10621489,10621490,10621491,10621492,10621498,10621505,10621506,10621508,10621509,10621515,10621525,10621526,10621527,10621528,10621531,10621532,10621533,10621545,10621568,10621570,10621574,10621578,10621579,10621586,10621590,10621591,10621592,10621603,10621604,10621605,10621606,10621607,10621608,10621609,10621621,10621622,10621623,10621624,10621625,10621626,10621627,10621634,10621636,10621639,10621642,10621644,10621645,10621648,10621649,10621650,10621651,10621652,10621653,10621654,10621655,10621656,10621657,10621658,10621659,10621660,10621661,10621662,10621663,10621664,10621665,10621666,10621667,10621668,10621669,10621670,10621671,10621672,10621673,10621674,10621675,10621676,10621677,10621678,10621679,10621680,10621681,10621682,10621683,10621684,10621685,10621686,10621687,10621688,10621689,10621690,10621691,10621692,10621693,10621694,10621695,10621696,10621697,10621698,10621699,10621700,10621701,10621702,10621703,10621704,10621705,10621706,10621707,10621708,10621709,10621710,10621711,10621712,10621713,10621714,10621715,10621716,10621717,10621718,10621719,10621720,10621721,10621722,10621723,10621724,10621725,10621726,10621727,10621728,10621729,10621730,10621731,10621732,10621733,10621734,10621735,10621736,10621737,10621738,10621739,10621740,10621741,10621742,10621743,10621744,10621746,10621747,10621952,10621953,10565153,10565225,10565233,10565319,10565323,10565346,10565347,10565348,10565699,10565707,10565708,10565822,10565823,10565824,10565825,10565826,10565827,10565828,10565829,10565830,10565831,10565832,10565833,10565834,10565835,10565836,10565837,10566055,10566066,10566083,10563152,10563153,10563154,10563156,10563195,10563196,10563197,10563198,10563199,10563200,10563201,10563202,10563203,10563204,10563205,10563206,10563207,10563208,10563209,10563210,10563211,10563212,10563213,10563215,10563222,10563223,10563224,10563225,10563276,10563291,10563450,10563451,10563452,10563453,10563454,10563455,10563456,10563457,10563458,10563459,10563460,10563461,10563462,10563463,10563464,10563465,10563466,10563467,10563572,10563574,10563602,10563605,10563606,10563607,10563608,10563609,10563610,10563611,10563612,10563613,10563614,10563615,10563616,10563617,10563618,10563619,10563620,10563621,10563622,10563623,10563624,10563625,10563626,10563627,10563628,10563629,10563630,10563631,10563632,10563633) 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'