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(8569495,11041316,7065977,7065996,7065997,7065998,7065999,8583495,7066042,8583548,10950705,8583560,10950753,7066165,7066178,7066185,7066186,7066187,7066209,7066239,8067907,10939434,8910057,8910466,10959184,10101496,10101566,8860416,10958351,8905975,8905977,8906018,8906019,8906022,8906037,8906056,8906084,8906085,8906086,8906088,8906100,8906101,8906142,8906168,8906169,8906170,8906205,8906207,8906216,8906217,8906218,8906219,8906220,8906222,8906223,8906224,8906237,8906243,8906244,8906245,8906246,8906247,8906248,8906249,8906314,8906335,8906336,8906337,8906338,8906390,8906391,8906394,8906401,8906402,10623491,8906403,10623492,8906404,8906406,8906407,8906408,8906409,8906421,8906426,8906427,8906428,8906549,8906552,8906773,8906853,8906854,10968547,8906952,10619897,10617016,10617072,10617127,8905042,10617144,10617145,10617146,10617147,10617148,10617149,10617150,10617151,10617152,10617153,10617154,10617158,10617159,10622293,10622314,10622317,10622326,10617326,10622339,10622366,8905311,8905312,8905313,10622434,10617439,10617440,10617441,10617442,10617443,10622457,10622461,10622492,10622495,10622500,10622501,10622504,10622521,10622525,10622530,10622535,10622537,8905473,8905733,8905859,8905860,10615002,10615027,10615030,10615031,10615046,10615067,10615069,10990766,10615334,10615353,10615354,10615358,10615389,10615394,10615399,10615400,10615417,10615418,10615419,10615422,10615423,10615426,10615438,10615439,10615450,10615465,10615472,10615473,10615483,10615488,10615490,10615491,10615504,10615507,10615533,10615536,10615543,10615548,10615552,10615575,10615583,10615607,10615608,10615625,10615631,10615643,10615644,10615645,10615709,10615720,10615729,10615730,10615731,10615732,10615733,10615734,10615735,10615745,10615749,10615750,10615762,10615803,10615819,10615828,10615846,10615849,10615879,10615911,10615924,10615925,10615937,10615939,10615951,10615953,10615954,10615955,10615969,10615970,10615983,10615984,10615989,10616007,8904529,8904535,8904552,8611405,8611449,8611466,8611467,10616855,10616879,10616880,10616882,10616892,10616894,10614066,8864083,10611261,10614268,10611268,10611269,10611270,10611271,10611272,10611273,10611274,10611275,10714125,10611330,10611331,10611338,10611342,10611345,10611346,10611347,10714183,10614426,10614427,10614428,10614429,10614430,10614431,10614432,10614433,10614434,10614435,10614436,10614437,10614438,10614439,10611761,10611776,10614786,10611801,10611802,10614808,10614809,10614810,10611815,10611830,10611998,10612094,7017141,7017142,7017143,7017144,7017145,7017146,7017147,7017148,7017149,7017150,7017151,7017152,7017153,7017154,10612264,7017263,7017264,7017265,7017266,7017281,7017282,7017305,7017306,7017307,7017308,7017343,7017344,7017345,7017346,7017347,7017348,7017393,7017394,7017395,7017396,7017397,7017398,10612411,10612493,10612502,10612503,10612507,10612508,10612509,10612510,10612512,10612520,10612524,10612525,10612526,10612527,10612528,10612531,10612532,10612538,7017533,7017534,10612547,7017539,7017540,10612551,10612552,7017545,10612554,7017546,10612555,10612556,10612557,10612558,7017551,7017552,10612565,10612566,10612567,10612568,10612570,10612571,10612573,10612579,10612580,10612585,7017579,7017580,10612594,10612595,10612596,10612597,10612608,10612609,7017603,7017604,10612618,10612619,10612624,7017627,7017628,10612644,10612645,10612651,7017651,7017652,10612679,10612680,7017679,7017680,7017681,7017682,7017683,7017684,7017685,7017686,7017687,10612697,7017688,10612699,10612716,7017711,7017712,7017713,7017714,10612724,7017715,7017716,10612725,7017717,7017718,7017719,7017720,7017721,10612730,7017722,7017723,7017724,7017725,7017726,7017727,7017728,7017729,7017730,7017731,7017732,7017733,7017734,7017735,7017736,7058248,7017737,7017738,7017751,7017752,7017753,7017754,7017795,10612836,10612837,10612838,10612839,10612844,10612845,10612846,10612848,10612853,10612865,10612866,10612874,10612875,10612876,10612879,10612880,10612901,10612902,10612903,10612916,10612927,10612949,10609978,10609982,10612993,10610042,10613079,10613081,10613082,10613084,10613085,10613086,10613087,10613088,10613089,10613090,10613091,10613092,10613093,10613094,10613102,10610323,10610357,10610362,10610364,10610372,10610373,10613645,10610694,10610793,10610836,10610862,9169314,9169357,7055534,7055553,9169449,7055639,9169475,9169476,9169484,9169496,9169522,9169534,7015196,7015197,7015198,7015199,7015200,7015201,7015202,7015203,7015204,7015205,7015206,7015207,9169553,7015208,7015209,7015210,7015211,7015212,7055724,7015213,7015214,7015215,9169561,7015216,9169572,9169573,9169665,9169668,9169674,9169681,9169829,7015486,7015487,4974691,7015498,7015499,7015504,7015505,9161960,7056193,7015682,7015683,7015838,7015839,7015840,7015841,7015842,7015843,7015844,7015845,7015846,7015847,7015888,7015889,7015890,7015891,7015892,7015893,7015894,7015895,7015896,7015897,7016010,7016011,7016012,7016013,7016020,7016021,7016022,7016023,7016044,7016045,7016046,7016047,7016048,7016049,7016080,7016081,7016082,7016083,7016104,7016105,7016106,7016107,7016108,7016109,7016110,7016111,7016112,7016113,7016114,7016115,7016116,7016117,7016118,7016119,7016120,7016121,7016132,7016133,7016144,7016145,7016152,7016153,7016166,7016167,7016168,7016169,7016170,7016171,7016172,7016173,7016174,7016175,7016176,7016177,7016178,7016179,9186560,7016243,7016244,7016245,7016246,2809283,9186887,7016621,7016622,7016623,7016624,7016625,7016626,7016627,7016628,7016629,7016630,7016631,7016632,7016633,7016634,7016635,7016636,7016637,7016638,7016639,7016640,7016641,7016642,7016643,7016644,7016871,7016872,7016893,7016894,7016895,7016896,7016897,7016898,7016899,7016900,7016901,7016902,7016903,7016904,7016905,7016906,7016907,7016908,10417225,9168331,10418265,10418266,10417273,10417274,10417275,10417276,9168363,10418291,10419292,10419293,10419294,10419295,10419296,10419297,10419298,10419299,10417318,10417319,10417320,10417321,10419322,10417322,10418323,10417323,10417324,10417325,10418326,10417326,10417327,10417330,10419332,10418344,10418345,10418346,10418347,10418348,9168459,10419388,10419389,10419390,10419391,10418397,10418398,10418399,10418400,10418401,10418402,9168484,10415423,10415424,10415430,10415431,10415451,10415452,10415453,10415454,10417455,10415455,10415456,10415457,10415458,10415459,10415460,10415461,10415462,10415463,10415464,10415465,10415466,10418473,10417480,10417481,10417482,10417483,10417484,10416492,10418510,10415514,10416544,10418565,10418566,10417570,10417599,10417607,10417608,10417609,10417610,10417638,10417639,10415642,10418667,10418681,10417682,10417683,7014446,7014447,10417725,7014462,7014463,7014472,7014473,10417759,10417760,10417761,10417762,10417763,10417764,10417769,10415771,10415772,10417785,10417793,7014544,7014545,10415884,10416893,10416894,10416895,10416925,10416926,10416927,10416928,10416929,10416930,10416931,10417957,10415960,10415961,10417962,10416971,10416973,10415977,9169063,10415988,10415994,10418087,10419096,10418097,10418127,10418133,10418138,9169255,9169256,9169257,9169263,10417185,10417193,10417201,10417212,10417218,10417219,10468900,10471173,10469304,10469349,9166806,9166807,8550001,8550002,10469506,8550102,8550203,8550221,10469754,10469755,10469833,10469834,10469835,10469945,10469953,10469958,10469959,10469960,10469964,10470007,10470008,10470009,10470010,10470011,10470012,10470013,10470014,10470022,10470059,10470061,10470084,10470093,10470136,10470208,10470219,10470220,10470245,10470246,10466252,10464257,10464258,10464259,10464260,10464268,10470273,10468281,10468286,10468287,10468288,10464289,10470289,10470324,10470350,10470398,10470399,10470401,10470405,9167830,10470407,10468422,10468423,9167859,9167860,9167861,10470458,10470459,9167885,9167886,10470480,10468499,10468512,10470514,10470515,10470516,10470517,10470519,10470526,10470529,10470534,10470579,9168012,10470602,10470603,10470621,10470623,10470630,10470654,10470655,10470656,10470714,9168201,9168202,9168203,9168204,10628321,10879925,10879931,10880220,10877531,10877532,10877571,10627321,10627332,10627777,10627927,10630026,10630029,10630033,10630034,10630039,10630040,10630043,10630044,10630045,10630047,10630048,10630049,10630050,10630051,10630052,10630053,10630054,10630055,10630056,10630057,10630058,10630059,10630060,10630061,10630062,10630063,10630064,10630065,10630066,10630067,10630069,10630071,10630072,10630073,10630074,10630075,10630076,10630077,10630079,10630080,10630081,10630082,10630083,10630084,10630085,10630086,10630087,10630088,10630090,10630091,10630092,10630093,10630094,10630095,10630096,10630097,10630098,10161944,10162126,10162140,10162143,10162179,10162183,10162193,10521879,10521880,10538858,10420822,10489242) 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'