Fatal error: Uncaught Exception: Error: Table 'd122688sd514513.oc_product' doesn't exist<br />Error No: 1146<br />
SELECT
p.product_id,
p.manufacturer_id,
pd.name,
IF( p.smp_url_category_id IS NULL OR (
SELECT
c2s.category_id
FROM
oc_category AS c
INNER JOIN
oc_category_to_store c2s
ON
c.category_id = c2s.category_id AND c2s.store_id = 0
WHERE
c.status = '1' AND c.category_id = p.smp_url_category_id
LIMIT
1
) IS NULL, (
SELECT
pc.category_id
FROM
oc_product_to_category pc
INNER JOIN
oc_category AS c
ON
c.category_id = pc.category_id AND c.status = '1'
INNER JOIN
oc_category_to_store c2s
ON
c2s.category_id = pc.category_id AND c2s.store_id = 0
WHERE
pc.product_id = p.product_id
ORDER BY
pc.category_id DESC
LIMIT
1
), p.smp_url_category_id ) AS category_id
FROM
oc_product p
LEFT JOIN
oc_product_description pd
ON
in /data02/virt122299/domeenid/www.avamarket.ee/htdocs/system/library/db/mysqli.php on line 48