divnejfilter.sql

SELECT * 
FROM e21 
INNER JOIN (
	SELECT GROUP_CONCAT(discount_amount) AS discount_amount, 
		GROUP_CONCAT(discount_type) AS discount_type, 
		discount_business_id, 
		discount_subcategory_id, 
		discount_evidence_number 
	FROM e21sle GROUP BY discount_business_id
) MAXD ON (business_id=MAXD.discount_business_id)
WHERE ((discount_type LIKE '%VIP%' OR discount_type LIKE '%STD%') AND business_eshop<>1 AND business_region_id='C10' AND business_category_id='A' AND business_subcategory_id='0555' AND business_region_id LIKE 'C%')