Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Valise a roulettes

Autres annonces du voisin

Tout voir
Service multi services
Service : multi services

Mery-sur-Oise 95540

Service : bricolage
Profil du voisin
Nicolas G Voisin vérifié
5.0 100% fiable

Mery-sur-Oise 95540

15€/h

Demander ce bricoleur
5.0 100%
Service tonte de pelouse
Service : tonte de pelouse

Mery-sur-Oise 95540

Service : tonte de la pelouse
Profil du voisin
Nicolas G Voisin vérifié
5.0 100% fiable

Mery-sur-Oise 95540

20€/h

Demander une tonte
5.0 100%
Service montage de meubles
Service : montage de meubles

Mery-sur-Oise 95540

Service : montage de meuble
Profil du voisin
Nicolas G Voisin vérifié
5.0 100% fiable

Mery-sur-Oise 95540

25€/h

Demander ce monteur
5.0 100%
Location nettoyeur haute pression
Location : nettoyeur haute pression

Mery-sur-Oise 95540

Nettoyeur haute pression
Profil du voisin
Nicolas G Voisin vérifié
5.0 100% fiable

Mery-sur-Oise 95540

15€/jr

Louer le karcher
5.0 100%
Location aspirateur souffleur
Location : aspirateur souffleur

Mery-sur-Oise 95540

Souffleur
Profil du voisin
Nicolas G Voisin vérifié
5.0 100% fiable

Mery-sur-Oise 95540

25€/jr

Louer le souffleur
5.0 100%
Location broyeur a vegetaux
Location : broyeur a vegetaux

Mery-sur-Oise 95540

Broyeur a végétaux
Profil du voisin
Nicolas G Voisin vérifié
5.0 100% fiable

Mery-sur-Oise 95540

20€/jr

Louer le broyeur
5.0 100%
Location ponceuse
Location : ponceuse

Mery-sur-Oise 95540

Ponceuse a plafond
Profil du voisin
Nicolas G Voisin vérifié
5.0 100% fiable

Mery-sur-Oise 95540

25€/jr

Louer la ponceuse
5.0 100%
Location decolleuse de papier peint
Location : decolleuse de papier peint

Mery-sur-Oise 95540

Machine a décollé papier peint
Profil du voisin
Nicolas G Voisin vérifié
5.0 100% fiable

Mery-sur-Oise 95540

12€/jr

Louer la décolleuse
5.0 100%
Location etais de macon
Location : etais de macon

Mery-sur-Oise 95540

Petit étais d'intérieur
Profil du voisin
Nicolas G Voisin vérifié
5.0 100% fiable

Mery-sur-Oise 95540

6€/jr

Louer l'étais
5.0 100%
Location cage transport animaux
Location : cage transport animaux

Mery-sur-Oise 95540

Cage a chat
Profil du voisin
Nicolas G Voisin vérifié
5.0 100% fiable

Mery-sur-Oise 95540

9€/jr

Louer la cage
5.0 100%
Location tronconneuse
Location : tronconneuse

Méry-sur-Oise 95540

Tronçonneuse a bois
Profil du voisin
Nicolas G Voisin vérifié
5.0 100% fiable

Méry-sur-Oise 95540

35€/jr

Louer la tronçonneuse
5.0 100%
Service nettoyage
Service : nettoyage

Mery-sur-Oise 95540

Lavage terrasse au jet a haute pression
Profil du voisin
Nicolas G Voisin vérifié
5.0 100% fiable

Mery-sur-Oise 95540

20€/h

Demander un nettoyage
5.0 100%
Location pistolet a colle
Location : pistolet a colle

Mery-sur-Oise 95540

Un pistolet a colle chaude
Profil du voisin
Nicolas G Voisin vérifié
5.0 100% fiable

Mery-sur-Oise 95540

9€/jr

Louer le pistolet
5.0 100%
Location perforateur
Location : perforateur

Mery-sur-Oise 95540

Perceuse a béton
Profil du voisin
Nicolas G Voisin vérifié
5.0 100% fiable

Mery-sur-Oise 95540

10€/jr

Louer le perforateur
5.0 100%
Location scie circulaire
Location : scie circulaire

Mery-sur-Oise 95540

Scie circulaire filaire
Profil du voisin
Nicolas G Voisin vérifié
5.0 100% fiable

Mery-sur-Oise 95540

10€/jr

