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(4970193,4970194,4970195,4970196,4970197,4970198,4970199,4970200,4970201,4970202,4970203,4970204,4970205,4970206,4970207,4970208,4970209,4970210,4970211,4970212,4970213,4970214,4970215,4970216,4970217,11001858,11001859,11001860,11001861,11001862,11001863,11001864,11001865,11001866,11001867,11001868,11001869,11001870,11001871,11001872,11001873,11001874,11001875,11001877,11001878,11001879,11001880,11001881,11001882,11001883,11001884,11001885,11001886,11001887,11001888,11028065,11028066,11015214,7068610,10963318,10963371,10963372,10963376,10963377,10944158,10944159,10944160,10944161,10944162,10944163,10944164,10944165,10944166,10944167,10944168,10944169,10944170,10944171,10963470,10940429,10963520,10963521,10950577,7065986,7074004,7074031,7074107,7074108,7074109,7074110,7074111,7074112,7074113,7074114,7074115,7074116,7074117,7074118,7074119,7074120,7074121,7074122,7074123,7074124,7074125,7074126,7074127,7074128,7074129,7074130,7074131,7074132,7074133,7074134,7074135,7074136,7074137,8067393,8067541,8067542,11013653,8837517,8837518,11013719,11013720,10938733,11039889,7067422,8837969,8837970,8837971,8837972,8837973,11001313,10939262,10939263,10939264,10939265,10939266,10939398,10962476,10939415,8838286,10962572,10962573,11014618,10998687,10998688,11037995,11037996,11037997,8065474,8065475,8065476,8065477,8065478,8065479,8065480,8836153,11025571,11012632,11012633,11012634,10999642,8066198,8066199,8066200,10932590,10932591,10932592,11000141,11000142,11000143,7065486,7065487,7065488,10932851,10932852,7073514,10974211,10974212,10974213,10974214,10974215,10974216,10933047,11013431,11013432,11013574,11013575,11013576,11036741,8834666,10942827,10942828,11036890,10942829,11036891,10942830,11036892,10942831,11036893,10942832,11036894,11036895,11036896,11036897,11036898,11036899,11036900,11036901,8834742,5999939,10959501,10959502,10959503,7071819,8970210,10959504,7071820,10995822,11034921,11034922,11034923,11034924,11034925,11034926,11034927,11034928,11034929,11034930,11034931,11034932,11034933,11034934,11034935,11034936,11034937,11034938,11034939,11034940,11034941,11034942,11034943,11034944,11034945,11034946,11034947,11034948,11034949,11034950,11034951,11034952,11034953,11034954,11034955,11034956,11034957,11034958,11034959,11034960,11034961,11034962,11034963,11034964,11034965,11034966,11034967,11034968,11034969,11034970,11034971,11034972,11034973,11034974,11034975,11034976,11034977,11034978,11034979,11034980,11034981,11034982,11034983,11034984,11034985,11035031,10944771,10944943,8564509,8564510,8564511,8564512,8564513,8564514,8073086,8073087,3656979,11048336,10942287,11048694,10942425,10984490,10984491,10984492,10984493,10984494,10984495,10984496,10984497,10984498,10984499,11048804,11045620,10980721,10980722,10980723,10980724,10980725,10980726,10980727,10980728,10980729,10980730,10980731,10980732,10980733,11019826,10967955,10623341,11046089,10623435,10919030,10618934,10618935,10618936,10618937,10618938,10618939,10618940,10618941,10618942,10618943,10618944,10618945,10618946,10618947,10618948,10922475,10922476,11005934,11005935,11005983,10922954,10922955,10922956,10922957,10922958,10922959,10922960,10922961,10922962,10922963,10922964,10922965,11006420,11006423,11006425,11006464,11006465,11006545,11006546,11006551,11006552,11006553,11006554,11006570,11032570,11032571,8570163,8570358,11030148,11030149,11030150,11030151,11030152,10916094,11017280,11043345,11043346,11043347,10916205,10916206,10916207,10916208,10916209,10916210,10916211,10916212,10916213,10916214,11017437,11017438,11017439,11017440,11017444,11017445,10978507,10978508,10978509,10978510,10978511,10978512,10978513,10978514,10978515,10978516,10978517,10978518,10978519,10978520,10978521,10978522,10978523,10978524,10978525,10978526,10978527,10978528,10978529,10978530,10978531,10978532,10978533,10978534,10978535,10978536,10978537,10921536,10921537,10921538,10921539,10921540,10921541,10921542,10921543,10921544,10921545,10921546,10921547,10921548,10921549,10921550,10921551,10921552,10921553,10921554,10921555,11004930,10953071,10953072,10953073,10953074,10917249,10917250,10917251,10917252,10917253,10917254,10917255,10917256,10917257,10917258,10917259,10917260,10917261,9205300,9205301,9205302,9205317,10565343,10565344,10565345,10611237,9181848,9181849,8864521,8864522,9198094,10566080,10566081,10566082,9179609,9179610,9171654,8862236,8862237,8862238,8862239,8862240,8862241,8862242,8862243,8862244,8862245,8862246,10563551,10563552,10609707,10612852,10612863,10612871,9204364,9204365,9204366,9204367,9204368,9204369,9204370,9196371,9204371,9196372,9204372,9196373,9204373,9204374,9204375,9204376,9204377,9204378,9204379,9204380,9204381,9204382,9204383,9204384,9204385,9204386,9204387,9204388,9204389,9204390,9204391,9204392,9204393,9204394,9204395,9204396,9204397,7058753,7058754,9172776,9172888,9172889,10613566,9193321,4974363,4974364,4974509,4974510,7055871,4974686,4974687,9193847,10515735,10515736,10513753,7056204,9186172,9186175,9186213,9186214,9178536,9178537,9178538,9178539,9178540,9178541,9178542,9178543,9178544,9178545,2809252,9170637,2809284,9186785,10516646,10516647,10516648,10516649,10516650,7057087,7057088,10514783,10514784,10514785,10514786,10514787,10512847,10516953,10516954,9176376,10418503,4973548,7054894,9160750,9160751,10419690,4973929,4973930,4973931,10417046,7055332,7055333,7055334,10417204,9166462,9166463,9166464,9166465,9166466,9166467,9166468,9166469,9166470,9166471,9166472,9166473,9166474,9166475,9174660,9174661,9174662,9174663,9174664,9174665,9174666,9174761,9174762,4972030,4972031,10469842,6667340,6667341,6667342,6667784,6667785,8917484,8917485,10466724,10466725,10466726,10466727,10466728,10466729,10466730,10466731,10466732,10466733,10466734,10466735,10466736,10466737,10466738,10466739,9168193,9176201,10628020,10174957,10628607,10628929,10628930,10175606,10175607,10175608,10175609,10160610,10175610,10160611,10175611,10160612,10175612,10160613,10175613,10160614,10160615,10160616,10160617,10160618,10160619,10160620,10160621,10160622,10160623,10160624,10160625,10160626,10160627,10160628,10160629,10160630,10160631,10160632,10160633,10160634,10160635,10160636,10160637,10160638,10160639,10160640,10160641,10160642,10160643,10160644,10160645,10160646,10160647,10160648,10160649,10160650,10160651,10160652,10160653,10160654,10160655,10160656,10160657,10160658,10160659,10160660,10160661,10160662,10160663,10160664,10160665,10160666,10160667,10160668,10160669,10178494,10178495,10178496,10178497,10178498,10163608,10627577,10627578,10627660,10627661,10627662,10630075,10176613,10630103,10161936,10630655,10630656,10630657,10630658,10630659,10177187,10162275,10168074,10168075,10168076,10168077,10168078,10168079,10168080,10168081,10168082,10168083,10168084,10163263,10178357,10178358,10178359,10580489,10580490,10580500,10572278,10572279,10578493,10578494,10578495,10578496,10578497,10578498,10578499,10578500,10578501,10578502,10578503,10578504,10578505,10578506,10578507,10578508,10578509,10578510,10578511,10578512,10578513,10578514,10578515,10578516,10578517,10578518,10578519,10578520,10578521,10578522,10578523,10578524,10578525,10578526,10578527,10578528,10578529,10578530,10578531,10578532,10578533,10578534,10578535,10578536,10578537,10578538,10578539,10578540,10578541,10578542,10578543,10578544,10578545,10578546,10578547,10578548,10578549,10578550,10578551,10578552,10578553,10578554,10578555,10578556,10578557,10578558,10578559,10578560,10578561,10578562,10578563,10578564,10578565,10578566,10578567,10578568,10578569,10578570,10578571,10578572,10578573,10578574,10578575,10578576,10578577,10578578,10578579,10578580,10578581,10578582,10578583,10578584,10578585,10578586,10578587,10578588,10578589,10578590,10569595,10569596,10575760,10581774,10575893,10575894,10573048,10573049,10573050,10573051,10573052,10573053,10573054,10585138,10585139,10585140,10567502,10567503,10567504,10567505,10567506,10567507,10567508,10570680,10570681,10570682,10570683,10570684,10570685,10570686,10570687,10570688,10570759,10579876,10574037,10521198,10521199,10521200,10521201,10521202,10521203,10521204,10521205,10521206,10521207,10521208,10521209,10521210,10521211,10521212,10520064,10520065,10520066,10520067,10520068,10520069,10520070,10520071,10520072,10520073,10520074,10520075,10520076,10520077,10524761,10524762,10524763,10524764,10524765,10524766,10524767,10524768,10524769,10531029,10423748,10421935,10472951,10472952,10472953,10473241,10473242,10473243,10473244,10473245,10473246,10479542,10479543,10479544,10479545,10479546,10479547,10479548,10479549,10479550,10479551,10479552,10479553,10479554,10481640,10473775,10473776,10473777,10473778,10473779,10473780,10473781,10473782,10473783,10473784,10473785,10473786,10473787,10473788,10473789,10473790,10481795,10481796,10474276,10474277,10476838) 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'