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(7076128,4970748,4970749,4970750,4970751,4970752,4970753,4970754,4970755,4970756,7065863,7065937,8583434,7066017,8583536,10950756,7066163,10437196,10437197,10437198,10437199,10990368,8617990,8065832,8860356,8860357,8860358,8860359,8860406,8860407,8860408,8860409,10837850,10837851,10837852,10837853,10837854,10837855,10837856,10837857,10837858,10837859,10837860,10837861,10837862,10837863,10837864,10837865,10837866,10837867,10837868,10837869,10837870,10837871,10837872,10837873,10837874,10837875,10837876,10837877,10837878,10837879,10837880,10837881,10837882,10837883,10837884,10837885,10837886,10837887,10837888,10837889,10837890,10837891,10837892,10837893,10837894,10837895,10837896,10837897,10837898,10837899,10837900,10837901,10837902,10837903,10837904,10837905,10837906,10837907,10837908,10837909,10837910,10837911,10837912,10837913,10837914,10837915,10837916,10837917,10837918,10837919,10837920,10837921,10837922,10837923,10837924,10837925,10837926,10837927,10837928,10837929,10837930,10837931,10837932,10837933,10837934,10837935,10837936,10837937,10837938,10837939,10837940,10837941,10837942,10837943,10837944,10837945,10837946,10837947,10837948,10837949,10837950,10837951,10837952,10837953,10837954,10837955,10837956,10837957,10837958,10837959,10837960,10837961,10837962,10837963,10837964,10837965,10837966,10837967,10837968,10837969,10837970,10837971,10837972,10837973,10837974,10837975,10837976,10837977,10837978,10837979,10837980,10837981,10837982,10837983,10837984,10837985,10837986,10837987,10837988,10837989,10837990,10837991,10837992,10837993,10837994,10837995,10837996,10837997,10837998,10837999,10838000,10838001,10838002,10838003,10838004,10838005,10838006,10838007,10838008,10838009,10838010,10838011,10838012,10838013,10838014,10838015,10838016,10838017,10838018,10838019,10838020,10838021,10838022,10838023,10838024,10838025,10838026,10838027,10838028,10838644,10617023,10617074,10617075,10617076,10617332,10622413,10622415,10617445,10622450,10622451,10622452,8905378,10622537,10622538,10615178,10615179,10615180,10615181,10615395,10615396,10615825,10615826,10615827,10615828,10615829,10615830,10615831,10615832,10615833,10615834,10615835,10615836,10615837,10615838,10615839,10615840,10615841,10615842,10615843,10615844,10615845,10615846,10615847,10615848,10615849,10615850,10615851,10615852,10615853,10615854,10615855,10615856,10615857,10615858,10615859,10615860,8611398,8611432,8611433,8611434,8611435,8611436,10616839,10616840,10616841,10616842,10616843,10616859,10616860,10616955,7059524,10714176,10714183,10614502,10614635,10614636,10614752,10611758,10611878,10611879,10612177,10612237,8862578,8862579,10609832,10609833,10609849,10612946,10612947,10612948,10613574,10613575,10613576,10613577,10613578,10613579,10613580,10613581,10613582,10613583,10613584,10613585,10613586,10613587,10613588,10613589,10613590,10613591,10613592,10613593,10613594,10613595,10613596,10613597,10613598,10613599,10613600,10613601,10613602,10613603,10613604,10613605,10613606,10613607,10613608,10613609,10613610,10613611,10613612,10613613,10613614,10613615,10613616,10613617,10613618,10613619,10613620,10613621,10613622,10613623,10613624,10613625,10613626,10613627,10613628,10613629,10613630,10613631,10613632,10613633,10613675,10613676,10613677,10610911,10610912,10610913,10610914,9169428,9169429,9169430,9169431,9169432,9169433,9169434,9169641,9169642,9169643,9169644,9169645,9169646,9169647,9169648,9169906,9169909,9169910,9169911,9169912,9169982,10416336,10416337,10416338,10416339,10416340,10416341,10416342,10416343,10416344,10416345,10416346,10416347,10416348,10416349,10416350,10416351,10416352,10416353,10416354,10416355,10416356,10416357,10416358,10416359,10416360,10416361,10416362,10416363,10415395,10415396,10415397,10415398,10415399,10415400,10415401,9168669,10419596,10419597,10419598,10419599,10419600,10419601,10416799,10416800,10416801,10416802,10416803,10416804,10416805,10416806,10416807,10416808,10416809,10416810,10416811,10416812,10416813,10416814,10416815,10416816,10416817,10416818,10416819,10416820,10416821,10416822,10416823,10416824,10416825,10416826,10416827,10416828,10416829,10416830,10416831,10416832,10416833,10416834,10416835,10416836,10416837,10416838,10416839,10416840,10416841,10416842,10416843,10416844,10416845,10416846,10416847,10416848,10416849,10416850,10416851,10416852,10416853,10416854,10416855,10416856,10416857,10416858,10416859,10416860,10416861,10416862,10416863,9168942,10416864,9168943,10416865,9168944,10416866,9168945,10416867,9168946,10416868,9168947,10416869,9168948,10416870,10416871,10416872,10416873,10416874,10416875,10416876,10416877,10416878,10416879,10416880,10416881,10416882,10416883,10416884,10416885,10416886,10416887,10416888,10416889,10416890,10416891,10416892,10416893,10416894,10416895,10416896,10416897,10416898,10416899,10416900,10418962,10419108,10419109,10419110,10419111,10419112,10419113,10418147,10418148,10418149,10418150,9169248,7055441,10470217,10470218,10470219,10470220,10470221,10470222,10470223,10470224,10470225,10470226,10470227,10470228,10470229,10470230,10470231,10470232,10468233,10470233,10470234,10470235,10470236,10470237,10470238,10470239,10470240,10470241,10464241,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,10468375,10470376,10470377,10470378,10470379,10470380,10470381,10470382,10470383,10470384,10470385,10470386,10470387,10470388,10470389,10470390,10470391,10470392,9167815,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,9168089,10468818,10468819,10162178,10162179,10162180,10162181,10162182,10162183,10162184,10162185,10162186,10162187,10162188,10162189,10162190,10162191,10162192,10162193,10162194,10162195,10162196,10167970,10568936,10568937,10525330,10521644,10527004,10527005,10527007,10527008,10486319,10486320,10486321,10486322) 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'