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(7067874,7067875,7067876,7067877,7067878,7067879,7067880,7067881,7067882,7067883,7067884,7067885,10962691,11001731,10939888,11001876,10939928,10939930,4970738,7076404,8569609,8569720,7065982,10963726,10963730,10963731,10963857,7066177,7074307,10437501,7074558,10437519,10437524,7074905,7075388,7075389,7075390,11001075,7075391,11001076,10962081,11001101,11001103,11001104,11001105,11001106,11001107,11001108,11001109,11001111,11001114,11001115,11001116,11001117,7075485,7075489,7075519,7075522,7075525,11001212,11001213,11001214,11001215,11001216,7075534,10962234,10962235,7075552,7075568,7075571,7075579,7067583,7075590,7075609,7075610,7075611,7075612,7075613,7075614,7075615,7075618,7075619,7075623,7075624,7075626,7075627,7075628,7075630,7075635,7075637,7075638,7075639,7075640,7075641,7075642,7075644,7075645,7075719,7075720,7067793,10985682,10985683,10985684,10985685,10985686,10985687,10985688,10985689,10985690,10985691,10985692,10985693,10985694,10985695,10985696,10985697,10985700,10985701,10985706,10985707,10985708,10985709,10985710,10985712,10985714,10985715,10985716,10985717,10985718,10985719,10985720,10985721,10985722,10985723,10985724,10985725,10985726,10985727,10985728,10985729,10985730,10985731,10985732,10985733,10985734,10985735,10985736,10985743,10985744,10985745,10985746,10985747,10985748,10985749,10985750,10985751,10985752,10985753,10985754,10985756,10985757,10985758,10931652,7072219,10960010,10960011,10999024,10999041,10999042,10999069,10999070,10999072,10999074,10999078,10999079,10999080,10999089,10999090,10999091,10999092,10999093,10960519,10960609,10960610,10960611,10960612,10960613,10960614,10960615,10960616,10960617,10960618,10960619,10999729,7065118,7065119,10960946,10960962,10960963,7073419,10961141,10961142,10961143,10961144,10961145,10961146,10961183,10961184,10961185,10961186,10961187,10961188,10961189,10961190,10961191,10961193,10961196,10961197,10961201,10961202,10961203,7073603,10942699,10942754,10997779,10997793,10997794,7071156,7071160,10997875,10997876,8861162,10958987,10958988,10958989,7071460,10985213,10943255,10943256,10985226,7071551,10998387,3655659,3655664,3655666,10940952,10940954,10957182,10957183,10957184,10941453,3656538,3656539,3656540,3656541,3656542,3656543,3656544,3656549,3656550,3656551,3656552,3656553,3656554,3656555,3656556,3656557,3656558,3656559,3656560,10996686,10996702,10996703,10996704,10942322,7070684,8860713,8860714,10622967,10623065,10618204,10967768,10967769,10967770,10967779,10967780,10618265,10967901,10967929,8070117,10968010,10968011,10968014,10968015,10968016,10968017,10968018,10968055,10968056,10994150,10994151,10994152,10623659,10968298,10968439,8070810,10619177,10619193,10624729,10624730,10624802,10624804,10619835,10619844,10619875,10619879,10619880,10619881,10619882,10619883,10619884,10619885,10619886,10619887,10619888,10619889,10619890,10619891,10619892,10619893,10619894,10619895,10619896,10619897,10619898,10619899,10619900,10619901,10619902,10619903,10619904,10619905,10619906,10992577,10617053,10966893,10966894,10966897,10953951,10928159,10954226,10954227,10954310,10954311,10954312,10954314,10617803,10622906,10622912,10622924,10622937,10619981,10990586,10990587,10990588,10990589,10990590,10990591,10990592,10990593,10990594,10990595,8569917,10615090,10620174,10620183,10620187,10620188,10620191,10620192,10620193,10620194,10620196,10620199,10620203,10620204,10620205,10620206,10620207,10615465,10620465,8570399,10615574,8570410,8570411,8570413,10620595,10615597,10615598,8570433,10620603,10620604,8570444,10620623,8570457,10615819,10991381,10991382,10991383,10991384,10965542,10616019,10616033,10616573,10616794,10616795,10562270,10562271,10562272,10562273,10562274,10562275,10562276,10562277,10559332,10559333,10559334,10611193,10611194,10614238,10611251,10614269,7059868,10614366,6665726,6665727,10614532,10562767,10611696,6666064,6666069,6666070,6666071,6666077,6666082,10611758,6666097,6666098,6666099,6666100,8864794,7057606,7057638,7057639,7057715,10612322,10612323,10612325,10609330,10609348,10609350,10609351,10609352,10609357,10609358,10609359,10609362,10609363,10609367,10609376,10609385,10609400,10609834,10558141,10610030,10613074,8862938,8862939,10558294,10613194,9164603,7058776,9164648,7058840,7058841,9164685,9164690,9164720,9164745,10613475,9164836,10613548,10613721,9173173,9173254,10515316,10515317,10515318,10515319,10515320,10515321,10515322,10515323,10515324,10515325,10515327,10515336,10515337,10515338,10515339,10515340,10513556,10513557,10513558,10517651,10517652,10517653,10517753,9169959,10517788,10517801,10517802,10517803,10517804,7056200,7056212,10512180,10512181,10512182,10512183,10512184,10512185,10512186,10512187,10512188,10512189,10512190,9170866,7057191,10516930,10516931,10516932,10516934,10516935,10516937,10516938,10516939,10516940,10516941,10516942,10516943,10516944,10516945,10516946,10516947,10516948,10516949,10516950,10516951,10516952,10516953,10516954,10516955,7057460,9160306,9160307,4973244,9168494,7055193,7055195,7055199,7055200,7055203,7055215,7055220,4973908,7055223,4973923,9161229,4971315,4971316,6667026,6667028,6667029,6667035,6667038,6667236,6667356,6667357,6667358,6667359,6667360,6667361,8563549,6667857,6667891,6667892,6667894,6667895,6667896,6667897,6667898,6667899,6667900,6667901,6668079,6668080,6668081,6668119,9168151,10628146,10628147,10159804,10159805,10159814,10159815,10159819,10159820,10159821,10159824,10159825,10628324,10159864,10159865,10159866,10159867,10159868,10159871,10159872,10159873,10159882,10159883,10159885,10159924,10628430,10628769,10628783,10628826,10628827,10628828,10629149,10155674,10155675,10155676,10155681,10155682,10155683,10155684,10155685,10155686,10155687,10156149,10156326,10156327,10156337,10156338,10627002,10632108,10632109,10627143,10627144,10632166,10632189,10632215,10632222,10632243,10163770,10627320,10627322,10627323,10627332,10627410,10627411,10627412,10627413,10627414,10627415,10627590,10627663,10627711,10627948,10154474,10154475,10154476,10154477,10154478,10154479,10154480,10630022,10630110,10630114,10630163,10630164,10630165,10630166,10630167,10630853,10630856,10626111,10626117,10626118,10626119,10626120,10626121,10626122,10626145,10626199,10626200,10626201,10626202,10626203,10626217,10631278,10631281,10631282,10631283,10631287,10631288,10631289,10626298,10631312,10631408,10626445,10626455,10631492,10631505,10163106,10163107,10163108,10163109,10163110,10163111,10626731,10163323,10631885,10626922,10626951,10626952,10626953,10566125,10566126,10566127,10566128,10566129,10521337,10521338,10525631,10525747,10525748,10525749,10525750,10525813,10526114,10526115,10526116,10526117,10526118,10526119,10526120,10526121,10526122,10526123,10526124,10526125,10526126,10526127,10526128,10526129,10526130,10526131,10526132,10526133,10526134,10526135,10526136,10526137,10526138,10526139,10526140,10526141,10526142,10526143,10526144,10526145,10526146,10526147,10526148,10526149,10526150,10526151,10526154,10526155,10526156,10526157,10526158,10526159,10526160,10526161,10526162,10526163,10526164,10526165,10526166,10526167,10526168,10526169,10526170,10526171,10526172,10526173,10526174,10526175,10526176,10526177,10526178,10526179,10526180,10526181,10526182,10526183,10526184,10526185,10526186,10526187,10526188,10526189,10526190,10526191,10526192,10526193,10526194,10526195,10526196,10526197,10526198,10526199,10526200,10526201,10526202,10526203,10526204,10526205,10526206,10526207,10526208,10526209,10526210,10526211,10526212,10526213,10526214,10526215,10526216,10526217,10526218,10526219,10526220,10526221,10526222,10526223,10526224,10526225,10526226,10526227,10526228,10526229,10526230,10526231,10526232,10526233,10526234,10526235,10526236,10526237,10526238,10526239,10526240,10526241,10526242,10526243,10526244,10526245,10526246,10526247,10526248,10526249,10526250,10526251,10526252,10526253,10526254,10526255,10526256,10526257,10526258,10526259,10526260,10526261,10526262,10526263,10526264,10526265,10526266,10526267,10526268,10526269,10526272,10526273,10526274,10526275,10526276,10526277,10526278,10526279,10526280,10526281,10526282,10526283,10526284,10526285,10526286,10526287,10526288,10526289,10526290,10526291,10526329,10526330,10526331,10526332,10526333,10526334,10526335,10526336,10526337,10526338,10526339,10526340,10526341,10526342,10526343,10526344,10526345,10526346,10526347,10526348,10526349,10526350,10526351,10526352,10526357,10526358,10526359,10526360,10526361,10522619,10522620,10522828,10524869,10524872,10524873,10524879,10524880,10524881,10524882,10524883,10524884,10524885,10524917,10524918,10525013,10525014,10525068,10421368,10421369,10422372,10422373,10422374,10422375,10422376,10422377,10422378,10422379,10422383,10421390,10422403,10420860,10420863,10420866,10420867,10420870,10420871,10420872,10420876,10420880,10420881,10420883,10420885,10477145,10477146) 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'