Sql query error
SQL query SELECT s.* FROM `S_stock_items` s RIGHT JOIN ( SELECT DISTINCT s.prod_code FROM `S_stock_items` s , `S_stock_category_link` l WHERE s.prod_code = l.prod_code AND ( l.categoryID = "1701" ) AND s.suspend_item = 0 AND s.deleted = 0 ORDER BY l.display_order , s.name ) AS subq ON s.prod_code = subq.prod_code
Gave the following error :
Table 'TP_fourleaf.S_stock_items' doesn't exist
File : /var/www/vhosts/www.fourleafclothing.co.uk/httpdocs/sm_red/includes/shop/product_display/functions_product_display.inc.php
Line : 261
File : /var/www/vhosts/www.fourleafclothing.co.uk/httpdocs/traderpro/default_cat_display.htm
Line : 141
File : /var/www/vhosts/www.fourleafclothing.co.uk/httpdocs/traderpro/index.php
Line : 40
