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(7074142,7074143,7074144,7074145,7074146,7074147,7074148,7074149,7074150,7074151,7074152,7074153,7074154,7074155,7074156,7074157,7074158,7074159,7074160,7074161,7074162,7074163,7074164,7074165,7074166,7074167,7074168,7074169,7074170,7074171,7074172,7074173,7074174,7074175,7074176,7074177,7074178,7074179,7074180,7074181,7074182,7074183,7074184,7074185,7074186,7074187,7074188,7074189,7074190,11042462,7075115,10962319,10962320,11035418,11035419,11035420,11035421,11035422,11035423,11035424,11035425,11035426,11035427,11035428,11035429,11035430,11035431,11035432,11035433,11035434,11035435,11035436,11035437,11035438,11035439,11035440,11035441,11035442,11035443,11035444,11035445,11035446,11035447,11035448,11035449,11035450,11035451,11035452,11035453,11035454,11035455,11035456,11035457,11035458,11035459,11035460,11035461,11035462,11035463,11035464,11035465,11035466,11035467,11035468,11035469,11035470,11035471,11035472,11035473,11035474,11035475,11035476,11035477,11035478,11035479,11035480,11035481,11035482,11035483,11035484,11035485,11035486,11035487,11035488,11035489,11035490,11035491,11035492,11035493,11035494,10967659,10981537,10981538,10993366,8570307,8570308,8570309,10921719,10921720,10921721,10921722,10921723,10921724,10921725,10921726,10921727,10921728,10921729,10921730,10921731,10921732,10921733,10921734,10921735,10921736,10921737,10921738,10921739,10921740,10921741,10921742,10921743,10921744,10921745,10921746,10921747,10921748,10921749,10921750,10921751,10921752,10921753,10921754,10921755,10921756,10921757,10921758,10921759,10921760,10921761,10921762,10921763,10921764,10921765,10921766,10921767,10921768,10921769,10921770,10921771,10921772,10921773,10921774,10921775,10921776,10921777,10921778,10921779,10921780,10921781,10921782,10921783,10921784,10921785,10921786,10921787,10921788,10921789,10921790,10921791,10921792,10921793,10921794,10921795,10921796,10921797,10921798,10921799,10921800,10921801,10921802,10921803,10921804,10921805,10921806,10921807,10921808,10921809,10921810,10921811,10921812,10921813,10921814,10921815,10921816,10921817,10921818,10921819,10921820,10921821,10921822,10921823,10921824,10921825,10921826,10921827,10921828,10921829,10921830,10921831,10921832,10921833,10921834,10921835,10921836,10921837,10921838,10921839,10921840,10921841,10921842,10921843,10921844,10921845,10921846,10921847,10921848,10921849,10921850,10921851,10921852,10921853,10921854,10921855,10921856,10921857,10921858,10921859,10921860,10921861,10921862,10921863,10921864,10921865,10921866,10921867,10921868,10921869,10921870,10921871,10921872,10921873,10921874,10921875,10921876,10921877,10921878,10921879,10921880,10921881,10921882,10921883,10921884,10921885,10921886,10921887,10921888,10921889,10921890,10921891,10921892,10921893,10921894,10921895,10921896,10921897,10921898,10921899,10921900,10921901,10921902,10921903,10921904,10921905,10921906,10921907,10921908,10921909,10921910,10921911,10921912,10921913,10921914,10921915,10921916,10921917,10921918,10921919,10921920,10921921,10921922,10921923,10921924,10921925,10921926,10921927,10921928,10921929,10921930,10921931,10921932,10921933,10921934,10921935,10921936,10921937,10921938,10921939,10921940,10921941,10921942,10921943,10921944,10921945,10921946,10921947,10921948,10921949,10921950,10921951,10921952,10921953,10921954,10921955,7058763,7058764,7058765,7058766,4974602,4974603,4974604,4974605,4974606,4974607,4974608,9174792,9174793,10468253,10468254,10468255,10462301,10468323,10468324,10468325,10468326,10468327,10468328,10468329,10468436,10629871,10629872,10629873,10629874,10629875,10629876,10629877,10629878,10629879,10629880,10629881,10629882,10629883,10629891,10629892,10629893,10629894,10629895,10629896,10629897,10629898,10629899,10629900,10629901,10629902,10629903,10629904,10629905,10629906,10629907,10629908,10629909,10629910,10629911,10629912,10629913,10629914,10629915,10629916,10629917,10629918,10629919,10629920,10629921,10629922,10629923,10629924,10629925,10629926,10629927,10629928,10629929,10629930,10629931,10629932,10629933,10629934,10629935,10629936,10629937,10629938,10629939,10629940,10629941,10629942,10629943,10629944,10629945,10629946,10629947,10629948,10629949,10629950,10629951,10629952,10629953,10629954,10629955,10629956,10629957,10629958,10629959,10629960,10629961,10629962,10629963,10629964,10629965,10629966,10629967,10629968,10629969,10629970,10629971,10629972,10629973,10629974,10629975,10629976,10629977,10629978,10629979,10629980,10629981,10629982,10629983,10629984,10629985,10629986,10629987,10629988,10629989,10629990,10629991,10629992,10629993,10629994,10629995,10629996,10629997,10578915,10578916,10578917,10578918,10578919,10578920,10578921,10578922,10578923,10578924,10578925,10578926,10578927,10578928,10578929,10578930,10578931,10578932,10578933,10578934,10578935,10578936,10578937,10578938,10578939,10578940,10578941,10578942,10578943,10578944,10578945,10578946,10578947,10578948,10578949,10578950,10578951,10578952,10578953,10578954,10578955,10578956,10578957,10578958,10578959,10578960,10578961,10578962,10578963,10579014,10579015,10579016,10579017,10579018,10579019,10579020,10579021,10579022,10579023,10579024,10579025,10579026,10579027,10579028,10579029,10579030,10579031,10579032,10579033,10579034,10579035,10579036,10579037,10579038,10579039,10579040,10579041,10579042,10579043,10579044,10579045,10579046,10579047,10579048,10579049,10579050,10579051,10579052,10579053,10579054,10579055,10579056,10579057,10579058,10579059,10579060,10579061,10579062,10579063,10579064,10579065,10579066,10579067,10579068,10579069,10579070,10579071,10579072,10579073,10579074,10579075,10579076,10579077,10579078,10579079,10579080,10579081,10579082,10579083,10579084,10579085,10579086,10579087,10579088,10579089,10579090,10579091,10579092,10579093,10579094,10579095,10579096,10579097,10579098,10579099,10579100,10579101,10579102,10579103,10579104,10579105,10579106,10579107,10579108,10579109,10579110,10579111,10579112,10579113,10579114,10579115,10579116,10579117,10579118,10579119,10579120,10579121,10579122,10579123,10579124,10579125,10579126,10579127,10579128,10579129,10579130,10579131,10579132,10579133,10579134,10579135,10579136,10579137,10579138,10579139,10579140,10579141,10579142,10579143,10579144,10579145,10579146,10579147,10579148,10579149,10579150,10579151,10579152,10579153,10579154,10579155,10579156,10579157,10579158,10579159,10579160,10579161,10579162,10579163,10579164,10579165,10579166,10579167,10579168,10579169,10579170,10579171,10579172,10579173,10579174,10579175,10579176,10579177,10579178,10579179,10579180,10579181,10579182,10579183,10579184,10579185,10579186,10579187,10579188,10579189,10579190,10579191,10579192,10579193,10579194,10579195,10579196,10579197,10579198,10579199,10579200,10579201,10579202,10579203,10579204,10579205,10579206,10579207,10579208,10579209,10579210,10579211,10579212,10579213,10579214,10579215,10579216,10579217,10579218,10579219,10579220,10579221,10579222,10579223,10579224,10579225,10579226,10579227,10579228,10579229,10579230,10579231,10579232,10579233,10579234,10579235,10579236,10579237,10579238,10579239,10579240,10579241,10579242,10579243,10579244,10579245,10579246,10579247,10579248,10579249,10579250,10579251,10579252,10579253,10579254,10579255,10579256,10579257,10579258,10579259,10579260,10579261,10579262,10579263,10579264,10579265,10579266,10579267,10579268,10579269,10579270,10579271,10579272,10579273,10579274,10579275,10579276,10579277,10579278,10579279,10579280,10579281,10579282,10579283,10579284,10579285,10579286,10579287,10579288,10579289,10579290,10579291,10579292,10579293,10579294,10579295,10579296,10579297,10579298,10579299,10579300,10579301,10579302,10579303,10579304,10579305,10579306,10579307,10579308,10579309,10579310,10579311,10579312,10579313,10579314,10579315,10579316,10579317,10579318,10579319,10579320,10579321,10579322,10579323,10579324,10579325,10579326,10579327,10579328,10579329,10579330,10579331,10579332,10579333,10579334,10579335,10579336,10579337,10579338,10579339,10579340,10579341,10579342,10579343,10579344,10579345,10579346,10579347,10579348,10579349,10579350,10579351,10579352,10579353,10579354,10579355,10579356,10579357,10579358,10579359,10579360,10579361,10579362,10579363,10579364,10579365,10579366,10579367,10579368,10579369,10579370,10579371,10579372,10579373,10579374,10579375,10579376,10579377,10579378,10579379,10579380,10579381,10579382,10579383,10579384,10579385,10579386,10579387,10579388,10579389,10579390,10579391,10579392,10579393,10579394,10579395,10579396,10579397,10579398,10579399,10579400,10579401,10579402,10579403,10579404,10579405,10579406,10579407,10579408,10579409,10579410,10579411,10579412,10579413,10579414,10579415,10579416,10579417,10579418,10579419,10579420,10579421,10579422,10579423,10579424,10579425,10579426,10579427,10579428,10579429,10579430,10579431,10579432,10579433,10579434,10579435,10579436,10579437,10579438,10579439,10579440,10579441,10579442,10528370,10528372,10480830) 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'