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,4970425,4970537,4970538,4970539,4970718,4970724,4970797,4970858,4970892,4970913,4970914,4970927,4971007,4971008,4971009,4971046,4971047,4971048,4971059,4971096,4971107,4971108,4971109,4971145,4971146,4971147,4968161,4968162,4968163,4968257,4968261,4968266,4968272,4968273,4968274,4968288,4968292,4968295,4968328,4968338,4968412,4968546,4968547,4968548,4968549,4968849,4968891,4968892,4968893,4968894,4968895,4968896,4968897,4969060,4969239,8074671,8074672,8074673,8074674,8074675,8074676,8074677,8074678,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,8074758,8074759,8074760,8074761,8074762,8074763,8074764,8074765,8074766,8074802,8074803,8074804,8074805,8074806,8074807,8074844,8074845,8074846,8074847,8074848,8074849,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,8075022,8075023,8075024,8075025,8075026,8075027,8075069,8075070,8075071,8075072,8075073,8075116,8075117,8075118,8075119,8075120,8075121,8075160,8075161,8075162,8075163,8075164,8075165,8075202,8075203,8075204,8075205,8075206,8075207,8075208,8075246,8075249,8075254,8075255,8075264,8075273,8075306,8075324,8075325,8075326,8075327,8075328,8075329,8075330,8075331,8075370,8075372,8075374,8075420,8075421,8075423,8075524,8075527,8075528,4967435,4967436,4967496,4967533,4967922,4967923,8073686,8073687,8073688,8073689,8073690,8073691,8073692,8073693,8073694,8073695,8073740,8073741,8073742,8073743,8073744,8073745,8073746,8073747,8073748,8073792,8073793,8073794,8073795,8073796,8073797,8073798,8073841,8073842,8073843,8073844,8073845,8073846,8073847,8073888,8073889,8073890,8073891,8073892,8073893,8073894,8073933,8073934,8073935,8073936,8073937,8073938,8073939,8073940,8073979,8073980,8073981,8073982,8073983,8073984,8073985,8074025,8074026,8074027,8074028,8074029,8074030,8074070,8074071,8074072,8074073,8074074,8074075,8074112,8074113,8074114,8074115,8074116,8074117,8074155,8074156,8074157,8074158,8074159,8074160,8074200,8074201,8074202,8074203,8074204,8074205,8074247,8074248,8074249,8074250,8074251,8074252,8074294,8074295,8074296,8074297,8074298,8074299,8074300,8074341,8074342,8074343,8074344,8074345,8074346,8074347,8074348,8074349,8074350,8074351,8074352,8074393,8074394,8074395,8074396,8074397,8074398,8074399,8074400,8074401,8074402,8074445,8074446,8074447,8074448,8074449,8074488,8074489,8074490,8074491,8074492,8074493,8074534,8074535,8074536,8074537,8074538,8074539,8074540,8074583,8074584,8074585,8074586,8074587,8074588,8074589,8074629,8074630,8074631,8074632,8074633,8074634,8072314,8072673,8072674,8072675,8072676,8072677,8072728,8072729,8072730,8072731,8072732,8072773,8072774,8072775,8072776,8072777,8073002,8073039,8073041,8073043,8073448,8073451,8073503,8073504,8073511,8073517,8073518,8073519,8073520,8073521,8073522,8073523,8073524,8073525,8073526,8073550,8073551,8073552,8073586,8073587,8073588,8073589,8073590,8073591,8073592,8073593,8073635,8073636,8073637,8073638,8073639,8073640,8073641,10622990,10623018,10623046,10623047,10623058,10623059,10623062,10623303,10623491,10623492,10623493,10623503,10623685,10623700,10623874,10623875,10624022,10624193,10624271,10624566,10624575,10624663,10624722,10624726,10624727,10624728,10621977,10621983,10621988,10621990,10621991,10621992,10621993,10621994,10621995,10621996,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622008,10622009,10622010,10622011,10622070,10622093,10622100,10622126,10622205,10622212,10622213,10622234,10622251,10622253,10622265,10622267,10622280,10622281,10622287,10622292,10622295,10622297,10622298,10622299,10622300,10622306,10622307,10622308,10622309,10622310,10622318,10622324,10622325,10622332,10622333,10622337,10622338,10622340,10622341,10622343,10622344,10622360,10622361,10622362,10622363,10622364,10622365,10622366,10622367,10622368,10622369,10622389,10622392,10622393,10622394,10622395,10622402,10622403,10622405,10622408,10622409,10622410,10622412,10622420,10622421,10622422,10622423,10622424,10622427,10622428,10622429,10622430,10622438,10622443,10622444,10622446,10622451,10622465,10622469,10622471,10622472,10622473,10622475,10622476,10622477,10622478,10622479,10622480,10622481,10622482,10622483,10622484,10622485,10622486,10622487,10622488,10622489,10622496,10622497,10622498,10622503,10622506,10622507,10622508,10622509,10622510,10622511,10622512,10622513,10622514,10622515,10622516,10622517,10622520,10622523,10622525,10622526,10622527,10622528,10622530,10622531,10622532,10622534,10622536,10622538,10622539,10622545,10622560,10620083,10620116,10620208,10620253,10620303,10620365,10620366,10620367,10620368,10620372,10620373,10620374,10620375,10620376,10620377,10620378,10620410,10620411,10620412,10620413,10620427,10620488,10620598,10620599,10620600,10620601,10620602,10620603,10620604,10620605,10620606,10620607,10620608,10620609,10620610,10620611,10620612,10620613,10620614,10620615,10620616,10620617,10620618,10620619,10620654,10620655,10620656,10620657,10620658,10620659,10620660,10620850,10620924,10620995,10621127,10621147,10621148,10621149,10621151,10621152,10621155,10621156,10621157,10621158,10621159,10621160,10621161,10621165,10621230,10621231,10621232,10621233,10621234,10621235,10621236,10621237,10621238,10621239,10621240,10621241,10621242,10621243,10621244,10621245,10621246,10621251,10621252,10621253,10621254,10621255,10621256,10621257,10621260,10621261,10621265,10621266,10621267,10621268,10621272,10621273,10621274,10621281,10621286,10621291,10621292,10621293,10621305,10621306,10621307,10621308,10621309,10621314,10621315,10621320,10621322,10621325,10621326,10621327,10621328,10621329,10621330,10621331,10621332,10621333,10621334,10621335,10621336,10621337,10621338,10621339,10621340,10621342,10621349,10621350,10621351,10621352,10621353,10621354,10621355,10621356,10621371,10621372,10621380,10621386,10621387,10621388,10621396,10621410,10621411,10621412,10621413,10621414,10621415,10621416,10621417,10621418,10621419,10621420,10621427,10621428,10621429,10621435,10621436,10621437,10621438,10621443,10621445,10621446,10621447,10621448,10621449,10621450,10621451,10621452,10621454,10621464,10621465,10621466,10621467,10621468,10621469,10621470,10621471,10621472,10621473,10621474,10621475,10621479,10621486,10621487,10621488,10621489,10621490,10621491,10621492,10621493,10621494,10621495,10621496,10621499,10621500,10621501,10621505,10621506,10621507,10621508,10621509,10621519,10621520,10621521,10621522,10621523,10621529,10621530,10621531,10621532,10621533,10621543,10621544,10621545,10621564,10621567,10621568,10621571,10621573,10621574,10621576,10621577,10621581,10621582,10621586,10621588,10621589,10621590,10621591,10621592,10621593,10621594,10621603,10621604,10621605,10621606,10621607,10621608,10621609,10621620,10621621,10621622,10621623,10621624,10621625,10621626,10621627,10621628,10621634,10621635,10621636,10621642,10621644,10621646,10621647,10621648,10621658,10621659,10621660,10621661,10621662,10621663,10621664,10621665,10621666,10621692,10621693,10621694,10621696,10621704,10621705,10621706,10621707,10621708,10621709,10621710,10621711,10621712,10621713,10621714,10621715,10621716,10621720,10621721,10621726,10621735,10621741,10621745,10621746,10621747,10565123,10565315,10565707,10565708,10563324,10563344,10563345,10563346,10563347,10563348,10563548,10563549,10563550,10563568,10563572,10563574,10563586,10563627,10563628,10563629,10563630,10563631,10563632,10563633,10563634,10563635,10563636,10563637,10563638,10563639,10563640,10563641,10563642,10563643,10563644,10563645,10563646,10563647,10563648,10563649,10563650,10563651,10563652,10563653,10563654,10563655,10563656,10563659,10563660,10563667,10563668,10563669,10563670,10563778,10563786,10563787,10563790,10563839,10563840,10563841,10564000,10564104,10564105,10564128,10564271,10564272,10564273,10564274,10564325,10564326,10564391,10564431,10564432,10564441,10564444,10564449,10564473,10564474,10564475) 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'