1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and products_description.language_id = '1' and TB.products_status = 1 and (sub' at line 9

select products_description.products_id, products_name,products_description, products_short_description, products_meta_title, products_meta_description, products_meta_keywords, TB.products_id, products_quantity, products_model, group_permission_0, group_permission_1, group_permission_2, group_permission_3, group_permission_4, products_image, products_weight, products_status, product_template, manufacturers_id, NV.blob_content, IM.image_nr, image_name from products_description JOIN products as TB on (TB.products_id = products_description.products_id) JOIN __NavC__blobs as NV on (NV.products_id = products_description.products_id) JOIN products_images as IM on (IM.products_id = products_description.products_id) where TB.products_id = and products_description.language_id = '1' and TB.products_status = 1 and (substr(NV.blob_content,1,2) = 'VE' or substr(NV.blob_content,1,2) = 'PU') and NV.language_id = 1

[XT SQL Error]