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('calendar script', tags)
				ORDER BY date_published desc
				|Column 'tags' in where clause is ambiguous