Did not go as expected, I can see the TABLE_PRODUCTS_XSELL1 in PhpmyAdmin, but it still throws this error:
Originally Posted by gilby
Do you have any other suggestions i should try?
1146 Table 'lemycouk_zc1.TABLE_PRODUCTS_XSELL1' doesn't exist
[select distinct p.products_id, p.products_image, pd.products_name from TABLE_PRODUCTS_XSELL1 xp, zen_products p, zen_products_description pd where xp.products_id = '42' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by xp.sort_order asc limit 6]
Thanks for taking the time.