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(4970275,4970276,4970277,4970301,4970302,4970303,4970304,4970305,4970306,4970307,4970308,4970309,4970310,4970311,4970312,4970313,4970314,4970315,4970316,4970317,4970318,4970319,4970320,4970321,4970322,4970323,4970324,4970325,4970326,4970327,4970328,4970329,4970330,4970331,4970332,4970333,4970334,4970335,4970336,4970337,4970338,4970339,4970340,4970341,4970342,4970343,4970344,4970345,4970346,4970347,4970348,4970349,4970350,4970351,4970352,4970353,4970354,4970355,4970356,4970357,4970358,4970359,4970360,4970361,4970362,4970363,4970364,4970365,4970366,4970367,4970368,4970369,4970370,4970371,4970372,4970373,4970374,4970375,4970376,4970377,4970378,4970379,4970380,4970381,4970382,4970383,4970384,4970385,4970386,4970387,4970388,4970389,4970390,4970391,4970392,4970393,4970394,4970395,4970396,4970397,4970398,4970676,4970684,4970698,4970702,4970710,4970716,4970724,4970729,4970730,4970737,4970739,4970762,4970763,4970765,4970766,4970771,4970772,4970914,4970923,4970927,4971059,4971101,4971102,4971103,4971107,4971108,4971109,4968702,4968703,4968804,4968805,4968862,4968942,4969007,4969008,4969009,4969010,4969303,4969332,4969333,4969334,4969335,4969336,4969337,8074711,8074712,8074713,8074714,8074715,8074753,8074754,8074755,8074756,8074757,8074973,8074974,8074975,8074976,8074977,8075017,8075018,8075019,8075020,8075021,8075237,8075238,8075239,4967332,4967333,4967334,4967335,4967336,4967408,4967409,4967410,4967411,4967412,4967427,4967428,4967429,4967511,4967512,4967513,4967514,4967774,4967775,4967776,4967777,4967778,4967779,4967780,4967781,4967782,4967783,4967784,4967785,4967786,4967787,4967788,4967789,4967790,4967791,4967792,4967793,4967794,4967795,4967796,4967797,4967798,4967799,4967800,4967801,4967802,4967803,4967804,4967805,4967806,4967807,4967808,4967809,4967810,4967811,4967812,4967813,4967814,4967815,4967816,4967817,4967818,4967841,4967844,4967854,4967855,4967922,4967923,4967940,4968156,4968157,4968158,8073888,8073889,8073890,8073891,8073892,8073893,8073894,8073933,8073934,8073935,8073936,8073937,8073938,8073939,8073940,8074247,8074248,8074249,8074250,8074251,8074252,8074294,8074295,8074296,8074297,8074298,8074299,8074300,8074534,8074535,8074536,8074537,8074538,8074539,8074540,8074583,8074584,8074585,8074586,8074587,8074588,8074589,8072163,8072164,8072165,8072166,8072167,8072168,8072169,8072170,8072171,8072172,8072173,8072174,8072175,8072176,8072177,8072178,8072179,8072180,8072181,8072182,8072183,8072184,8072185,8072186,8072187,8072188,8072189,8072190,8072191,8072192,8072193,8072194,8072195,8072196,8072197,8072198,8072199,8072200,8072201,8072202,8072203,8072204,8072205,8072206,8072207,8072208,8072209,8072210,8072211,8072212,8072213,8072214,8072215,8072216,8072217,8072218,8072219,8072220,8072221,8072222,8072223,8072224,8072225,8072226,8072227,8072228,8072229,8072230,8072231,8072232,8072233,8072234,8072235,8072236,8072237,8072238,8072239,8072240,8072241,8072242,8072243,8072244,8072245,8072246,8072247,8072248,8072249,8072250,8072251,8072252,8072253,8072254,8072255,8072256,8072257,8072258,8072259,8072260,8072261,8072262,8072263,8072264,8072265,8072266,8072267,8072268,8072269,8072270,8072271,8072272,8072273,8072274,8072275,8072276,8072277,8072278,8072279,8072280,8072281,8072282,8072283,8072284,8072285,8072286,8072287,8072288,8072289,8072290,8072291,8072292,8072427,8072469,8072777,8072924,8072931,8073530,8073531,10622988,10622989,10623046,10623047,10623055,10623099,10623116,10623296,10623297,10623298,10623299,10623351,10623366,10623367,10623368,10623369,10623370,10623371,10623372,10623373,10623374,10623375,10623376,10623445,10623457,10623458,10623459,10623460,10623461,10623462,10623463,10623464,10623491,10623492,10623493,10623499,10623503,10623750,10623790,10623791,10623792,10623793,10623794,10623795,10623796,10623797,10623798,10623799,10623800,10623801,10623802,10623803,10623804,10623926,10623927,10624091,10624092,10624093,10624094,10624095,10624096,10624097,10624098,10624099,10624100,10624101,10624102,10624103,10624104,10624105,10624106,10624107,10624108,10624109,10624110,10624111,10624112,10624113,10624114,10624115,10624116,10624117,10624118,10624207,10624271,10624401,10624402,10624403,10624428,10624429,10624430,10624431,10624432,10624433,10624587,10624731,10624732,10624769,10624770,10624771,10624772,10624773,10624774,10624775,10624776,10621977,10621978,10622005,10622007,10622040,10622042,10622043,10622053,10622054,10622081,10622082,10622084,10622085,10622096,10622097,10622098,10622122,10622123,10622124,10622189,10622196,10622280,10622281,10622295,10622297,10622298,10622299,10622300,10622307,10622308,10622310,10622324,10622333,10622343,10622361,10622362,10622363,10622364,10622365,10622367,10622369,10622389,10622392,10622393,10622394,10622395,10622403,10622421,10622422,10622423,10622424,10622438,10622446,10622465,10622479,10622480,10622483,10622485,10622486,10622488,10622489,10622498,10622503,10622506,10622507,10622509,10622510,10622511,10622512,10622513,10622517,10622520,10622526,10622539,10622827,10622828,10622829,10622864,10622865,10620055,10620071,10620083,10620121,10620164,10620167,10620168,10620169,10620180,10620181,10620182,10620183,10620213,10620253,10620344,10620345,10620376,10620421,10620471,10620472,10620473,10620474,10620475,10620518,10620542,10620543,10620544,10620545,10620620,10620621,10620622,10620623,10620624,10620625,10620626,10620650,10620699,10620700,10620701,10620702,10620703,10620704,10620705,10620706,10620707,10620708,10620709,10620710,10620794,10620795,10620797,10620810,10620811,10620841,10620842,10620896,10620937,10620938,10621117,10621118,10621149,10621152,10621156,10621157,10621158,10621159,10621166,10621244,10621245,10621246,10621265,10621267,10621272,10621302,10621337,10621338,10621339,10621353,10621355,10621386,10621387,10621388,10621420,10621427,10621452,10621464,10621472,10621473,10621499,10621570,10621576,10621577,10621578,10621579,10621608,10621626,10621635,10621640,10621641,10621642,10621663,10621664,10621665,10621667,10621670,10621671,10621672,10621674,10621677,10621679,10621681,10621682,10621685,10621686,10621687,10621690,10621691,10621695,10621697,10621700,10621701,10621702,10621703,10621706,10621712,10621715,10621717,10621718,10621720,10621725,10621726,10621728,10621729,10621730,10621734,10621738,10621739,10621740,10621938,10621939,10621940,10621941,10621942,10621943,10621944,10621945,10621946,10621947,10621948,10621949,10621958,10565153,10565158,10565202,10565203,10565204,10565205,10565206,10565207,10565253,10565254,10565255,10565256,10565259,10565347,10566080,10566081,10566082,10563222,10563223,10563224,10563225,10563264,10563265,10563266,10563307,10563420,10563421,10563422,10563450,10563451,10563452,10563453,10563454,10563455,10563456,10563457,10563458,10563459,10563460,10563461,10563462,10563463,10563464,10563465,10563466,10563467,10563521,10563522,10563523,10563524,10563525,10563526,10563527,10563528,10563529,10563548,10563549,10563550,10563571,10563602,10563627,10563628,10563659,10563660,10563667,10563668,10563669,10563670,10563671,10563672,10563673,10563674,10563675,10563676,10563677,10563678,10563679,10563680,10563681,10563682,10563683,10563684,10563733,10563734,10563735,10563742,10563743,10563744,10563745,10563746,10563747,10563748,10563749,10563750,10563751,10563752,10563753,10563754,10563755,10563756,10563757,10563758,10563759,10563760,10563761,10563762,10563763,10563764,10563765,10563766,10563767,10563768,10563769,10563770,10563771,10563772,10563773,10563774,10563775,10563776,10563833,10563836,10563837,10563838,10563839,10563840,10563841,10563849,10563850,10563854,10563855,10563867,10563879,10563880,10563881,10563882,10563883,10563884,10563885,10563886,10563887,10563888,10563889,10563890,10563891,10563892,10563893,10563894,10563895,10563896,10563897,10563898,10563899,10563900,10563901,10563902,10563910,10563911,10563912,10563913,10563914,10563915,10563916,10563992,10564008,10564009,10564010,10564027,10564029,10564030,10564031,10564032,10564033,10564034,10564035,10564036,10564037,10564038,10564039,10564040,10564041,10564042,10564043,10564044,10564045,10564046,10564047,10564048,10564049,10564050,10564051,10564052,10564053,10564054,10564055,10564056,10564057,10564058,10564059,10564060,10564061,10564062,10564063,10564064,10564065,10564066,10564067,10564068,10564069,10564070,10564071,10564072,10564073,10564074,10564075,10564076,10564077,10564078,10564079,10564080,10564081,10564082,10564083,10564103,10564122,10564214,10564215,10564216,10564217,10564218,10564227,10564228,10564229,10564230,10564231,10564232,10564233,10564234,10564235,10564236,10564237,10564238,10564239,10564240,10564241,10564242) 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'