use thiqljmz_banksfinders;
INSERT INTO cardtypes (cardtypecode, cardtypedesc, cardtypeDetails, useascategory)
VALUES
('AIRP', 'Airport Lounge', 0, 0),
('FUEL', 'Fuel Discounts', 0, 0),
('MOVI', 'Movies Discount', 0, 0),
('CASH', 'Easy Cash', 0, 0),
('BALT', '0% Balance Transfer', 0, 0),
('DINE', 'Dining Offers', 0, 0),
('HLTH', 'Health Club Memberships', 0, 0),
('FORE', '0% Foreign Transaction Fee', 0, 0),
('PARK', 'Valet Parking', 0, 0),
('GOLF', 'Golf Benefits', 0, 0),
('CONC', 'Concierge Service', 0, 0),
('TRVL', 'Free Travel Insurance', 0, 0),
('MEET', 'Airport Meet & Greet', 0, 0),
('PICK', 'Airport Pick-Up / Drop', 0, 0),
('ROAD', 'Roadside Assistance', 0, 0),
('FLEX', 'Flexible Payments', 0, 0),
('AMZN', 'Amazon Prime Membership', 0, 0),
('AGOD', 'Agoda Offer', 0, 0),
('AVIS', 'Avis Car Rental', 0, 0),
('ACCI', 'Accident Insurance', 0, 0),
('SALM', 'Salam Points', 0, 0),
('PROT', 'Protection Benefits', 0, 0),
('EMAR', '30% discount on Emaar Attraction', 0, 0),
('TALA', 'Talabat Benefits', 0, 0);




use thiqljmz_banksfinders;
insert into creditcardsfetures(creditcardsfeturesDetails, idcreditcards, creditcardshortfeature)
select distinct cts.cardtypedesc feature,cc.idcreditcards,cts.cardtypedesc Ashortfeature from creditcardstypes ct 
INNER join creditcards cc on cc.idcreditcards=ct.idcreditcards
inner join cardtypes cts on cts.idcardtype=ct.idcardtype
where cts.useascategory =0;



DELETE FROM creditcardsfetures
WHERE idcreditcardsbenefits NOT IN (
  SELECT * FROM (
    SELECT MIN(idcreditcardsbenefits)
    FROM creditcardsfetures
    GROUP BY creditcardsfeturesDetails, idcreditcards, creditcardshortfeature
  ) AS keep_rows
);


DELETE FROM creditcardsfetures
WHERE idcreditcardsbenefits NOT IN (
  SELECT * FROM (
    SELECT MIN(idcreditcardsbenefits)
    FROM creditcardsfetures
    GROUP BY  idcreditcards, creditcardshortfeature
  ) AS keep_rows
);