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(8630461,8630462,8630463,8630464,8630465,8630466,10939537,8630467,8630468,10930095,8630470,8630471,8630472,8630473,8630474,8630475,8630476,8630477,8630478,8630479,8630480,8630482,8630483,8630484,8630485,8630486,8630487,8630488,8630489,8630490,8630491,8630492,8630493,8630494,8630495,8630496,8630497,8630498,8630499,8630500,8630501,8630502,8630503,8630504,8630505,8630506,8630507,8630508,8630509,8630512,8630514,8630515,8630516,8630517,8630518,8630519,8630520,8630521,8630522,8630523,8630524,8630525,8630526,8630527,8630528,8630529,8630530,8630531,8630532,8630533,8630534,8630535,8630536,8630537,8630538,8630539,8630540,8630541,8630542,8630543,8630544,8630545,8630546,8630547,8630548,8630549,8630550,8630551,8630552,8630553,8630554,8630555,8630556,8630557,8630558,8630559,8630560,8630561,8630562,8630563,8630564,8630565,8630566,8630567,8630568,8630569,8630570,8630571,8630572,8630573,8630574,8630575,8630576,8630577,8630578,8630579,8630580,8630581,8630582,8630583,8630584,8630585,8630586,8630587,8630588,8630589,8630590,8630591,8630592,8630593,8630594,8630595,8630596,8630597,8630598,8630599,8630600,8630601,8630602,8630603,8630604,8630605,8630606,8630607,8630608,8630609,8630610,8630611,8630612,8630613,8630614,8630615,8630616,8630617,8630618,8630619,8630620,8630621,8630622,8630623,8630624,8630632,8630633,8630634,8630635,8630636,8630637,8630638,8630639,8630640,8630641,8630642,8630643,8630647,8630649,8630650,8630651,8630652,8630653,8630654,8630657,8630658,8630659,8630660,8630661,8630662,8630663,8630664,8630665,8630666,8630667,8630668,8630669,8630670,8630671,8630672,8630673,8630674,8630675,8630676,8630677,8630678,8630679,8630680,8630681,8630682,8630683,8630684,8630685,8630686,8630687,8630688,8630689,8630690,8630691,8630698,8630699,8630700,8630701,8630702,8630703,8630704,8630710,8630711,8630712,8630713,8630714,8630715,8630716,8630717,8630718,8630719,8630720,8630721,8630722,8630723,8630724,8630725,8630726,8630727,8630728,8630729,8630730,8630731,8630732,8630733,8630734,8630735,8630736,8630737,8630738,8630739,8630740,8630741,8630742,8630744,8630745,8630747,8630748,8630749,8630750,8630751,8630752,8630753,8630754,8630755,8630756,8630757,8630758,8630759,8630760,8630765,8630766,8630767,8630768,8630769,8630770,8630771,8630772,8630773,8630774,8630775,8630776,8630777,8630778,8630779,8630780,8630781,8630782,8630783,8630786,8630787,8630789,8630791,8630792,8630793,8630794,8630795,8630796,8630797,8630798,8630799,8630800,8630801,8630802,8630803,8630804,8630805,8630806,8630807,8630810,8630811,8630812,8630813,8630814,8630815,8630816,8630818,8630820,8630821,8630823,8630825,8630827,8630829,8630831,8630832,8630833,8630834,8630835,8630836,8630837,8630838,8630839,8630840,8630843,8630845,8630847,8630849,8630852,8630853,8630854,8630855,8630856,8630857,8630858,8630859,8630860,8630861,8630862,8630863,8630864,8630865,8630866,8630870,8630872,8630873,8630874,8630875,8630876,8630877,8630878,8630879,8630880,8630881,8630882,8630883,8630884,8630885,8630886,8630887,8630890,8630892,8630893,8630894,8630895,8630896,8630897,8630898,8630899,8630900,8630901,8630902,8630903,8630904,8630905,8630906,8630907,8630908,8630912,8630918,8630936,8630943,8630958,8630959,8630960,8630963,8630964,8630965,8630966,8630967,8630970,8630971,8630972,8630973,8630974,8630976,8630977,8574513,8630983,8630987,8630988,8630989,8630990,8630991,8630993,8630994,8630995,8630996,8630997,8630998,8630999,8631001,8631002,8631003,8631004,8631005,8631007,8631009,8631010,8631011,8631012,8631013,8631027,8631028,8631029,8631030,4970732,4970734,8569510,8569511,10940293,3229008,3229130,3229131,3229203,3229285,8575733,8575734,8575735,3230230,8573102,8573126,8573150,8573162,8573163,3227401,8573184,8573185,8837553,8573316,10939126,10939511,7201200,7201309,7201366,7201590,7201591,7201592,7201593,7201594,7201595,7201596,7201597,7201598,7201599,7201600,7201727,7201728,7201729,7201741,7201742,7201775,7201776,7201777,7201778,7201779,7201780,7201781,7201782,7201974,8065804,7202129,7202133,7202137,7202162,7202165,7202168,8572118,8572122,7202209,7202210,7202259,7202265,7202266,7202285,7073166,11000164,11000165,11000166,7202735,9794578,9794579,9794580,9794588,9794592,7202768,7202769,9794594,7202770,7202771,3227094,3227184,7200087,7200091,7200105,7200106,7200107,7200108,7200109,7200110,7200111,3237396,3237398,7200233,10958986,10959088,7200763,8835196,10100083,7198680,7198685,7198688,7198694,7198725,7198784,7198785,7198853,7199130,7199135,7199211,10101492,8860395,7199844,7196163,7196291,7196316,7196317,7196378,7196511,7196512,7196524,7196526,7196527,7197051,8613644,7197075,8906893,8906894,8906895,8906896,7197103,10838801,7197437,3234663,3234664,3234729,7197940,7197941,10619928,3232382,10617123,8541521,8541549,8905240,8905242,3232913,3232914,3232915,8905663,8542165,8905711,8905844,8905862,8569936,10620117,10620118,10425358,10620200,10620201,10620202,10425577,10425910,10425937,10426193,10426197,8540418,8610793,10426338,10426371,10426372,8540612,8540613,8540631,10616475,8611238,10616644,10616655,8611390,8611391,10616888,10610975,10610976,10610977,10610978,6669828,6669829,6669830,6669831,10614518,10614519,10614520,10614521,10614522,10614523,10614530,10614547,10614548,10614552,10614553,10614554,10614565,9166129,10611856,6666259,8549450,10612319,10609834,10612916,10612940,10610061,10613157,10610343,10610344,10613393,9204758,10613421,10610429,10613431,10613432,10613434,10558592,10613504,10613505,10613513,10613514,10613525,10613527,10613531,10610729,10610730,10613732,10613733,10613737,10613738,10610881,10610890,10610895,10610898,10610899,10610901,6673506,9169305,9169306,9169307,9169308,9169310,9169317,6673552,6673563,7055527,10117565,6673576,9169370,9169395,9169396,6673738,9169586,6673803,6673808,10515423,6674175,6674198,6674229,6674230,6674232,6674233,6674236,6674237,6674238,6674240,6674241,6674242,10118233,6674243,10118234,6674247,6674249,6674256,10118247,10118248,6674276,6674278,6674280,6674281,6674327,6674328,6674329,6674330,6674331,6672524,6672525,6672527,6672592,10415325,6672652,6672653,6672655,9168453,6672661,6672662,6672664,6672669,9192464,6672670,9192466,6672673,9192468,6672675,6672680,9192475,6672684,6672686,6672697,6672698,6672716,6672725,6672727,10416481,10415575,10415576,10415585,10415586,10415595,10415597,10415598,10415599,10415600,10415601,10415604,10415605,10415606,10415607,6672896,6672897,10415614,6672898,6672899,6672900,6672901,10415675,10415676,10415677,10415678,10415679,10415680,10415685,6673082,6673089,10417811,10417812,10417814,10417816,10417818,10417820,10417822,10417824,10417826,10417828,10417830,10417832,10417834,10417837,6673122,10417839,6673124,10417841,6673125,6673126,10417843,10417845,10417847,10417849,10417850,10417852,10417854,10417856,10417858,10417860,10417862,10417864,10417866,10417868,10417870,10417872,10417874,10417876,10417878,10417881,10417883,10417885,10417887,10417889,10417891,10417893,10417895,10417897,10417899,10417901,10417903,10417905,10417907,10417909,10417911,10417913,10417915,10417917,10417919,10417921,10417922,10417925,10417927,10417930,10417932,10417934,10417938,10418018,6673317,9169289,9169290,9169292,9169293,6670727,6670762,9166623,9166624,8550037,8550038,6666924,8550100,8916631,10469618,10469619,8916794,9167953,9167965,9167966,9167993,9168103,10888487,10888637,10888638,10888639,10888640,10888641,10888642,10888655,10888656,10888713,10946563,10946564,10946565,10883945,10883966,10893983,10893984,10893985,10893986,10893987,10893988,10889019,10889020,10889021,10889068,10884094,10884324,10884420,10884421,10889451,10884493,10889622,10884652,10889707,10884950,10889997,10890165,10885313,10885316,10887513,10632011,10632012,10632013,10887544,10887545,10887546,10887553,10887554,10887557,7000826,10887724,10627319,10883143,10627667,10627793,10883358,10883359,10883378,10883392,10883396,10883397,10883398,10883408,10883409,10883410,10883411,10883412,10883421,10883429,10630146,10630147,10630148,10885751,10886057,10881151,10881220,10881221,10881223,10881226,10631058,10886878,10886910,10626431,10167992,10887052,10882082,10882127,10882145,10882284,10631794,10631795,10882359,10626955,10626956,10626957,10647388,10582561,10588641,10545324,10544310,10542423,10542424,10542441,10542453,10542602,10542603,10542654,10522839,10498367,10498368,10498369,10498370,10421543,10498499,10420768,10420769,10408152,10408159,10408820,10408823,10408824,10409008) 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'