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,7065918,7065919,7065920,7065938,7065955,7065956,7065957,7065958,7065982,7065986,7066011,7066024,7066025,7066026,7066027,7066029,7066030,7066031,7066056,7066058,7066060,7066061,7066100,7066123,7066127,7066130,7066131,7066132,7066133,7066134,7066135,7066136,7066173,7066179,7066209,7066213,7066214,7066215,7066216,7066217,7066218,7066219,7066220,7066221,7066222,7066223,7066224,7066225,7066226,7066227,7066228,7066229,7066230,7066231,7066232,7066233,7066234,7066235,7066236,7066237,7066238,7066239,7066240,7066241,7066242,7066243,7066244,7066245,7066246,7066247,7066248,7066249,7066250,7066266,8067918,8067919,8067922,8067923,8067924,8067925,8067929,8067938,8067939,8067940,7064547,7064548,7065336,8860324,8860379,8860384,8860391,8860392,8860394,8860414,8860443,8860444,8860445,8860446,10623491,10623492,10623493,10623736,10623965,10927509,10927510,10927511,10927512,10927513,10927514,10927515,10622406,10622525,10622526,10622537,10620121,10620791,10613981,10614022,10614023,10614027,10614028,10614029,10614048,10614055,10614056,10614064,10614204,10614274,10614282,10614291,10614292,10614301,10614304,10614314,10614327,10614328,10614329,10614376,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,10559708,10559710,10614570,10614571,10614572,10614573,10614574,10614575,10614576,10614577,10614578,10614579,10614580,10614581,10614582,10614583,10614584,10614585,10614586,10614587,10614588,10614629,10614639,10614656,10614658,10614669,10614713,10614863,10614864,10611962,10611963,10611964,10611965,10611966,10611967,10611968,10612035,10612036,10612075,10612089,10612108,10612135,10612136,10612137,10612189,10612263,10612265,10612267,10612269,10612270,10612271,10612272,10612273,10612274,10612287,10612344,10612529,10612755,10612758,10612803,10612804,10612910,10612911,10612912,10612913,10612914,10612932,10612933,10612952,10612968,10612969,10613034,10613055,10613122,10613123,10613124,10613125,10613126,10613127,10613157,10613184,10613187,10613207,10613348,10613369,10613463,10613488,10613513,10613514,10613522,10613534,10613536,10613537,10613646,10613647,10613648,10613649,10613650,10613651,10613652,10613653,10613654,10613655,10613656,10613657,10613658,10613659,10613660,10613661,10613662,10613663,10613664,10613665,10613666,10613667,10613668,10613669,10613670,10613671,10613672,10613673,10613674,10613675,10613676,10613677,10613678,10613679,10613680,10613681,10613682,10613683,10613684,10613685,10613686,10613687,10613688,10613689,10613690,10613691,10613692,10613693,10613694,10613695,10613696,10613697,10613698,10613699,10613700,10613701,10613702,10613703,10613704,10613705,10613706,10613707,10613708,10613709,10613710,10613711,10613712,10613713,10613714,10613715,10613716,10613717,10613718,10613719,10613720,10613721,10613722,10613723,10613724,10613725,10613726,10613801,10613808,10613809,10613844,10613853,10613942,10613943,10513398,10419253,10419256,10419257,10419258,10419259,10419260,10419261,10419262,10417284,10419285,10419286,10419288,10419292,10419295,10419296,10419297,10419298,10419300,10419301,10416302,10419302,10416303,10419303,10416304,10419304,10419305,10416305,10419306,10416306,10419307,10416307,10419308,10419309,10419310,10419311,10419312,10419313,10419314,10419315,10419316,10419317,10419318,10419319,10419320,10416320,10419321,10419322,10419323,10419324,10419325,10419326,10419327,10419328,10419329,10419330,10419331,10417358,10417359,10417360,10417386,10417387,10417388,10417389,10417390,10417391,10417392,10417393,10417448,10419466,10419467,10417486,10419493,10417493,10419494,10417494,10419495,10419496,10419497,10419498,10416610,10416617,10416618,10417634,10416640,10416641,10416649,10417650,10416651,10416655,10416656,10416658,10416659,10416661,10416662,10416673,10416674,10416718,10416719,10416762,10416763,10416765,10416766,10416770,10416779,10416781,10416797,10419876,10419877,10419878,10419879,10419880,10419881,10416955,10416956,10416957,10416976,10416977,10416978,10416979,10416980,10416981,10416982,10416983,10416984,10416985,10416986,10416987,10416988,10416989,10416990,10416991,10416992,10416993,10416994,10416995,10416996,10416997,10416998,10416999,10417000,10417001,10417002,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,10467604,10467605,10467606,10467607,10467608,10467609,10467610,10467611,10467612,10467613,10467614,10467615,10467616,10467617,10467618,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'