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(4970724,4970759,8569558,7065968,7066245,7066246,8067922,8067923,8067924,8067925,10939419,7064547,7064548,10944446,11048421,11048434,10623060,10618178,10618179,10618180,10618181,10618300,10618301,10618304,10623491,10623492,10623505,10623605,10623606,10619177,10616970,10616971,10616972,10621987,10616996,10616997,10616998,10617000,10617002,10617005,10617006,10617008,10617016,10617031,10617033,10617044,10617048,10617049,10617050,10617054,10617055,10617056,10617068,10617071,10617072,10617079,10617080,10617081,10617082,10617083,10617084,10617085,10617086,10617087,10617088,10617089,10617090,10617091,10617092,10617093,10617094,10617095,10617096,10617097,10617098,10617108,10617114,10617123,10617124,10617134,10617135,10617136,10617137,10617145,10617146,10617148,10617149,10617151,10617154,10617155,10617156,10617157,10617158,10617159,10617164,10617165,10617166,10617231,10617232,10617233,10617236,10617238,10617240,10617242,10617243,10617246,10617247,10617248,10617250,10617251,10617255,10617261,10617311,10617312,10617314,10617316,10617317,10617318,10622429,10615024,10615077,10615079,10615091,10615092,10615161,10615162,10615163,10615202,10615232,10615246,10615267,10615312,10615315,10615334,10615335,10615363,10615398,10615439,10615483,10615536,10615540,10615548,10615555,10615556,10615568,10615569,10615570,10615571,10615583,10615604,10615615,10615654,10615685,10615718,10615818,10615820,10615821,10615822,10615823,10615826,10615870,10615923,10615925,10615926,10615927,10615931,10615941,10615943,10615944,10615945,10615950,10615952,10615953,10615954,10615955,10615956,10615957,10615967,10615971,10615972,10615979,10615980,10615981,10615983,10615984,10615985,10615987,10615989,10615990,10616018,10616044,10616045,10616046,10616058,10616062,10616089,10616092,10616193,10616301,10616462,10616464,10616465,10616466,10616467,10616468,10616469,10616471,10616472,10616473,10616474,10616476,10616477,10616479,10616485,10616490,10616491,10616492,10616493,10616494,10616495,10616497,10616498,10616499,10616500,10616501,10616502,10616503,10616505,10616506,10616507,10616508,10616509,10616510,10616511,10616512,10616513,10616517,10616518,10616519,10616520,10616522,10616525,10616526,10616527,10616528,10616529,10616530,10616533,10616534,10616546,10616547,10616548,10616576,10616577,10616641,10616642,10616643,10616644,10616645,10616684,10616689,10616690,10616691,10616692,10616695,10616697,10616698,10616699,10616700,10616701,10616704,10616714,10616730,10616733,10616734,10616735,10616739,10616745,10616746,10616747,10616748,10616749,10616750,10616751,10616752,10616753,10616754,10616755,10616756,10616757,10616758,10616759,10616760,10616761,10616762,10616763,10616764,10616765,10616766,10616767,10616768,10616769,10616770,10616771,10616772,10616773,10616774,10616775,10616783,10616790,10616791,10616804,10616866,10616888,10616889,10616890,10616891,10616901,10616911,10616913,10616932,10616940,10616941,10616943,10610984,10610985,10611012,10614024,10611048,10614048,10614050,10611053,10611054,10614078,10614079,10614085,10614086,10614089,10611123,10611126,10611146,10611147,10611148,10611149,10611150,10611176,10611179,10614207,10614208,10611232,10614274,10614282,10611293,10614314,10614316,10611334,10611336,10611338,10611339,10611367,10611368,10611369,10611370,10614376,10614411,10614463,10614464,10614475,10614476,10614485,10614486,10614488,10614489,10614492,10614501,10614537,10559710,10614566,10614567,10614568,10614572,10614592,10559766,10614626,10614627,10614629,10614632,10614639,10614663,10614755,10611764,10611774,10611788,10611801,10611802,10611812,10614819,10611819,10611830,10611831,10611832,10611833,10611834,10611835,10611854,10614857,10614858,10614859,10614862,10611864,10611878,10611879,10611965,10611966,10612035,10612036,10612051,10612069,10612108,10612159,10609165,10609169,10612189,10609239,10609261,10612267,10612273,10612284,10609285,10612285,10612286,10612294,10612328,10612342,10612344,10612346,10609350,10609352,10609357,10609359,10609367,10612381,10612407,10612408,10612409,10612410,10612411,10612412,10612414,10612417,10612424,10612426,10612427,10612428,10612429,10612430,10609443,10609444,10612483,10612484,10612485,10612486,10612487,10612488,10612489,10612490,10612491,10612492,10612493,10612496,10612497,10612498,10612499,10612500,10612501,10612502,10612503,10612505,10612506,10612507,10612508,10612509,10612510,10612513,10612516,10612517,10612518,10612519,10612520,10612521,10612522,10612523,10612524,10612525,10612526,10612527,10612528,10612529,10612530,10612531,10612532,10612534,10612535,10612536,10612538,10612539,10612542,10612543,10612546,10612547,10612551,10612552,10612553,10612554,10612555,10612556,10612557,10612558,10612559,10612562,10612563,10609565,10612565,10612566,10612567,10612568,10612570,10612571,10612573,10612575,10612577,10612578,10612579,10612580,10612583,10612584,10612585,10612586,10612587,10612588,10612589,10612592,10612594,10612596,10612597,10612599,10612601,10612604,10612608,10612609,10612611,10612618,10612619,10612620,10612622,10612623,10612624,10612625,10612626,10612633,10612635,10612637,10612638,10612639,10612641,10612642,10612643,10612644,10612645,10612646,10612647,10612648,10612650,10612651,10612652,10612653,10612655,10612657,10612658,10612659,10612660,10612661,10612663,10612664,10612666,10612667,10612668,10612673,10612675,10612677,10612678,10612679,10612680,10612681,10612682,10612683,10612684,10612685,10612687,10612688,10612689,10612690,10612697,10612698,10612699,10612700,10612701,10612702,10612703,10612704,10612705,10612706,10612707,10612711,10612713,10612714,10612715,10612716,10612717,10612718,10609719,10612720,10612721,10612722,10612723,10609723,10612733,10612735,10612757,10612758,10612763,10609764,10609765,10612765,10612766,10612769,10609770,10612782,10612803,10612804,10612805,10612809,10609818,10609819,10612824,10609824,10609826,10609828,10612833,10612834,10612836,10612837,10612838,10609838,10612839,10612840,10612841,10612842,10612843,10612844,10612845,10612846,10612847,10612848,10612850,10612852,10612853,10612856,10612860,10612862,10612863,10612864,10612865,10612866,10612867,10612868,10612869,10612870,10612871,10612872,10612873,10612874,10612875,10612876,10612877,10612878,10612879,10612880,10612881,10612882,10612883,10612884,10609905,10612907,10612910,10612911,10612912,10612913,10612914,10612936,10612937,10612938,10612939,10612941,10612942,10612943,10612945,10609946,10609975,10609976,10609978,10609979,10609981,10609983,10609990,10609998,10610006,10613019,10610025,10610035,10610037,10610039,10610041,10610042,10610044,10610046,10610048,10610053,10610054,10610098,10610108,10610233,10610259,10610268,10610270,10610271,10610274,10610289,10613293,10613294,10613295,10613296,10613297,10610298,10613298,10613299,10613300,10613301,10613302,10613303,10613304,10613305,10610310,10610311,10610318,10610319,10613322,10613342,10613349,10613350,10613356,10613357,10610359,10613359,10610362,10610364,10613365,10613366,10613367,10613368,10610371,10610372,10610373,10610396,10613440,10613442,10613453,10610466,10610468,10610476,10610480,10610481,10610486,10610492,10610493,10613504,10613513,10613514,10613522,10613527,10613528,10613530,10613531,10613547,10613562,10613646,10613653,10610671,10610674,10610675,10610676,10613744,10610773,10610789,10610790,10610793,10610794,10610836,10613844,10610862,10610901,10610908,10610937,10610939,10610940,10610941,10610942,10610958,10515335,10517791,10517792,10517793,10416223,10419253,10419255,10419256,10419257,10419258,10419259,10419260,10419261,10419262,10416281,10417284,10419297,10419298,10418316,10418317,10418318,10418319,10418320,10418321,10415321,10418322,10418323,10415323,10418324,10418325,10418326,10418327,10418328,10418329,10418330,10418331,10418341,10415342,10415343,10415344,10419407,10419408,10416446,10416458,10416459,10416460,10416461,10416462,10416463,10416464,10419470,10419493,10419494,10415495,10416495,10418498,10418499,10415507,10417531,10417532,10417533,10417534,10417535,10418552,10418553,10418555,10418556,10418557,10418569,10418570,10418571,10418573,10418574,10418575,10418576,10418577,10418578,10418579,10415616,10416631,10416633,10415634,10416635,10419651,10419652,10419655,10419656,10419657,10419658,10419659,10419660,10419665,10415688,10415689,10418734,10417743,10418806,10418807,10418808,10418809,10418810,10418811,10418812,10418813,10418814,10418815,10418816,10418817,10418818,10418819,10418820,10418821,10418822,10418823,10418824,10418825,10418826,10418827,10418828,10418829,10418830,10418831,10418832,10418833,10418834,10418835,10418836,10418837,10418838,10418839,10418840,10418841,10418842,10418843,10418844,10418845,10418846,10418847,10418848,10418849,10418850,10418851,10418852,10418853,10418854,10418855,10418856,10418857,10418858,10418859,10418860,10418861,10418862,10418863,10418881,10418933,10416955,10416956,10416957,10417036,10417037,10417038,10419160,10419161,10419162,10416195,10471087,10471088,10471089,10471090,10471091,10471092,10471093,10471094,10471095,10467104,10467409,10463432,10465712,10464285,10462516,10462729) 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'