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(4970672,4970727,4970744,8067914,8067916,10938697,10939409,10939410,10939411,10939412,10939416,10931546,10931547,8065833,10623490,10622434,10622536,10620200,10620201,10620202,10620488,10613964,10610965,10614068,10614093,10614115,10614116,10611117,10614118,10611118,10611119,10614119,10614120,10614121,10614129,10614141,10614142,10614143,10614181,10611185,10614209,10611226,10614259,10611334,10611336,10611338,10611339,10614376,10614445,10611474,10614518,10614619,10614626,10614660,10614661,10614682,10611685,10611709,10614710,10614711,10614712,10614713,10614714,10614715,10614716,10614717,10614718,10614722,10614732,10614733,10614734,10614735,10614736,10614737,10614738,10614739,10614740,10614741,10614742,10614743,10614744,10614745,10614746,10614749,10614751,10614753,10614762,10614763,10614765,10614766,10614767,10611779,10611823,10614825,10614826,10614827,10614833,10614838,10614839,10614840,10614841,10614842,10614843,10614844,10614845,10614846,10614847,10614848,10614849,10614855,10614856,10611856,10614857,10614858,10614859,10614861,10611864,10614891,10614892,10614900,10614901,10614902,10614906,10614907,10614908,10614909,10614912,10614913,10614914,10614915,10614943,10611984,10612021,10612056,10612069,10612082,10612083,10612093,10612133,10612171,10612176,10612191,10612192,10612234,10609245,10609246,10612253,10612254,10612255,10612256,10612257,10612294,10612328,10612344,10612347,10612381,10609392,10612408,10612409,10612410,10612411,10612412,10612418,10612419,10612420,10612421,10612422,10612423,10612425,10612428,10612431,10612433,10612434,10612435,10612436,10612438,10612439,10612440,10609440,10612441,10612442,10612448,10612450,10612454,10612457,10612458,10612464,10612465,10612467,10612468,10612469,10612470,10612471,10612472,10612473,10612474,10612483,10612484,10612485,10609485,10612486,10609486,10612487,10609487,10612488,10612489,10612490,10612491,10612492,10612493,10612496,10612497,10612498,10612499,10612501,10612505,10612506,10612513,10612516,10612517,10612518,10612519,10612520,10612521,10612522,10612523,10612524,10612525,10612526,10612527,10612528,10612529,10612530,10612532,10612533,10612535,10612537,10612539,10612540,10612541,10612542,10612544,10612545,10612546,10612547,10612548,10612549,10612550,10612551,10612552,10612553,10612554,10612556,10612557,10609557,10612558,10609559,10609562,10612562,10609564,10612564,10612565,10609565,10612566,10612567,10609567,10612568,10612569,10612570,10612571,10612572,10612573,10612579,10612580,10612581,10612582,10612583,10612584,10612585,10612586,10612587,10612588,10612589,10609589,10612590,10612591,10612592,10609592,10612595,10612596,10609596,10612597,10612599,10612600,10612601,10612602,10612603,10612604,10612605,10612606,10612607,10612608,10612609,10612610,10612611,10612612,10612613,10612614,10612615,10612616,10612617,10612618,10612619,10612623,10612625,10612626,10612631,10612632,10612634,10612637,10612639,10612641,10612644,10612645,10612647,10612648,10612651,10612654,10612655,10612657,10612660,10612662,10612663,10612664,10612666,10612667,10612668,10612670,10612671,10612672,10612673,10612674,10612675,10612678,10612679,10612680,10612682,10612683,10612684,10612685,10612686,10612688,10612689,10612690,10612692,10612693,10612694,10612695,10612697,10609698,10612698,10612699,10612700,10612701,10612702,10612703,10612704,10612705,10612706,10612707,10612708,10612709,10612710,10612711,10612712,10612713,10612715,10612717,10612718,10612720,10612721,10612722,10612723,10612725,10612730,10612731,10612732,10612733,10612734,10612735,10612736,10612737,10612738,10612739,10612740,10612741,10612742,10612743,10612744,10612745,10612746,10612747,10612748,10612749,10612750,10612751,10612752,10612753,10612754,10612755,10612756,10612759,10612760,10612761,10612762,10612763,10612764,10612765,10612766,10612768,10609770,10612772,10609772,10609774,10609775,10612781,10612782,10612783,10612784,10612785,10612786,10612787,10612789,10612790,10612791,10612792,10612793,10612794,10612795,10612796,10612797,10612805,10612806,10612807,10612808,10612809,10609823,10612825,10612826,10609827,10612827,10612828,10609828,10609829,10612829,10612830,10609830,10612831,10612832,10612833,10612834,10612835,10612836,10612837,10612838,10612841,10612842,10612843,10612844,10612845,10612846,10612849,10612850,10612851,10612852,10612853,10612854,10609856,10612856,10612857,10609858,10612858,10612859,10612861,10612862,10612863,10612864,10612865,10612866,10612867,10612868,10612869,10612870,10612871,10612872,10612873,10612874,10612875,10612876,10612877,10612878,10612879,10612880,10612881,10612886,10612887,10612888,10612889,10612890,10612891,10612892,10612893,10612894,10612895,10612896,10612897,10612898,10612899,10612900,10612907,10612912,10612914,10609958,10612973,10612977,10612978,10609980,10609994,10612998,10612999,10609999,10613000,10613001,10610001,10613002,10610002,10613003,10613004,10613005,10613006,10610006,10613007,10613008,10613023,10613036,10610054,10613056,10613057,10613058,10613060,10613061,10613062,10613063,10613064,10613065,10613066,10613068,10613069,10613074,10613075,10613077,10613078,10613083,10613090,10613092,10610111,10610175,10610176,10610177,10610178,10610180,10610190,10610191,10610229,10610230,10610231,10610232,10610233,10610268,10610293,10610294,10613305,10610341,10610342,10613358,10610365,10610366,10613388,10613393,10613421,10613422,10613430,10613431,10613432,10613434,10613445,10613455,10613466,10613478,10613481,10613484,10613488,10613489,10613490,10610491,10613503,10613504,10613505,10613507,10613512,10613513,10613514,10613522,10613525,10613526,10613527,10613528,10613530,10613531,10613547,10613550,10613554,10613555,10613557,10613559,10613561,10613562,10613563,10613565,10613568,10613570,10613571,10613658,10613659,10613660,10613662,10613663,10613664,10613665,10613666,10613667,10613670,10613671,10613672,10613673,10613674,10613680,10613681,10613682,10613683,10613684,10613685,10613686,10613687,10613688,10613689,10613690,10613691,10613692,10613694,10610696,10613706,10613707,10613708,10610710,10610713,10610723,10610724,10610725,10610726,10610727,10610728,10610732,10610733,10610734,10610735,10610736,10610737,10610738,10610740,10610741,10610742,10610743,10610744,10610745,10610746,10610747,10610748,10610749,10610750,10610751,10610752,10610872,10610901,10610908,10610909,10610932,10610942,10517656,10517791,10517792,10517793,10419257,10419264,10419265,10415273,10419285,10419286,10415288,10415289,10415291,10415292,10419292,10419295,10419297,10419298,10415326,10415339,10419342,10415343,10419354,10419382,10419383,10419385,10419395,10419396,10419474,10419477,10419479,10415481,10419481,10419484,10415590,10419602,10419603,10419607,10419610,10419614,10419622,10419623,10419627,10419632,10419633,10419641,10419642,10419651,10419652,10419653,10419654,10419655,10419661,10419662,10419663,10419664,10419665,10415717,10415724,10415725,10415758,10415759,10415760,10415761,10415762,10415763,10415764,10415765,10415766,10415767,10415768,10415769,10415770,10415771,10415772,10415773,10415774,10415775,10415776,10415777,10415778,10415779,10415780,10415781,10415789,10415790,10415791,10415792,10415793,10415794,10415795,10415796,10415797,10415798,10415799,10415800,10415801,10415802,10415803,10415804,10415805,10415806,10415807,10415808,10415809,10415810,10415811,10415812,10415813,10415814,10415815,10415816,10415817,10415818,10415819,10415820,10415821,10415822,10415823,10415824,10415825,10415826,10415827,10415828,10415829,10415830,10415831,10415832,10415833,10415834,10415835,10415836,10415837,10415838,10415839,10415840,10415841,10415842,10415843,10415844,10415845,10415846,10415847,10415848,10415849,10415850,10415851,10415852,10415853,10415854,10415855,10415856,10415857,10415858,10415859,10415860,10415861,10415862,10415863,10415864,10415865,10415866,10419867,10415867,10415868,10419869,10415869,10415870,10415871,10419872,10415872,10419873,10415873,10415874,10415875,10415876,10415877,10415878,10415879,10415880,10415881,10415882,10415883,10415884,10415885,10415886,10415887,10415888,10415889,10415890,10415891,10415892,10415893,10415894,10415895,10415896,10415897,10415898,10415899,10415900,10415901,10415902,10415903,10415904,10415905,10415906,10415907,10415908,10415909,10415910,10415911,10415912,10415913,10415914,10415915,10415916,10415917,10415918,10415919,10415920,10415921,10415922,10416027,10416029,10416031,10416033,10416038,10416041,10416046,10416047,10416052,10416053,10416055,10416056,10416057,10416076,10416113,10416114,10416117,10416118,10416120,10416124,10416126,10416128,10416130,10416132,10416133,10416135,10416137,10416138,10416139,10416140,10416142,10416143,10416145,10416147,10416149,10416150,10416151,10416152,10416153,10416154,10416155,10416156,10416157,10416158,10416159,10416160,10416161,10416162,10416163,10416164,10416165,10416166,10416167,10416168,10416169,10416170,10416171,10416172,10416173,10416174,10416175,10416176,10416177,10416178,10416179,10416180,10416181,10471029,10471055,10471102,10471103,10471116,10469903,10469904,10469905,10469906,10470204,10470742,10470757,10470802) 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'