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

A louer porte velo

Autres annonces du voisin

Tout voir
Location camion camionnette

Il y a + de 30j

Il y a + de 30j

Camionette Volkswagen transporter 11 m3

300€/weekend

Anet
Service garde enfants

Il y a + de 30j

Il y a + de 30j

Babysitting vacances scolaire semaine ou

12€/heure

Anet
Location robe de mariee

Il y a + de 30j

Il y a + de 30j

A louer robe de mariee taille 36 s

300€/jour

Anet
Service chat

Il y a + de 30j

Il y a + de 30j

Garde votre chat jour et ou nuit vacance

20€/jour

Anet
Location tondeuse

Il y a + de 30j

Il y a + de 30j

Tondeuse wolf essence

30€/jour

Lommoye
Service cours informatique

Il y a + de 30j

Il y a + de 30j

Aide sur informatique

25€/heure

Anet
Location matelas gonflable

Il y a + de 30j

Il y a + de 30j

Matelas gonflable

15€/jour

Anet
Service gardiennage

Il y a + de 30j

Il y a + de 30j

Garde maison surveillance vacances absen

50€

Anet

Annonces similaires

Tout voir
Location porte velo

Il y a + de 30j

Il y a + de 30j

Porte vélo

12€/jour

La Couture-Boussey
Location porte velo

Il y a + de 30j

Il y a + de 30j

Location porte vélos taules

12€/jour

Thiverval-Grignon
Location porte velo

Il y a + de 30j

Il y a + de 30j

Porte velo x3

10€/jour

Poissy
Location porte velo
4,2/5 résa

Il y a + de 30j

Il y a + de 30j

Location d'un porte-vélos

10€/jour

Saint-Clair-sur-Epte
Location porte velo
5/5 résa

Il y a + de 30j

Il y a + de 30j

Porte Vélos (3) Barre de toit

15€/semaine

5/5 Le Vésinet
Location porte velo
5/5 résa

Il y a + de 30j

Il y a + de 30j

Porte Vélos (3) boule attelage

25€/semaine

5/5 Le Vésinet
Location porte velo
4,4/5 résa

Il y a + de 30j

Il y a + de 30j

A louer porte ski

20€/jour

Ecrosnes
Location porte velo

Il y a + de 30j

Il y a + de 30j

Porte 3 vélos attelage

20€/semaine

Bercheres-les-Pierres
Location porte velo

Il y a + de 30j

Il y a + de 30j

Porte 4 vélos attelage

20€/semaine

Bercheres-les-Pierres
Location porte velo

Il y a + de 30j

Il y a + de 30j

Porte 4 vélos crochet d'attelage

35€/semaine

Sainte-Colombe-la-Commanderie

