Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Location : Aspirateur sans sac

Autres annonces du voisin

Tout voir
Service montage video
Service montage video
MONTAGE VIDéO DE TOUT TYPE
Profil du voisin
Mathias G

Aubagne 13400

50€

Location colocation appartement
Location colocation appartement

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE APPARTEMENT
Profil du voisin
Mathias G

Aubagne 13400

450€/m

Service cours photo
Service cours photo
COURS DE MONTAGE VIDéO / PHOTOGRAPHIE
Profil du voisin
Mathias G

Aubagne 13400

20€/h

Location magnetoscope
Location magnetoscope
LECTEUR DVD + CABLE HDMI
Profil du voisin
Mathias G

Aubagne 13400

-- €

Location ordinateur
Location ordinateur
ORDINATEUR POUR RENDU & EXPORT LOGICIEL
Profil du voisin
Mathias G

Aubagne 13400

-- €

Service aide demenageur
Service aide demenageur
SERVICE : DéMéNAGEMENT
Profil du voisin
Mathias G

Aubagne 13400

-- €

Location matelas de voyage
Location matelas de voyage
MATELAS GONFLABLE & POMPE & SAC
Profil du voisin
Mathias G

Aubagne 13400

-- €

Location micro ondes
Location micro ondes
LOCATION : MICRO-ONDES
Profil du voisin
Mathias G

Aubagne 13400

-- €

Location four
Location four

Demande il y a + de 30j

Il y a + de 30j

LOCATION MINI FOUR
Profil du voisin
Mathias G

Aubagne 13400

-- €

Location imprimante
Location imprimante
LOCATION : IMPRESSION
Profil du voisin
Mathias G

Aubagne 13400

-- €

Location mixeur
Location mixeur
LOCATION MIXEUR MULTIFONCTION
Profil du voisin
Mathias G

Aubagne 13400

-- €

Location appareil a raclette
Location appareil a raclette
LOCATION MINI APPAREIL A RACLETTE
Profil du voisin
Mathias G

Aubagne 13400

-- €

Annonces similaires

Tout voir
Location aspirateur
Location aspirateur
ASPIRATEUR EAU ET POUSSIèRE
Profil du voisin
Hotel D

Marseille 13001

12€/j

Location aspirateur
Location aspirateur
LAVAGE AUTO
Profil du voisin
Joseph M

Marignane 13700

20€/j

Location aspirateur
Location aspirateur
LOCATION : KARCHER 120 BARS.
Profil du voisin
Voisin #236769

Marseille 13003

20€/j

Location aspirateur
Location aspirateur
ASPIRATEUR à EAU
Profil du voisin
Christophe H Voisin vérifié
5.0 86% fiable

Marseille 13009

20€/j

5.0 86%
Location aspirateur
Location aspirateur
ASPIRATEUR à SAC
Profil du voisin
Elodie J Voisin vérifié
1.0 67% fiable

Brignoles 83170

5€/j

1.0 67%
Location aspirateur
Location aspirateur
ASPIRATEUR CHANTIER
Profil du voisin
Lolo A

Brignoles 83170

20€/j

Location aspirateur
Location aspirateur
ASPIRATEUR KARCHER
Profil du voisin
Nathalie Q Voisin vérifié
100% fiable

Cuers 83390

20€/j

100%
Location aspirateur
Location aspirateur
LOCATION ASPIRATEUR DE CHANTIER
Profil du voisin
Romain S Voisin vérifié
5.0 100% fiable

Bandol 83150

15€/j

5.0 100%
Location aspirateur
Location aspirateur
ASPIRATEUR SOUFFLEUR BROYEUR
Profil du voisin
Leslie G Voisin vérifié
5.0 100% fiable

Six-Fours-les-Plages 83140

30€/j

5.0 100%
Location aspirateur
Location aspirateur
ASPIRATEUR
Profil du voisin
Rosalie F

Marseille 13008

20€/j

Louer un aspirateur entre particuliers ou proposer un aspirateur en location.

