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(10940520,10940521,10940522,10940523,10940524,10940525,10940526,10940527,10940528,10940529,10940530,8569889,8569890,8068603,8068604,8068605,8068606,8068607,8068608,8068609,8068610,8068611,8068612,8068613,8068614,8068615,8068616,8068617,8068618,8068619,8068620,8068621,8068622,8068623,8068624,8068625,8068626,8068627,8068628,8068629,8068630,8068631,8068632,8068633,8068634,8068635,8068636,8068637,8068638,8068639,8068640,8068641,8068642,8068643,8068644,8068645,8068646,8068647,8068648,8068649,8068650,8068651,8068652,8068653,8068654,8068655,8068656,8068657,8068658,8068659,8068660,8068661,8068662,8068663,8068664,8068665,8068666,8068667,8068668,8068669,8068670,8068671,8068672,8068673,8068674,8068675,8068676,8068677,8068678,8068679,8066565,8066566,8066567,8066568,8066569,8066570,8066571,8066572,8066573,8066574,8066575,8066576,8066577,8066578,8066579,8066580,8066581,8066582,8066583,8066584,8066585,8066586,8066587,8066588,8066589,8066590,8066591,8066592,8066593,8066594,8066595,8066596,8066597,8066598,8066599,8066600,8066601,8066602,8066603,8066604,8066605,8066606,8066607,8066608,8066609,8066610,8066611,8066612,8066613,8066614,8066615,8066616,8066617,8066618,8066619,8066620,8066621,8066622,8066623,8066624,8066625,8066626,8066627,8066628,8066629,8066630,8066631,8066632,8066633,8066634,8066635,8066636,8066637,8066638,8066639,8066640,8066641,8066642,8066643,8066644,8066645,8066646,8066647,8066648,8066649,8066650,8066651,8066652,8066653,8066654,8066655,8066656,8066657,8066658,8066659,8066660,8066661,8066662,8066663,8066664,8066665,8066666,8066667,8066668,8066669,8066670,8066671,8066672,8066673,8066674,8066675,8066676,8066677,8066678,8066679,8066680,8066681,8066682,8066683,8066684,8066685,8066686,8066687,8066688,8066689,8066690,8066691,8066692,8066693,8066694,8066695,8066696,8066697,8066698,8066699,8066700,8066701,8066702,8066703,8066704,8066705,8066706,8066707,8066708,8066709,8066710,8066711,8066712,8066713,8066714,8066715,8066716,8066717,8066718,8066719,8066720,8066721,8066722,8066723,8066724,8066725,8066726,8066727,8066728,8066729,8066730,8066731,8066732,8066733,8066734,8066735,8066736,8066737,8066738,8066739,8066740,8066741,8066742,8066743,8066744,8066745,8066746,8066747,8066748,8066749,8066750,8066751,8066752,8066753,8066754,7069034,7069035,11048696,10979620,10979621,10979622,10979623,10979624,10979625,10979626,10979627,10979628,10979629,10979630,10979631,10979632,10979633,10979634,10979635,10979636,10979637,10979638,10979639,10979640,10979641,10979642,10979643,10979644,10979645,10979646,10979647,10979648,10979649,10979650,10979651,10979652,10979653,10979654,10979655,10979656,10979657,10979658,10979659,10979660,10979661,10979662,10979663,10979664,10979665,10979666,10979667,10979668,10979669,10979670,10979671,10979672,10979673,10979674,10979675,10979676,10979677,10979678,10979679,10979680,10979681,10979682,10979683,10979684,10979685,10979686,10979687,10979688,10979689,10979690,10979691,10979692,10979693,10979694,10979695,10979696,10979697,10979698,10979699,10979700,10979701,10979702,10979703,10979704,10979705,10979706,10979707,10979708,10979709,10979710,10979711,10979712,10979713,10979714,10979715,10979716,10979717,10979718,10979719,10979720,10979721,10979722,10979723,10979724,10979725,10979726,10979727,10979728,10979729,10979730,10979731,10979732,10979733,10979734,10979735,10979736,10979737,10979738,10979739,10979740,10979741,10979742,10979743,10979744,10979745,10979746,10979747,10979748,10979749,10979750,10979751,10979752,10979753,10979754,10979755,10979756,10979757,10979758,10979759,10979760,10979761,10979762,10979763,10979764,10979765,10979766,10979767,10979768,10979769,10979770,10979771,10979772,10979773,10979774,10979775,10979776,10979777,10979778,10979779,10979780,10979781,10979782,10979783,10979784,10979785,10979786,10979787,10979788,10979789,10979790,10979791,10979792,10979793,10979794,10979795,10979796,10979797,10979798,10979799,10979800,10979801,10979802,10979803,10979804,10979805,10979806,10979807,10979808,10979809,10979810,10979811,10979812,10979813,10979814,10979815,10979816,10979817,10979818,10979819,10979820,10979821,10979822,10979823,10979824,10979825,10979826,10979827,10979828,10979829,10979830,10979831,10979832,10979833,10979834,10979835,10979836,10979837,10979838,10979839,10979840,10979841,10979842,10979843,10979844,10979845,10979846,10979847,10979848,10979849,10979850,10979851,10979852,10979853,10979854,10979855,10979856,10979857,10979858,10979859,10979860,10979861,10979862,10979863,10979864,10979865,10979866,10979867,10979868,10979869,10979870,10979871,10979872,10979873,10979874,10979875,10979876,10979877,10979878,10979879,10979880,10979881,10979882,10979883,10979884,10979885,10979886,10979887,10979888,10979889,10979890,10979891,10979892,10979893,10979894,10979895,10979896,10979897,10979898,10979899,10979900,10979901,10979902,10979903,10979904,10979905,10979906,10979907,10979908,10979909,10979910,10979911,10979912,10979913,10979914,10979915,10979916,10979917,10979918,10979919,10979920,10979921,10979922,10979923,10979924,10979925,10979926,10979927,10979928,10979929,10979930,10979931,10979932,10979933,10979934,10979935,10979936,10979937,10979938,10979939,10979940,10979941,10979942,10979943,10979944,10979945,10979946,10979947,10979948,10979949,10979950,10979951,10979952,10979953,10979954,10979955,10979956,10979957,10979958,10979959,10979960,10979961,10979962,10979963,10930760,10930761,10930762,10621439,10621440,10621441,10621442,10621443,10621444,10621445,10621446,10621447,10621448,10621449,10621450,10621451,10621452,10621453,10621454,10621455,10621456,10621457,10621458,10621459,10621460,10621461,10621462,10621463,10621464,10621465,10621466,10621467,10621468,10621469,10621470,10621471,10621472,10621473,10621474,10621475,10621476,10621477,10621478,10621479,10621480,10621481,10621482,10621483,10621484,10621485,10621486,10621487,10621488,10621489,10621490,10621491,10621492,10979506,10979507,10979508,10979509,10979510,10979511,10979512,10979513,10979514,10979515,10979516,10979517,10979518,10979519,10979520,10979521,10979522,10979523,10979524,10979525,10979526,10979527,10979528,10979529,10979530,10979531,10979532,10979533,10979534,10979535,10979536,10979537,10979538,10979539,10979540,10979541,10979542,10979543,10979544,10979545,10979546,10979547,10979548,10979549,10979550,10979551,10979552,10979553,10979554,10979555,10979556,10979557,10979558,10979559,10979560,10979561,10979562,10979563,10979564,10979565,10979566,10979567,10979568,10979569,10979570,10979571,10979572,10979573,10979574,10979575,10979576,10979577,10979578,10979579,10979580,10979581,10979582,10979583,10979584,10979585,10979586,10979587,10979588,10979589,10979590,10979591,10979592,10979593,10979594,10979595,10979596,10979597,10979598,10979599,10979600,10979601,10979602,10979603,10979604,10979605,10979606,10979607,10979608,10979609,7057827,7057828,7057829,7057830,7057831,7057832,7057833,7057834,7057835,7057836,8863620,8863621,8863622,8863623,8863624,7056594,7056595,7056596,7056597,7056598,7056599,7056600,7056601,7056602,7056603,7056604,7056605,7056606,7056607,7056608,7056609,7056610,7056611,7056612,7056613,7056614,7056615,7056616,7056617,7056618,7056619,7056620,7056621,7056622,7056623,7056624,7056625,7056626,7056627,7056628,7056629,7056630,7056631,7056632,7056633,7056634,7056635,7056636,7056637,7056638,7056639,7056640,7056641,7056642,7056643,7056644,7056645,7056646,7056647,7056648,7056649,7056650,7056651,7056652,7056653,7056654,7056655,7056656,7056657,7056658,7056659,7056660,7056661,7056662,7056663,7056664,7056665,7056666,7056667,7056668,7056669,7056670,7056671,7056672,7056673,7056674,7056675,7056676,7056677,7056678,7056679,7056680,7056681,7056682,7056683,7056684,7056685,7056686,7056687,7056688,7056689,7056690,7056691,7056692,7056693,7056694,7056695,7056696,7056697,7056698,7056699,7056700,7056701,7056702,7056703,7056704,7056705,7056706,7056707,7056708,7056709,7056710,7056711,7056712,7056713,7056714,7056715,7056716,7056717,7056718,7056719,7056720,7056721,7056722,7056723,7056724,7056725,7056726,7056727,7056728,7056729,7056730,7056731,7056732,7056733,7056734,7056735,7056736,7056737,7056738,7056739,7056740,7056741,7056742,7056743,7056744,7056745,7056746,7056747,7056748,7056749,7056750,2809400,2809401,4972232,4972233,4972234,4972235,4972236,4972237,4972238,4972239,4972240,4972241,4972242,4972243,4972244,4972245,4972246,4972247,4972248,4972249,4972250,4972251,4972252,4972253,4972254,8917203,8917204,8917205,8917206,8917207,8917208,8917209,8917210,8917211,10421123,10421124,10421125,10421126,10421127,10421128) 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'