Louer la scie
5.0 100%

Annonces similaires

Tout voir
Location valise
Location : valise

Rosny-sur-Sei... 78710

Loue vanity case
Profil du voisin
Celine G

Rosny-sur-Seine 78710

5€/sem

Louer la valise
Location valise
Location : valise

Saint-Denis 93200

Location valise
Profil du voisin
Minouche D

Saint-Denis 93200

25€/sem

Louer la valise
Location valise
Location : valise

Noisy-le-Gran... 93160

Loue grosse valise
Profil du voisin
Cyrille O Voisin vérifié
5.0 100% fiable

Noisy-le-Grand 93160

20€/jr

Louer la valise
5.0 100%
Location valise
Location : valise

Paris 75012

Petite valise cabine
Profil du voisin
Alexandra R Voisin vérifié

Paris 75012

25€/sem

Louer la valise
Location valise
Location : valise

Pavillons-sou... 93320

Valise à louer
Profil du voisin
Mira M

Pavillons-sous-Bois 93320

25€/sem

Louer la valise
Location valise
Location : valise

Sarcelles 95200

Petite valise à roulette
Profil du voisin
Laïla M

Sarcelles 95200

25€/sem

Louer la valise
Location valise
Location : valise

Levallois-Per... 92300

Location valise xl grand volume
Profil du voisin
Sabrina Q Voisin vérifié

Levallois-Perret 92300

25€/sem

Louer la valise
Location valise
Location : valise

Courbevoie 92400

Sac kipsta 40 l
Profil du voisin
Kévin L

Courbevoie 92400

15€/sem

Louer la valise
Location valise
Location : valise

Paris 75004

Grande valise
Profil du voisin
Alexiane Voisin vérifié
100% fiable

Paris 75004

50€/sem

Louer la valise
100%
Location valise
Location : valise

Saint-Ouen 93400

Location valise delsey rigide
Profil du voisin
Dahiss P

Saint-Ouen 93400

15€/jr

Louer la valise

