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(10939647,10939648,10939649,10939650,10939651,8569447,8569661,10963508,10963509,10963510,10963511,10963512,10963513,10963514,10963515,10963516,10963517,10963518,10963519,10963520,10963521,10963522,10963523,10963524,10963525,10963526,10963527,4971060,10963528,10963529,4971061,10963530,4971062,10963531,10963532,10963533,10963534,10963535,10963536,10963537,10963538,10963539,10963540,10963541,10963542,10963543,10963544,10963545,10963546,10963547,10963548,10963549,10963550,10963551,10963552,10963553,10963554,10963555,10963556,10963557,10963558,10963559,10963560,10963561,10963562,10963563,10963564,10963565,10963566,10963567,10963568,10963569,10963570,4968306,4968307,4968308,4968309,7066766,7066767,7066836,7074844,7066909,7066910,7066911,7066912,7066913,7066914,7066915,7066916,7066917,7066918,7066919,7066920,7066921,7066922,7066923,7066924,7066925,7066926,7066927,7066928,7066929,7074948,10962060,10962061,10962062,7075442,7075443,7067560,7064603,8065820,7065342,7065421,7065422,7065604,7065930,7065931,7065932,10942789,10942793,10942820,10942893,10942897,10942898,10942899,10942900,10942903,10942911,10943064,10943065,10943066,10943067,10943069,10943070,10943109,10940853,10940854,10940855,7069480,7069481,7069482,8073121,8073137,8073166,8073265,8073288,8073327,10967950,10967951,10619129,10619130,10619131,10619132,10619133,10619134,10619135,10619136,10619137,10619138,10619139,10619140,10619141,10619142,10619143,10619144,10619145,10619146,10619147,10619148,10619149,10619150,10619151,10619152,10619153,10619154,10619155,10619156,10619157,10619158,10619159,10619160,10619161,10619162,10619163,10619164,10619165,10619166,10619167,10619168,10619835,10619836,10619863,10953691,10622533,10622551,10622552,10622553,10622554,10622555,10622556,10622557,10622558,10622559,10622560,10622561,10617572,10954604,10954605,10954606,10954607,10954608,10954609,10954610,10954611,8570352,8570353,8570354,10930654,10930655,10930656,10926786,10926787,10926846,7059465,7059466,8864338,6665832,10612005,10612006,10609388,10609389,10609390,8862715,10610170,10610171,10610172,10610173,10610174,10610175,10610176,10610177,10610178,10610179,10610180,10610181,10610182,10610183,10610184,10610185,10610186,10610187,10610188,10610189,10610190,10610191,10610192,10610193,10610194,10610195,10610196,10610197,10610198,10610199,10610200,10610201,10610202,10610203,10610204,10610205,10610206,10610207,10610208,10610209,10610210,10610211,10610212,10610213,10610214,10610215,10610216,10610217,10610218,10610219,10610220,10610221,10610222,10610223,10610224,10610225,10610226,10610227,10610228,10610229,10610230,10610231,10610232,10610233,10610234,10610235,10610236,10610237,10610238,10610239,10610240,10610241,10610242,10610243,10610244,10610245,10610246,10610247,10610248,10610249,10610250,10610251,7058843,7058844,7058845,7058846,7058847,7058848,7058849,7058850,7058852,7058854,7058857,7058858,7058861,7058863,7058864,7058900,7058929,7058930,7058931,7058932,7058936,7058937,7059064,7059066,7059069,7059075,7059076,7059077,7059078,7059079,7059080,7059081,7059084,7059085,7059086,7059090,7059092,7059093,7059097,7059098,7059099,7059100,7059101,7059102,7059103,7059104,7059105,7059106,7059107,7059108,7059109,7059111,7059112,7059115,7059118,7059119,7059122,7059123,7059124,7059128,7059129,7059130,7059131,7059132,7059133,7059135,7059136,7059137,7059138,7059139,7059140,7059141,7059144,7059145,7059146,7059148,7059150,7059151,7059158,7059163,7059165,7059166,7059167,10610664,7059173,7059176,7059178,7059179,7059180,7059181,7059187,7059188,7059191,7059192,10610697,10564864,7059408,7059446,7059447,7059448,7059449,7059450,7059451,7059452,7059453,7059454,7059455,7059456,7059457,7059458,7059459,7059460,10517112,10517113,10517114,10517115,10517116,10517117,10517118,10517119,10517120,10517121,10517122,10517123,10517124,10517125,10517126,10517127,10517128,10517129,10517130,10517131,10517132,10517133,10517134,10517135,10517136,10517137,10517138,10517139,10517140,10517141,10517142,10517143,10517144,10517145,10517146,10517147,10517148,10517149,10517150,10517151,10517152,10517153,10517154,10517155,10517156,10517157,10517158,10517159,10517160,10517161,10517162,10517163,10517164,10517165,10517166,10517167,10517168,10517169,10517170,10517171,10517172,10517173,10517174,10517175,10517176,10517177,10517178,10517179,10517180,10517181,10517182,10517183,10517184,10517185,10517186,10517187,10517188,10517189,10517190,10517191,10517192,10517193,10517194,10517195,10517196,10517197,10517198,10517199,10517200,10517201,10517202,10517203,10517204,10517205,10517206,10517207,10517208,10517209,10517210,10517211,10517212,10517213,10517214,10517215,10517216,10517217,10517218,10517219,10517220,10517221,10517222,10517223,10517224,10517225,10517226,10517227,10517228,10517229,10517230,10517231,10517232,10517233,10517234,10517235,10517236,10517237,10517238,10517239,10517240,10517241,10517242,10517243,10517244,10517245,10513246,10517246,10517247,10517248,10517249,10517250,10517251,10517252,10517253,10517254,10517255,10517256,10517257,10517258,10517259,10517260,10517261,10517262,10517263,10517264,10517265,10517266,10517267,10517268,10517269,10517270,10517271,10517272,10517273,10517274,10517275,10517276,10517277,10517278,10517279,10517280,10517281,10517282,10517283,10517284,10517285,10517286,10517287,10517288,10517289,10517290,10517291,10517292,10517293,10517294,10517295,10517296,10517297,10517298,10517299,10517300,10517301,10517302,10517303,10517304,10517305,10517306,10517307,10517308,10517309,10517310,10517311,10517312,10517313,10517314,10517315,10517316,10517317,10517318,10517319,10517320,10517321,10517322,10517323,10517324,10517325,10517326,10517327,7055868,7055897,7055898,7055899,7055900,7055901,7055902,7055903,7055904,7055905,7055906,7055907,7055908,7055909,7055910,7055911,4974770,4974771,4974772,4974773,4974774,4974775,4974776,4974777,4974778,4974779,4974780,4974781,4974782,4974783,4974784,10517812,10517813,10517814,10517815,10517816,10517817,10517819,10516964,10516965,10516966,10516967,10516968,10516969,10516970,10516971,10516972,10516973,10516974,10516975,10516976,10516977,10516978,10516979,10516980,10516981,10516982,10516983,10516984,10516985,10516986,10516987,10516988,10516989,10516990,10516991,10516992,10516993,10516994,10516995,10516996,10516997,10516998,10516999,10517000,10517001,10517002,10517003,10517004,10517005,10517006,10517007,10517008,10517009,10517010,10517011,10517012,10517013,10517014,10517015,10517016,10517017,10517018,10517019,10517020,10517021,10517022,10517023,10517024,10517025,10517026,10517027,10517028,10517029,10517030,10517031,10517032,10517033,10517034,10517035,10517036,10517037,10517038,10517039,10517040,10517041,10517042,10517043,10517044,10517045,10517046,10517047,10517048,10517049,10517050,10517051,10517052,10517053,10517054,10517055,10517056,10517057,10517058,10517059,10517060,10517061,10517062,10517063,10517064,10517065,10517066,10517067,10517068,10517069,10517070,10517071,10517072,10517073,10517074,10517075,10517076,10517077,10517078,10517079,10517080,10517081,10517082,10517083,10517084,10517085,10517086,10517087,10517088,10517089,10517090,10517091,10517092,10517093,10517094,10517095,10517096,10517097,10517098,10517099,10517100,10517101,10517102,10517103,10517104,10517105,10517106,10517107,10517108,10517109,10517110,10517111,8918274,8918275,10418730,10418731,10467177,10467777,10467778,10467779,10467780,10467781,10467782,10467783,10467784,10467785,10467786,10467787,10467788,10467789,10467790,10467791,10467792,10467793,10467794,10467795,10467796,10467797,8916932,8916933,8563381,8563382,4972505,4972506,10464575,10464576,10464577,10628177,10628850,10628851,10628852,10628853,10628854,10628855,10630288,10630299,10630300,10630302,10630303,10630304,10630305,10630306,10630310,10630311,10630312,10630313,10630314,10630843,10630844,10630845,10630846,10630847,10630848,10630849,10630850,10630851,10630852,10630858,10630859,10630860,10630861,10630862,10630863,10630865,10630866,10630867,10630868,10630869,10630872,10630873,10630874,10630875,10630876,10630877,10630879,10630880,10630882,10630883,10630884,10630885,10630886,10630887,10630888,10630889,10630890,10630891,10630897,10630898,10630899,10630900,10630901,10630902,10630903,10630904,10630905,10630906,10630907,10630908,10630909,10630910,10630911,10630912,10630913,10630914,10630915,10630916,10630918,10630919,10630920,10630921,10630922,10630923,10630924,10630925,10630926,10630927,10630928,10630929,10630930,10630931,10630932,10630933,10630935,10630936,10630938,10630939,10630940,10630942,10630943,10630944,10630945,10630946,10630947,10630948,10630949,10630950,10631019,10631020,10631021,10631022,10631023,10631024,10631025,10631026,10631027,10631028,10631030,10631031,10631032,10631033,10631034,10631036,10631037,10631050,10631368,10631369,10631884,10522476,10522477,10420415,10420416,10420653) 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'