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(4970674,4970678,4970689,4970690,4970691,4970692,4970693,4970694,4970695,4970696,4970697,4970698,4970724,8067904,8067914,8067915,8067916,8067917,10931549,10931550,10620073,10620074,10614048,10614210,10614255,10614256,10614257,10614258,10614259,10614260,10614261,10614262,10614263,10614264,10614289,10614296,10614297,10614355,10614376,10614411,10614417,10614418,10614419,10614420,10614421,10614422,10614423,10614501,10614595,10614634,10614646,10614857,10614886,10566084,10611981,10612062,10612063,10612064,10612082,10612083,10612084,10612085,10612086,10612109,10612126,10612258,10612259,10612260,10612270,10612344,10612381,10612431,10612432,10612433,10612434,10612435,10612436,10612437,10612438,10612439,10612440,10612441,10612442,10612443,10612444,10612445,10612446,10612447,10612448,10612449,10612450,10612451,10612452,10612453,10612454,10612455,10612456,10612457,10612458,10612459,10612460,10612461,10612462,10612463,10612464,10612465,10612466,10612467,10612468,10612469,10612470,10612471,10612472,10612473,10612474,10612475,10612476,10612477,10612478,10612479,10612480,10612481,10612482,10612483,10612484,10612485,10612486,10612487,10612488,10612489,10612490,10612491,10612492,10612493,10612494,10612495,10612496,10612497,10612498,10612499,10612500,10612501,10612502,10612503,10612504,10612505,10612506,10612507,10612508,10612509,10612510,10612511,10612512,10612513,10612514,10612515,10612516,10612517,10612518,10612519,10612520,10612521,10612522,10612523,10612524,10612525,10612526,10612527,10612528,10612529,10612530,10612531,10612532,10612533,10612534,10612535,10612536,10612537,10612538,10612539,10612540,10612541,10612542,10612543,10612544,10612545,10612546,10612547,10612548,10612549,10612550,10612551,10612552,10612553,10612554,10612555,10612556,10612557,10612558,10612559,10612560,10612561,10612562,10612563,10612564,10612565,10612566,10612567,10612568,10612569,10612570,10612571,10612572,10612573,10612574,10612575,10612576,10612577,10612578,10612579,10612580,10612581,10612582,10612583,10612584,10612585,10612586,10612587,10612588,10612589,10612590,10612591,10612592,10612593,10612594,10612595,10612596,10612597,10612598,10612599,10612600,10612601,10612602,10612603,10612604,10612605,10612606,10612607,10612608,10612609,10612610,10612611,10612612,10612613,10612614,10612615,10612616,10612617,10612618,10612619,10612620,10612621,10612622,10612623,10612624,10612625,10612626,10612627,10612628,10612629,10612630,10612631,10612632,10612633,10612634,10612635,10612636,10612637,10612638,10612639,10612640,10612641,10612642,10612643,10612644,10612645,10612646,10612647,10612648,10612649,10612650,10612651,10612652,10612653,10612654,10612655,10612656,10612657,10612658,10612659,10612660,10612661,10612662,10612663,10612664,10612665,10612666,10612667,10612668,10612669,10612670,10612671,10612672,10612673,10612674,10612675,10612676,10612677,10612678,10612679,10612680,10612681,10612682,10612683,10612684,10612685,10612686,10612687,10612688,10612689,10612690,10612691,10612692,10612693,10612694,10612695,10612696,10612697,10612698,10612699,10612700,10612701,10612702,10612703,10612704,10612705,10612706,10612707,10612708,10612709,10612710,10612711,10612712,10612713,10612714,10612715,10612716,10612717,10612718,10612719,10612720,10612721,10612722,10612723,10612724,10612725,10612726,10612727,10612728,10612729,10612730,10612731,10612732,10612733,10612734,10612735,10612736,10612737,10612738,10612739,10612740,10612741,10612742,10612743,10612744,10612745,10612746,10612747,10612748,10612749,10612750,10612751,10612752,10612753,10612754,10612755,10612756,10612757,10612758,10612759,10612760,10612761,10612762,10612763,10612764,10612765,10612766,10612767,10612768,10612769,10612770,10612771,10612772,10612773,10612774,10612775,10612776,10612777,10612778,10612779,10612780,10612781,10612782,10612783,10612784,10612785,10612786,10612787,10612788,10612789,10612790,10612791,10612792,10612793,10612794,10612795,10612796,10612797,10612798,10612799,10612800,10612801,10612802,10612803,10612804,10612805,10612806,10612807,10612808,10612809,10612810,10612811,10612812,10612813,10612814,10612815,10612816,10612817,10612818,10612819,10612820,10612821,10612822,10612823,10612824,10612825,10612826,10612827,10612828,10612829,10612830,10612831,10612832,10612833,10612834,10612835,10612836,10612837,10612838,10612839,10612840,10612841,10612842,10612843,10612844,10612845,10612846,10612847,10612848,10612849,10612850,10612851,10612852,10612853,10612854,10612855,10612856,10612857,10612858,10612859,10612860,10612861,10612862,10612863,10612864,10612865,10612866,10612867,10612868,10612869,10612870,10612871,10612872,10612873,10612874,10612875,10612876,10612877,10612878,10612879,10612880,10612881,10612882,10612883,10612884,10612885,10612886,10612887,10612888,10612889,10612890,10612891,10612892,10612893,10612894,10612895,10612896,10612897,10612898,10612899,10612900,10612901,10612902,10612903,10612904,10612905,10612906,10612907,10612908,10612909,10612910,10612911,10612912,10612913,10612914,10612915,10612916,10612945,10612958,10612993,10613025,10613079,10613085,10613087,10613088,10613127,10613193,10613235,10613322,10613372,10613380,10613440,10613442,10613453,10613553,10613634,10613635,10613646,10613654,10613750,10613752,10613804,10613805,10613806,10416253,10419257,10419260,10419261,10416282,10416283,10416284,10416301,10416347,10416364,10419365,10416365,10416366,10416367,10416368,10416369,10416370,10416371,10416372,10416373,10416374,10416375,10416376,10416377,10416378,10416379,10416380,10416381,10416382,10416383,10416384,10416385,10416386,10416387,10416388,10416389,10416390,10416391,10416392,10416393,10416394,10416395,10416396,10416397,10416398,10416399,10416400,10416401,10416402,10416403,10416404,10416405,10416406,10416407,10416408,10416409,10416410,10416411,10416412,10416413,10416414,10416415,10416416,10416417,10416418,10416419,10416420,10416421,10416422,10416423,10416424,10416425,10416426,10416427,10416428,10416429,10416430,10416431,10416432,10416433,10416434,10416435,10416436,10416437,10416438,10416439,10419439,10416440,10416441,10416442,10416443,10416444,10416445,10416446,10416447,10416448,10416449,10416450,10416451,10416452,10416453,10416454,10416455,10416456,10416457,10416458,10416459,10416460,10416461,10416462,10416463,10416464,10416465,10416466,10416467,10416468,10416469,10416470,10416471,10416472,10416473,10416474,10416475,10416476,10416477,10416478,10416479,10416480,10416481,10416482,10416483,10416484,10416485,10416486,10416487,10416488,10416489,10416490,10416491,10416492,10416493,10416494,10416495,10416496,10416497,10416498,10416499,10416500,10416501,10416502,10416503,10416504,10416505,10416506,10416507,10416508,10416509,10416510,10416511,10416512,10416513,10416514,10416515,10416516,10416517,10416518,10416519,10416520,10416521,10416522,10416523,10416524,10416525,10416526,10416527,10416528,10416529,10416530,10416531,10416532,10416533,10416534,10416535,10416536,10416537,10416538,10416539,10416540,10416541,10416542,10416543,10416544,10416545,10416546,10416547,10416548,10416549,10416550,10416551,10416552,10416553,10416554,10416555,10416556,10416557,10416558,10416559,10416560,10416561,10416562,10416563,10416564,10416565,10416566,10416567,10416568,10416569,10416570,10419570,10416571,10416572,10416573,10416574,10416575,10416576,10416577,10416578,10416579,10416580,10416581,10416582,10416583,10416584,10416585,10416586,10416587,10416588,10416589,10416590,10416591,10416592,10416593,10416594,10416595,10416596,10416597,10416598,10416599,10416600,10416601,10416602,10416603,10416604,10416605,10419605,10416606,10416607,10416608,10416609,10416610,10416611,10416612,10419612,10416613,10416614,10416615,10416616,10419616,10416617,10416618,10416619,10416620,10416621,10416622,10416623,10416624,10419625,10416625,10416626,10416627,10416628,10416629,10416630,10416631,10416632,10416633,10416634,10419635,10416635,10416636,10416637,10416638,10419639,10416639,10416640,10416641,10416642,10416643,10416644,10419644,10416645,10416646,10416647,10416648,10416649,10419649,10416650,10416651,10416652,10419652,10416653,10416654,10419654,10416655,10416656,10416657,10419657,10416658,10416659,10416660,10416661,10416662,10416663,10416664,10419664,10416665,10419852,10419853,10419854,10419855,10419856,10419857,10419858,10419859,10419860,10419861,10419862,10419863,10419864,10419865,10419866,10419867,10419868,10419869,10419870,10419871,10419872,10419873,10471104,10471105,10471106,10471107,10471108,10471109,10471110,10471111,10471112,10471113,10471114,10471115,10471116,10471117,10471118,10471119,10471120,10469908,10469909,10469910,10469911,10469912,10469913,10469914,10469915,10469916,10469917,10469918,10469919,10469920,10469921,10469922,10469923,10469924,10469925,10469926,10469927,10469928,10469929,10469930,10469931,10469932,10469933,10469934,10469935,10469936,10469937,10469938,10469939,10469940,10469941,10469942,10469943,10469944,10469945,10469946,10469947,10469948,10469949,10469950,10470624,10470625,10470626,10470627,10470628,10470629,10470630,10470631) 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'