Louer une valise entre particuliers ou proposer une valise 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='472371'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='valise' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='1083'

  4. 0.0001

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

  5. 0.0001

    SELECT c.cate_id, 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='93'

  6. 0

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

  7. 0.0002

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='271885' 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` = 271885

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

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

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

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

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

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

  24. 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 (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.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 (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 = 472371

  30. 0.0001

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

  31. 0.0001

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

  32. 0

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

  33. 0

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

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

  35. 0.0001

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

  36. 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 = '472371'

  37. 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='271885' AND wish_id<>'472371' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  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='595' 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=271885 AND note_visu IN (1,3,4)

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

  41. 0.0002

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

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

  43. 0.0001

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

  44. 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='600' LIMIT 0,1

  45. 0.0001

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

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

  47. 0.0001

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

  48. 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='6' LIMIT 0,1

  49. 0.0001

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

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

  51. 0.0001

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

  52. 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='44' LIMIT 0,1

  53. 0.0001

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

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

  55. 0.0001

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

  56. 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='1142' LIMIT 0,1

  57. 0.0001

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

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

  59. 0.0001

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

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

  61. 0.0001

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

  62. 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='970' LIMIT 0,1

  63. 0.0001

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

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

  65. 0.0001

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

  66. 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='29' LIMIT 0,1

  67. 0.0001

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

  68. 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='33' LIMIT 0,1

  69. 0.0001

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

  70. 0.0001

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

  71. 0.0059

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.0667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.0667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.617039197041 AND ville_latitude_deg<49.516360802959 AND ville_longitude_deg>1.5136765190362 AND ville_longitude_deg<2.8863234809638 HAVING distance <= 50 ORDER BY distance ASC

  72. 0.0011

    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 (95540,95430,95630,95740,95430,95840,95760,95150,95550,95840,95560,95250,95620,95480,95290,95300,95590,95310,95320,95560,95300,95390,95690,95300,95570,95220,95130,95300,95680,95690,95660,95560,95560,95260,95590,95610,95240,95370,95810,95260,95690,95130,95600,95520,95570,95650,95690,95590,95580,95580,95000,95330,95340,95120,95570,95340,95530,95810,95000,95270,95110,60230,95810,78700,95230,95650,95270,78780,95160,95350,95570,95210,95218,95460,95490,78500,95270,95810,95340,95280,95810,78570,95170,78600,95100,95270,95650,95820,95880,95270,95350,60530,95410,95830,95440,95720,95650,95650,95720,78260,95810,60540,60540,95870,95800,93800,95400,95200,78570,78600,60820,95270,95830,95360,95000,60530,93430,95450,95270,60110,95810,95720,95640,93380,60530,92230,78800,60540,78420,95270,95180,60110,60540,95640,95850,78360,92700,78510,92270,95450,92390,93450,60530,78955,95270,78740,95720,95190,95640,95850,95190,95450,78480,95400,95640,92600,60119,78300,92000,60540,95270,95270,95450,93240,60530,93200,93210,60530,92250,78740,60460,60110,92400,95640,78540,95140,60260,95450,60240,78110,92300,95450,78670,78670,95640,95640,95270,60530,78230,92110,60119,95450,95190,95500,60175,92500,78100,60270,93440,95500,60570,95380,78400,60460,95500,93400,92200,95470,78560,60119,95450,93120,93300,78250,60580,60110,93350,95640,95450,95670,78130,95500,78750,60340,60173,78240,95380,60570,92800,92150,95750,60730,78130,95450,78250,78112,78290,78380,60730,78250,78240,60240,60340,78630,78430,78250,93700,93150,93500,78160,60730,60560,95700,60149,78620,95450,78250,95450,95380,78170,78920,60240,60500,78630,78410,95450,95450,60740,60730,95750,60660,92380,92210,93310,60110,75001,75000,75002,75003,75004,75005,75006,75007,75008,75009,75010,75011,75012,75013,75014,75015,75016,75017,75018,75019,75020,75116,60790,60660,60660,60520,60240,60500,60250,78870,78440,95380,60240,95470,78250,95380,60660,60660,78590,93000,92430,92420,60240,60570,60730,92100,60430,60240,60790,93600,60240,60160,95420,95450,78580,93260,93230,78820,60240,60790,78150,95470,78410,93420,95470,78440,93140,92410,92170,95420,60520,93170,60240,78150,60790,78860,60250,60240,95420,92310,78410,78440,60160,78440,78810,93100,60240,60790,60128,78590,77990,78121,93130,92130,60240,60300,60300,78580,93270,60790,92240,78450,95420,92190,92360,78440,60250,92120,77230,78450,78440,60520,60240,94250,60240,60180,94300,78126,78810,60300,78580,93320,93340,60430,92370,60128,60240,78140,77990,78410,78410,60660,78220,60250,60250,60430,78330,93250,78000,92140,93290,60240,92320,60100,60240,94270,95510,60240,93110,94160,77230,78580,93190,93390,92220,95420,95420,78124,93410,78680,94200,94205,78440,78210,94110,78970,95420,78440,60300,60430,60300,78440,60290,60870,95420,60430,78124,93220,78850,94120,77290,77230,60250,92350,78340,94220,60240,94800,93360,92260,92330,60250,60240,60240,60290,78390,93370,94170,77181,93470,60240,60390,60240,95510,95420,60390,60250,94240,94230,94231,94232,94233,94234,94235,94236,94237,94238,94239,78440,60390,60290,94130,60290,78370,60550,95420,60370,78350,78440,92340,60430,60370,60240,95420,94410,94140,78350,78530,92290,60390,60250,77270,60140,60240,60370,60430,94340,78640,95510,77230,60240,60290,95510,94700,60390,78650,93330,77230,60240,60700,60300,60240,78770,77181,78580,60870,60240,60290,78190,94400,60250,78280,94360,93460,77290,60300,78930,94550,60134,60134,91570,77280,77230,78520,60940,78640,60950,60140,78180,91370,77500,60240,78520,78117,78770,78930,77410,60590,94320,92160,95420,93160,60940,78640,94500,60000,94260,60590,60870,60300,95420,60140,60390,78990,94350,95780,78200,60330,60240,77230,78520,78770,60140,77410,94100,94210,94340,78960,94150,60300,60300,94600,78640,78200,78711,94000,60240,91430,91430,78930,60930,91400,60950,60590,77230,78650,60430,60600,95710,60000,78930,91300,94430,60240,60810,77410,77177,78770,60390,77230,60600,78770,95510,60940,78117,60810,78930,77420,78770,95710,77230,60700,60600,77410,94310,94390,78770,60590,60590,60140,78114,91320,78760,60810,60390,78490,94420,78470,27140,77410,78790,78790,78840,95780,60510,60700,60590,91120,60510,60510,91190,78310,94380,77230,78200,78930,78930,60155,91190,78470,60510,60600,60840,60240,78320,77360,60590,77186,95770,78490,60950,78200,77185,60810,60330,60510,78270,95510,60700,94460,94290,78490,77230,60300,95770,95770,27630,60700,60140,78490,78490,94490,94880,94880,95710,77200,77400,78790,60390,60600,60000,60510,60390,60600,91550,91400,78320,91440,78310,27630,91140,78200,91160,60590,27720,78200,77184,77410,78790,60650,94370,94380,95780,94190,77230,60600,91380,91160,60330,78270,27420,27630,60650,91200,60810,27830,78200,78490,60155,60000,77410,78470,77165,78520,27720,77400,78910,78910,60700,60510,91420,77165,78710,27140,77400,78790,94480,77340,60590,78690,94470,78490,78490,94510,78200,60000,78460,60440,78200,94450,60000,60600,60410,91140,27630,77600,77400,78200,77410,91940,77090,77183,78910,60700,77400,78270,91940,91190,91160,60600,60810,78320,91560,78890,60510,78790,77165,77165,60650,78720,78720,78940,27630,77410,60850,78200,60810,60410,60700,60600,77178,91270,77600,77600,27620,78270,78840,77400,78910,60330,77165,77400,91470,60600,60650,27870,78490,77680,60440,60440,27420,60800,77410,60510,77600,60590,91940,60510,77450,60510,27660,27660,60410,78690,91330,78490,91230,78460,91260,78910,60190,60190,91160,91400,60000,77178,60190,27620,78790,60650,94440,77410,78980,78270,60600,78940,60600,91360,78790,60710,60650,78720,91210,60130,91360,91470,27630,77450,78200,60600,60440,78910,60000,91390,91600,77164,77600,60190,60130,77144,94440,27140,27420,77144,77700,27630,91800,78270,60510,78200,60510,91620,60190,60590,60130,77450,78111,91170,60510,60510,91640,77122,91620,60410,60680,60480,60800,60650,78610,91700,27420,78910,27150,77135,91470,27630,60850,27150,60710,94440,77450,77165,77165,60650,78270,78270,77700,60112,60650,91470,78720,60440,77124,60410,77330,77600,60190,60130,27150,77170,77150,78980,60190,60190,78910,60112,78610,94520,94520,27420,60800,60510,91350,60510,91460,78980,60800,60480,91310,91310,60130,60130,91860,27510,27420,91310,27620,60440,60440,78270,77450,60410,60850,91240,77150,60320,27860,78550,27620,27140,60590,78270,60130,77700,78550,91000,91130,27150,60126,78490,27510,60112,91800,77450,91700,60850,60130,60130,60130,27510,78790,78610,77124,60650,60130,27150,91700,60112,77139,60440,77450,91450,77139,60126,78790,60112) AND fami_id='5' AND cate_id='93' AND type_id='1' AND ssrubr_id='1083' AND wish_id<>'472371' AND wish_url='' ORDER BY rand() LIMIT 0,10

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

  74. 0.0001

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

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

  76. 0.0001

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

  77. 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='1083' LIMIT 0,1

  78. 0.0001

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

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

  80. 0.0001

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

  81. 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='1083' LIMIT 0,1

  82. 0.0001

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

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

  84. 0.0001

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

  85. 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='1083' LIMIT 0,1

  86. 0.0001

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

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

  88. 0.0002

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

  89. 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='1083' LIMIT 0,1

  90. 0.0001

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

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

  92. 0.0001

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

  93. 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='1083' LIMIT 0,1

  94. 0.0001

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

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

  96. 0.0001

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

  97. 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='1083' LIMIT 0,1

  98. 0.0001

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

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

  100. 0.0001

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

  101. 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='1083' LIMIT 0,1

  102. 0.0001

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

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

  104. 0.0001

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

  105. 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='1083' LIMIT 0,1

  106. 0.0001

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

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

  108. 0.0001

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

  109. 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='1083' LIMIT 0,1

  110. 0.0001

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

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

  112. 0.0001

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

  113. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1083

  114. 0.0009

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

  115. 0

    SELECT count(*) as nbwish FROM wish

  116. 0.0533

    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

116 requetes sql en 0.0739

Taille variable Globale : 79.51 KB