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(4970757,4970758,4970759,4970760,4970761,4970762,4970763,4970764,4970765,4970766,4970767,4970768,4970772,8067918,8067919,8067922,8067923,8067924,8067925,8067929,8067938,8067939,8067940,10939103,10939388,10939389,10939390,10939419,10939425,10939434,10939436,10939437,10939438,10939439,8065833,8065834,8065835,8065841,8065849,8065850,10623491,10623492,10623493,10623736,10623965,10622406,10622525,10622526,10622537,10620121,10620791,10613981,10614022,10614023,10614027,10614028,10614029,10614048,10614055,10614056,10614064,10611141,10614204,10614274,10614282,10614291,10614292,10611293,10614301,10614304,10614314,10614327,10614328,10614329,10611351,10611352,10611358,10614376,10611423,10614441,10614442,10614443,10614444,10614445,10614446,10614447,10614448,10614449,10614450,10614451,10614452,10614453,10614454,10614455,10614456,10614457,10614458,10614459,10614460,10614461,10614462,10614463,10614464,10614465,10614466,10614467,10614468,10614469,10614470,10614471,10614516,10614570,10614571,10614572,10614573,10614574,10614575,10614576,10614577,10614578,10614579,10614580,10614581,10614582,10614583,10614584,10614585,10614586,10614587,10614588,10614629,10611705,10611706,10611707,10611782,10611830,10611831,10611832,10611833,10611834,10611892,10611959,10611960,10611961,10609158,10609165,10609169,10609230,10609261,10609284,10609355,10609369,10609398,10609443,10609444,10609815,10609843,10609844,10609846,10609847,10609848,10609849,10609850,10609851,10609852,10609853,10609854,10609855,10609856,10609857,10609858,10609859,10609860,10609861,10609862,10609863,10609864,10609865,10609866,10609867,10609868,10609869,10609870,10609871,10609872,10609873,10609874,10609875,10609876,10609877,10609878,10609879,10609880,10609881,10609882,10609883,10609884,10609885,10609886,10609887,10609888,10609889,10609890,10609891,10609892,10609893,10609894,10609895,10609896,10609897,10609898,10609899,10609900,10609901,10609902,10609903,10609904,10609905,10609906,10609907,10609908,10609909,10609910,10609911,10609912,10609913,10609914,10609915,10609916,10609917,10609918,10609919,10609920,10609921,10609922,10609923,10609924,10609925,10609926,10609927,10609928,10609929,10609930,10609931,10609932,10609933,10609934,10609935,10609936,10609937,10609938,10609939,10609940,10609941,10609942,10609943,10609944,10609945,10609946,10609947,10609948,10609949,10609950,10609951,10609952,10609953,10609954,10609955,10609956,10609957,10609958,10609959,10609960,10609961,10609962,10609963,10609964,10609965,10609966,10609967,10609968,10609969,10609970,10609971,10610035,10610037,10610039,10610041,10610042,10610044,10610053,10610054,10610067,10610268,10610274,10610298,10610310,10610311,10610377,10610378,10610379,10610380,10610381,10610382,10610383,10610384,10610385,10610386,10610387,10610388,10610389,10610390,10610391,10610392,10610393,10610394,10610395,10610396,10610397,10610398,10610399,10610400,10610401,10610402,10610403,10610404,10610405,10610406,10610407,10610408,10610409,10610410,10610411,10610412,10610413,10610414,10610415,10610416,10610417,10610418,10610419,10610420,10610421,10610422,10610423,10610424,10610425,10610426,10610427,10610468,10610568,10610573,10610613,10610666,10610667,10610674,10610675,10610676,10610683,10610698,10610789,10610838,10610870,10610872,10610915,10610916,10610946,10610947,10610948,10610949,10610950,10610951,10610952,10610953,10610954,10610955,10610956,10610957,10419253,10419256,10419257,10419258,10419259,10419260,10419261,10419262,10419285,10419286,10419288,10419292,10419295,10419296,10419297,10419298,10419300,10419301,10419302,10419303,10419304,10419305,10419306,10419307,10419308,10419309,10419310,10419311,10419312,10419313,10419314,10415314,10419315,10415315,10419316,10415316,10419317,10419318,10419319,10419320,10419321,10419322,10415323,10419323,10419324,10419325,10419326,10419327,10419328,10419329,10419330,10419331,10415342,10415343,10415344,10419466,10419467,10415481,10415482,10415483,10415484,10415485,10415486,10415487,10415488,10415489,10415490,10415491,10415492,10415493,10419493,10415494,10419494,10415495,10419495,10415496,10419496,10415497,10419497,10415498,10419498,10415499,10415500,10415501,10415502,10415503,10415504,10415505,10415506,10415507,10415508,10415509,10415510,10415511,10415512,10415513,10415514,10415605,10415607,10415646,10415647,10415648,10415649,10415650,10415651,10415652,10415653,10415654,10415655,10415656,10415657,10415658,10415659,10415660,10415661,10415662,10415663,10415664,10415665,10415666,10415667,10415668,10415669,10415670,10415671,10415672,10415673,10415674,10415782,10415783,10415784,10415785,10415786,10415787,10415788,10419876,10419877,10419878,10419879,10419880,10419881,10416187,10416189,10416190,10470876,10470877,10470878,10470879,10470880,10470881,10470882,10470883,10470884,10470885,10470886,10470887,10470888,10470889,10470890,10470891,10470892,10470893,10470894,10470895,10470896,10470897,10470898,10470899,10470900,10470901,10470902,10470903,10470904,10470905,10470906,10470907,10470908,10470909,10470910,10470911,10470912,10470913,10470914,10470915,10470916,10470917,10470918,10470919,10470920,10470921,10470922,10470923,10470924,10470925,10470926,10470927,10470928,10470929,10470930,10470931,10470932,10470933,10470934,10470935,10470936,10470937,10470938,10470939,10470940,10470941,10470942,10470943,10470944,10470945,10470946,10470947,10470948,10470949,10470950,10470951,10470952,10470953,10470954,10470955,10470956,10470957,10470958,10470959,10470960,10470961,10470962,10470963,10470964,10470965,10470966,10470967,10470968,10470969,10470970,10470971,10470972,10470973,10470974,10470975,10470976,10470977,10470978,10470979,10470980,10470981,10470982,10470983,10470984,10470985,10470986,10470987,10470988,10470989,10470990,10470991,10470992,10470993,10470994,10470995,10470996,10470997,10470998,10470999,10471000,10471001,10471002,10471003,10471004,10471005,10471006,10471007,10471008,10471009,10471010,10471011,10471012,10471013,10471014,10471015,10471016,10471017,10471018,10471019,10471020,10471021,10471022,10471023,10471024,10471025,10471026,10471027,10471028,10471029,10471030,10471031,10471032,10471033,10471034,10471035,10471036,10471037,10471038,10471039,10471040,10471041,10471042,10471043,10471044,10471045,10471046,10471047,10471048,10471049,10471050,10471051,10471052,10471053,10471054,10471055,10471056,10471057,10471058,10471059,10471060,10471061,10471062,10471063,10471064,10471065,10471066,10471067,10471068,10471069,10471070,10471071,10471072,10471073,10471074,10471075,10471076,10471077,10471078,10471079,10471080,10471081,10471082,10471083,10471084,10471085,10471086,10471087,10471088,10471089,10471090,10471091,10471092,10471093,10471094,10471095,10471096,10471097,10471098,10471099,10471100,10471101,10471102,10471103,10471104,10471105,10471106,10471107,10471108,10471109,10471110,10471111,10471112,10471113,10471114,10471115,10471116,10471117,10471118,10471119,10471120,10471121,10471122,10471123,10471124,10471125,10471126,10471127,10471128,10471129,10471166,10471175,10469902,10469947,10469948,10470654,10470655,10470656,10470657,10470658,10470659,10470660,10470661,10470662,10470663,10470664,10470665,10470666,10470667,10470668,10470669,10470670,10470671,10470672,10470673,10470674,10470675,10470676,10470677,10470678,10470679,10470680,10470681,10470682,10470683,10470684,10470685,10470686,10470687,10470688,10470689,10470690,10470691,10470692,10470693,10470694,10470695,10470696,10470697,10470698,10470699,10470700,10470701,10470702,10470703,10470704,10470705,10470706,10470707,10470708,10470709,10470710,10470711,10470712,10470713,10470714,10470715,10470716,10470717,10470718,10470719,10470720,10470724,10470725,10470726,10470727,10470728,10470729,10470730,10470731,10470732,10470733,10470734,10470735,10470736,10470737,10470738,10470739,10470740,10470741,10470742,10470743,10470744,10470745,10470746,10470747,10470748,10470749,10470750,10470751,10470752,10470753,10470754,10470755,10470756,10470757,10470758,10470759,10470760,10470761,10470762,10470763,10470764,10470765,10470766,10470767,10470768,10470769,10470770,10470771,10470772,10470773,10470774,10470775,10470776,10470777,10470778,10470779,10470780,10470781,10470782,10470783,10470784,10470785,10470786,10470787,10470788,10470789,10470790,10470791,10470792,10470793,10470794,10470795,10470796,10470797,10470798,10470799,10470800,10470801,10470802,10470803,10470804,10470805,10470806,10470807,10470808,10470809,10470810,10470811,10470812,10470813,10470814,10470815,10470816,10470817,10470818,10470819,10470820,10470821,10470822,10470823,10470824,10470825,10470826,10470827,10470828,10470829,10470830,10470831,10470832,10470833,10470834,10470835,10470836,10470837,10470838,10470839,10470840,10470841,10470842,10470843,10470844,10470845,10470846,10470847,10470848,10470849,10470850,10470851,10470852,10470853,10470854,10470855,10470856,10470857,10470858,10470859,10470860,10470861,10470862,10470863,10470864,10470865,10470866,10470867,10470868,10470869,10470870,10470871,10470872,10470873,10470874,10470875) 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'