$query="
SELECT product_thumb_image
FROM jos_vm_product
WHERE product_id IN(

SELECT product_id
FROM jos_vm_product_category_xref
WHERE category_id = $id

)";