Discuter
Description de l'annonce
Bonjour,
je suis à la recherche d'un camping car à louer pour 5 couchages du 25 au 28/06 pour nous rendre à un mariage à Villeneuve le compte 77 #campingcar
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Bonjour,
je suis à la recherche d'un camping car à louer pour 5 couchages du 25 au 28/06 pour nous rendre à un mariage à Villeneuve le compte 77 #campingcar
Annonces similaires
Tout voirLouer un camping-car entre particuliers ou proposer un camping-car en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
240€
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='355391'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='campingcar' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='972'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'campingcar' 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='173'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='77'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='162482' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 162482
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 = 355391
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=972 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='355391'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='355391' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 162482 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=162482 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 = 162482 AND W.type_id = 1) OR (W.util_id <> 162482 AND W.type_id = 2)) AND (M.post_util_id = 162482 OR M.dest_util_id = 162482) 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='162482' 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 = '355391'
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='162482' AND wish_id<>'355391' 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='77144'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.75- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.417039197041 AND ville_latitude_deg<49.316360802959 AND ville_longitude_deg>2.0664237413096 AND ville_longitude_deg<3.4335762586904 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 ('77144','77600','77700','77144','77400','77400','77600','77400','77700','77400','77600','77600','77600','77450','77400','77400','77700','77700','77400','77600','77450','77164','77410','77450','77700','77450','77174','77450','77183','77090','77360','77580','77410','77860','77200','77410','77174','77450','77135','77177','77860','77186','77450','77410','77410','77410','77450','77680','77860','77185','77580','77580','77500','77420','77410','77181','77184','77100','77220','77580','77410','77270','77580','77100','77124','77610','77410','77330','77163','77340','77410','77100','93470','77181','93460','77410','93160','77124','93370','77580','77470','77163','94420','77165','77220','77220','77165','77165','77580','94350','77230','93410','94510','77163','77580','77124','77610','93390','93190','93220','93330','77290','77610','93290','77290','77124','77470','77220','77165','77230','77470','77580','77515','77230','77610','93360','77150','77470','94490','94880','94880','77470','93340','93320','94360','93270','77122','77230','77150','77173','77230','77470','94500','77580','77580','94170','93250','77910','77220','94430','77230','77165','77610','77910','77610','93420','94370','77515','94380','93600','77470','93110','94120','94210','77515','94100','94340','94130','77990','77910','77515','77230','77390','77610','77230','77170','77540','93130','77910','77120','94440','77139','77230','93140','77580','77230','77166','94440','94470','94340','77120','77660','77165','77165','94410','77990','93000','77230','94380','77178','77170','77230','95700','77170','77131','77440','94000','77515','77178','77139','94440','93700','93150','93100','93260','93230','94300','77440','77390','77660','77120','95380','94520','94520','60330','77390','77111','77139','77640','94700','60330','93170','94460','95500','77440','94450','77131','77280','77111','94160','91330','77230','77166','94220','77120','95380','91480','77540','77139','95500','93350','95500','94140','77120','60440','77390','93310','95500','77120','95380','77440','91800','77540','93500','77390','95470','60330','77380','77390','95380','93440','77260','77260','91800','60330','60950','77440','77440','77390','94190','60440','77440','95190','77440','91860','77540','77260','77390','95140','94600','94400','77390','91480','93300','93120','94205','94200','77540','95470','91560','95400','77120','77390','77720','77540','77550','93240','77120','77550','95720','94290','94270','77169','60128','94310','94390','60440','91230','77440','77139','77640','94800','94320','77510','77169','60950','77260','95380','77540','94480','93200','93210','77440','77390','75014','75001','75000','75020','75008','75009','75010','75011','75019','75012','75013','75018','75015','75116','75017','75004','75005','75002','75006','75003','75007','75016','60620','95470','77127','60950','60128','60440','77550','95190','77390','93380','60620','95670','77145','60620','77440','91200','95720','95200','95400','91270','93400','60620','94250','95190','77720','77550','95360','77260','94550','93450','92390','94110','93430','95440','77390','95350','77950','77720','77120','91250','77141','91210','94239','94231','94232','94233','77120','94234','94235','94236','94238','94230','94240','94237','95410','77260','94150','95850','77950','77750','92120','77169','95470','77370','95850','60620','91450','91550','60440','95720','77440','95170','77750','92110','92170','95270','91450','91280','92340','77840','60300','92240','77115','77138','95880','95460','93800','60520','77720','95350','60620','60300','60300','77720','77950','92230','91260','92220','77169','60520','60620','95160','95720','77950','91320','95270','60890','95270','77260','91250','91000','91090','60440','77720','60560','95270','77176','94260','92600','91130','77970','91000','92300','77510','60440','60620','77730','60520','77240','77320','77370','91250','91170','92320','77240','77720','77720','77950','60440','95230','92200','92330','77950','92260','77510','92160','60620','91100','77750','77176','77840','95570','95330','77440','91420','60300','92270','92130','60620','77970','77730','95218','95210','77320','95270','95580','95580','91350','77750','92140','77320','95270','60890','77320','77730','92400','92350','77510','95570','92250','77510','92100','91390','91600','02310','77720','95570','95270','92700','77115','92290','95600','77820','91300','77720','60800','77000','77000','60890','95120','60580','77840','95100','91370','95270','02810','92360','92190','91360','92800','92150','77320','91380','91160','91080','95680','02310','77750','60300','77350','91250','91830','77240','77370','77730','95110','91700','91100','91090','77320','77970','60620','95570','95560','91070','91360','60800','60300','60800','77510','95390','02310','02810','95270','60260','60800','60810','60620','92210','77370','77000','77370','60890','60810','60890','77310','95560','77750','95870','77370','95560','77970','60800','95130','91160','77190','77310','02310','91700','60300','77350','95320','91120','92500','60300','60300','60620','02310','92000','95130','60890','78800','92310','77320','77370','77320','91540','91540','02810','95560','95270','60810','77350','91160','91700','91160','77970','02810','92370','77820','02310','91140','77320','92410','91570','77310','77000','77320','77370','60810','77820','77510','92380','60117','95270','77510','60800','02810','95590','91430','78420','95840','60500','60141','91830','91240','60890','02310','77370','91540','78140','77370','60800','95240','02310','91220','91220','77370','92420','92430','02310','60500','78500','95270','77590','02460','60800','60270','77590','60300','91620','02310','95530','91430','91310','91140','95590','60141','95550','95150','77160','77560','78220','02810','95370','95250','91540','77370','91810','02810','91750','95840','77510','91310','91310','78400','78170','77320','02400','02810','95740','77320','77190','78350','60117','60300','78360','95590','60820','60700','02310','60810','77590','77320','60740','91750','91750','60800','60810','02810','77160','78600','91620','02810','77560','60800','91710','60129','77930','78290','78380','77510','95220','77370','95260','91400','60810','60117','77320','91400','02470','77930','60117','78000','95480','02810','60340','02400','95540','91460','95820','78150','91310','95260','91630','77930','78600','02600','02400','78430','77920','77850','78560','02470','60320','60460','91610','60800','78110','77133','78150','78350','78530','60340','91440','60410','77520','77133','95340','02470','95430','95630','02810','77830','95290','02570','77560','91630','77160','95660','60129','77560','77830','77160','91180','02460','02570','95340','60129','91940','02400','91290','77160','02460','77630','77930','78230','02540','95760','02400','02400','95620','60127','02600','02470','77154','95430','91770','60117','77930','77320','77154','02470','91190','78117','60410','91940','60410','77870','60410','91290','60320','60320','60410','60160','77320','77560','02470','60100','91840','77930','91630','02400','60700','78160','78750','78870','77650','78100','60460','02400','02470','60530','60180','02600','77160','60129','91590','77830','78700','77160','91190','60550','60700','60230','60530','91760','77520','02600','91940','91630','91190','77650','60660','77320','60700','60123','02400','78117','02470','02570','77320','78620','91630','60127') AND fami_id='5' AND cate_id='173' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='972' AND wish_id<>'355391' 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='972' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=524968 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 = 524968 AND W.type_id = 1) OR (W.util_id <> 524968 AND W.type_id = 2)) AND (M.post_util_id = 524968 OR M.dest_util_id = 524968) 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 = 524968
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='972' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=521958 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 = 521958 AND W.type_id = 1) OR (W.util_id <> 521958 AND W.type_id = 2)) AND (M.post_util_id = 521958 OR M.dest_util_id = 521958) 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 = 521958
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='972' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=439331 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 = 439331 AND W.type_id = 1) OR (W.util_id <> 439331 AND W.type_id = 2)) AND (M.post_util_id = 439331 OR M.dest_util_id = 439331) 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 = 439331
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='972' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=309662 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 = 309662 AND W.type_id = 1) OR (W.util_id <> 309662 AND W.type_id = 2)) AND (M.post_util_id = 309662 OR M.dest_util_id = 309662) 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 = 309662
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='972' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=82839 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 = 82839 AND W.type_id = 1) OR (W.util_id <> 82839 AND W.type_id = 2)) AND (M.post_util_id = 82839 OR M.dest_util_id = 82839) 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 = 82839
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='972' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=266610 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 = 266610 AND W.type_id = 1) OR (W.util_id <> 266610 AND W.type_id = 2)) AND (M.post_util_id = 266610 OR M.dest_util_id = 266610) 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 = 266610
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='972' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=352574 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 = 352574 AND W.type_id = 1) OR (W.util_id <> 352574 AND W.type_id = 2)) AND (M.post_util_id = 352574 OR M.dest_util_id = 352574) 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 = 352574
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='972' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=351849 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 = 351849 AND W.type_id = 1) OR (W.util_id <> 351849 AND W.type_id = 2)) AND (M.post_util_id = 351849 OR M.dest_util_id = 351849) 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 = 351849
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='972' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=266607 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 = 266607 AND W.type_id = 1) OR (W.util_id <> 266607 AND W.type_id = 2)) AND (M.post_util_id = 266607 OR M.dest_util_id = 266607) 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 = 266607
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='972' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=252479 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 = 252479 AND W.type_id = 1) OR (W.util_id <> 252479 AND W.type_id = 2)) AND (M.post_util_id = 252479 OR M.dest_util_id = 252479) 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 = 252479
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 972
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