Les cartes promo
select * from k_card C left outer join k_type T on T.type_id = C.card_type_id left outer join k_user U on U.user_id = C.card_user_id left outer join k_abonnements A on BINARY A.abonnement_id = BINARY U.user_abonnement where card_status = "" and card_multidiffusion = ?
Toutes les cartes de CHOLET PROMO