Discuter
Description de l'annonce
Je cherche un parking près de l aéroport Roissy Charles Degaulle #parking proche aeroport
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Je cherche un parking près de l aéroport Roissy Charles Degaulle #parking proche aeroport
Annonces similaires
Tout voirLouer un garage/parking entre particuliers ou proposer un garage/parking en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
10€
Pour appeler mon voisin & organiser le rendez-vous.
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
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='646637'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='parking-proche-aeroport' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='520'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'parking-proche-aeroport' 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 filtre_dpt='95'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='548461' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 548461
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 = 646637
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=520 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='646637'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='646637' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 548461 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=548461 LIMIT 1
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 = 548461 AND W.type_id = 1) OR (W.util_id <> 548461 AND W.type_id = 2)) AND (M.post_util_id = 548461 OR M.dest_util_id = 548461) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='548461' AND note_visu IN (1,3,4)
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 = '646637'
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='548461' AND wish_id<>'646637' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='95700'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.550339197041 AND ville_latitude_deg<49.449660802959 AND ville_longitude_deg>1.8312660970883 AND ville_longitude_deg<3.2020739029117 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_cp IN ('95700','95500','95500','95380','93420','95190','95380','95500','93600','95380','95380','77990','77990','95720','93290','95500','95190','93270','77290','95400','95380','95140','95720','95470','93410','93150','93700','95190','93440','77230','77230','95670','93190','93390','95850','77230','95200','95400','95440','95470','95720','77270','93350','93470','95850','77181','77290','95350','77230','93320','93340','93240','95720','95470','95470','95460','93380','77410','95270','93370','93140','77181','95270','95270','95270','60128','93000','77230','95350','95410','95360','93250','93220','95570','77230','77230','95160','95270','93120','93300','77410','93130','77410','95170','93430','93210','93200','77230','95330','77410','93500','95570','77500','60128','93230','93260','95270','95570','77410','77230','93360','60560','60520','95270','93110','95880','93460','77280','93450','92390','95270','93310','77177','95580','95580','77230','95230','93100','93800','60330','77230','95560','95270','60950','93170','94170','93330','95570','60520','94120','95600','93160','60580','95680','95560','77230','77410','60520','93400','95218','95210','95560','77410','92230','77360','60260','77420','94300','77400','77165','77165','95390','95120','77400','95270','94360','77410','94130','94350','77186','95560','77230','95270','77400','77200','92110','60330','95590','77165','77165','77400','77410','95320','92600','95110','77185','94160','95270','60950','77400','75013','75012','75015','75016','75017','75018','75019','75020','75116','75011','75010','75005','75003','75006','75002','75000','75007','75004','75009','75014','75001','75008','95840','95100','77410','92300','94500','95590','77400','77450','92270','77600','95130','94420','94340','95130','77400','94410','77410','77165','60330','77600','77600','77450','77090','77183','92700','60270','77184','94220','95590','60950','77600','95840','77178','60820','60300','60300','95150','95550','94430','94210','60300','60300','94100','94340','60500','77144','77700','92200','77450','92250','92400','60500','95260','95740','94200','77144','94205','60300','77600','94700','77178','77450','60300','95870','94270','95250','77122','95240','77340','94140','60330','95260','77700','95820','77124','60300','77164','94490','94880','94880','95540','77680','95340','60300','94000','95290','92170','95370','94250','95660','77450','94510','60740','95530','95340','60460','94800','95630','95430','77450','78800','77165','77165','78500','60440','92120','60300','60340','77600','60440','60440','95620','92800','92150','95220','60340','94400','95480','77124','60300','95760','77700','77450','92000','92240','60300','77135','94110','94370','94380','78420','94380','77100','77124','60810','77700','77450','92500','60530','95430','77100','77910','77124','60230','92100','94600','77139','60440','60530','92220','78600','92130','60460','60440','60810','94233','94234','94231','94237','94238','94239','94236','94235','94240','94230','94232','77860','60810','94320','77139','94470','77910','92320','94460','92210','60440','60530','77330','60700','78360','95690','60160','77580','95340','94550','77860','77700','60530','92140','77100','92340','77860','77174','60660','94390','94310','92190','92360','78600','60530','92330','92260','95310','94440','94450','60100','78400','60180','92380','94190','95300','77139','60800','92350','60160','94150','60810','60530','77910','95610','78700','95690','94290','77150','60440','95690','77139','77470','92410','77174','60810','92310','77150','95300','92430','92420','60540','60540','60660','60660','78110','95300','94260','95690','60550','94440','91330','60440','78170','60870','60660','60660','77910','77580','78290','78380','77580','94440','60540','60800','92290','77470','77170','91560','77580','78560','92160','60800','60810','92370','77470','95300','94480','78230','77580','60530','77220','77470','91320','77580','91200','95810','78430','78780','95000','78570','78140','60620','95000','60810','78260','91370','77440','60540','77173','91550','60870','91800','60870','94520','94520','77440','60620','78100','77580','60290','60620','77220','95520','60700','60290','91230','60410','78220','60700','60540','95650','77139','77470','91270','78750','91300','60660','77470','78150','78150','77163','60800','95810','60620','60250','77580','60700','77610','77220','78300','78160','60110','60800','91860','60940','91800','60940','95810','95280','60940','78570','77470','78112','60140','91570','95490','60410','60290','60620','78955','60700','78000','60730','78870','77220','60410','60250','91480','91420','91210','77170','95650','77440','78620','60730','60800','60620','60620','78350','77440','77440','91260','95810','60110','77163','60800','95810','60800','78590','95650','77166','91430','60410','77660','91380','91160','60320','78240','91120','60140','91480','95810','60250','77380','60140','60730','60290','77580','77610','91430','60570','95000','77440','77440','78510','77610','60620','95800','77660','77163','60410','60290','77220','91160','60800','60110','60250','78670','78670','78240','78530','78350','77580','60570','60800','60129','91170','77145','60730','60410','60620','95810','91140','95830','77515','77580','95650','95650','78590','77440','77440','95180','60140','78480','60620','60700','60730','91390','91600','78540','77390','91400','91450','60140','77166','60620','77580','60700','77170','91360','77610','60620','60700','91130','91000','95640','60620','91160','60117','78210','78330','95830','60290','91360','60320','60320','77610','95450','78630','95640','60710','91350','78860','78740','60320','77440','78117','60250','60890','60129','60119','60710','60140','77111','91250','91160','77640','60175','77127','91140','91450','78450','91090','91000','60250','60110','77840','60600','77120','60129','91400','77610','78740','95450','60126','77111','95450','60190','95450','77260','77260','77515','60250','77515','77515','78280','60680','95640','60890','60126','60250','91700','77610','91440','60890','91190','91700','95640','78450','60800','78117','77440','60600','91280','60141','60119','60600','91250','60570','60129','60890','78130','60117','78390','60240','78810','60127','77440','60600','60840','60190','60190','60250','77120','91700','60117','60250','91190','91620','77390','95640','77550','95450','77260','78630','60190','77540','60890','60600','91080','60430','60610','95450','91940','60430','60119','60110','60600','60880','60173','91070','91240','78130','78250','78180','95640','95640','78340','77550','78960','91620','60890','78920','60370','60149','91310','60790','78114','77550','77390','02810','95450','91250','78121','91100','60190','60680','60680','91310','91310','77390','60141','78580','77515','78190','60600','78250','78250','91190','91940','91940','77550','91220','91090','60127','91220','77840','78810','60370','78410','77131','60430','78470','77260','77390','77390','78250','95450','77640','60430','60117','60370','60240','91460','77120','77120','60790','95450','60790','60117','78470','60190','95640','77120','78370','77260','60790','60880','60600','60880','60890','95750','77260','78250','60600','60790','77176','60600','60190','77390','91100','02600','95450','91310','77390','78850','77131','78470','60430','60680','60123','91400','91640','60190','77540','02460','02810','95450','77440','78580','78410','60790','77950','77390','78460','60134','60240','77260','77120','78990','60240','77840','95450','77390','60240','78580','77390','91250','91830','60510','77540','77950','60190','60600','60190','95450','60600','60134','77176','91540','91540','77240','91180','60350','77510','78820','95450','60430','78640','60600','77240','60240','78124','78250','78410','77138','60240','02600','78440','60510','91540','60930','60123','60240','91470','95750','77720','60190','77169','77540','78124','78126','60240','60600','77950','91810','78640','77169','77750','78580','91470','77390','77950','02600','60240','91290','02810','02310','77120','78320','77540','02600','78320','60510','77730') 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='520' AND wish_id<>'646637' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_slug, 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='520' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=485263 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 = 485263 AND W.type_id = 1) OR (W.util_id <> 485263 AND W.type_id = 2)) AND (M.post_util_id = 485263 OR M.dest_util_id = 485263) 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 = 485263
SELECT ssrubr_slug, 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='520' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=129864 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 = 129864 AND W.type_id = 1) OR (W.util_id <> 129864 AND W.type_id = 2)) AND (M.post_util_id = 129864 OR M.dest_util_id = 129864) 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 = 129864
SELECT ssrubr_slug, 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='520' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=297308 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 = 297308 AND W.type_id = 1) OR (W.util_id <> 297308 AND W.type_id = 2)) AND (M.post_util_id = 297308 OR M.dest_util_id = 297308) 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 = 297308
SELECT ssrubr_slug, 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='520' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=12314 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 = 12314 AND W.type_id = 1) OR (W.util_id <> 12314 AND W.type_id = 2)) AND (M.post_util_id = 12314 OR M.dest_util_id = 12314) 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 = 12314
SELECT ssrubr_slug, 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='520' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=192161 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 = 192161 AND W.type_id = 1) OR (W.util_id <> 192161 AND W.type_id = 2)) AND (M.post_util_id = 192161 OR M.dest_util_id = 192161) 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 = 192161
SELECT ssrubr_slug, 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='520' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=176383 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 = 176383 AND W.type_id = 1) OR (W.util_id <> 176383 AND W.type_id = 2)) AND (M.post_util_id = 176383 OR M.dest_util_id = 176383) 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 = 176383
SELECT ssrubr_slug, 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='520' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=166359 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 = 166359 AND W.type_id = 1) OR (W.util_id <> 166359 AND W.type_id = 2)) AND (M.post_util_id = 166359 OR M.dest_util_id = 166359) 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 = 166359
SELECT ssrubr_slug, 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='520' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=157048 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 = 157048 AND W.type_id = 1) OR (W.util_id <> 157048 AND W.type_id = 2)) AND (M.post_util_id = 157048 OR M.dest_util_id = 157048) 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 = 157048
SELECT ssrubr_slug, 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='520' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=153158 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 = 153158 AND W.type_id = 1) OR (W.util_id <> 153158 AND W.type_id = 2)) AND (M.post_util_id = 153158 OR M.dest_util_id = 153158) 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 = 153158
SELECT ssrubr_slug, 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='520' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=153154 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 = 153154 AND W.type_id = 1) OR (W.util_id <> 153154 AND W.type_id = 2)) AND (M.post_util_id = 153154 OR M.dest_util_id = 153154) 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 = 153154
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 520
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 n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)
Contactez-nous