Poster une annonce

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.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='350368'

  3. 0

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='aspirateur' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='746'

  4. 0.0001

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

  5. 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='110'

  6. 0

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

  7. 0.0001

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

  8. 0

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

  9. 0

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

  10. 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

  11. 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

  12. 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 (88) ORDER BY ssrubr_order ASC

  13. 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 (81) ORDER BY ssrubr_order ASC

  14. 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 (110) ORDER BY ssrubr_order ASC

  15. 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 (227) ORDER BY ssrubr_order ASC

  16. 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 (176) ORDER BY ssrubr_order ASC

  17. 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 (79) ORDER BY ssrubr_order ASC

  18. 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 (208) ORDER BY ssrubr_order ASC

  19. 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 (228) ORDER BY ssrubr_order ASC

  20. 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 (207) ORDER BY ssrubr_order ASC

  21. 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

  22. 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

  23. 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

  24. 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

  25. 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

  26. 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

  27. 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

  28. 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

  29. 0.0001

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 350368

  30. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=746 LIMIT 1

  31. 0.0001

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

  32. 0.0001

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

  33. 0

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

  34. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 137779 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''

  35. 0.0002

    SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137779 AND W.type_id = 1) OR (W.util_id != 137779 AND W.type_id = 2)) AND (`post_util_id` = 137779 OR `dest_util_id` = 137779) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  36. 0.0001

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

  37. 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 = '350368'

  38. 0.0002

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id 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='137779' AND wish_id<>'350368' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  39. 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='1005' LIMIT 0,1

  40. 0.0001

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

  41. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137779 AND W.type_id = 1) OR (W.util_id != 137779 AND W.type_id = 2)) AND (`post_util_id` = 137779 OR `dest_util_id` = 137779) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  42. 0.0002

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

  43. 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='504' LIMIT 0,1

  44. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137779 AND W.type_id = 1) OR (W.util_id != 137779 AND W.type_id = 2)) AND (`post_util_id` = 137779 OR `dest_util_id` = 137779) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  45. 0.0002

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

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

  47. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137779 AND W.type_id = 1) OR (W.util_id != 137779 AND W.type_id = 2)) AND (`post_util_id` = 137779 OR `dest_util_id` = 137779) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  48. 0.0002

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

  49. 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='792' LIMIT 0,1

  50. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137779 AND W.type_id = 1) OR (W.util_id != 137779 AND W.type_id = 2)) AND (`post_util_id` = 137779 OR `dest_util_id` = 137779) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  51. 0.0001

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

  52. 0

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

  53. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137779 AND W.type_id = 1) OR (W.util_id != 137779 AND W.type_id = 2)) AND (`post_util_id` = 137779 OR `dest_util_id` = 137779) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  54. 0.0001

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

  55. 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='996' LIMIT 0,1

  56. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137779 AND W.type_id = 1) OR (W.util_id != 137779 AND W.type_id = 2)) AND (`post_util_id` = 137779 OR `dest_util_id` = 137779) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  57. 0.0001

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

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

  59. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137779 AND W.type_id = 1) OR (W.util_id != 137779 AND W.type_id = 2)) AND (`post_util_id` = 137779 OR `dest_util_id` = 137779) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  60. 0.0001

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

  61. 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

  62. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137779 AND W.type_id = 1) OR (W.util_id != 137779 AND W.type_id = 2)) AND (`post_util_id` = 137779 OR `dest_util_id` = 137779) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  63. 0.0001

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

  64. 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='839' LIMIT 0,1

  65. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137779 AND W.type_id = 1) OR (W.util_id != 137779 AND W.type_id = 2)) AND (`post_util_id` = 137779 OR `dest_util_id` = 137779) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  66. 0.0001

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

  67. 0

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

  68. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137779 AND W.type_id = 1) OR (W.util_id != 137779 AND W.type_id = 2)) AND (`post_util_id` = 137779 OR `dest_util_id` = 137779) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  69. 0.0001

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

  70. 0

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

  71. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137779 AND W.type_id = 1) OR (W.util_id != 137779 AND W.type_id = 2)) AND (`post_util_id` = 137779 OR `dest_util_id` = 137779) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  72. 0.0001

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

  73. 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='688' LIMIT 0,1

  74. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137779 AND W.type_id = 1) OR (W.util_id != 137779 AND W.type_id = 2)) AND (`post_util_id` = 137779 OR `dest_util_id` = 137779) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  75. 0.0002

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

  76. 0.0001

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

  77. 0.0021

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((43.2833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((43.2833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((5.56667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>42.833639197041 AND ville_latitude_deg<43.732960802959 AND ville_longitude_deg>4.9489744915506 AND ville_longitude_deg<6.1843655084494 HAVING distance <= 50 ORDER BY distance ASC

  78. 0.0022

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id 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 (13400,13470,13821,13830,13420,13260,13360,13190,13600,13112,13780,13380,13950,13124,13390,13720,13600,13119,83640,13720,13780,13015,13014,13013,13012,13011,13010,13005,13008,13001,13007,13003,13004,13006,13009,13000,13016,13002,13105,83640,83270,13850,13109,13710,83740,83330,13790,83860,13120,13240,13530,83330,13320,13790,13480,83150,13790,13590,13100,83870,13170,83170,13100,13100,83330,83110,83470,13740,83910,13114,83190,83136,13180,13126,13090,13080,13098,13100,13290,13540,13100,83470,83140,13820,83183,13730,83470,13700,83170,83136,13127,83500,13620,83136,13220,83470,13340,83000,83200,83100,13122,83210,13510,13880,13770,83136,13960,13130,83149,83210,83160,83430,13650,13111,13490,83210,83136,83170,83560,83560,83210,83130,83210,13860,83390,83560,83119,83220,83136,83136,83170,83560,13760,13580,83260,83170,83670,13500,13117,13610,84120,83143,13115,83390,83670,13840,83136,83390,13610,83570,84120,13410,83320,83670,13920,84120,83400,13680,83560,83560,83570,13110,83890,84530,13330,83660) AND fami_id='5' AND cate_id='110' AND type_id='1' AND ssrubr_id='746' AND wish_id<>'350368' AND wish_url='' ORDER BY rand() LIMIT 0,10

  79. 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='746' LIMIT 0,1

  80. 0.0001

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

  81. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 424504 AND W.type_id = 1) OR (W.util_id != 424504 AND W.type_id = 2)) AND (`post_util_id` = 424504 OR `dest_util_id` = 424504) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  82. 0.0001

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

  83. 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='746' LIMIT 0,1

  84. 0.0001

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

  85. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 540297 AND W.type_id = 1) OR (W.util_id != 540297 AND W.type_id = 2)) AND (`post_util_id` = 540297 OR `dest_util_id` = 540297) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  86. 0.0001

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

  87. 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='746' LIMIT 0,1

  88. 0.0001

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

  89. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 236769 AND W.type_id = 1) OR (W.util_id != 236769 AND W.type_id = 2)) AND (`post_util_id` = 236769 OR `dest_util_id` = 236769) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  90. 0.0001

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

  91. 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='746' LIMIT 0,1

  92. 0.0001

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

  93. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 300822 AND W.type_id = 1) OR (W.util_id != 300822 AND W.type_id = 2)) AND (`post_util_id` = 300822 OR `dest_util_id` = 300822) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  94. 0.0001

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

  95. 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='746' LIMIT 0,1

  96. 0.0001

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

  97. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 280530 AND W.type_id = 1) OR (W.util_id != 280530 AND W.type_id = 2)) AND (`post_util_id` = 280530 OR `dest_util_id` = 280530) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  98. 0.0002

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

  99. 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='746' LIMIT 0,1

  100. 0.0001

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

  101. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 351828 AND W.type_id = 1) OR (W.util_id != 351828 AND W.type_id = 2)) AND (`post_util_id` = 351828 OR `dest_util_id` = 351828) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  102. 0.0002

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

  103. 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='746' LIMIT 0,1

  104. 0.0001

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

  105. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 374643 AND W.type_id = 1) OR (W.util_id != 374643 AND W.type_id = 2)) AND (`post_util_id` = 374643 OR `dest_util_id` = 374643) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  106. 0.0002

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

  107. 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='746' LIMIT 0,1

  108. 0.0001

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

  109. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 287180 AND W.type_id = 1) OR (W.util_id != 287180 AND W.type_id = 2)) AND (`post_util_id` = 287180 OR `dest_util_id` = 287180) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  110. 0.0002

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

  111. 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='746' LIMIT 0,1

  112. 0.0001

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

  113. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 247269 AND W.type_id = 1) OR (W.util_id != 247269 AND W.type_id = 2)) AND (`post_util_id` = 247269 OR `dest_util_id` = 247269) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  114. 0.0002

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

  115. 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='746' LIMIT 0,1

  116. 0.0001

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

  117. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 328210 AND W.type_id = 1) OR (W.util_id != 328210 AND W.type_id = 2)) AND (`post_util_id` = 328210 OR `dest_util_id` = 328210) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  118. 0.0002

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

  119. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 746

  120. 0.0017

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

  121. 0

    SELECT count(*) as nbwish FROM wish

  122. 0.0512

    SELECT note.*, post.util_prenom as postp, post.util_nom as postn, dest.util_prenom as destp, dest.util_nom as destn, w.wish_id, w.wish_desc, w.fami_id FROM note, util_info dest, util_info post, wish w WHERE note.wish_id=w.wish_id AND note.post_util_id=post.util_id AND note.dest_util_id=dest.util_id AND note_visu IN (1,2,3,4) AND post_util_id<>'7' ORDER BY note_date DESC, note_hour DESC

122 requetes sql en 0.07

Taille variable Globale : 79.6 KB