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(4970450,4970682,4970714,4970745,4970746,4970747,4970748,4970749,4970750,4970751,4970752,4970753,4970754,4970755,4970756,4970766,4970767,4970768,10623060,10623491,10623492,10623498,10622344,10622401,10622404,10622409,10622414,10622430,10622525,10622539,10620119,10620120,10620572,10419243,10419244,10419245,10419246,10419247,10419248,10419249,10419250,10419251,10419252,10419253,10419254,10419255,10419256,10419257,10419258,10419259,10419260,10419261,10419262,10419263,10419264,10419265,10419266,10419267,10419268,10419269,10419270,10419271,10419272,10419273,10419274,10419275,10419276,10419277,10419278,10419279,10419280,10419281,10419282,10419283,10419284,10419285,10419286,10419287,10419288,10419289,10419290,10419291,10419292,10419293,10419294,10419295,10419296,10419297,10419298,10419299,10419300,10419301,10419302,10419303,10419304,10419305,10419306,10419307,10419308,10419309,10419310,10419311,10419312,10419313,10419314,10419315,10419316,10419317,10419318,10419319,10419320,10419321,10419322,10419323,10419324,10419325,10419326,10419327,10419328,10419329,10419330,10419331,10419332,10419333,10419334,10419335,10419336,10419337,10419338,10419339,10419340,10419341,10419342,10419343,10419344,10419345,10419346,10419347,10419348,10419349,10419350,10419351,10419352,10419353,10419354,10419355,10419356,10419357,10419358,10419359,10419360,10419361,10419362,10419363,10419378,10419379,10419380,10419381,10419382,10419383,10419384,10419385,10419386,10419387,10419388,10419389,10419390,10419391,10419392,10419393,10419394,10419395,10419396,10419397,10419437,10419438,10419439,10419458,10419459,10419460,10419461,10419462,10419463,10419464,10419465,10419472,10419473,10419474,10419475,10419476,10419477,10419478,10419479,10419480,10419481,10419482,10419483,10419484,10419485,10419486,10419487,10419488,10419489,10419490,10419491,10419492,10419564,10419565,10419592,10419593,10419594,10419595,10419653,10419654,10419655,10419656,10419657,10419658,10419659,10419660,10419661,10419662,10419663,10419664,10419665,10419811,10419874,10419875,10471121,10471122,10471123,10471124,10471125,10471168,10469894,10469895,10469896,10469897,10469898,10469899,10469900,10469901,10469931,10469936,10469937,10469938,10469939,10469940,10469941,10469942,10469943,10469944,10469945,10469946,10469951,10469952,10469953,10469954,10469955,10469956,10469957,10469958,10469959,10469960,10469961,10469962,10469963,10469964,10469965,10469966,10469967,10469968,10469969,10469970,10469971,10469972,10469973,10469974,10469975,10469976,10469977,10469978,10469979,10469980,10469981,10469982,10469983,10469984,10469985,10469986,10469987,10469988,10469989,10469990,10469991,10469992,10469993,10469994,10469995,10469996,10469997,10469998,10469999,10470000,10470001,10470002,10470003,10470004,10470005,10470006,10470007,10470008,10470009,10470010,10470011,10470012,10470013,10470014,10470015,10470016,10470017,10470018,10470019,10470020,10470021,10470022,10470023,10470024,10470025,10470026,10470027,10470028,10470029,10470030,10470031,10470032,10470033,10470034,10470035,10470036,10470037,10470038,10470039,10470040,10470041,10470042,10470043,10470044,10470045,10470046,10470047,10470048,10470049,10470050,10470051,10470052,10470053,10470054,10470055,10470056,10470057,10470058,10470059,10470060,10470061,10470062,10470063,10470064,10470065,10470066,10470067,10470068,10470069,10470070,10470071,10470072,10470073,10470074,10470075,10470076,10470077,10470078,10470079,10470080,10470081,10470082,10470083,10470084,10470085,10470086,10470087,10470088,10470089,10470090,10470091,10470092,10470093,10470094,10470095,10470096,10470097,10470098,10470099,10470100,10470101,10470102,10470103,10470104,10470105,10470106,10470107,10470108,10470109,10470110,10470111,10470112,10470113,10470114,10470115,10470116,10470117,10470118,10470119,10470120,10470121,10470122,10470123,10470124,10470125,10470126,10470127,10470128,10470129,10470130,10470131,10470132,10470133,10470134,10470135,10470136,10470137,10470138,10470139,10470140,10470141,10470142,10470143,10470144,10470145,10470146,10470147,10470148,10470149,10470150,10470151,10470152,10470153,10470154,10470155,10470156,10470157,10470158,10470159,10470160,10470161,10470162,10470163,10470164,10470165,10470166,10470167,10470168,10470169,10470170,10470171,10470172,10470173,10470174,10470175,10470176,10470177,10470178,10470179,10470180,10470181,10470182,10470183,10470184,10470185,10470186,10470187,10470188,10470189,10470190,10470191,10470192,10470193,10470194,10470195,10470196,10470197,10470198,10470199,10470200,10470201,10470202,10470203,10470204,10470205,10470206,10470207,10470208,10470209,10470210,10470211,10470212,10470213,10470214,10470215,10470216,10470217,10470218,10470219,10470220,10470221,10470222,10470223,10470224,10470225,10470226,10470227,10470228,10470229,10470230,10470231,10470232,10470233,10470234,10470235,10470236,10470237,10470238,10470239,10470240,10470241,10470242,10470243,10470244,10470245,10470246,10470247,10470248,10470249,10470250,10470251,10470252,10470253,10470254,10470255,10470256,10470257,10470258,10470259,10470260,10470261,10470262,10470263,10470264,10470265,10470266,10470267,10470268,10470269,10470270,10470271,10470272,10470273,10470274,10470275,10470276,10470277,10470278,10470279,10470280,10470281,10470282,10470283,10470284,10470285,10470286,10470287,10470288,10470289,10470290,10470291,10470292,10470293,10470294,10470295,10470296,10470297,10470298,10470299,10470300,10470301,10470302,10470303,10470304,10470305,10470306,10470307,10470308,10470309,10470310,10470311,10470312,10470313,10470314,10470315,10470316,10470317,10470318,10470319,10470320,10470321,10470322,10470323,10470324,10470325,10470326,10470327,10470328,10470329,10470330,10470331,10470332,10470333,10470334,10470335,10470336,10470337,10470338,10470339,10470340,10470341,10470342,10470343,10470344,10470345,10470346,10470347,10470348,10470349,10470350,10470351,10470352,10470353,10470354,10470355,10470356,10470357,10470358,10470359,10470360,10470361,10470362,10470363,10470364,10470365,10470366,10470367,10470368,10470369,10470370,10470371,10470372,10470373,10470374,10470375,10470376,10470377,10470378,10470379,10470380,10470381,10470382,10470383,10470384,10470385,10470386,10470387,10470388,10470389,10470390,10470391,10470392,10470393,10470394,10470395,10470396,10470397,10470398,10470399,10470400,10470401,10470402,10470403,10470404,10470405,10470406,10470407,10470408,10470409,10470410,10470411,10470412,10470413,10470414,10470415,10470416,10470417,10470418,10470419,10470420,10470421,10470422,10470423,10470424,10470425,10470426,10470427,10470428,10470429,10470430,10470431,10470432,10470433,10470434,10470435,10470436,10470437,10470438,10470439,10470440,10470441,10470442,10470443,10470444,10470445,10470446,10470447,10470448,10470449,10470450,10470451,10470452,10470453,10470454,10470455,10470456,10470457,10470458,10470459,10470460,10470461,10470462,10470463,10470464,10470465,10470466,10470467,10470468,10470469,10470470,10470471,10470472,10470473,10470474,10470475,10470476,10470477,10470478,10470479,10470480,10470481,10470482,10470483,10470484,10470485,10470486,10470487,10470488,10470489,10470490,10470491,10470492,10470493,10470494,10470495,10470496,10470497,10470498,10470499,10470500,10470501,10470502,10470503,10470504,10470505,10470506,10470507,10470508,10470509,10470510,10470511,10470512,10470513,10470514,10470515,10470516,10470517,10470518,10470519,10470520,10470521,10470522,10470523,10470524,10470525,10470526,10470527,10470528,10470529,10470530,10470531,10470532,10470533,10470534,10470535,10470536,10470537,10470538,10470539,10470540,10470541,10470542,10470543,10470544,10470545,10470546,10470547,10470548,10470549,10470550,10470551,10470552,10470553,10470554,10470555,10470556,10470557,10470558,10470559,10470560,10470561,10470562,10470563,10470564,10470565,10470566,10470567,10470568,10470569,10470570,10470571,10470572,10470573,10470574,10470575,10470576,10470577,10470578,10470579,10470580,10470581,10470582,10470583,10470584,10470585,10470586,10470587,10470588,10470589,10470590,10470591,10470592,10470593,10470594,10470595,10470596,10470597,10470598,10470599,10470600,10470601,10470602,10470603,10470604,10470605,10470606,10470607,10470608,10470609,10470610,10470611,10470612,10470613,10470614,10470615,10470616,10470617,10470618,10470619,10470620,10470621,10470622,10470623,10470624,10470625,10470626,10470627,10470628,10470629,10470630,10470631,10470632,10470633,10470634,10470635,10470636,10470637,10470638,10470639,10470640,10470641,10470642,10470643,10470644,10470645,10470646,10470647,10470648,10470649,10470650,10470651,10470652,10470653,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) 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'