SQLSTATE[42S02]: Base table or view not found: 1146 Table 'admin_assite.shop_products' doesn't exist
SELECT
shop_products.id AS `id`,
shop_products.category_id AS `category_id`,
shop_products.active AS `active`,
shop_products.synchronized AS `synchronized`,
shop_products.tecdoc_export AS `tecdoc_export`,
shop_products.tecdoc_export_desc_id AS `tecdoc_export_desc_id`,
shop_products.in_promotion AS `in_promotion`,
shop_products.sort AS `sort`,
shop_products.name AS `name`,
shop_products.name_long AS `name_long`,
shop_products.ean AS `ean`,
shop_products.oem AS `oem`,
shop_products.product_code AS `product_code`,
shop_products.product_code_copy AS `product_code_copy`,
shop_products.product_code_clean AS `product_code_clean`,
shop_products.size AS `size`,
shop_products.external_id AS `external_id`,
shop_products.magfakt_id AS `magfakt_id`,
shop_products.magfakt_code AS `magfakt_code`,
shop_products.magfakt_group_id AS `magfakt_group_id`,
shop_products.expected_delivery_date AS `expected_delivery_date`,
shop_products.product_line AS `product_line`,
shop_products.helper_as_product AS `helper_as_product`,
shop_products.regenerated AS `regenerated`,
shop_products.part_similar_id AS `part_similar_id`,
shop_products.part_similar_application_id AS `part_similar_application_id`,
shop_products.g_zamiennik AS `g_zamiennik`,
shop_products.on_depot AS `on_depot`,
shop_products.news_sort AS `news_sort`,
shop_products.price AS `price`,
shop_products.producer_id AS `producer_id`,
shop_products.supplier_id AS `supplier_id`,
shop_products.warranty AS `warranty`,
shop_products.top AS `top`,
shop_products.products_in_package AS `products_in_package`,
shop_products.max_order_count AS `max_order_count`,
shop_products.min_order_count AS `min_order_count`,
shop_products.show_in_catalogue AS `show_in_catalogue`,
shop_products.weight AS `weight`,
shop_products.cache AS `cache`,
shop_products.description_short AS `description_short`,
shop_products.description_long AS `description_long`,
shop_products.description_news AS `description_news`
FROM
shop_products WHERE shop_products.`in_promotion` = '1'