Table 'devvipiriscom._product_filters_products_1' doesn't exist (1146)
SELECT MIN(IF(shared_prices.product_id IS NOT NULL, shared_prices.price, vi_product_prices.price)) as min, MAX(IF(shared_prices.product_id IS NOT NULL, shared_prices.price, vi_product_prices.price)) as max FROM vi_product_prices LEFT JOIN vi_products as products ON products.product_id = vi_product_prices.product_id LEFT JOIN vi_product_prices as prices_2 ON vi_product_prices.product_id = prices_2.product_id AND vi_product_prices.price > prices_2.price AND prices_2.lower_limit = 1 AND prices_2.usergroup_id IN (0, 0, 1) LEFT JOIN vi_ult_product_prices AS shared_prices ON shared_prices.product_id = products.product_id AND shared_prices.lower_limit = 1 AND shared_prices.usergroup_id IN (0, 0, 1) AND shared_prices.company_id = 1 INNER JOIN _product_filters_products_1 ON products.product_id = _product_filters_products_1.product_id WHERE products.status IN ('A') AND vi_product_prices.lower_limit = 1 AND vi_product_prices.usergroup_id IN (0, 0, 1) AND prices_2.price IS NULL
app/Tygh/Database/Connection.php, line: 1713
| File: | app/Tygh/Database/Connection.php |
| Line: | 1490 |
| Function: | throwError |
| File: | app/Tygh/Database/Connection.php |
| Line: | 700 |
| Function: | execQuery |
| File: | app/Tygh/Database/Connection.php |
| Line: | 333 |
| Function: | query |
| File: | app/functions/fn.database.php |
| Line: | 35 |
| Function: | getArray |
| File: | app/controllers/common/debugger.php |
| Line: | 60 |
| Function: | db_get_array |
| File: | app/functions/fn.control.php |
| Line: | 729 |
| Function: | include |
| File: | app/functions/fn.control.php |
| Line: | 460 |
| Function: | fn_run_controller |
| File: | index.php |
| Line: | 19 |
| Function: | fn_dispatch |