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(3228955,10861935,8583156,8583169,3229188,7065983,9215652,8583479,10950728,10950744,10849456,10849457,10849458,10849459,9216085,9216086,9216087,10862781,10862782,10862783,10862800,8632190,3227394,3227396,3227398,3227399,8067906,10938641,8573237,3227576,3227577,8573375,8573376,8573377,10860703,10962455,8630436,7201181,7201182,7201183,7201186,7201189,7201190,7201191,7201202,10985798,3238537,3238538,10985805,8627829,8628005,8628006,8628027,7201637,10858797,10858804,8911587,8911588,10858963,7202135,7202194,7202239,7202245,8628724,8628820,8628821,8628823,8628825,8628826,8628829,8628830,8628832,8628836,8628889,8628890,8628891,8628892,8628955,10859666,10859667,10859668,10859670,10859672,10859674,10859675,10859676,10859677,10859681,10859684,10859688,10859689,8629340,8629341,10857514,7200526,8626975,8626993,8626994,8626995,7200625,7200627,7200628,7200629,7200631,7200632,7200645,8910469,8910470,8910471,7200723,10959203,10959204,10857810,7200985,7200988,7200991,7200995,7201011,7201023,7201024,7201025,7201026,7201027,7201028,7201029,7201059,7201060,7201063,7201091,7201157,7201159,7201163,7201164,7201165,7201166,7201167,7201168,7201169,7201170,7201171,7201172,7201173,7201174,7201175,7201176,7201177,7201178,7198741,10863806,10864143,10864204,10864208,10864209,10101568,11048411,11048412,10864823,10864824,10864825,10864826,7196232,7196238,11045815,11045831,11045832,10618280,10618295,10618300,10618301,10618305,10618306,10618307,10618308,10618309,10618310,10618311,10618312,10618320,11045991,7196556,8906913,10854206,10854207,10838884,11047054,11047060,11047061,11047062,11047063,11047064,11047065,8907462,3234982,3235104,3235105,7198001,7198049,7198070,7198072,10619893,10616967,10616968,10616969,10617009,10617014,10617033,8634673,8634674,8634675,8634676,10617108,10617111,8611931,10617156,10617173,10617182,10617189,10617190,10617191,10617192,10852704,10852705,10617509,10954259,10852869,8612652,10615014,10615065,8632811,10615202,10425573,10850521,10850535,10615289,10615321,10615322,10850607,10850608,10850609,10850610,10850611,10615373,10615374,10615375,10615376,10615378,10615391,10425910,10615723,10615925,10426271,10615943,10991661,10991662,8540528,10991757,10991758,10991759,10991760,10426472,8540627,8540629,10991849,10616497,8611308,10616502,8611406,8904929,10616909,10616956,10611013,10611014,10614060,10614067,10614068,10614069,10611069,10611070,10611071,10611072,10611073,10611074,10611077,10611078,10611138,10611139,8853326,8853327,8853329,8853333,10611179,6669832,10611432,10611433,10611434,10611435,10611436,10611437,10611438,10611439,10611440,10611441,10611442,10611443,10611444,10611445,10714261,10611446,10611447,10611448,10611449,10611450,10611451,10611458,10614463,10614486,10611560,10614662,10611667,10611680,10611766,10611863,10611880,10611882,10611883,10611884,10611885,10611886,10611887,10611888,10611889,10611890,10611891,10611895,10611896,10611902,10611903,10611904,6666255,10611942,10611955,8851182,8851222,10612088,10612179,8851402,8851432,8851467,10612381,10609387,8851563,10612424,8851647,8851648,8851649,8851650,8851651,8851652,8851653,8851654,8851655,8851656,10609497,10609498,10609499,8851704,9163880,8851770,8851771,8851772,10609947,10609948,10609972,10612997,10612999,10613003,10613005,10613006,10613009,10613010,10610013,10613016,10610076,10613084,8852327,8852338,10610190,10610191,8852386,10613293,10613297,10610349,10610350,10613356,10613357,10613365,10613366,10613367,10610493,8852728,8852729,10610724,10613745,10613785,10613786,7055534,8849314,8849335,8849337,8849338,8849351,8849353,8849367,8849374,8849376,8849377,8849379,8849382,8849406,8849408,8849410,8849411,9169586,9911802,10117804,10117871,6673903,9169708,9911966,7056001,9169870,9169871,6674116,8849918,8849961,9912418,10118550,8850420,8850651,8850674,8850678,8850683,8850684,8850753,8850754,8850755,8850756,8850757,8850758,8850759,8850760,8850761,8850762,8850763,8850764,8850765,8850766,8850767,8850768,8850769,8850770,8850771,8850772,8850773,8850774,8850775,8850776,8850777,8850778,8850779,8850780,8850781,8850782,8850783,8850784,8850785,8850786,8850787,8850788,8850789,8850790,8850791,8850792,8850793,8850794,8850795,8850796,8850797,8850798,8850799,8850800,8850801,8850802,8850803,8850804,8850805,8850806,8850807,8850808,8850809,8850810,8850811,8850812,8850813,8850814,8850815,8850816,8850817,8850818,8850819,8850820,8850821,8850822,8850823,8850824,8850825,8850826,8850827,8850828,8850829,8850830,8850831,8850832,8850833,8850834,8850835,8850836,8850837,8850858,8850859,8851045,8851048,7013963,7013964,10416345,10416346,6672784,10417501,10417539,8848700,8848702,8848703,8848708,8848714,6673198,9161157,9169185,10418147,10418148,10418149,10418150,7014905,7014906,7014907,7014908,7014909,7014910,7014911,7014912,7014913,7014914,7014915,7014916,7014917,9161282,8549956,976479,10468462,10888608,10883625,10883658,10628311,10628312,10884074,10884100,10884480,10889756,10890046,10890094,10171394,10877480,10877483,10877484,10877485,10632106,10632107,10882690,10883042,10888254,10888256,10888257,10888259,10627771,10888362,10883419,10625239,10625240,10625241,10161930,10885932,10885933,10885934,10885935,10949007,10886391,10881566,10881572,10886632,10876655,10876808,10876816,10876828,10608031,10608032,10602237,10608404,10602752,10647227,10603071,10647309,10603653,10603654,10603656,10603657,10603658,10603778,10603779,10603780,10603842,10603850,10603851,10603852,10603853,10603875,10603879,10607010,10607011,10604441,10604468,10604493,10604518,10604533,10604546,10604555,10604638,10601735,10537646,10522577,10522578,10522579,10508248,10508249,10508254,10508255,10508256,10508280,10508307,10505544,10506574,10506575,10506576,10507621,10507666,10507758,10508769,10507771,10508771,10507772,10507773,10507774,10508807,10507816,10507817,10507909,10413356,10413358,10411613,10407654,10494361,10494362,10494363,10407756,10407840,10409972,10409973,10409974,10414096,10414097,10414098,10414100,10414101,10414102,10414104,10414105,10414106,10414107,10414111,10414114,10414115,10414120,10414121,10409099,10409100,10409101,10407183) 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'