SELECT M.pid as id, M.pid, M.title as name, M.tinyurl, M.vat, M.active, M.ptype, M.fitimgtoframe, tags,categz, (SELECT CONCAT(price,'#',saleprice,'#',onsale) FROM sc_ws_products_price WHERE product_id=M.id AND currency_id=:valutaid2 AND usergroup_id=:usergroup2 ORDER BY price LIMIT 1) as prices FROM sc_ws_products M INNER JOIN sc_ws_products_variant V ON V.product_id=M.pid AND M.lang=:lang2 WHERE M.lang=:lang AND M.active=:active AND V.active=:active2 AND (V.quantity>:quantity OR V.unlimited=:unlimited) GROUP BY M.pid HAVING prices!='' ORDER BY M.ordering
Error!: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'finommechanika_db.sc_ws_products_price' doesn't exist