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(10250074,7076148,7076150,7076162,8911778,10276529,10276555,10263568,10276583,10276591,8836387,10263623,10276629,10276659,10276676,10943967,10276772,10276784,10276831,10944243,10263972,4971095,10211998,10277050,10199142,8572614,10199208,10199210,10225408,10264410,10225472,8573010,8573126,10212762,10238798,10238838,10238875,10238877,10225933,10262073,10275084,8910455,10275159,10223190,10223191,10223192,7067019,8068026,10262288,10275288,10275315,10275328,8910793,10197523,10262575,10197601,10210617,10197648,10197697,10197719,10197723,8068520,8068533,10262820,8835621,8068666,10262955,8068706,10260072,8564075,8908453,10260106,10195112,10195113,10195114,10221118,8908546,10221201,10221228,10260237,8908596,10221290,10221296,10221306,10221309,10221313,10260362,10260378,10260398,10260413,8564501,7072279,10260575,10260592,10260635,10260643,10195648,10260670,8564716,8564738,10273804,10208814,10273814,8564853,10208877,10260895,10260932,10261144,10261165,10261176,10261193,10261204,10261253,10261269,10261271,10209293,10261301,10209306,10261381,4967517,10261444,10261445,10261467,10261484,10261490,10261498,10209507,10222536,10261538,10261544,10261545,10261610,10261666,10261726,7065571,10196844,10209865,10261945,10261959,10262016,10275036,10275047,10262055,10275060,10272073,10207126,10207127,8907480,8907515,10207170,10207174,10259183,10259221,10259228,10259242,10272309,10272313,10259317,10207318,10272320,10272321,10207329,8861024,10220380,10220394,10220418,10220448,10207506,10220532,10207533,10207570,10220578,10259584,10220605,10220661,10259667,10259690,10220703,10259729,10246794,10246795,10246808,10246809,10246810,10220835,10220860,10220877,10259887,10220890,10220936,8563943,10259974,8905439,8905453,10244255,10244262,10205307,10270327,10205334,10205453,10244459,10940959,10244482,10205545,10231565,10941049,10941050,10941051,10205616,10283622,10205630,10244684,10231684,10244704,10270712,10244723,10205734,10244735,10218739,10244743,10205753,10244763,10270765,10270775,10270778,10205784,10205785,8906133,8906136,10270795,8906152,8906153,8906154,8906155,8906156,8906159,8906160,8906161,10244819,8906167,7069596,8906185,8906187,10283843,8906192,10283860,8906208,8906216,8906217,8906220,8906234,8906243,8906248,8906255,8906256,8906260,8906261,8906262,8906264,8906267,8906275,8906284,8906287,8906289,8906293,8906297,8906299,8906300,10283953,8906301,10205953,10245002,10245003,10245005,10206015,10219021,10219026,7069790,7069791,7069792,7069793,10271045,10245053,10245054,10245055,10271156,10219168,10219199,10271207,8906582,10219241,10219284,10219329,10193353,10271371,10271372,10271396,10206513,10206514,10271519,8906870,10271545,8860275,10219627,10193635,10206640,10258664,10271691,10258694,10206698,10258717,10206739,10258751,10206761,10206776,10284777,10206780,10284801,10245828,10206865,10271873,8860551,10245889,10245890,10245923,10245924,10271935,10219937,10216106,10216111,10216128,10268135,10216161,10268177,10623079,10623080,10623081,10623082,10623083,10623084,10623085,10623086,10190189,10268206,10216218,10216229,10923652,10216240,10216243,10923668,10923670,10216269,10216270,10928696,10928697,10928698,10928699,10216368,10216373,10216387,10923833,10216418,10216428,10268437,10923888,10216482,10923905,10216490,10268496,10229508,10216513,10268579,10268604,10216613,10268619,10268628,10216637,10216645,10924079,10268681,10216696,10216718,10623666,10623667,10623668,10623669,10623670,10623671,10623672,10623673,10623674,10924191,10623675,10623676,10623677,10623678,10623679,10623680,10623681,10623682,10623683,10623684,10623685,10623686,10623687,10623688,10623689,10623690,10623691,10623692,10924282,10924286,10216880,10216884,8904265,10924346,8904277,8904278,8904279,8904280,8904281,8904286,8904288,8904289,8904290,8904296,8904297,8904298,8904301,10229988,10924408,10216991,10924431,10924451,10924491,10924514,10924531,10924552,10924584,10924650,10269248,10924702,10924710,10924725,10619309,10217423,10269430,10204441,10924877,10269473,10924935,10243536,8904904,10243598,10243602,10243609,10217610,10925032,10217614,10217620,10217623,10217632,10925062,10925070,10243653,10243654,10243659,10217684,10217688,10243690,10243692,10243693,10217721,10925142,10925144,10925147,10925157,10925158,10925160,10925166,10217749,10243758,10217765,10217766,10243780,10217788,10217800,10243803,10243826,10243838,10243921,8905294,10925364,10244038,10241083,10189093,10432160,10202302,10202326,10267379,10617323,10617324,10267425,10215429,10215431,10927894,10927895,10215486,10927906,10617396,10617397,10617398,10215497,10617439,10922958,10267556,10215585,10923028,10267612,10267622,10267640,10215696,10241803,10241804,10241805,10202817,10202829,10202844,10202891,10189893,10189894,10189895,10189896,10189897,10189898,10267901,10189902,10202920,10202960,10267961,10622890,10622920,10920524,8569902,10615091,10265250,10278264,10278265,10278268,10920740,10920747,10239367,10920787,10920812,10620296,10620299,10265402,10920821,10920830,10620325,10925843,10278437,10239532,10920957,10920998,10265595,10265597,10926022,10926023,10926024,10921040,10926052,10921062,10926063,10921073,10239660,10615572,10921107,10200709,10200710,10200711,10200712,10200713,10239718,10926154,10265748,10921191,10921233,10921239,10921242,10921261,10921269,8838616,10921275,10265858,10921307,10921328,10921424,10921429,10921436,10921438,10921441,10921444,10921448,10266100,10921555,10266184,8839040,10266359,10188366,10188374,10188376,10188377,10188378,10188379,10188380,10188381,10188382,10188383,10188384,10188385,10188386,10621383,10621414,10921967,10266562,10621468,10621544,10188658,10266690,10621668,10621733,10279905,10201977,10927433,8863870,8863871,8863872,8863873,8863874,8863875,8863877,10614060,10565455,10565456,10565457,10565458,10565459,9181769,9173807,9173808,9166250,9195397,9163423,9171440,9171441,9171442,9171443,9179518,10612188,10612246,9171727,9195909,8862567,10612942,10612970,9212436,9212437,9196607,9196608,10613353,10613376,8863346,8863356,8863536,8863770,9193901,9193933,9194514,9170578,9194657,9194664,10514502,10514503,10514504,9186920,9194927,10518758,10512853,9179186,9195209,9160309,10416231,10416232,10416233,9160319,10416234,10416235,9160322,10416242,10416243,10416244,10416245,10416246,9160332,10416247,10416248,9160334,10416249,9160335,10416250,10416251,10416252,10417466,10417467,10417468,10416503,10416504,9176604,10416549,9168731,9168732,9168748,9168764,10417006,4971381,9206632,8865220,4971602,10465331,10465333,4971617,10467609,9183064,9191248,9207292,9207293,9183514,9183515,9183516,9183517,9183518,9183519,9183520,9183521,10468301,8917723,9192128,10169498,10164499,10169506,10159520,10179529,10164574,10164625,10164646,10164655,10169669,10154670,10164675,10164715,10164730,10164735,10164738,10169757,10159760,10169775,10169796,10159860,10175056,10155085,10165132,10165152,10165158,10165171,10165183,10155238,10165279,10165316,10165330,10160379,10170400,10170430,10175453,10170548,10175558,10170582,10170606,10170638,10170639,10165720,10165742,10155742,10165783,10165795,10175886,10165892,10165909,10161031,10161095,10156184,10186277,10186278,10629766,10186314,10186316,10186318,10186320,10186322,10186324,10186440,10186453,10168487,10168545,10168548,10168561,10168586,10168593,10173638,10158750,10168757,10158766,10173772,10168784,10168808,10158822,10655297,10174040,10174052,10174059,10179071,10655384,10159088,10169111,10164129,10164215,10164226,10164232,10164239,10164256,10164261,10169263,10164264,10164293,10169297,10627782,10164308,10627805,10627806,10627807,10627808,10627810,10627811,10627812,10627815,10627816,10627817,10627818,10169345,10159354,10164368,10164390,10164403,10169405,10627897,10627898,10627899,10627900,10164425,10169428,10169438,10627919,10169449,10627928,10627929,10655770,10186560,10630040,10630041,10630100,10171675,10186690,10181823,10630474,10187005,10167010,10187020,10630498,10630501,10172053,10182157,10630692,10167216,10167223,10167418,10167511,10182573,10162588,10182593,10182601,10162729,10162740,10162823,10183213,10183237,10168237,10163265,10168273,10183276,10168342,10168367,10168418,10168446,10168452,10168464,10183467,10183471,10183472,10168480,10589479,10589875,10578719,10527206,10524328,10526431,10526432,10526433,10526434,10526435,10526436,10526437,10526438,10526439,10526440,10526441,10526443,10526444,10526445,10526446,10526447,10526448,10526450,10526451,10526452,10526453,10526454,10526455,10526456,10526457,10526458,10526459,10526460,10522499,10522500,10423467,10423468,10421590,10421591,10421592,10421593,10420682,10480989,10485990,10485997,10473091,10483151,10481186,10481187,10481188,10477230,10481261,10486275,10483391,10483392,10483393,10483394,10483395,10483396,10483397,10483398,10483399,10483400,10483401,10481419,10481420,10481421,10486541,10481743,10479771,10481803,10479824,10481877,10481879,10477880,10486909,10477909,10476339,10476344,10482606,10482785) 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'