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(7067816,7067817,7067818,7067819,7075819,7075820,7075822,7067824,7075825,7067827,7067829,7067830,7075830,7075831,7075832,7075833,7075835,7075836,7067844,7075845,7075848,7075849,7067849,7067851,7075852,7067853,7075853,7067855,10939570,7067856,7067857,7067859,7067861,7067863,7075864,7067864,7075865,7067865,7075866,7075869,7067869,7075870,7067872,7075872,7075873,7075874,7075875,7075876,7075877,7075878,7075879,7075880,7075882,7075883,7075884,7075885,8068869,7075887,7075889,8068872,7075891,7075892,7075896,7075897,7075898,7075900,7075902,7075903,7075907,7075908,7075916,7075918,7067922,7075923,7075924,7075925,7075926,7075937,7075988,7075989,7075990,7075994,7075996,7075998,7075999,7076000,7076002,7076055,7076091,7076093,7076094,7076095,7076096,7076097,7076108,7076113,7076127,7076136,7076225,7076235,7076252,7076256,7076277,7076298,7076299,7076301,7076302,7076303,7076304,7076322,7076336,7076343,7068346,7076348,7076373,7076374,7076394,7076395,7076398,7076400,7076401,7076409,7068653,10940460,7065816,7073822,7065823,7065826,7065828,7073828,7065829,7073830,7073831,7065832,7073833,7073834,7065837,7073839,7073841,7073843,7065847,7065865,7065868,7073870,7073873,7065880,7065883,7065896,7073902,7073903,7073905,7073908,7073909,7073910,7073911,7073912,7073924,7073926,7073928,7073930,7073932,7073934,7073936,7073938,7073939,7073942,7073967,7065986,7065988,7074049,7074187,7074193,7074198,7074202,7074209,7074212,7074221,7074224,7074231,7074233,7074243,7074246,7066271,7066293,10437249,7074309,7074310,7074311,7066342,7074343,7066345,7066357,7066359,7066360,7066361,7066363,7066364,7066367,7066369,7066370,7066372,7066377,7066382,7066397,7066400,7066404,7066406,7066408,7066413,7066416,7066419,7066421,7066422,7066424,7066425,7066427,7066429,7066431,7066434,7066437,7066441,7066442,7066447,7066449,7066452,7066455,7066457,7066461,7066463,7066465,7066467,7066469,7066473,7074552,7074553,7074557,7066571,7066573,7066576,7066673,7066690,7066726,7066728,7066736,7066737,7066738,7066739,7066751,7066754,7066760,7066761,7066762,7066763,7066764,7066767,7066776,7066777,7066781,7066785,7066786,7066795,7066797,7066809,7066816,7066819,7066828,7066835,7074867,7074869,7074870,7074871,7074872,7074873,7074874,7066881,7074899,7074900,7074901,7074903,7074907,7066937,7066941,7066944,7066945,7066956,7066971,7066991,7066994,7066999,7067012,7067022,7075052,7075060,7075061,7075063,7075064,7075070,7075071,7075073,7067081,10938832,10938842,7075164,7075165,7075166,10938881,7075167,7075168,7075169,7067170,7075170,10938885,7075171,7075172,7067173,7075174,7075175,7067176,7075176,7075177,7075178,7075179,7075181,7075182,7075184,7075185,7067186,7075186,7075188,7067189,7075190,7075191,7067192,7075192,7075193,7075194,7075195,7075196,7067197,7075198,7075199,7075201,7075202,7075204,7075205,7075207,7075209,7075210,7075211,7075213,7075214,7075216,7075217,7075218,7075219,7075220,7067222,7075223,7075224,7067225,7075225,7075226,7067226,7067227,7067228,7075228,7067229,7067230,7075231,7067232,7075232,7067233,7075234,7067236,7075236,7075238,7067240,7067241,7075241,7067242,7067244,7075244,7067245,7075245,7067246,7067247,7075247,7075248,7067249,7067250,7075250,7067252,7075252,7067253,7075256,7075257,7067259,7075259,7075260,7075261,7067261,7075262,7067263,7075264,7067265,7067266,7067267,7075267,7075269,7075271,7075272,7067272,7067279,7067291,7075291,7075292,7067301,7075302,7075303,7075304,7075305,7075311,7075312,7075316,7067317,7075318,7075319,7075321,7075326,7075352,7075356,7067367,7075368,7067369,7075371,7067371,7067372,7075372,7075375,7075378,7075379,7067383,7067385,7075392,7067397,7067398,7067404,7075406,7075407,7075409,7067410,7075411,7075413,7067415,7075430,7075432,7075433,7075436,7075439,10939159,7075446,7075451,7075462,7075464,7075466,7067472,7075473,7067478,7075487,7075489,7075490,7075517,7075518,7075519,7075524,7075525,7075528,7075530,7075532,7075535,7075538,7075539,7075540,7075541,7075542,7067542,7075543,7075545,7075547,7075549,7075552,7067553,7067556,7067557,7075557,7067558,7075560,7075562,7067563,7067564,7075564,7067567,7075569,7067571,7067573,7075574,7067574,7075576,7075578,7067578,7075579,7067580,7067581,7075582,7075584,7067584,7075586,7075587,7075589,7075591,7075593,7067593,7067594,7075595,7067595,7075597,7067597,7067599,7075600,7067601,7075602,7067604,7075605,7075606,7075607,7067607,7067608,7075609,7075610,7067611,7075614,7075616,7075618,7067618,7075619,7075620,7075621,7075623,7075625,7067626,7075627,7075628,7075630,7075632,7075634,7075635,7067635,7067638,7075639,7067639,7067640,7075641,7067641,7067642,7075644,7067644,7075646,7075649,7067649,7075650,7075651,7075653,7075657,7067658,7075659,7067659,7075661,7075662,7075664,7067664,7075666,7067668,7067670,7067671,7067673,7075676,7067676,7067684,7067685,7067686,7067691,7067692,7067693,7075699,7075707,7075708,7067708,7067709,7067710,7067711,7067712,7067713,7067714,7067715,7067717,7067718,7067719,7075722,7067722,7067723,7075724,7067724,10939439,7067725,7067726,7075727,7067727,7075728,7067728,7075729,7075730,7067730,7075731,7067731,7067732,7075733,7067734,7075734,7067735,7075735,7075736,7075738,7075739,7075740,7075741,7067741,7067742,7067743,7075743,7075745,7067745,7075746,7067746,7067747,7075748,7075750,7075751,7075753,7075754,7075755,7075756,7075757,7075759,7075760,7075761,7067761,7067762,7075763,7067767,7075769,7075771,7075773,7075777,7075780,7075785,7075789,7075800,7075808,7067811,7067812,7067815,7071821,7071822,7071823,7071825,7071828,7071830,7071835,7071849,7071858,7071869,7071870,7071878,7071879,7071884,7071956,7071957,7071964,7071966,7071968,7071973,7071977,7071983,7071986,7071987,7071990,7071993,7071995,7072009,7072011,7072058,7072087,7072088,7072089,7072091,7072092,7072093,7072094,7064095,7072096,7064097,7072097,7072098,7072107,7072205,7072207,7064257,7064336,7064369,7064371,7064373,7064459,7064471,7064588,7064594,7064595,7064601,7064614,7064615,7064616,7064617,7064652,7064676,7064689,7064712,7064718,7064720,7064723,7064732,7064736,7064739,7064747,7064748,7064751,7064754,7064756,7064757,7064758,7064761,7064763,7064764,7064768,7064792,7064816,7064817,7064818,7064825,7064826,7064827,7064828,7064831,7064833,7064835,7064838,7064857,7064858,7064864,7064865,7064874,7064901,7064902,7064910,7064911,7064915,7064922,7064923,7064924,7064926,7064931,7064932,7064935,7064975,7064977,7064979,7064983,7064985,7064986,7064990,7064993,7064994,7064996,7065000,7065008,7065017,7065043,7065044,8066132,7065076,7065143,7065144,7065146,7065148,7065149,7065150,7065151,7065152,7065153,7065280,7065281,7065282,7065283,7065334,7065355,7065359,7065366,7065408,7065409,7065411,7065412,7065414,7065415,7065418,7065422,7065574,7065586,7065589,7065599,7065601,7065603,7065607,7065608,7065610,7065611,7065615,7065625,7065631,7065636,7065639,7065648,7065651,7065654,7065658,7065659,7065664,7065666,7065669,7065671,7065673,7065680,7065683,7065686,7065690,7065692,7065697,7065701,7065721,7065723,7065724,7065725,7065730,7065733,7065741,7065743,7065745,7065747,7065748,7065750,7065753,7065760,7065765,7065768,7065773,7065784,7065787,7065789,7065790,7065791,7065792,7065797,7065799,7065800,7065801,7065807,7065808,10942600,10942611,10942622,10942624,10942774,10942913,10942923,10943151,10943169,10943228,8861469,10943330,10943346,8861535,10940974,10941916,10942201,10942215,10942220,10942254,8860496,10942401,10942404,10942410,8860604,10942521,10623489,10622632,10622633,10622644,10926651,10926652,10926653,10926654,10565329,10565330,10559692,10559693,10559695,10559696,10559697,10559699,10564448,10564449,10564450,10564451,10564453,10513387,10513404,10517556,10517558,10517559,10517560,10517561,10517562,10517563,10517571,10517572,10517574,10517592,10517593,10517599,10517600,10517601,10517602,10517603,10517604,10513886,10513888,10513889,10513891,10513896,10513899,10513913,10513914,10513915,10513918,10513919,10513920,10513921,10513922,10513923,10513924,10513925,10513926,10513927,10513928,10513929,10513930,10513931,10513932,10513933,10513934,10513938,10513939,10513940,10513944,10513945,10513948,10513964,10513968,10513975,10513980,10513982,10513983,10513984,10513989,10514004,10514005,10514008,10514009,10514010,10514011,10514012,10514013,10514014) 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'