SELECT site_products.*, site_mkt_products.short_url FROM site_products INNER JOIN site_mkt_products ON site_products.catalog_number = CONCAT('MKT_SKU_', site_mkt_products.id) WHERE site_products.is_active = 1 AND site_products.product_type = 'market_products' AND FIND_IN_SET('blog', tags) ORDER BY date_published desc |Column 'tags' in where clause is ambiguous