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(7067847,7075847,7075911,7076064,7076070,7068142,7068143,7076252,7068254,7076255,7068262,7076272,7076276,7076277,7076280,7076321,10224560,10224561,10224562,10224563,7068327,7076329,7068332,7068334,7076340,7068343,7068344,7068349,7068350,7068356,7076360,10198809,7068738,7068749,10933288,7074102,7074130,7074137,7066138,7066169,7066171,7066185,10199502,10199503,10199504,7074268,10437311,10437312,10437313,10437314,7066402,10212745,10199776,10212802,10199809,7074619,7066665,7074730,7074781,7066827,7074847,7074940,7074986,7074987,7066997,8067991,8067992,8067993,8067994,8067995,8067996,8067997,8067998,8068001,8068002,8068032,8068033,8068034,8068035,8068042,8068043,8068044,8068050,10197341,8068086,10197400,8068211,8068222,8068223,8068237,8068238,8068266,10197523,10197524,8068282,8068283,8068293,8068294,8068374,8068407,8068408,7067453,8068473,8068474,8068475,8068484,8068530,8068531,8068532,8068617,8068625,8068640,8068641,10197930,7071827,10208570,10208636,10208637,10208641,7072436,7072457,7064458,7072458,7072548,7072549,7072550,7072551,7072552,7072553,7072554,7072555,7072579,7072603,7064678,7072800,7072947,7072961,10209269,7073068,10196318,10209406,10932773,10209576,7073346,7070849,10207100,10207165,10207166,10207167,10207168,10207169,7071029,8861087,10942931,10942944,10207504,10207651,10207652,8861320,10207662,8861351,8861352,10943291,8861497,10943315,10943316,10207873,10207874,8861542,8861547,8861548,10943383,10943391,10943401,10943418,8970220,7071755,7071771,7071772,7071773,10205142,10205143,10205167,7068937,7068963,7068964,7068965,7068981,7069009,10205286,10205287,7069183,7069233,7069234,7069235,7069236,7069237,7069238,7069257,10205552,10205553,10205554,10205555,10205556,10205557,10205558,10205559,10205560,10205561,10205562,10205563,10205564,10205565,10205566,10205567,7069462,10941354,7069984,10941727,10941844,10941845,10941855,10206432,10206433,10941912,10941913,10206476,10206477,10206478,10941956,10941971,10941972,10941978,10942035,8860337,10206711,10206712,10206779,10206780,10206781,10206782,10206783,10206784,10206852,10206853,7070651,10942429,7070732,7070741,7070742,10942458,7070743,10942473,7070798,7070819,10923480,10923481,10923482,10923483,10923519,10923520,10923534,10923544,10190134,10190137,10923565,10923566,10928576,10928590,10923593,10928597,10928601,10923619,10928621,10928622,10928633,10923636,10923653,10928654,10923654,10928655,10923655,10923656,10928656,10928657,10928658,10928659,10928660,10928661,10618235,10618277,10928812,10923829,10923882,10923974,10923975,10923976,10923977,10924056,10924057,10924058,10924059,10924390,10619022,10619023,10619024,10619025,10619026,10619027,10619028,10204228,10204229,10204230,10924784,10924785,10924786,10924787,10924788,10924789,10924875,10924876,10924877,10924878,10924879,10925186,10925187,10925188,10925239,10925240,10925383,10925384,10925385,10925386,10617063,10617064,10202205,10202206,10617107,10202207,10922644,10922645,10922730,10922731,10922732,10922733,10922734,10922754,10922760,10922761,10922762,10922763,10922764,10922765,10922766,10922767,10922768,10922813,10215444,10622345,10622346,10215445,10622347,10215446,10215447,10622348,10622349,10215448,10622350,10215449,10215450,10622351,10622352,10215451,10215452,10622353,10215453,10622354,10622355,10215454,10215455,10622356,10622357,10215456,10215457,10622358,10215458,10622359,10922898,10922907,10922960,10922961,10927992,10928006,10617509,10923030,10928062,10923147,10923148,10923176,10923281,10923282,10923361,10923390,10923406,10923407,10923408,10923409,10923452,10923453,8569814,10925505,10925506,10925507,10925508,10615014,10920537,10920557,8569880,8569881,8569884,10615078,10615079,10925721,10925722,10925723,10925724,10925725,10925726,10925842,10920873,10920874,10620408,10620422,8570282,8570301,8570302,10615471,8570347,10620664,10620670,10921211,10921239,10615820,10930729,10930730,10921499,10615987,10615989,10615990,10921597,10921598,10921599,10921614,10201209,10201222,10201223,10930962,10921731,10921751,10921752,10621252,10621253,10621254,10621255,10621256,10621257,10621269,10621270,10621271,10621277,10616284,10616285,10616286,10616287,10616288,10621300,10621311,10621374,10188665,10621652,10621653,10621654,10616669,10621706,10201878,10201982,10559290,10559320,10614296,7059848,7059853,7059872,7059873,8864335,10614472,10614821,7057480,7057486,7057494,7057503,7057521,10612033,10612069,10560242,10560243,10560244,10560245,10560246,7057630,10557504,10557633,10557634,10557635,10557636,10557637,10612488,10612518,10612589,10612604,10612633,10612641,10612647,10612648,10612655,10612658,10612675,10612684,10612685,10612689,10612690,10612701,7058230,8862666,7058319,10612836,10612938,10612943,10613106,7058748,10564454,8863171,10613306,8863176,10613342,7058853,7058870,8863314,8863320,8863321,8863322,8863323,8863324,8863325,8863347,8863348,8863362,8863363,8863364,8863365,8863390,8863395,8863411,8863412,8863413,10613553,7059064,7059065,7059099,8863472,8863473,8863474,10613608,7059124,8863500,8863510,8863511,7059156,8863542,8863543,8863544,8863545,8863546,8863547,7059273,7059323,7059449,7059460,7055749,10517544,10515597,10515598,10515599,4974647,10515614,4974794,7056108,4974854,7056232,10513887,7056285,10513962,10513963,7056481,7056482,7056483,10512142,10516557,2809381,10512758,10512759,10512760,10512761,10512787,10519053,10519054,10519055,10519056,10519057,10519058,10519089,7057466,10416244,8917988,10418260,10418261,10418262,9160352,9160353,10417544,10419568,8918320,10417739,10417760,10417766,10417775,10417790,10417817,10417818,10418829,10417836,10417837,9160928,9160929,10417853,10417854,10417871,10417872,10417888,10417889,10419892,10419896,10419902,10417906,10417907,10418984,10420040,10417057,10420058,10417058,10417076,10418083,10417093,10418095,10419104,10417106,10419107,10417107,10417108,10418124,10418131,7055433,6666481,6666482,6666483,10469149,10471178,10471179,10471180,4971471,10471194,6666642,6666643,6666644,6666645,6666646,6666647,6666648,4971507,4971508,8865219,4971604,10467359,4972038,4972039,4972040,4972077,4972098,4972128,4972129,4972236,10467985,10468019,10468044,10468141,6667577,8917229,6667653,6667660,6667661,10470376,10470380,10470381,10470385,10470483,10470490,10470590,10470593,6668155,10628012,10628013,10628014,10628015,10628016,10628017,10628022,10628090,10628828,10629606,10629607,10629658,10629754,10629755,10629808,10629837,10629904,10627002,10632053,10632094,10627279,10627281,10627282,10630114,10630191,10630213,10630227,10630228,10630230,10630351,10630360,10630361,10630362,10630373,10630374,10630375,10630376,10630377,10630378,10630379,10630380,10630381,10630382,10630455,10630461,10630502,10630515,10630516,10630517,10630518,10630519,10630520,10630521,10630522,10630523,10630524,10630525,10630526,10630527,10630610,10630611,10630612,10630711,10630712,10630713,10630878,10630895,10631005,10631008,10631009,10626131,10631155,10631156,10626195,10631204,10631207,10631208,10631238,10631239,10631240,10631241,10631242,10631243,10631244,10631245,10626441,10626516,10626551,10626552,10626742,10631885,10571402,10571403,10571404,10571405,10571406,10571407,10574460,10574461,10574462,10568619,10568620,10571658,10571659,10574752,10574779,10571789,10571790,10571791,10571792,10571793,10571794,10571795,10574796,10571796,10571797,10574797,10571798,10574897,10574898,10569290,10569291,10569292,10569293,10566470,10566471,10566472,10566473,10566474,10566475,10566476,10566477,10566478,10566479,10572480,10566480,10572481,10572482,10572483,10569495,10569496,10569518,10569519,10569520,10569521,10572522,10569684,10569685,10569686,10569687,10569688,10569705,10569706,10569707,10569708,10569709,10569710,10569711,10569712,10569713,10569852,10572999,10573000,10573001,10570067,10570068,10570081,10570082,10570083,10570096,10570097,10570098,10573243,10573244,10570280,10570281,10570282,10570283,10570284,10570285,10570286,10570287,10570455,10570456,10570457,10573479,10573480,10573481,10570542,10570543,10570544,10570545,10570546,10521184,10521185,10521189,10521190,10521191,10521192,10521193,10521194,10521263,10521264,10521266,10521291,10521292,10521666,10521667,10521840,10521841,10521916,10521917,10521918,10521919,10522018,10522019,10522214,10522463,10522510,10522511,10522525,10522527,10522528,10522529,10522531,10522728,10520827,10520829,10520830,10520831,10520832,10520833,10520834,10520850,10520852,10520853,10520854,10520855,10522889,10520901,10520904,10520905,10520917,10522950,10522951,10522952,10523105,10523106,10420288,10420314,10421397,10420643,10420899,10421947,10421948,10421949,10421950,10422007,10422008,10422009,10422018,10422027,10422038,10422039,10422050,10422064,10422065,10422066,10422067,10421091,10422100,10421102,10422121,10422122,10422151,10422167,10422200,10422209,10422210,10473626,10474074,10472871) 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'