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(3238793,8911449,10843165,10843170,10843171,8835900,10198163,10198164,10198165,10858809,7201813,7201814,7201834,8595359,8595448,10859149,10198909,10198910,10198911,10198912,10198913,10198914,10198915,10198916,10198917,10198918,10198919,10198920,10198921,10198922,10198923,10198924,10198925,10198926,10843996,10844115,10844298,10844299,10199296,10199297,10199353,10199391,10199392,10199393,10199394,10199412,10199434,10199435,10199439,10199440,10437205,10199517,10929314,8573353,8573427,7066854,7066877,8834921,4969285,4969286,4969287,4969288,10236218,10236219,10236220,10236221,10236222,10249355,7075318,10103255,8627869,10221185,10221186,10221282,10221283,10221284,10221285,10221286,10221287,10221288,10221289,10221290,10221319,10221322,10931639,8625561,8625563,8625566,8625569,8909104,8625836,8625837,8625840,8625842,8625843,8625844,8625846,8625850,8625852,8625855,8625856,8625857,8625859,8625862,8557196,10932185,10932197,8616197,10856738,8626237,10841359,10196392,10196654,10196718,10196719,10196720,8626699,7070895,10194179,10943050,10839749,10839774,10839781,8615091,10940764,10940765,10940766,10231564,10231565,8542386,10231627,10231628,10231629,10231630,10231631,10231632,10231633,10231634,10231635,10231636,10231637,10231638,10231639,10231640,3923805,8554756,8554759,8613650,8554832,10854324,8860503,8860504,3234564,8860520,10203130,10928798,10618453,10618454,10618455,10618456,10618457,10618458,10618459,10618460,10618461,10618462,10618463,10618464,10618465,10618466,10618467,10618468,10618469,10618470,10618471,10618472,10623501,10618578,10618579,10618580,10618581,10618582,10618623,10618796,10618797,10618798,10618799,10618800,10618801,10618802,10618803,10618804,10618805,10618816,10618817,10618849,10618850,10618875,10618876,10618877,10618878,10618898,10618899,10618934,10618935,10618936,10618937,10618938,10618939,10618940,10618941,10618942,10618943,9217985,9217986,8540852,8540854,10618983,8540896,10426763,10851970,10851971,10852044,10852049,7155355,7155363,3232245,7155379,7155393,7155394,7155407,10427307,7155498,10925125,10925126,10925127,10269837,10282844,10282846,8612042,8612114,8583877,8583878,10622132,8632467,8632468,10460432,10460446,10460447,10460448,10460449,10460450,10460451,10460463,10460464,10460465,10460469,10460470,10460479,10460480,10460485,10460488,10460495,10460527,10460528,10460529,10460530,10460531,10460555,10460557,10620003,10447570,10447571,10447578,10447582,10447586,10239747,10239982,10239983,10239984,10239990,10239991,10459180,10459181,10459182,10459216,10459217,10459218,10459219,10459220,10459221,10459222,8839142,8839143,3229153,3229267,3229271,10846754,10214863,10214864,10214865,10202031,10202032,10215033,10202033,10202034,10202035,10202036,10202037,10202038,10202039,10202040,10202041,10202042,10202043,10202044,10202045,9165425,9165426,9165427,9165428,9165429,3654802,3654807,9189665,6670080,6670081,8853841,9182097,9182098,9182099,3655311,9214158,9214159,9214160,9182198,9182199,9182200,9182201,9182202,9182203,9182204,9182205,9182206,9182207,9182208,9182209,9182210,9182211,9182212,9182213,9182214,9182215,9182216,9182217,9182218,3655425,9182219,9182220,9182221,9913516,9913517,9913518,9913648,9913649,9211597,9171688,9171689,9171690,9171691,9171692,9171693,10563603,10563604,8566580,8851926,8862712,9172198,9172211,9172226,9172245,3653597,3653602,3653617,9172572,9172573,9172574,9172575,10564446,10564447,9172736,9172737,9172757,9172758,9172759,9172776,8852818,8852947,8852970,8853001,10511244,10511245,10511246,10511247,10511309,10511334,10511335,10511336,10511391,10511392,10511393,10511394,10511395,10511396,10511397,10511398,10511399,10511400,10511401,10511402,10511403,10511404,10511405,9193597,8592747,7055801,7055802,10511455,10511456,10511457,10511478,10511479,10511480,10511481,10511482,7055855,10511521,10511522,10511523,10511524,10511525,10511526,10511527,10513528,7055881,10513529,7055882,10513530,7055883,10513531,7055884,10513532,10513533,10513534,10513535,10513536,10513537,7055891,10513538,10513539,10513540,10513541,10513542,10513543,10513544,10513545,10513546,10513547,10517553,10517554,10125970,10511620,10511621,10511622,10511623,10511624,10511625,10511626,10511627,10511628,10511629,10511630,10511631,10511632,10511634,10511725,10511726,10511727,10511728,10511729,10511732,10511733,10511949,10511950,10511951,10511952,10511953,10511954,10511955,10511956,10511957,10511958,10511959,10511960,10511961,10511962,10511963,10511964,10511965,10511966,10511967,10511968,10511969,10512070,6674480,6674496,10514108,9170306,6674514,6674527,6674532,9170328,10514148,10514149,10514150,10514151,9170343,10514186,10514187,10514188,10514189,10514190,10514191,10516201,9170404,10514226,10514245,10514246,10514247,10514248,10514249,10514250,10514267,10514268,10514269,9178463,10514310,10514311,10514335,10514352,10514356,9170666,10514497,9170691,9170696,10514523,10514524,10514525,10514526,10516536,10516553,10514558,10516620,10516633,10516634,10516635,10514636,10516646,10516647,10516648,10516649,10516650,10514716,10514717,10514718,10514719,10514720,10514743,10514744,10514745,10119138,10119148,10119154,9186957,10119155,9186958,10514772,9186959,10514773,10514774,10514775,10514776,10514777,10514778,10514779,10514780,10119179,10514800,10514801,10514814,10514867,10514868,10514869,10514897,10514898,10516953,10516954,10514982,10514983,9913406,9913407,9913408,10515014,9913409,10515015,9913410,10515016,9913411,10515017,10515018,10515019,10515020,10515021,10515022,9913502,9192351,9192352,9192358,9910646,9910647,9192614,10416943,10416945,10417175,9193258,10417198,9193286,9193287,10469109,10469128,10469150,9174613,9174614,9174615,9174616,10469247,10469252,10469269,10469273,8865258,9190877,9190878,9190879,9190880,8854750,9917202,10465680,10465681,8550344,6667190,9191274,9175331,9183385,9175601,9191967,9191968,9191978,7013869,7013870,9184257,10893472,10893473,10903801,10903874,10903875,10903876,10903877,10903878,10903879,10903880,10903881,10903882,10170697,10626967,10907575,10627345,10164084,10908215,10908216,10908217,10908218,10908222,10627742,10893471,10171724,10171725,10171726,10171727,10171728,10171729,10171730,10171731,10171732,10171733,10890848,10172202,10172203,10172208,10172209,10172210,10891328,10891494,10187506,10891495,10891496,10891497,10891522,10891523,10891524,10891603,10891604,10891605,10891620,10891621,10896869,10896870,10896871,10896872,10912115,10163139,10163140,10163141,10163142,10163143,10163144,10163145,10897133,10163146,10163147,10163148,10163149,10163150,10163151,10163178,10163179,10163180,10163247,10163252,10163256,10163263,10163278,10649544,10649545,10649546,10649547,10649548,10643565,10602768,10603510,10651014,10651015,10651016,10651017,10651018,10651019,10651020,10651021,10651022,10651023,10588054,10588055,10588056,10588057,10648123,10648124,10648183,10648184,10604039,10588508,10588509,10588510,10588511,10588512,10588513,10588514,10588515,10588516,10588517,10604388,10533333,10533334,10533335,10533336,10533337,10533338,10533339,10533340,10533341,10533342,10533343,10533344,10533345,10533346,10533347,10533348,10533349,10533350,10533351,10549600,10549602,10549603,10549703,10549704,10541773,10541774,10541775,10541776,10541777,10551881,10551882,10551883,10550013,10548330,10548331,10550360,10550361,10550362,10550363,10550365,10548371,10548372,10548424,10528929,10548960,10538962,10538963,10538964,10538965,10538966,10538967,10425244,10425245,10510142,10510143,10510144,10510145,10509173,10509174,10509175,10509176,10509177,10509178,10509179,10509180,10509181,10509182,10509183,10509184,10509185,10509186,10509187,10509188,10509189,10509190,10509191,10509192,10420333,10420343,10420362,10420388,10510280,10510281,10420390,10510282,10510283,10421392,10420392,10510284,10510285,10510286,10510349,10510375,10510376,10510377,10510389,10510412,10510413,10510470,10510471,10510472,10509497,10509498,10509499,10509500,10509501,10509502,10509518,10509519,10509520,10509521,10509522,10509526,10509539,10510573,10509604,10509605,10509608,10510611,10509644,10509653,10509685,10509686,10509708,10509709,10509710,10510711,10509720,10509721,10509722,10509723,10509724,10510733,10510734,10510735,10509740,10509741,10510769,10510770,10510771,10510772,10510773,10507773,10510779,10509799,10510800,10509800,10510801,10509801,10509802,10509803,10509804,10509841,10509842,10509843,10509866,10509867,10509868,10509873,10509899,10508907,10508908,10508912,10510016,10510017,10510051,10510052,10510053,10510054,10422174,10422175,10510092,10510093,10510109,10510110,10510111,8562236,8562242,8562244,10485977,10485980,10485983,10485985,10485986,10485994,10486002,10486006,10486010,10413647,10413655,10479562,10479575,10494893,10481946,10481947,10481948,10481950,10476181,10476206,10476224,10476240,10476248,10476263,10476270,10476271,10476272,10476280,10408707,10476806,10476807,10476808) 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'