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(10940413,10940414,10940415,10940416,10940417,10940418,8067424,8067471,8067472,8067473,8067474,8067475,8067476,8067477,8067478,8067479,10938500,10938501,10938502,4967147,8066191,8066192,8066193,8066194,8066195,8066196,3655635,3655636,3655927,8072743,8072744,8072745,8072746,8072747,8073443,10623332,10623426,10918952,10919941,10919942,10920206,10920207,10917472,10917473,10917474,10917475,10917476,10917477,10917478,10917479,10917480,10917481,10917482,10917483,10917484,10917485,10917486,10917487,10917488,10917489,10917490,10917491,10917492,10917493,10917494,10917495,10917496,10917497,10917498,10917499,10917500,10917501,10917502,10917503,10917504,10917505,10917506,10917507,10917508,10917509,10917510,10917511,10917512,10917513,10917514,10917515,10917516,10917517,10917518,10917519,10917520,10917521,10917522,10917523,10917524,10917525,10917526,10917527,10917528,10917529,10917530,10917531,10917532,10917533,10917534,10917535,10917536,10917537,10917538,10917539,10917540,10917541,10917542,10917543,10917544,10917545,10917546,10917547,10917548,10917549,10917550,10917551,10917552,10917553,10917554,10917555,10917556,10917557,10917558,10917559,10917560,10917561,10917562,10917563,10917564,10917565,10917566,10917567,10917568,10917569,10917570,10917571,10917572,10917573,10917574,10917575,10917576,10917577,10917578,10917579,10917580,10917581,10917582,10917583,10917584,10917585,10917586,10917587,10917588,10917589,10917590,10917591,10917592,10917593,10917594,10917595,10917596,10917597,10917598,10917599,10917600,10917601,10917602,10917603,10917604,10917605,10917606,10917607,10917608,10917609,10917610,10917611,10917612,10917613,10917614,10917615,10917616,10917617,10917618,10917619,10917620,10917621,10917622,10917623,10917624,10917625,10917626,10917627,10917628,10917629,10917630,10917631,10917632,10917633,10917634,10917635,10917636,10917637,10917638,10917639,10917640,10917641,10917642,10917643,10917644,10917645,10917646,10917647,10917648,10917649,10917650,10917651,10917652,10917653,10917654,10917655,10917656,10917657,10917658,10917659,10917660,10917661,10917662,10917663,10917664,10917665,10917666,10917667,10917668,10917669,10917670,10917671,10917672,10917673,10917674,10917675,10917676,10917677,10917678,10917679,10917680,10917681,10917682,10917683,10917684,10917685,10917686,10917687,10917688,10917689,10917690,10917691,10917692,10917693,10917694,10917695,10917696,10917697,10917698,10917699,10917700,10917701,10917702,10917703,10917704,10917705,10917706,10917707,10917708,10917709,10917710,10917711,10917712,10917713,10917714,10917715,10917716,10917717,10917718,10917719,10917720,10917721,10917722,10917723,10917724,10917725,10917726,10917727,10917728,10917729,10917730,10917731,10917732,10917733,10917734,10917735,10917736,10917737,10917738,10917739,10917740,10917741,10917742,10917743,10917744,10917745,10917746,10917747,10917748,10917749,10917750,10917751,10917752,10917753,10917754,10917755,10917756,10917757,10917758,10917759,10917760,10917761,10917762,10917763,10917764,10917765,10917766,10917767,10917768,10917769,10917770,10917771,10917772,10917773,10917774,10917775,10917776,10917777,10917778,10917779,10917780,10917781,10917782,10917783,10917784,10917785,10917786,10917787,10917788,10917789,10917790,10917791,10917792,10917793,10917794,10917795,10917796,10917797,10917798,10917799,10917800,10917801,10917802,10917803,10917804,10917805,10917806,10917807,10917808,10917809,10917810,10917811,10917812,10917813,10917814,10917815,10917816,10917817,10917818,10917819,10917820,10917821,10917822,10917823,10917824,10917825,10917826,10917827,10917828,10917829,10917830,10917831,10917832,10917833,10917834,10917835,10917836,10917837,10917838,10917839,10917840,10917841,10917842,10917843,10917844,10917845,10917846,10917847,10917848,10917849,10917850,10917851,10917852,10917853,10917854,10917855,10917856,10917857,10917858,10917859,10917860,10917861,10917862,10917863,10917864,10917865,10917866,10917867,10917868,10917869,10917870,10917871,10917872,10917873,10917874,10917875,10917876,10917877,10917878,10917879,10917880,10917881,10917882,10917883,10917884,10917885,10917886,10917887,10917888,10917889,10917890,10917891,10917892,10917893,10917894,10917895,10917896,10917897,10917898,10917899,10917900,10917901,10917902,10917903,10917904,10917905,10917906,10917907,10917908,10917909,10917910,10917911,10917912,10917913,10917914,10917915,10917916,10917917,10917918,10917919,10917920,10917921,10917922,10917923,10917924,10917925,10917926,10917927,10917928,10917929,10917930,10917931,10917932,10917933,10917934,10917935,10917936,10917937,10917938,10917939,10917940,10917941,10917942,10917943,10917944,10917945,10917946,10917947,10917948,10917949,10917950,10917951,10917952,10917953,10917954,10917955,10917956,10917957,10917958,10917959,10917960,10917961,10917962,10917963,10917964,10917965,10917966,10917967,10917968,10917969,10917970,10917971,10917972,10917973,10917974,10917975,10917976,10917977,10917978,10917979,10917980,10917981,10917982,10917983,10917984,10917985,10917986,10917987,10917988,10917989,10915472,10915473,10915474,10915475,10915476,10915477,10915478,10915479,10915480,10915481,10915482,10915483,10915484,10915485,10915486,10915487,10915488,10915489,10915490,10915491,10915492,10915493,10915494,10915495,10915496,10915497,10915498,10915499,10915500,10915501,10915502,10915503,10915504,10915505,10915506,10915507,10915508,10915509,10915510,10915511,10915512,10915513,10915514,10915515,10915516,10915517,10915518,10915519,10915520,10915521,10915522,10915523,10915524,10915525,10915526,10915527,10915528,10915529,10915530,10915531,10915532,10915533,10915534,10915535,10915536,10915537,10915538,10915539,10915540,10915541,10915542,10915543,10915544,10915545,10915546,10915547,10915548,10915549,10915550,10915551,10915552,10915553,10915554,10915555,10915556,10915557,10915558,10915559,10915560,10915561,10915562,10915563,10915564,10915565,10915566,10915567,10915568,10915569,10915570,10915571,10915572,10915573,10915574,10915575,10915576,10915577,10915578,10915579,10915580,10915581,10915582,10915583,10915584,10915585,10915586,10915587,10915588,10915589,10915590,10915591,10915592,10915593,10915594,10915595,10915596,10915597,10915598,10915599,10915600,10915601,10915602,10915603,10915604,10915605,10915606,10915607,10915608,10915609,10915610,10915611,10915612,10915613,10915614,10915615,10915616,10915617,10915618,10915619,10915620,10915621,10915622,10915623,10915624,10915625,10915626,10915627,10915628,10915629,10915630,10915631,10915632,10915633,10915634,10915635,10915636,10915637,10915638,10915639,10915640,10915641,10915642,10915643,10915644,10915645,10915646,10915647,10915648,10915649,10915650,10915651,10915652,10915653,10915654,10915655,10915656,10915657,10915658,10915659,10915660,10915661,10915662,10915663,10915664,10915665,10915666,10915667,10915668,10915669,10915670,10915671,10915672,10915673,10915674,10915675,10915676,10915677,10915678,10915679,10915680,10915681,10915682,10915683,10915684,10915685,10915686,10915687,10915688,10915689,10915690,10915691,10915692,10915693,10915694,10915695,10915696,10915697,10915698,10915699,10915700,10915701,10915702,10915703,10915704,10915705,10915706,10915707,10915708,10915709,10915710,10915711,10915712,10915713,10915714,10915715,10915716,10915717,10915718,10915719,10915720,10915721,10915722,10915723,10915724,10915725,10915726,10915727,10915728,10915729,10915730,10915731,10915732,10915733,10915734,10915735,10915736,10915737,10915738,10915739,10915740,10915741,10915742,10915743,10915744,10915745,10915746,10915747,10915748,10915749,10915750,10915751,10915752,10915753,10915754,10915755,10915756,10915757,10915758,10915759,10915760,10915761,10915762,10915763,10915764,10915765,10915766,10915767,10915768,10915769,10915770,10915771,10915772,10915773,10915774,10915775,10915776,10915777,10915778,10915779,10915780,10915781,10915782,10915783,10915784,10915785,10915786,10915787,10915788,10915789,10915790,10915791,10915792,10915793,10915794,10915795,10915796,10915797,10915798,10915799,10915800,10915801,10915802,10915803,10915804,10915805,10915806,10915807,10915808,10915809,10915810,10915811,10915812,10915813,10915814,10915815,10915816,10915817,10915818,10915819,10915820,10915821,10915822,10915823,10915824,10915825,10915826,10915827,10915828,10915829,10915830,10915831,10915832,10915833,10915834,10915835,10915836,10915837,10915838,10915839,10915840,10915841,10915842,10915843,10915844,10915845,10915846,10915847,10915848,10915849,10915850,10915851,10915852,10915853,10915854,10915855,10915856,10915857,10915858,10621144,10621145,10621146,10621147,10621148,10621149,10621150,10621151,10621152,10621153,10621154,10621155,10621156,10621157,10621158,10621159,10621160,10621161,10564124,10564125,10564126,10564127,10564128,10419583,10420149,10420173,10420174,10420175,10420176,10420177,10420178,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420192,10420193,10420194,10420195,10420196,10420197,10420198,10420199,10471545) 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'