Louer un porte-velo entre particuliers ou proposer un porte-velo 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.0003

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

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='porte-velo' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='722'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'porte-velo' 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='227'

  11. 0.0001

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

  12. 0.0001

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

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

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=722 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  18. 0.0001

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

  19. 0

    SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=314721 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 = 314721 AND W.type_id = 1) OR (W.util_id <> 314721 AND W.type_id = 2)) AND (M.post_util_id = 314721 OR M.dest_util_id = 314721) 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='314721' 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 = '558642'

  23. 0.0002

    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='314721' AND wish_id<>'558642' 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='862' 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=314721 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 = 314721

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

  28. 0.0002

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

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

  30. 0.0002

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

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

  32. 0.0002

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

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

  34. 0.0002

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

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

  36. 0.0002

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

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

  38. 0.0002

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

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

  40. 0.0002

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

  41. 0.0001

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

  42. 0.0096

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.85*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.85*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.55- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.400339197041 AND ville_latitude_deg<49.299660802959 AND ville_longitude_deg>0.86665176374622 AND ville_longitude_deg<2.2333482362538 HAVING distance <= 50 ORDER BY distance ASC

  43. 0.005

    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 ('28560','28260','28560','78910','28410','78550','78790','78790','28260','78910','78980','28260','28260','28260','78910','28260','28410','27540','78550','78111','78550','28410','28260','78980','78790','78790','78550','28260','28260','28410','78980','28410','28410','28260','27530','78910','78910','78790','78550','78550','28410','78980','78910','78980','78790','27780','78200','28570','28410','27640','78200','27730','78200','28410','28500','78790','27750','78910','78950','78790','78200','78200','78200','78910','27730','78980','78910','27220','28520','28520','28500','78200','28500','78113','27730','78930','78930','78790','27220','78790','27710','78940','27220','78980','78200','27810','78890','27640','78113','78113','27220','78200','78770','78930','28500','78930','78930','27220','78200','78113','28210','28210','78940','78270','27640','28500','27220','78113','78200','28500','78770','27650','78113','78270','27220','78490','78930','78490','27120','28500','78710','27120','28500','78200','78711','27650','28500','78770','27220','78930','27220','27220','78770','27120','28500','78270','78580','28100','78490','28210','28210','78490','78270','78270','78200','27120','78520','27220','78770','78770','78770','27320','27120','78125','78520','28500','27220','27220','78270','28210','78270','78440','27120','28500','27650','78270','28210','27120','28210','27120','78650','78490','78490','27770','78490','78270','28210','27220','78125','78610','27220','27120','78520','27120','28210','28210','78270','28210','78970','78680','27120','78840','27320','78270','28210','28500','27120','28500','78520','78580','78650','78490','78490','27220','78270','28500','78124','27220','78640','78270','78410','78410','27220','78490','28500','78125','78126','78124','27220','28380','27120','78440','27620','78490','27120','28500','78125','27320','28500','78640','28210','78580','78580','27120','78440','78440','27220','78410','78840','28210','78440','78640','28500','78610','27220','78640','28130','28210','27950','27620','28350','27620','78270','27200','28130','27120','27930','27950','95780','78410','27930','27120','95780','78760','27320','78690','78850','27320','78440','95780','78440','27120','28500','27220','78820','95510','27120','28170','78610','27220','28210','95510','78125','28230','27930','28130','78580','27930','27120','27320','78810','95510','78440','28500','78121','78310','27930','28270','28270','27950','78410','27950','95510','28130','27120','27120','28170','78125','27240','78920','78310','28170','28500','78125','78630','95510','78250','78370','78610','78690','27620','28130','27320','28230','78250','27930','27240','27930','78990','27120','28170','27950','78440','78120','78250','78810','27630','27950','27240','27180','28350','95450','95510','27950','78130','78440','27120','78125','95710','78440','28170','78320','27240','78130','78250','27920','27920','28270','78450','28130','27930','78250','27630','28130','78340','27600','27950','27930','27510','95710','27950','78630','78125','78250','95420','95420','28320','27930','78320','27930','28170','78320','27930','28130','27510','95450','28130','28130','27510','27630','28130','95420','78190','27490','28270','28170','78860','78450','78540','27570','78125','27930','27940','28300','27240','78240','28170','27000','78740','78390','95420','27490','95420','78670','78670','95450','78480','27180','95710','27600','28300','27630','27180','27510','27240','27570','28300','78125','27930','95450','78740','78720','27630','27930','27240','78240','95420','27180','27630','28320','28320','78510','28270','95450','27600','95450','27930','27240','27940','78470','27570','27240','78180','78590','95180','95450','78720','78720','78330','27240','27490','28320','95420','27940','27600','27240','95450','28170','78720','95420','78955','27510','28300','28130','78120','27630','28270','27930','28300','27240','95420','27700','22680','78300','95000','78590','78620','78720','28170','78112','27630','28170','95450','78210','78960','28270','78570','95770','28300','27490','95420','95450','78120','27570','27600','95420','28320','27930','95800','27180','27180','78470','27190','78460','28300','78280','78870','27930','78160','27930','27420','27600','95450','27240','78750','28300','95420','78100','27940','27930','27490','27420','28700','28190','95280','28270','78260','95450','27510','28270','78114','28170','78660','95770','95770','28700','27180','28270','27600','27240','22870','78460','27930','28700','78570','78230','27160','95650','27930','27930','95490','95450','27510','27190','28700','28190','28300','27190','95450','27600','91470','27190','60240','28270','27130','28700','95450','27420','27700','27190','78780','95750','95640','95420','27240','78430','78150','78560','27190','27190','78110','95650','95650','27720','78830','27180','95000','78730','27930','27930','78150','28170','27700','28300','78730','78117','28300','27600','60240','27940','78470','27130','28190','27700','27700','28250','27510','27420','27160','78290','78380','95650','27930','27400','28300','78660','78700','91470','27190','95000','28300','28250','95640','95640','27940','60240','78117','91470','27160','78000','28250','27420','27870','78600','27190','60240','78730','78730','27130','28170','78530','78350','28700','27400','27930','78170','14380','78830','78400','27160','91190','60240','27400','95610','95830','27160','60240','27400','27420','78360','27420','28000','27400','27400','27400','27430','28300','28700','27700','95520','27930','27190','27180','28300','28700','28250','27110','95750','28270','91470','60240','27700','60240','27190','95830','91190','28270','78600','27160','27190','60240','78220','27700','27180','92420','92430','28190','95650','27720','28300','28250','27400','95300','28190','95640','78350','78660','91400','27190','27150','92380','27420','78660','28630','78730','28300','27160','27150','91940','28270','91190','78140','28110','27400','27700','95300','28700','60240','78420','27190','27190','78660','95310','91400','27130','92410','28270','27700','27400','28700','95640','91410','28190','78500','95640','92500','92310','60240','27110','92000','28630','27720','92370','60240','28700','91470','95810','28250','27150','95220','27190','95530','78800','91470','95640','91440','27150','27150','95810','27420','28630','27150','27190','28630','28600','27430','60240','27700','95370','27400','27400','27190','95480','91410','27160','92210','27180','95300','78660','27160','91940','91640','60240','27430','27430','27430','27160','91410','27110','27190','91530','91640','91400','91430','28190','27400','27110','60240','60240','28190','60240','27430','91940','95870','28190','95240','28190','27430','27110','27110','91410','27830','91640') AND fami_id='5' AND cate_id='227' AND type_id='1' AND ssrubr_id='722' AND wish_id<>'558642' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

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

  45. 0.0001

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

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

  47. 0.0002

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

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

  49. 0.0001

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

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

  51. 0.0002

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

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

  53. 0.0001

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

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

  55. 0.0002

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

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

  57. 0.0001

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

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

  59. 0.0002

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

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

  61. 0.0001

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

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

  63. 0.0003

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

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

  65. 0.0002

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

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

  67. 0.0001

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

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

  69. 0.0002

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

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

  71. 0.0001

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

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

  73. 0.0001

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

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

  75. 0.0002

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

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

  77. 0.0001

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

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

  79. 0.0002

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

  80. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 722

  81. 0

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

  82. 0.0002

    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

  83. 0.0004

    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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  101. 0.0017

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

  102. 0.0357

    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'

  103. 0.03

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

103 requetes sql en 0.0972

Taille variable Globale : 83.32 KB