Description de l'annonce
Bonjour,
Je recherche une place de parking à l'année dans un endroit sécurisée pour ma moto à Marcoussis dans le secteur de Babilou Marcoussis Jacquemarderie. Merci d'avance
#Parking securise
Voir les annonces autour de moi Géolocaliser
Poster une annonce
Bonjour,
Je recherche une place de parking à l'année dans un endroit sécurisée pour ma moto à Marcoussis dans le secteur de Babilou Marcoussis Jacquemarderie. Merci d'avance
#Parking securise
Louer un garage/parking entre particuliers ou proposer un garage/parking 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='436789'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='parking-securise' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='518'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'parking-securise' 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='79'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('91' 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='263825' 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` = 263825
SELECT util_cp FROM utilisateur WHERE util_id=263825 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 = 436789
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=518 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 263825 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='436789'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='436789' 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=263825 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=263825 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 = 263825 AND W.type_id = 1) OR (W.util_id <> 263825 AND W.type_id = 2)) AND (M.post_util_id = 263825 OR M.dest_util_id = 263825) 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 = '436789'
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='263825' AND wish_id<>'436789' 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='91460'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.6333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.6333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.23333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.183639197041 AND ville_latitude_deg<49.082960802959 AND ville_longitude_deg>1.5529216332696 AND ville_longitude_deg<2.9137383667304 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 ('91460','91620','91310','91310','91310','91620','91310','91180','91680','91240','91160','91700','91140','91340','91290','91520','91160','91290','91940','91220','91640','91640','91220','91680','91360','91940','91700','91630','91140','91630','91160','91360','91650','91400','91640','91650','91630','91440','91160','91380','91190','91940','91790','91640','91390','91400','91600','91120','91630','91630','91700','91470','91650','91530','91420','91730','91070','91350','91470','91430','91430','91170','91300','91730','91910','91190','91400','91810','91260','91080','91190','91530','91580','91470','91730','91570','91510','91510','91370','78470','91320','91770','91470','91550','91710','91470','91130','91000','91850','92160','91090','91540','91530','94260','91470','91210','78830','78117','91760','91580','92290','91200','91540','91270','78460','94150','91580','78117','91580','78350','91530','91090','91000','91450','94480','91610','91540','91410','91540','78114','78530','78350','91580','92350','78460','91100','92340','92260','92330','91590','94550','91450','78830','78470','94290','91230','94390','94310','94240','94236','94231','94232','94234','94235','94239','94238','94237','94233','94230','91560','91410','91750','94320','91250','91580','78720','78960','92140','92370','91100','91590','91590','78140','92320','92220','78220','78720','78730','78730','78280','78470','94190','91410','92190','92360','91590','91250','91280','78720','94110','78000','78720','91250','94600','91590','91150','92310','92130','91750','94400','91590','78720','78180','91800','94800','91830','91250','92240','92120','91590','94450','94460','91830','92410','91860','91870','91330','94250','91150','91590','91410','78210','91410','92100','91480','78320','94270','92430','92420','91800','78150','92170','91880','78320','94140','91150','94205','94200','92210','77127','78730','78730','92380','94380','94700','91890','78150','94000','78190','94440','78120','91820','91820','94520','94520','78390','94220','78330','91150','91480','94470','78320','91750','77380','78170','77240','77176','91410','91780','91780','77310','91410','94440','92150','92800','78590','94160','91150','91840','78690','94440','91720','78730','94410','78120','78660','75014','75016','75017','75011','75015','75019','75010','75008','75007','75005','75004','75003','75002','75000','75001','75009','75018','75020','78870','75013','75006','75116','75012','94370','94380','78125','78310','94340','91490','78990','91150','78610','77176','77310','94340','94210','94100','78380','78290','77550','78590','77170','78430','78450','78340','78310','91490','77310','91150','94430','77930','92500','92200','77240','91410','91490','91720','78160','94300','77550','78400','91720','94880','94880','94490','77930','78620','77170','78690','94130','91410','77350','78860','78560','78610','94500','78370','77240','91410','93170','77930','77930','92400','78120','91780','77166','78760','91150','91410','92250','91150','92000','93100','92300','78750','92110','77150','91690','78450','94120','93310','78112','94360','93400','94510','91720','91690','78110','77930','94170','77350','91490','78125','92600','78230','91690','78660','78660','77150','93230','93260','77350','78610','91150','92700','78660','91150','78800','92270','78100','78490','78420','77190','77930','93110','78640','94420','91150','77550','91740','93500','91690','91150','78360','78490','94350','28700','78660','77190','77166','77950','91690','91720','78810','93330','93130','78490','78490','77950','78640','77340','91490','78640','78240','77111','77550','77630','77173','93360','28700','93120','93300','95870','91720','91740','78850','78125','93000','78240','92230','91690','78640','77000','77000','77630','77950','93250','78810','78660','93450','92390','93140','91930','78660','78125','93160','77170','77630','93210','93200','78600','77184','77950','91720','78490','78490','77330','77000','45300','95100','91150','28700','91150','78500','78121','93220','78610','77000','77950','77123','77111','93800','93460','78490','78600','77680','77185','91740','77123','78125','93350','78300','77420','78650','93320','93340','28700','78630','77390','78125','78490','78650','93240','91660','93150','93700','93430','28700','95110','45300','78125','45330','95530','95210','95218','95880','45330','93440','77760','28700','78490','77123','78770','28310','91660','28700','28700','77950','28320','77186','95360','78490','78955','77390','77590','28700','93380','77390','77220','93370','28700','77500','78124','77183','77090','77200','95130','78490','77135','78940','95240','95120','77590','78260','77220','95370','93390','93190','78580','78670','78670','91670','77390','28700','78580','95230','45300','77390','28230','45300','95140','45330','95170','77115','45330','28700','95410','77220','95500','78770','28700','93270','78630','77760','28700','78124','77360','78770','78125','28700','78700','77760','77177','77164','28230','78125','28700','77181','93470','77220','45300','95130','28320','78570','28700','77390','77600','93600','78890','95600','28700','78770','95220','95580','95580','78940','77115','95400','28700','78770','28320','28310','93410','78540','28700','95160','45300','77390','78570','77760','28700','77600','77600','45480','45330','95350','77400','78770','77720','95500','78920','78580','77181','95200','95400','28320','78510','78780','45300','77590','95320','95390','95250','95680','78580','78910','45300','95480','77760','77400','77220','78480','78125','77390','28130','78113','77300','78130','93420','77760','77400','77820','28310','77920','28310','78125','77600','77610','95350','77720','78113','78126','77270','77760','95610','45480','78113','93290','78910','77410','77400','77600','28700','95440','77210','28700','78770','77390','78950','95500','77850','77820','28320','95000','78410','28310','95150','95550','45300','28700','77600','95500','77760','78910','77210','77400','95330','95280','95720','45300','77760','45330','77870','28700','77760','28310','28210','28130','77610','77390','78550','95460','45480','78580','95700','78410','78410','78410','45330','78113','78910','95000','95190','77144','77720','28130','77400','28700','78910','95000','28700','77400','78113','28130','77174','95840','95740','28310','95180','95560','77133','45480','77610','95720','45300','45300','45390','78410','78930','77390','77390','95570','78680','28150','77760','95490','45480','45390','45390','78740','78130','95570','77760','77700','78790','78113','77610','95310','95570','78790','78790','95300','28310','77760','78740','77410','28130','78250','78550','45480','95800','77820','78930','77780','95720','77720','78910','77144','77700','77290','77720','28210','77720','77810','28130','28700','95840','77700','28310','95540','77610','78550','28150','78250','45300','95430','95560','77174','28150','78250','95560','95380','77760','77610','45390','77133','28700','28130','77410','78970','78550','95190','95650','45480','77390','28130','95450','77410','28410','28210','78250','77890','28700','77430','95300','77880','78550','45390','78820','28210','77410','28130','78930','95520','95720','77690','45390','28150','77720') AND fami_id='5' AND cate_id='79' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='518' AND wish_id<>'436789' 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='518' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=421856 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 = 421856 AND W.type_id = 1) OR (W.util_id <> 421856 AND W.type_id = 2)) AND (M.post_util_id = 421856 OR M.dest_util_id = 421856) 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 = 421856
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='518' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=482499 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 = 482499 AND W.type_id = 1) OR (W.util_id <> 482499 AND W.type_id = 2)) AND (M.post_util_id = 482499 OR M.dest_util_id = 482499) 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 = 482499
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='518' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=434635 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 = 434635 AND W.type_id = 1) OR (W.util_id <> 434635 AND W.type_id = 2)) AND (M.post_util_id = 434635 OR M.dest_util_id = 434635) 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 = 434635
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='518' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=419482 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 = 419482 AND W.type_id = 1) OR (W.util_id <> 419482 AND W.type_id = 2)) AND (M.post_util_id = 419482 OR M.dest_util_id = 419482) 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 = 419482
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='518' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=9194 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 = 9194 AND W.type_id = 1) OR (W.util_id <> 9194 AND W.type_id = 2)) AND (M.post_util_id = 9194 OR M.dest_util_id = 9194) 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 = 9194
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='518' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=79915 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 = 79915 AND W.type_id = 1) OR (W.util_id <> 79915 AND W.type_id = 2)) AND (M.post_util_id = 79915 OR M.dest_util_id = 79915) 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 = 79915
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='518' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=330449 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 = 330449 AND W.type_id = 1) OR (W.util_id <> 330449 AND W.type_id = 2)) AND (M.post_util_id = 330449 OR M.dest_util_id = 330449) 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 = 330449
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='518' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=322619 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 = 322619 AND W.type_id = 1) OR (W.util_id <> 322619 AND W.type_id = 2)) AND (M.post_util_id = 322619 OR M.dest_util_id = 322619) 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 = 322619
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='518' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=284521 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 = 284521 AND W.type_id = 1) OR (W.util_id <> 284521 AND W.type_id = 2)) AND (M.post_util_id = 284521 OR M.dest_util_id = 284521) 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 = 284521
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='518' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=227085 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 = 227085 AND W.type_id = 1) OR (W.util_id <> 227085 AND W.type_id = 2)) AND (M.post_util_id = 227085 OR M.dest_util_id = 227085) 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 = 227085
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