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(8630632,8630643,8630681,8630754,8630757,8630767,8630768,8630769,8630770,8630771,8630772,8630773,8630774,8630775,8630776,8630792,10861442,10861443,8630874,8630881,8630884,8630907,8630987,8630988,8631002,8631007,8631041,8631043,8631061,8631066,8631196,8631205,8631206,8631207,8631208,8631209,8631210,8631211,8631212,8631213,8631214,8631215,8631216,8631217,8631218,8631219,8631384,8631385,8631386,8631387,8631388,8631389,8631390,8631391,8631392,8631393,8631394,8631395,8631396,8631397,8631398,8631399,8631401,8631402,8631403,8631404,8631413,8631414,8631415,8631416,8631417,8631418,8631419,8631422,8631423,8631424,8631425,8631428,8631429,8631430,8631431,8631432,8631433,8631434,8631435,8631437,8631438,8631439,8631440,8631441,8631442,8631443,8631450,8631451,8631458,8631459,8631460,8631461,8631466,8631467,8631468,8631469,8631474,8631508,8631533,8631534,8631566,8631601,8631602,8631605,8631634,8631644,8631645,8631647,8631649,8631650,8583517,8631775,8631799,8631806,8632191,8632343,8632449,8632450,8632451,8632458,8632459,8632460,8632497,8632500,8632502,8632554,8632558,8632575,8629654,10860312,10860313,8629705,8629707,8629709,8629714,8629718,8629759,8629780,8629781,8629892,8629894,8629896,8629961,8629964,8629986,8630031,8630032,8630033,8630034,8630035,8630036,8630037,8630038,8630039,8630040,8630041,8630042,8630043,8630044,8630045,8630046,8630047,8630048,8630049,8630050,8630051,8630052,8630053,8630054,8630055,8630056,8630057,8630058,8630059,8630060,8630061,8630062,8630063,8630064,8630065,8630066,8630067,8630068,8630069,8630070,8630071,8630074,8630075,8630076,8630077,8630099,8630100,8630114,8630115,8630116,8630119,8630120,8630128,8630131,8630132,8630173,8630177,8630223,8630254,8630259,8630260,8630261,8630262,8630264,8630265,8630280,8630282,8630283,8630425,8630426,8630427,8630443,8630449,8630452,8630496,8630504,8630506,10861150,8630534,7201220,7201221,8627659,8627660,8627661,8627662,8627664,8627665,8627666,8627667,8627669,8627670,8627671,8627672,8627674,8627675,8627676,8627677,8627679,8627728,8627774,8627840,8627845,8627851,8627856,8627861,8627886,8627887,8627888,8627904,8627905,8627906,8627918,8627919,8627920,8627921,8627922,10866572,8627931,8627932,8627933,8628046,8628051,8628057,8628074,8628079,8628086,8628088,8628092,8628096,8628170,8628356,8628395,8628396,8628422,8628515,8628516,8628525,8628656,8628690,8628704,8628705,8628706,8628707,8628708,8628709,8628710,8628725,8628727,8628740,8628773,8628795,8628833,8628834,8628835,8628873,8628886,8628887,8628888,8628908,8628909,8628910,8628911,8628912,8628913,7202518,8628920,8628921,8628922,8628923,8628924,8628925,8628938,8628939,8628940,8628941,8628942,8628949,8628950,8628951,8628952,8628953,8628954,8628968,8628969,8628970,8628971,8628972,8628973,8628974,8628975,8628976,8628977,8628978,8628979,10859623,8629003,8629012,8629013,8629016,8629017,8629018,8629019,8629020,8629021,8629022,8629023,8629024,8629035,8629036,8629037,8629038,8629044,8629045,8629046,8629047,8629048,8629049,8629050,8629051,8629095,8629096,8629097,8629098,8629099,8629100,8629165,8629166,8629188,8629192,8629226,8629251,8629254,8629255,8629256,8629258,8629259,8629260,8629265,8629369,8629463,8629486,8629521,8629560,8626627,8626671,8626672,8626673,8626694,8626697,8626698,8626733,8626740,8626749,8626750,8626751,8626752,8626753,8626931,8626941,8627254,8627325,8627326,8627388,8627468,8627469,8627471,8627472,8627478,8627479,8627480,8627487,8627488,8627489,8627490,8627492,8627493,8627494,8627495,8627496,8627497,8627498,8627499,8627502,8627510,10858155,10858156,8627515,8627516,8627517,10858159,8627519,10858161,8627520,10858162,10858163,8627521,8627522,8627523,8627524,8627525,10858168,8627526,8627527,10858172,10858173,10858175,10858177,8624584,8624655,8624690,8624925,10855620,10855621,7198760,8625176,7198781,7198782,8625209,8625222,8625231,8625235,8625236,8625277,8625278,8625279,8625280,8625291,8625292,8625293,8625294,8625295,8625296,8625297,8625298,8625299,8625300,8625301,8625303,8625304,8625305,8625306,8625497,8625498,10856187,10856188,8625631,8625632,8625633,8625755,8625757,8625758,8625759,8625763,8625764,8625765,8625766,8625767,8625768,8625769,8626052,8626057,8626064,8626065,8626068,8626181,8626260,7200111,10853300,10853301,3923523,10623494,7196951,7196952,7196953,7196954,7196955,7196956,7196957,7196959,7196960,7196962,7196965,7196967,7196970,7196971,7196972,7196973,7196974,7196975,7196976,7196977,7196978,7196979,7196980,7196982,7196984,7196985,7197674,8624338,8624416,8624417,8624418,8624426,8624427,8624434,8624446,8624462,8624463,8624475,8624476,8624514,8624546,8624557,8624558,8624559,8624560,8624561,8624562,8624564,8624565,8624566,8624567,8624568,8624569,8634632,8634641,8634648,8634651,8634673,8634674,8634675,8634676,8634677,8634678,8634679,8634680,8634681,8634682,8634683,8634684,8634685,8634686,8634711,8634725,8634736,8634737,8634752,8634773,8634809,8634819,8634835,10852579,10852580,10852581,10852582,10852588,10852589,10852590,8634959,8634996,8634997,8634998,8634999,8635000,8635001,8635002,8635003,8635004,8635005,8635006,8635010,8635011,8635012,8635013,10617510,10425386,8632742,10425484,10425576,8632890,8632905,8633019,8633020,8633102,8633117,8633179,10425911,8633192,8633194,8633200,8633201,8633202,8633214,8633216,8633228,8633232,10426012,10426014,8633323,8633544,8633561,8633574,8633611,8633624,10426402,8633920,8633921,8633922,8633923,8633924,8633925,8633926,8633954,8633956,8633958,8633965,8634004,8634121,8634368,8634369,8634370,8634472,8634473,8634525,8634526,8634527,8634528,8634533,8634534,8634535,8634536,10609036,10609100,8566660,10610233,10610729,10610730,10610739,10610954,6673529,6673530,6673538,6673540,6673542,6673543,9169428,10427683,8848193,8848909,8848911,9167398,9168121,10888487,10884075,10884420,10884799,10884800,10885166,10890246,10905548,10161842,10886818,10882134,10882150,10882154,10626724,10626725,10608029,10608607,10608610,10607651,10498367,10414056,10414649,10412725,10412726,10412728,10412729,10412731,10412732,10412733,10412734,10412736,10412738,10412740,10412741,10412742,10412744,10412745,10412746,10410783,10410784,10410793,10409027,10409030,10409032,10409034,10409037,10409039,10409041) 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'