DELETE FROM fos_user_user_group WHERE `user_id` in (16 , 100 , 129 , 134 , 164 , 174 );
DELETE FROM contact WHERE `user_id` in (16 , 100 , 129 , 134 , 164 , 174 );

DELETE FROM potager_signale WHERE `user_id` in (16 , 100 , 129 , 134 , 164 , 174 );
DELETE FROM stat WHERE `user_id` in (16 , 100 , 129 , 134 , 164 , 174 );
DELETE FROM favoris WHERE `user_id` in (16 , 100 , 129 , 134 , 164 , 174 );
DELETE FROM liste_favoris WHERE `user_id` in (16 , 100 , 129 , 134 , 164 , 174 );
DELETE FROM abonnement WHERE `potager_id` in (select id FROM potager WHERE `user_id` in (16 , 100 , 129 , 134 , 164 , 174 ));
DELETE FROM statistique_vue_potager WHERE `stats_id` in (select id FROM potager WHERE `user_id` in (16 , 100 , 129 , 134 , 164 , 174 ));
DELETE FROM favoris WHERE `potager_id` in (select id FROM potager WHERE `user_id` in (16 , 100 , 129 , 134 , 164 , 174 ));
DELETE FROM potager WHERE `user_id` in (16 , 100 , 129 , 134 , 164 , 174 );

DELETE FROM r_d_v WHERE `user_id` in (16 , 100 , 129 , 134 , 164 , 174 );
DELETE FROM smslogs WHERE `user_id` in (16 , 100 , 129 , 134 , 164 , 174 );
DELETE FROM message WHERE `thread_id` in (select id FROM thread WHERE `user_id` in (16 , 100 , 129 , 134 , 164 , 174 ));
DELETE FROM thread WHERE `user_id` in (16 , 100 , 129 , 134 , 164 , 174 );
DELETE FROM commande_details WHERE `commande_id` in (select id FROM commande WHERE `user_id` in (16 , 100 , 129 , 134 , 164 , 174 ));
DELETE FROM cart WHERE `commande_id` in (select id FROM commande WHERE `user_id` in (16 , 100 , 129 , 134 , 164 , 174 ));
DELETE FROM commande WHERE `user_id` in (16 , 100 , 129 , 134 , 164 , 174 );

DELETE FROM fos_user_user WHERE `id` in (16 , 100 , 129 , 134 , 164 , 174 );




-- ---------------------------------------------------------
-- supprimer le compte dev.khadija.potager@gmail.com -------
-- ---------------------------------------------------------


DELETE FROM fos_user_user_group WHERE `user_id` in (124);
DELETE FROM contact WHERE `user_id` in (124);

DELETE FROM potager_signale WHERE `user_id` in (124);
DELETE FROM stat WHERE `user_id` in (124);
DELETE FROM favoris WHERE `user_id` in (124);
DELETE FROM liste_favoris WHERE `user_id` in (124);
DELETE FROM abonnement WHERE `potager_id` in (select id FROM potager WHERE `user_id` in (124));
DELETE FROM statistique_vue_potager WHERE `stats_id` in (select id FROM potager WHERE `user_id` in (124));
DELETE FROM favoris WHERE `potager_id` in (select id FROM potager WHERE `user_id` in (124));
DELETE FROM potager WHERE `user_id` in (124);

DELETE FROM r_d_v WHERE `user_id` in (124);
DELETE FROM smslogs WHERE `user_id` in (124);
DELETE FROM message WHERE `thread_id` in (select id FROM thread WHERE `user_id` in (124));
DELETE FROM thread WHERE `user_id` in (124);
DELETE FROM commande_details WHERE `commande_id` in (select id FROM commande WHERE `user_id` in (124));
DELETE FROM cart WHERE `commande_id` in (select id FROM commande WHERE `user_id` in (124));
DELETE FROM commande WHERE `user_id` in (124);

DELETE FROM fos_user_user WHERE `id` in (124);