debug magento needed urgently (must work now)

some categories load perfectly fine. Others not. Works after re-index but only for a while and again stops working. Clearing cache returns it to problematic state again. Whoever fixes it must monitor it to make sure it doesn't break again. Error received is: There has been an error processing your request SQLSTATE[42S22]: Column not found: 1054 Unknown column '[login to view URL]' in 'where clause', query was: SELECT FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1 AS `range`, COUNT(*) AS `count` FROM `catalog_product_index_price` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND [login to view URL] IN(2, 4) AND cat_index.category_id = '17' WHERE ([login to view URL] = 1) AND ( e.website_id = '1' ) AND ( e.customer_group_id = 0) AND (e.min_price IS NOT NULL) GROUP BY FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1 ORDER BY FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1 ASC must be able to work and solve this immediately!! Today. Also, must monitor the results