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(8068812,8068813,8068817,8068822,8068827,8068834,8068835,8068839,8068845,8068867,8068868,4970706,4970762,4970925,10944264,10944270,4968228,4968232,10437206,10437207,10437248,4968670,4968671,10437569,10437573,10437574,10437614,10437618,10437619,10437620,8067931,8067955,8067959,8067963,8067967,8067971,8067974,8067975,8067977,8067980,8067982,8067984,8067987,8067995,8067996,8067998,8067999,8068002,8068017,8068020,8068021,8068022,8068023,8068024,8068025,8068030,8068033,8068034,8068035,8068036,8068044,8068047,8068050,8068052,8068053,8068056,8068061,8068062,8068065,8068066,8068071,8068072,8068073,8068074,8068076,8068089,8068097,8068099,8068101,8068112,8068113,8068115,8068124,8068127,8068128,8068129,8068135,8068136,8068137,8068138,8068147,8068153,8068160,8068165,8068171,8068172,8068176,8068177,8068181,8068182,8068187,8068188,8068189,8068193,8068194,8068200,8068201,8068208,8068209,8068210,8068215,8068216,8068218,8068230,8068231,8068250,8068252,8068253,8068255,8068257,8068258,8068262,8068264,8068265,8068267,8068271,8068273,8068276,8068281,8068283,8068286,8068287,8068290,8068291,8068292,8068294,8068298,8068299,8068303,8068306,8068320,8068324,8068327,8068328,8068334,8068339,8068346,8068348,8068357,8068358,8068366,8068367,8068368,8068372,8068373,8068378,8068380,8068383,8068384,8068385,8068388,8068390,8068393,8068394,8068397,8068398,8068399,8068411,8068414,8068415,8068418,8068421,8068422,8068424,8068428,8068431,8068433,8068439,8068441,8068442,8068443,8068452,8068461,8068463,8068468,8068469,8068471,8068475,8068480,8068483,8068484,8068485,8068486,8068490,8068491,8068495,8068496,8068502,8068503,8068504,8068505,8068506,8068507,8068508,8068512,8068513,8068514,8068516,8068518,8068519,8068527,8068529,8068532,8068543,8068544,8068545,8068546,8068551,8075293,4968060,8072368,8072369,8072370,8072371,8072372,8072373,8072374,8072384,8072385,8072396,8072428,8072463,8072464,8072465,8072466,8072467,8072468,8072469,8072552,8072553,8072584,8072585,8072698,8072699,8072700,8072701,8072702,8072995,8073449,8073458,8073529,10623291,10623292,10623293,10623294,10623295,10623296,10623297,10623298,10623299,10623300,10623301,10623302,10623304,10623309,10623323,10623417,10623502,10623503,10623657,10623659,10624841,10624955,10621977,10621981,10621983,10622019,10622025,10622051,10622059,10622062,10622073,10622075,10622082,10622083,10622084,10622085,10622086,10622087,10622089,10622090,10622095,10622096,10622102,10622193,10622194,10622260,10622261,10622263,10622270,10622273,10622276,10622277,10622343,10622361,10622362,10622364,10622371,10622375,10622378,10622379,10622380,10622381,10622382,10622383,10622399,10622417,10622429,10622430,10622433,10622439,10622457,10622458,10622506,10622518,10622524,10622527,10622528,10622548,10622549,10622900,10622917,10622919,10620044,10620045,10620106,10620119,10620120,10620121,10620203,10620204,10620205,10620206,10620242,10620321,10620324,10620345,10620352,10620356,10620358,10620366,10620370,10620371,10620372,10620379,10620380,10620381,10620382,10620383,10620384,10620386,10620387,10620388,10620393,10620394,10620397,10620398,10620399,10620400,10620401,10620403,10620404,10620405,10620409,10620410,10620416,10620417,10620418,10620424,10620425,10620654,10620655,10620656,10620657,10620658,10620660,10620664,10620665,10620859,10620860,10620861,10620875,10620876,10621070,10621074,10621075,10621109,10621110,10621111,10621112,10621113,10621114,10621115,10621116,10621117,10621119,10621120,10621121,10621122,10621123,10621124,10621125,10621127,10621128,10621129,10621131,10621132,10621133,10621135,10621136,10621138,10621140,10621142,10621143,10621144,10621145,10621146,10621147,10621148,10621149,10621150,10621152,10621153,10621154,10621160,10621161,10621162,10621163,10621165,10621236,10621237,10621238,10621241,10621242,10621244,10621245,10621246,10621248,10621249,10621250,10621255,10621256,10621257,10621259,10621261,10621266,10621268,10621269,10621271,10621273,10621274,10621275,10621276,10621278,10621279,10621284,10621286,10621290,10621296,10621299,10621300,10621302,10621310,10621312,10621313,10621315,10621317,10621318,10621319,10621321,10621323,10621324,10621327,10621328,10621329,10621330,10621331,10621332,10621333,10621334,10621337,10621338,10621339,10621342,10621346,10621347,10621348,10621351,10621355,10621362,10621367,10621368,10621369,10621370,10621371,10621372,10621373,10621374,10621377,10621378,10621379,10621380,10621381,10621382,10621387,10621388,10621389,10621393,10621394,10621395,10621398,10621399,10621405,10621408,10621412,10621413,10621416,10621417,10621418,10621419,10621420,10621421,10621422,10621423,10621424,10621425,10621426,10621429,10621431,10621432,10621433,10621434,10621435,10621436,10621437,10621438,10621439,10621440,10621441,10621442,10621443,10621453,10621454,10621479,10621480,10621482,10621484,10621485,10621493,10621496,10621497,10621500,10621501,10621502,10621503,10621504,10621505,10621507,10621508,10621509,10621510,10621511,10621512,10621515,10621516,10621517,10621518,10621519,10621520,10621523,10621524,10621525,10621527,10621528,10621530,10621533,10621534,10621535,10621536,10621539,10621540,10621541,10621542,10621545,10621564,10621567,10621568,10621569,10621570,10621572,10621573,10621574,10621575,10621576,10621577,10621578,10621580,10621581,10621582,10621583,10621584,10621585,10621586,10621587,10621588,10621589,10621590,10621591,10621592,10621593,10621594,10621595,10621596,10621597,10621598,10621599,10621600,10621601,10621602,10621603,10621604,10621605,10621606,10621607,10621608,10621609,10621610,10621611,10621612,10621613,10621614,10621615,10621616,10621617,10621618,10621619,10621627,10621628,10621629,10621630,10621635,10621636,10621638,10621639,10621641,10621643,10621644,10621646,10621647,10621648,10621649,10621650,10621658,10621660,10621662,10621667,10621671,10621673,10621674,10621675,10621676,10621680,10621686,10621693,10621695,10621696,10621697,10621698,10621700,10621702,10621703,10621706,10621707,10621709,10621711,10621712,10621716,10621717,10621718,10621719,10621720,10621722,10621723,10621725,10621730,10621734,10621740,10621744,10621958,10565149,10565151,10565153,10565154,10565155,10565156,10565157,10565159,10565933,10565934,10565935,10565936,10565960,10565961,10565962,10566015,10563138,10563139,10563140,10563141,10563142,10563143,10563144,10563145,10563146,10563147,10563148,10563149,10563150,10563151,10563395,10563396,10563397,10563398,10563399,10563400,10563401,10563402,10563403,10563404,10563405,10563406,10563407,10563408,10563409,10563410,10563411,10563412,10563413,10563414,10563415,10563416,10563567,10563584,10563585,10563586,10563603,10563604,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,10563685,10563686,10563687,10563688,10563689,10563690,10563691,10563692,10563693,10563694,10563695,10563696,10563697,10563698,10563699,10563700,10563701,10563702,10563703,10563704,10563705,10563706,10563707,10563708,10563709,10563710,10563711,10563712,10563713,10563714,10563715,10563716,10563717,10563718,10563719,10563720,10563721,10563722,10563723,10563724,10563725,10563726,10563727,10563728,10563729,10563730,10563731,10563732,10563733,10563734,10563735,10563736,10563737,10563738,10563739,10563740,10563741,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,10563777,10563778,10563779,10563780,10563781,10563782,10563783,10563784,10563785,10563786,10563787,10563788,10564431,10564432,10564441,10517230,10517264,10517265,10517266,10517315,10517316,10517326,10517654,10517655,10419386,10419387,10419403,10419447,10419673,10419674,10419703,10419704,10419705,10419706,10419796,10419797,10419832,10419833,10419939,10419969,10420001,10420109,10420159,10420177,10420202,10420205,10471179,10471182,10471210,10471211,10471212,10471213,10471214,10471215,10471216,10471217,10471218,10471219,10471220,10471221,10471222,10471223,10471224,10471225,10471226,10471227,10471230,10471232,10471233,10471235,10471236,10471237,10471239,10471240,10471241,10471242,10471244,10471490,10471491,10471492,10469887,10469944,10470073,10470237,10470312,10470313,10470314,10470315,10470316,10470317,10470318,10470319,10470320,10470321,10470322,10470323,10470324,10470325,10470326,10470327,10470328,10470329,10470330,10470331,10470332,10470333,10470334,10470335,10470336,10470337,10470338,10470339,10470340,10470341,10470342,10470343,10470344,10470397,10470493,10470494,10470513) 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'