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(7067850,7067851,7067852,7067853,10943454,10943455,10943456,10943460,10943461,10943462,10943463,10943464,7067976,7067977,10943489,10943657,7068167,7068169,7068171,7068243,7068244,4970680,4970684,4970700,4970749,4970751,4970767,10944069,10944070,4970917,7068724,4971060,7068725,7068726,7068727,7068728,7068729,7068730,7068731,7068732,7068733,7068734,7068735,7068736,7068737,7068738,7068739,7068740,7068741,7068742,7068743,7068744,7068745,7068746,7068747,7068748,7068749,7068750,7068751,7068752,7068753,7068754,7068755,7068756,7068757,7068758,7065907,7065908,7065909,7065919,7065949,4968322,4968332,7066088,7066142,7066190,4968607,10437256,10437382,10437399,4968861,10437486,7066742,7066765,7066803,7066817,7066826,7066852,7066859,7067222,7067225,7067226,7067227,7067229,7067241,7067245,4969589,4969590,4969591,7067262,7067263,7067279,7067398,7067444,7067625,7067633,7067634,7067637,7067643,7067644,7067686,7067697,7067712,7067713,7067765,8068790,7067812,6000103,7064019,7064020,7064022,7064029,10931528,7064094,7064095,7064096,7064097,10931888,10931902,7064473,7064551,10932020,10932021,10932022,10932023,10932024,10932025,10932026,10932038,7064616,10932070,7064650,7064652,10932106,4967031,10932243,10932261,10932291,10932475,10932477,10932591,10932598,10932655,10932671,10932675,10932677,10932685,10932832,10932833,10932892,10933070,10933213,10942537,10942539,10942540,10942594,10942735,8860924,8861047,8861048,8861114,8861115,8861116,8861117,8861118,8861119,8861120,8861121,10942969,8861183,10943052,10943053,8861275,10943109,10943134,10943136,10943143,8861336,10943160,10943171,10943176,8861388,8861399,8861400,8861409,10943229,10943230,8861419,10943250,5999942,5999954,5999957,5999978,5999979,5999980,5999981,5999983,5999985,5999987,5999989,5999991,5999994,5999997,5999999,6000001,6000003,6000012,6000015,6000018,6000019,6000020,8970228,10931200,10931201,6000092,10944467,10940834,10940837,10940838,10940839,10940850,10944720,10944721,10944722,10944723,10940988,10944795,10944810,10944840,10944865,10944889,8072305,8072358,8072362,8072364,8072368,8072370,8072371,8072372,8072391,8072392,8072449,8072463,8072464,8072653,8072654,8072655,8072656,8072657,8073080,10942052,10942053,10942066,10942108,10942141,10942144,10942191,10942214,10942215,10942216,10942276,8860481,8860482,8860489,8860555,8860557,8860601,8860613,10942496,10623041,10623042,10928562,10923580,10928632,10623314,10923830,10923831,10923832,10623404,10623488,10924063,10623658,10924307,10924308,10924402,10924403,10924404,10924405,10924406,10924407,10924408,10924409,10924410,10924411,10924412,10924413,10924414,10924415,10924416,10924417,10924418,10924419,10924420,10924421,10924422,10924423,10924424,10924425,10924426,10924427,10924428,10924429,8070818,10924623,10924624,10924625,10924626,10924627,10924628,10924629,10924630,10924631,10924632,8070830,8070831,10924633,10924634,10924635,10924636,10924637,10924638,10924639,10924640,10924641,10924642,10924643,8070905,8071105,8071106,8071107,8071310,8071327,8071343,8071355,10925451,10927479,10927481,10927482,10927483,10927484,10927485,10927486,10927487,10927488,10927489,10927490,10622034,10922644,10922647,10922652,10922655,10922656,10922662,10922665,10922688,10622277,10622278,10622279,10622280,10622281,10622282,10927909,10927910,10927914,10927915,10622409,10927925,10927932,10927933,10622427,10622429,10622430,10927967,10927977,10927994,10927995,10928079,10928085,10928098,10928108,10923114,10923117,10923118,10923119,10923121,10923122,10923124,10923145,10923149,10923152,10923154,10923157,10923158,10923162,10923163,10923166,10923167,10923168,10923170,10923172,10923173,10923177,10923178,10923179,10923180,10923181,10923194,10923195,10923197,10928200,10923202,10923203,10928353,10622902,10923415,10923416,10923418,10923421,10622914,10622915,10622916,10923427,10923435,10923436,10923437,10923438,10923439,10925477,10925478,10619975,10620029,10925580,10925581,10925582,10925583,10925584,10925585,10620222,10620223,10920735,10920850,10920851,10620353,10620354,10620355,10920866,10920867,10920868,10920869,10925873,10925874,10925875,10925879,10920957,10920969,10920970,10920971,10925982,10925983,10926032,10921038,10921061,10926079,10926080,10926127,10926143,10926144,10926145,10620640,10926155,10620653,10926172,10926178,10926198,10926199,10926235,10926236,10926237,10926238,10926239,10926242,10926275,10926276,10926305,10926331,10926332,10926333,10921334,10921335,10921389,10921390,10921391,10921471,10921640,10921641,10921642,10921673,10926695,10926702,10926703,10926707,10926708,10926713,10921747,10926760,10921760,10921761,10921762,10921763,10921764,10921765,10921766,10921767,10921768,10921769,10921770,10921771,10921772,10921773,10921774,10921875,10921876,10921877,10921975,10922004,10927059,10927065,10927074,10922076,10922077,10927436,10927437,10927438,10927439,10927440,10927441,10927442,10927443,10927444,10927445,10927446,10927447,10927448,10922452,10922457,10565154,10559290,10565308,10565309,10565310,10565311,10565315,10565328,10614199,10614201,10614221,10614282,10614298,10559483,10614441,10614442,10614464,10614466,10559622,10614495,10614506,10614538,10559698,10614552,10614553,10614554,10614566,10614595,10559758,10565877,10614775,10614776,10614794,10566006,10614857,10614861,10566013,10566064,10566065,10611962,10611989,10612039,10612043,10612049,10612050,10612096,10557296,10557297,10557298,10557299,10557300,10557301,10557302,10557303,10557304,10557305,10557306,10557307,10557308,10557309,10563322,10563323,10612207,10612208,10612210,10612211,10612227,10612238,10612242,10557502,10557536,10557537,10563537,10557538,10563538,10563539,10557539,10557544,10557545,10557546,10557547,10557548,10612417,10563573,10563575,10563580,10563584,10563587,10563590,10563591,10563605,10612521,10612522,10612534,10612652,10612757,10563934,10563935,10612806,10612846,10612848,10612921,10612931,10612941,10612958,10564205,10613077,10564261,10564262,10564316,10613166,10564317,10564318,10564319,10558323,10564386,10564387,10564388,10613296,10613303,10564456,10564457,10558472,10613356,10613357,10613369,10613373,10613379,10558579,10613478,10564631,10613484,10613489,10613490,10613491,10564649,10564686,10613562,10564749,10564750,10564751,10564752,10564753,10564754,10564755,10564756,10564757,10613630,10613646,10564808,10564809,10564855,10613766,10613769,10513148,10513189,10513190,10513200,10513201,10513202,10513247,10517325,10517328,10513344,10513345,10513346,10513347,10513348,10513349,10513350,10513351,10513352,10513353,10513354,10513355,10513356,10513357,10513358,10513359,10513360,10513361,10513362,10513363,10513364,10513365,10513366,10513367,10513368,10513369,10513370,10513371,10513372,10513388,10513401,10511511,10511512,10511513,10511514,10511515,10511516,10511517,10511518,10517526,10517527,10511598,10511599,10511600,10511601,10511602,10511603,10513625,10511704,10511705,10511706,10511707,10511708,10513723,10513724,10513725,10513726,10513823,10513824,10511893,10513905,10513906,10513946,10513947,10514009,10514010,10514011,10514012,10514015,10514031,10514032,10514033,10514117,10514118,10514119,10514120,10514121,10514122,10514123,10514124,10514125,10514126,10514127,10514128,10514129,10514130,10514131,10514132,10514133,10514134,10514135,10514136,10514137,10514138,10514139,10514140,10514141,10514142,10514143,10514144,10514145,10512145,10514146,10512146,10514147,10514148,10514149,10514150,10514151,10514152,10514153,10514154,10514155,10514156,10514157,10514172,10514173,10514241,10514354,10514355,10514511,10514512,10514513,10514532,10512576,10514767,10514768,10512810,10512811,10512847,10512849,10512850,10512851,10518903,10518904,10518905,10518906,10518907,10518908,10518909,10518910,10514979,10514990,10514991,10518991,10513046,10513073,10513086,10513087,10513088,10416236,10419241,10416270,10419302,10419384,10416403,10416406,10416424,10416425,10416426,10416441,10416478,10416550,10416554,10416560,10419576,10416780,10416781,10416782,10419786,10419790,10416798,10419819,10419820,10416822,10416824,10416828,10416829,10416831,10416832,10416835,10416838,10416841,10416843,10416845,10416847,10416849,10416852,10416853,10416855,10416858,10416859,10416861,10416862,10416863,10416864,10416866,10416868,10416869,10416871,10416873,10416875,10416879,10416881,10416884,10416887,10416889,10416893,10416896,10416962,10416967,10416977,10416978,10416993,10416994,10416995,10417008,10417061,10420063,10420064,10420068,10417068,10417089,10417090,10420102,10420103,10420104,10420105,10420106,10420107,10417113,10417114,10417116,10417117,10417118,10471106,10471107,10471108,10471109,10471110,10471111,10471114,10471117,10471119,10471277,10471278,10471279,10471487,10471499,10471500,10465856,10469913,10469915,10469917,10469922,10469923,10469924,10469932,10469943,10469946,10469965,10470091,10470137,10470146,10470232,10470277,10470315,10470375,10470476,10470723,10470727,10470733) 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'