Kiwiiz : service & location entre voisins.
Utiliser ma position
Logo recherche

Indiquer un code postal ou une ville Indiquer un code postal

Flèche vers le champ lieu

Poster une annonce

Cherche à louer camping car

Autres annonces du voisin

Tout voir
Location micro ondes

Demande il y a + de 30j

Il y a + de 30j

Location : Micron ondes

20€/semaine

Foussemagne

Annonces similaires

Tout voir
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Vacances Espagne

520€/mois

Grand-Charmont
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Recherche Location van ou camping car (4

340€

Courchaton
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Loue camping car (5 jours)

150€

Mulhouse
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Recherche a louer camping car

645€/semaine

Echenans-sous-Mont-Vaudois
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Cherche camping-car à louer (1 semaine)

950€/semaine

Saulnot
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Location camping car pour 2 jours

160€

Munster
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Location camping-car (pour 10 jours)

650€

Audincourt
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Cherche camping car Haute Saône

240€

Saint-Germain

Louer un camping-car entre particuliers ou proposer un camping-car en location.

Poster une annonce
Retour
Fermer

Location entre voisins

Lancez votre recherche pour voir les annonces.

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wiiz-annonce.php

  1. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

  2. 0.0002

    SHOW TABLES LIKE 'pays'

  3. 0.0002

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

  4. 0.0002

    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

  5. 0.0001

    SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL

  6. 0.0005

    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<>''

  7. 0.0001

    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='494112'

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='campingcar' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='972'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'campingcar' LIMIT 1

  10. 0.0001

    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'

  11. 0

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='90'

  12. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='182780' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  13. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 182780

  14. 0.0001

    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 = 494112

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=972 LIMIT 1

  16. 0.0001

    SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='494112'

  17. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='494112' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')

  18. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 182780 AND util_tel != ''

  19. 0

    SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=182780 LIMIT 1

  20. 0.0002

    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 = 182780 AND W.type_id = 1) OR (W.util_id <> 182780 AND W.type_id = 2)) AND (M.post_util_id = 182780 OR M.dest_util_id = 182780) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  21. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='182780' AND note_visu IN (1,3,4)

  22. 0.0001

    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 = '494112'

  23. 0.0001

    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='182780' AND wish_id<>'494112' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  24. 0.0001

    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='704' LIMIT 0,1

  25. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=182780 AND note_visu IN (1,3,4)

  26. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 182780

  27. 0.0001

    SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='90150'

  28. 0.0061

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.6667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.6667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.96667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.217039197041 AND ville_latitude_deg<48.116360802959 AND ville_longitude_deg>6.2989580974193 AND ville_longitude_deg<7.6343819025807 HAVING distance <= 50 ORDER BY distance ASC

  29. 0.0125

    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 ('90150','90150','90150','90150','90150','90150','90150','90150','90150','90160','90110','90380','90110','90110','90160','90150','90150','90170','90150','90300','90150','90340','90150','90110','90340','90130','90130','90160','68210','90300','90360','90170','90360','68210','90110','90340','68210','68210','68210','90110','68210','90300','90130','90170','90140','68210','90400','68210','68780','90200','90000','90300','68210','68210','90140','68210','90400','90400','68210','68210','68210','68290','90300','68780','68780','68780','90400','90300','68780','68210','90100','90400','90140','90140','90100','90140','90330','68210','90850','90200','90400','90140','90100','90170','90100','68780','90300','68210','90850','68780','90400','90100','68210','68210','68210','90350','90200','68116','90200','90400','68210','68290','90600','68210','68290','68210','68290','90120','90400','90800','68210','90800','90200','90400','68210','90700','90100','70400','90800','70400','90800','68290','68290','68290','68290','68210','25600','68290','90100','90100','68210','68210','70400','90120','68210','68580','68210','68520','90200','68210','68800','68290','68290','25490','68700','90200','68520','68720','70400','70400','70400','68800','25600','68210','68580','25600','25490','90100','70400','90200','68720','68700','68580','68800','90100','25200','68700','68520','70290','70400','68290','90100','25490','90100','70400','68720','70400','68800','90100','25490','70400','68990','68800','25200','25600','25600','68130','70290','68580','70400','70400','68580','68580','68720','90100','25460','68130','02926','68118','90100','90100','68620','25400','70400','90500','25200','25230','25400','68720','68990','70400','02924','68700','90370','02925','70290','70290','25550','70400','68130','68950','70400','68760','68470','90100','02933','68470','68700','68700','68720','68720','68130','68720','68720','90500','25400','68690','25230','68550','70400','25550','25420','02935','68560','70400','25550','68580','25400','25230','02933','25750','25750','68480','25630','68580','25550','25750','68560','02923','70250','70400','68470','68121','68470','90100','70440','90100','70270','68790','68720','68470','68130','68550','25700','25550','70200','68720','68560','25550','68760','88540','68690','68130','68130','68700','25420','02915','68560','25550','68350','02944','68130','70400','25230','25550','68580','02932','88160','88560','68470','02922','70400','68460','70200','25310','68130','68720','25310','70440','68350','70200','68130','25420','25550','25750','68640','68310','68850','70440','68120','68640','70400','25350','70200','25113','68960','68960','70400','02916','02943','70200','70200','25420','68500','68960','68830','25750','88160','68120','68480','25420','02900','02900','02900','70270','68130','68130','70270','68960','25310','02905','68440','70200','70200','70200','25310','68200','68100','68130','68500','68500','02942','25260','25310','25260','70200','70200','68640','68500','25700','68480','68820','68130','68500','68480','68480','68440','68510','68480','88160','70270','70270','68440','88160','25310','68110','02946','68480','68130','68480','02906','88310','68500','02908','68540','70310','25260','70400','02902','88360','68130','25150','68480','02907','68260','70200','68480','68440','68360','68510','70200','68480','70400','25150','25260','68480','68400','70270','70200','68510','68640','68530','68480','70200','68440','25150','02904','25310','70400','68270','25250','68480','68610','25250','68840','25250','25250','02947','68540','68440','02950','25250','68130','70400','68390','02952','68610','70200','68510','70400','25310','02903','68500','68440','70200','70200','02953','70310','68480','68480','25250','02912','70270','68390','25150','02912','25190','02914','68510','68640','68510','25310','68190','68530','02950','25260','68440','68510','02953','25310','25150','68170','68500','68220','68610','68480','68480','68440','68510','02807','25260','88310','88290','70110','25150','68500','02888','68220','70200','68510','70110','70110','68270','68820','68480','68480','25190','68510','25190','02954','02889','68190','25190','25250','68500','68500','70270','70310','70200','68640','70110','70310','70200','68390','70200','68380','68190','25250','68480','25250','02882','02882','68870','68500','70110','70110','25250','02807','25190','70200','68220','25250','68730','70270','88360','25150','70310','68250','68480','70310','70200','02803','68480','70310','25190','68730','25250','70310','68510','02884','25250','25150','88250','88290','68870','70110','70310','25150','25250','68380','70200','02813','70300','25150','70200','70110','25190','25190','25190','68480','70310','02885','02857','02883','68220','70110','70110','68480','70110','68890','68250','02886','70200','88120','25250','25250','68570','25470','25470','70310','25250','68220','70200','25470','25190','68480','68730','02856','02812','25250','70310','70280','02814','25190','70300','25250','68380','70110','25250','68480','70110','68570','25190','70110','68890','68250','68230','68680','25190','02887','68380','70110','70280','25250','68140','25190','25190','70200','70280','02806','68220','70110','25470','88120','68220','68250','68220','02362','68220','02802','02855','70200','68140','88120','04118','70200','70300','68490','70280','70110','68680','68490','02364','68380','70280','25190','68490','25190','70110','02854','88120','70110','68220','02363','25190','68250','68740','25250','02800','02800','68480','04117','68128','68220','25470','70200','70200','02800','25340','02873','04124','02353','25190','70300','25340','70110','88200','04245','88120','70110','25470','02805','25470','25340','70240','25340','68140','68220','68140','04116','68220','25190','25430','68420','68490','88200','70200','04115','02853','02362','68250','68250','88340','88120','68230','04254','70300','68140','68140','02354','68740','25470','68220','25190','70300','02863','70110','25430','25470','25470','70110','04112','02718','04123','04123','02718','88400','25340','25190','70240','70110','02717','68127','04112','04105','04112','25680','25680','02360','25190','02822','04244','68128','68740','88340','68140','68140','25120','25430','70110','02852','02842','25340','68420','25340','25120','68740','25340','68128','68300','25680','68230','04253','70300','02717','25380','70240','68420','68420','25340','70240','04114','70300','70240','25470','04055','02715','04108','88400','68250','88120','70110','25120','25340','70300','68490','68740','02714','25450','04243','68330','70110','70110','04056','04104','68420','02823','02350','02338','70300','04054','04091','04030','04019','04018','04000','04002','04010','04009','04070','04075','04020','04005','70300','68420','25680','02713','04102','02864','04102','02715','70110','02714','04031','25430','02716','25340','02843','88530','25340','68250','25120','70300','88120','25340','25120','04223','02748','04051','04057','02830','04001','04106','25380','70300','88200','25470','02338','25430','88200','04107','88230','04103','25430','25430','04041','04089','04039','04089','04089','04089','04041','04039','04101','04242','70240','70240','70220','68230','68230','25380','25340','04252','04252','70240','02748','70240','25340','88530','02712','25680','88370','25430','02824','02830','04053','70000','25340','04222','68420','04059','02722','70300','04058','02345','70300','68740','88400','68127','02732','25680','02720','25380','70300','25430','70240') 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<>'494112' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

  30. 0.0001

    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

  31. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=515678 AND note_visu IN (1,3,4)

  32. 0.0001

    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 = 515678 AND W.type_id = 1) OR (W.util_id <> 515678 AND W.type_id = 2)) AND (M.post_util_id = 515678 OR M.dest_util_id = 515678) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  33. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 515678

  34. 0.0001

    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

  35. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=495949 AND note_visu IN (1,3,4)

  36. 0.0001

    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 = 495949 AND W.type_id = 1) OR (W.util_id <> 495949 AND W.type_id = 2)) AND (M.post_util_id = 495949 OR M.dest_util_id = 495949) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  37. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 495949

  38. 0.0001

    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

  39. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=135690 AND note_visu IN (1,3,4)

  40. 0.0001

    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 = 135690 AND W.type_id = 1) OR (W.util_id <> 135690 AND W.type_id = 2)) AND (M.post_util_id = 135690 OR M.dest_util_id = 135690) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  41. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 135690

  42. 0.0001

    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

  43. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=104494 AND note_visu IN (1,3,4)

  44. 0.0001

    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 = 104494 AND W.type_id = 1) OR (W.util_id <> 104494 AND W.type_id = 2)) AND (M.post_util_id = 104494 OR M.dest_util_id = 104494) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  45. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 104494

  46. 0.0001

    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

  47. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=220989 AND note_visu IN (1,3,4)

  48. 0.0001

    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 = 220989 AND W.type_id = 1) OR (W.util_id <> 220989 AND W.type_id = 2)) AND (M.post_util_id = 220989 OR M.dest_util_id = 220989) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  49. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 220989

  50. 0.0001

    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

  51. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=188529 AND note_visu IN (1,3,4)

  52. 0.0001

    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 = 188529 AND W.type_id = 1) OR (W.util_id <> 188529 AND W.type_id = 2)) AND (M.post_util_id = 188529 OR M.dest_util_id = 188529) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  53. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 188529

  54. 0.0001

    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

  55. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=90252 AND note_visu IN (1,3,4)

  56. 0.0001

    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 = 90252 AND W.type_id = 1) OR (W.util_id <> 90252 AND W.type_id = 2)) AND (M.post_util_id = 90252 OR M.dest_util_id = 90252) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  57. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 90252

  58. 0.0001

    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

  59. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=29774 AND note_visu IN (1,3,4)

  60. 0.0001

    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 = 29774 AND W.type_id = 1) OR (W.util_id <> 29774 AND W.type_id = 2)) AND (M.post_util_id = 29774 OR M.dest_util_id = 29774) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  61. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 29774

  62. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 972

  63. 0.0001

    SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`

  64. 0.0001

    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

  65. 0.0003

    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

  66. 0.0003

    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

  67. 0.0002

    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

  68. 0.0002

    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

  69. 0.0002

    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

  70. 0.0003

    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

  71. 0.0002

    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

  72. 0.0002

    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

  73. 0.0002

    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

  74. 0.0003

    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

  75. 0.0002

    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

  76. 0.0001

    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

  77. 0.0001

    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

  78. 0.0001

    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

  79. 0.0001

    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

  80. 0.0001

    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

  81. 0.0001

    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

  82. 0.0002

    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

  83. 0.0014

    SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7

  84. 0.0238

    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'

  85. 0.0175

    SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

85 requetes sql en 0.0716

Taille variable Globale : 83.23 KB