1054. Query Error 1054: Unknown column 'count_null' in 'order clause' Query: SELECT p.id,p.name,p.url,p.category_id,(p.count > 0 || p.count IS NULL) AS in_stock FROM shop_product p JOIN shop_category_products cp1 ON cp1.product_id = p.id JOIN shop_search_index si ON p.id = si.product_id WHERE p.status = 1 AND cp1.category_id IN (540) AND (si.word_id IN (1606,84041,116132,139719,139715,31411,9747,56597,56601,2596,234160,56585,56618,297347,56608,53574,69448,56592,74357,128969,56586,35936,135689,56587,12835,87398,128088,118650,56605,24622,56609,56610,56599,56588,165964,56589,38248,140865,2581,99726,56590,39061,71000,24620,24621,56611,19271,56847,9376,273707,15063,15064,3380,56607,56600,10528,404846,392136,392139,10945,115481,340780,4646,340782,228697,41374,41226,139909,272824,58874,147408,147405,396257,142312,85777,215597,139718,31414,9751,56640,56645,2601,234162,56626,56658,297349,56650,53577,69451,56638,74361,128971,56628,35942,135691,56629,272052,12863,87403,128091,118653,56647,24633,56652,56654,56642,56631,165967,56633,38253,140868,2587,99727,56635,39063,71005,394065,231764,24629,24631,56655,19274,56849,9382,273709,15086,15088,3383,56648,56644,10531,107765,107764,107767,107768,10950,115484,340786,4651,340787,190571,228699,123073,123329,41228,41229,139911,272825,147407,58876,142314,142315,23222,177458,68889,23224,35984,85778,85779,9907,285238)) GROUP BY p.id ORDER BY in_stock DESC,count_null DESC, p.count DESC, p.id

Запрашиваемый ресурс недоступен.

Cайт был реконструирован и ссылки на товары поменялись, попробуйте воспользоваться поиском.