Description de l'annonce
Bonjour j'habite au Bourget devant la gare rer . À 15min de châtelet.
#Chambre en colocation
Voir les annonces autour de moi Géolocaliser
Poster une annonce
Bonjour j'habite au Bourget devant la gare rer . À 15min de châtelet.
#Chambre en colocation
Louer une chambre entre particuliers ou proposer une chambre en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom, filtre_villes, dpt_url FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci
SHOW TABLES LIKE 'pays'
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom FROM wish w LEFT JOIN util_info ui ON w.util_id=ui.util_id WHERE wish_id='641755'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='chambre-en-colocation' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='505'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'chambre-en-colocation' LIMIT 1
SELECT c.cate_id, c.cate_title, cate_title_aff, cate_title_slug, c.fami_id, f.fami_title, f.fami_url FROM category c, family f WHERE c.fami_id=f.fami_id AND c.fami_id='5' AND c.cate_id='193'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('93' USING utf8mb4) COLLATE utf8mb4_general_ci
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='541121' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 541121
SELECT util_cp FROM utilisateur WHERE util_id=541121 LIMIT 1
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 641755
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=505 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 541121 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='641755'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='641755' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=541121 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=541121 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 541121 AND W.type_id = 1) OR (W.util_id <> 541121 AND W.type_id = 2)) AND (M.post_util_id = 541121 OR M.dest_util_id = 541121) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT `empreinte_carbone`,s.prix_leroymerlin, s.prix_loxam, s.prix_kiloutou FROM `ssrubr` as s INNER JOIN wish as w ON w.ssrubr_id = s.ssrubr_id WHERE w.wish_id = '641755'
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish w INNER JOIN util_info ui ON w.util_id = ui.util_id WHERE wish_visu IN (1,6,10) AND w.util_id='541121' AND wish_id<>'641755' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (w.wish_area IS NULL OR w.wish_area='' OR w.wish_area='FR')
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='93350'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.483639197041 AND ville_latitude_deg<49.382960802959 AND ville_longitude_deg>1.7321822878414 AND ville_longitude_deg<3.1011577121586 HAVING distance <= 50 ORDER BY distance ASC
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('93350','93440','93700','93150','93120','93300','93240','95140','93500','95500','93200','93210','93000','93140','93380','95400','93310','93260','93230','95500','92390','93450','95360','93430','93130','93400','95410','93170','93100','93600','95400','95200','93800','95880','93320','93340','95170','93250','95350','95500','92230','93270','93110','95500','92110','93420','94300','95720','95160','95440','75001','75000','75002','75003','75004','75005','75006','75007','75008','75009','75010','75011','75012','75013','75014','75015','75016','75017','75018','75019','75020','75116','92600','93190','93390','95190','95230','93220','93360','95700','92300','95210','95218','95350','94120','93410','94170','92270','94160','95720','95580','95580','93370','95460','93290','94130','95600','95120','92200','95100','77181','93470','92700','93330','92400','95330','95380','95110','92250','94220','95720','94200','94205','95190','93460','94360','94410','95680','94270','94340','95570','92170','94250','95570','95390','93160','95130','77500','95870','77270','77181','95380','94350','94140','94700','95720','95850','92120','94500','95190','94800','95130','95320','92800','92150','92240','95570','95380','95380','77290','78800','94110','94100','94210','94340','95380','92000','77990','77420','77990','92100','95560','94430','95270','94400','95240','92500','77177','95270','95850','95560','92130','94420','95570','94000','92220','95560','78500','78420','77410','95530','92320','95670','94240','94230','94231','94232','94233','94234','94235','94236','94237','94238','94239','95840','92210','95370','95560','95250','95150','95550','77186','77185','95470','92140','94600','77360','77410','94320','95270','95270','92190','92360','95270','92340','94550','95270','94380','95470','95590','92260','92330','94490','94880','94880','77230','77200','95740','77230','77184','78600','78360','95220','77290','92380','95470','92350','95840','77230','78400','77400','77340','92410','95270','94370','94380','94310','94390','95270','95270','95480','92310','77230','94510','94460','77410','77400','92430','92420','95470','94150','77410','78600','77090','77183','77410','92290','78170','77600','94260','94470','95540','92370','77230','78290','78380','77400','77410','92160','95590','60128','78110','77400','94290','94190','77230','95270','78140','77680','78560','77400','77600','77600','95270','94450','95430','95630','95270','91320','77410','78430','77400','91370','77230','60560','78230','77230','95430','78220','77600','78700','77230','77400','95590','60520','94480','91200','60260','91560','95260','94440','91300','95760','91550','60580','95290','60128','77164','78150','78150','78100','95260','91330','95610','77230','78750','95620','91570','77600','95660','95310','77144','78160','78000','77135','94440','77280','77450','78260','77410','91270','60520','78350','77330','91230','78870','78570','78112','77144','77700','60820','77230','95340','94440','77230','95300','60330','78780','77165','91430','77150','78620','91420','91800','78300','77410','77600','77410','60950','95820','60520','91120','77170','77450','95000','77165','78590','91430','91380','91160','95340','77150','77410','95300','94520','94520','95300','77165','77165','78350','78530','60270','91210','95000','91260','95690','78955','77450','91160','78240','77700','77700','78570','77230','60230','91140','91860','91400','78590','91800','77450','60530','78240','77450','95280','60330','95520','95690','78210','95300','91170','95340','78330','60460','60500','91160','78117','91390','91600','60500','95490','77165','77700','95690','91480','77173','91360','60950','78670','78670','95650','77450','91360','78860','77450','60530','60300','60300','91480','91140','77174','78510','77450','95690','91400','95810','91160','77124','78450','77700','77170','91000','91130','60340','60340','60330','91350','91450','60530','60740','78280','77380','95650','77178','78630','91440','91190','95000','77122','78540','95650','60300','60950','78480','78117','77220','77860','60530','95800','60300','60300','60460','77580','91190','77220','91700','95810','77178','78390','77100','77100','77124','95180','60530','78450','60540','60540','77174','60300','77166','77124','91940','77860','91620','95810','91090','91000','60330','91700','91450','60300','78180','78960','78810','91700','91250','78114','77220','78740','60300','77165','77165','60540','78340','91620','77220','77860','60300','60530','91240','77124','95650','95650','91940','91190','60300','60300','78190','91310','77127','95810','77166','91940','78470','60440','95810','91310','91310','91080','60660','60160','60540','91070','78740','77910','77100','78630','78130','60530','91250','95830','78470','77610','60440','91280','95450','60440','78121','95450','77139','91460','91220','91220','77910','78810','77580','77580','95810','77170','60110','60810','60540','95450','77220','78370','78920','78580','95830','78470','60440','77580','60110','91400','77580','77390','91640','91090','77111','60160','77139','60660','60660','78130','60660','60660','60180','60700','91310','78460','91100','60100','60810','91250','60440','78250','60810','77550','95450','78850','95810','77610','77470','95640','78410','77470','77580','78990','77163','95450','77111','78250','77910','95640','60440','91470','77610','78250','77470','91100','77470','95450','91180','77610','78580','77580','91470','60110','60870','77139','77139','78640','60730','78250','60250','60550','77910','60570','77550','95640','78320','78320','78250','77550','91470','60119','95640','78640','77163','77580','78720','60730','78580','77163','77470','91640','77550','60810','91680','78410','78124','60730','78460','91290','77176','60800','60810','78124','77390','95640','95640','78720','95450','60570','91540','91540','91540','91290','60660','77610','60290','95640','60440','91810','60290','78310','78640','60240','95450','60250','91250','91830','60175','78650','78760','78126','91470','91630','60870','77470','78580','77470','91640','78410','60119','91520','91340','77440','95450','91630','95450','78320','77610','60440','60810','78310','91680','60870','77610','60730','78820','77390','60110','60800','91470','77390','77440','78720','91630','78640','77580','77515','60800','60730','60700','91630','77176','78410','78410','91540','95640','60290','95450','91710','60140','78250','95450','60620','60700','60250','60119','77240','77580','77950','60810','60940','60620','91640','60250','60940','77580','77240','77390','78440','77390','95450','77139','60410','60173','78490','60620','60940','77240','95750','78680','77660','91630','78690','78650','77950','77440','60700','95450','60620','78770','91650','77515','78720','77390','78440','77440','78770','78440','60290','60290','91750','78490','60240','60140','60700','78490','78490','91650','77950','91530','91830','78690','77540','91770','60140','78440','60800','60149','78830','77440','91790','60570','60410','77515','78970','77660','77950','77580','77390','60110','78770','91610','77310','60800','77390','78770','60430','60410','60620','95750','60620','77515','91650','77310','77440','77440','78770','77120','60240','60620','60250','78440','60790','78580','78440','60290','91750','95420','60790','60140','91730','60250','78830','91470','91760','60250','60140','60800','60240','78440','77440','77440','60410','78770','78610','77390','95420','95450','78490','77120','78490','78490','60800','77131','60250','91850','78440','60800','60790','60430','60320','77350','60240','77390','77390','78490','60700','77145','77390','77950','78930','78490','77640','60790','78930','60250','78440','91510','91510','77310','60240','91910','91730','77540','78720','60240','60620','78770','60240','77350','91530','77720','60410','60240','77720','77515','77000','77000','91530','60600','60700','91590','60790','60410','60620','60800','95510','60430','77950','91750','60700','60250','91580','91730','77350','60800','60129','77440','77260','77260','60790','60140','95420','60620','77120','77115','78610','60240','60430','77540','95420','60620','77190','60370','78440','77131','78125','60240','60710','60240','60240','91410','60370','60890','95420','95420','60620','78940','60620','78440','78930','77260','60370') AND fami_id='5' AND cate_id='193' AND type_id='1' AND ssrubr_id='505' AND wish_id<>'641755' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=517413 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 517413 AND W.type_id = 1) OR (W.util_id <> 517413 AND W.type_id = 2)) AND (M.post_util_id = 517413 OR M.dest_util_id = 517413) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 517413
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=504553 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 504553 AND W.type_id = 1) OR (W.util_id <> 504553 AND W.type_id = 2)) AND (M.post_util_id = 504553 OR M.dest_util_id = 504553) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 504553
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=484354 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 484354 AND W.type_id = 1) OR (W.util_id <> 484354 AND W.type_id = 2)) AND (M.post_util_id = 484354 OR M.dest_util_id = 484354) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 484354
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=486151 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 486151 AND W.type_id = 1) OR (W.util_id <> 486151 AND W.type_id = 2)) AND (M.post_util_id = 486151 OR M.dest_util_id = 486151) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 486151
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=139668 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 139668 AND W.type_id = 1) OR (W.util_id <> 139668 AND W.type_id = 2)) AND (M.post_util_id = 139668 OR M.dest_util_id = 139668) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 139668
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=122065 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 122065 AND W.type_id = 1) OR (W.util_id <> 122065 AND W.type_id = 2)) AND (M.post_util_id = 122065 OR M.dest_util_id = 122065) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 122065
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=358342 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 358342 AND W.type_id = 1) OR (W.util_id <> 358342 AND W.type_id = 2)) AND (M.post_util_id = 358342 OR M.dest_util_id = 358342) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 358342
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=435626 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 435626 AND W.type_id = 1) OR (W.util_id <> 435626 AND W.type_id = 2)) AND (M.post_util_id = 435626 OR M.dest_util_id = 435626) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 435626
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=395915 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 395915 AND W.type_id = 1) OR (W.util_id <> 395915 AND W.type_id = 2)) AND (M.post_util_id = 395915 OR M.dest_util_id = 395915) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 395915
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=386589 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 386589 AND W.type_id = 1) OR (W.util_id <> 386589 AND W.type_id = 2)) AND (M.post_util_id = 386589 OR M.dest_util_id = 386589) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 386589
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (87) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (88) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (81) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (110) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (227) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (176) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (79) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (208) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (228) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (207) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (95) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (173) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (83) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (93) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (193) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (91) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (232) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (92) ORDER BY ssrubr_order ASC
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT COUNT(*) AS nbavis FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
Contactez-nous