SELECT link_url, product_title, product_image, inventory_currency, inventory_price, inventory_mrp FROM isw_tag INNER JOIN isw_link ON link_relation_id=tag_relation_id INNER JOIN isw_product ON product_id=link_relation_id INNER JOIN isw_inventory ON inventory_relation_id=product_id WHERE tag_title LIKE '%subscription%' AND link_status=200 AND link_type='product' AND link_site_id='17' AND inventory_in_stock=1 AND product_id!=4007 GROUP BY tag_relation_id ORDER BY RAND() LIMIT 0, 10