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

Montage meuble

Autres annonces du voisin

Tout voir
Location disqueuse

Il y a + de 30j

Il y a + de 30j

Location disqueuse electrique 230 MM

20€/jour

Vergeze
Location aspirateur

Il y a + de 30j

Il y a + de 30j

Aspirateur chantier HILTI

20€/jour

Vergèze
Location scie sauteuse

Il y a + de 30j

Il y a + de 30j

Scie sauteuse professionnelle

15€/jour

Vergeze
Location scie circulaire

Il y a + de 30j

Il y a + de 30j

Scie circulaire a batterie HILTI

20€/jour

Vergeze
Location coupe bordures

Il y a + de 30j

Il y a + de 30j

Coupe bordure

15€/jour

Vergeze
Location porte velo

Il y a + de 30j

Il y a + de 30j

Porte velo attelage

20€/jour

Vergeze
Location nettoyeur vapeur

Il y a + de 30j

Il y a + de 30j

Location nettoyeur polti

25€/jour

Vergeze
Location agrafeuse

Il y a + de 30j

Il y a + de 30j

Agrafeuse cloueuse electrique

10€/jour

Vergeze
Location ponceuse

Il y a + de 30j

Il y a + de 30j

Ponceuse bosch disque dia 150

20€/jour

Vergeze
Location perforateur

Il y a + de 30j

Il y a + de 30j

Perforateur filaire

20€/jour

Vergeze
Location marteau piqueur

Il y a + de 30j

Il y a + de 30j

Marteau piqueur HILTI 5 kilo

35€/jour

Vergeze
Location visseuse

Il y a + de 30j

Il y a + de 30j

Visseuse 22 v Hilti

15€/jour

Vergeze
Location meuleuse

Il y a + de 30j

Il y a + de 30j

Meuleuse hilti 125 mm

17€/jour

Vergeze
Location boulonneuse

Il y a + de 30j

Il y a + de 30j

Boulonneuse hilti

20€/jour

Vergeze
Location videoprojecteur

Il y a + de 30j

Il y a + de 30j

Videoprojecteur

40€/jour

Vergeze
Location visseuse

Il y a + de 30j

Il y a + de 30j

Boulonneuse hilti

15€/jour

Vergeze
Location babyphone

Il y a + de 30j

Il y a + de 30j

Visiophonne

5€/semaine

Vergeze
Location chaine a neige

Il y a + de 30j

Il y a + de 30j

Location chaîne a neige

50€/semaine

Vergèze
Location coffre de toit

Il y a + de 30j

Il y a + de 30j

Coffre de toit

50€/semaine

Vergeze

Annonces similaires

Tout voir
Service montage de meubles

Il y a + de 30j

Il y a + de 30j

Bricolage intérieur/extérieur

25€/heure

Montpellier
Service montage de meubles

Il y a + de 30j

Il y a + de 30j

Montage dressing et meuble, bricolage

15€/heure

Mudaison
Service montage de meubles

Il y a + de 30j

Il y a + de 30j

Service : Montage de meubles

25€/heure

Nimes
Service montage de meubles

Il y a + de 30j

Il y a + de 30j

Service : Tapissier

25€/heure

Generargues
Service montage de meubles
5/5 résa

Il y a + de 30j

Il y a + de 30j

Monteur de meubles - Installation de dre

25€/heure

5/5 Montpellier
Service montage de meubles

Il y a + de 30j

Il y a + de 30j

Service : Montage de meuble

35€/heure

Saint-Gely-du-Fesc
Service montage de meubles

Il y a + de 30j

Il y a + de 30j

Service : Montage de meuble

25€/heure

Nimes
Service montage de meubles

Il y a + de 30j

Il y a + de 30j

Service : Montage de meubles

20€/heure

Montpellier
Service montage de meubles

Il y a + de 30j

Il y a + de 30j

Service : Montage meuble

30€/heure

Montfrin
Service montage de meubles
3,3/5 résa

Il y a + de 30j

Il y a + de 30j

Service : Bon bricoleur

20€/heure

Claret

Demande un service de montage de meubles entre voisins ou proposer mes services de montage de meubles.

Poster une annonce
Retour
Fermer

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

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

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

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

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='montage-de-meubles' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='600'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'montage-de-meubles' 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='3' AND c.cate_id='50'

  11. 0

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

  12. 0.0001

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

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

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=600 LIMIT 1

  16. 0.0001

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

  17. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='327463' 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` = 129015 AND util_tel != ''

  19. 0

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

  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='129015' AND wish_id<>'327463' 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='55' 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=129015 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 = 129015

  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='678' 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 = 129015

  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='42' 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 = 129015

  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='33' 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 = 129015

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

  34. 0.0003

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

  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='722' 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 = 129015

  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='681' 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 = 129015

  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='76' 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 = 129015

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

  42. 0.0002

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

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

  44. 0.0002

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

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

  46. 0.0002

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

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

  48. 0.0002

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

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

  50. 0.0002

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

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

  52. 0.0002

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

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

  54. 0.0002

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

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

  56. 0.0002

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

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

  58. 0.0002

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

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

  60. 0.0002

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

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

  62. 0.0001

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

  63. 0.0001

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

  64. 0.004

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((43.7333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((43.7333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((4.21667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>43.283639197041 AND ville_latitude_deg<44.182960802959 AND ville_longitude_deg>3.5943521238984 AND ville_longitude_deg<4.8389878761016 HAVING distance <= 50 ORDER BY distance ASC

  65. 0.0091

    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 ('30310','30121','30920','30600','30670','30660','30114','30620','34400','30111','30250','30470','30114','30420','30600','30620','30740','30980','30980','34590','30640','30620','34400','30540','34400','30250','30870','30870','34400','34400','30250','30820','34400','30510','34160','30250','30250','30220','34400','30250','34400','34400','30250','34160','30730','34130','34160','30730','30250','34160','34130','30250','30250','30132','30900','30000','34160','34160','34160','30250','30128','34160','30730','34670','34130','30260','34160','34160','34670','34130','34160','34160','30800','13460','30260','30260','30730','30220','34160','30230','30260','30730','30260','34160','30730','30230','34130','30190','30260','34280','34160','34160','30260','30129','34740','30190','30190','30260','30320','34130','30260','30240','30260','30350','30190','30190','30190','30127','34820','30260','30350','34920','30260','34820','34270','34270','34270','30129','30190','30320','30350','30350','30260','30190','34830','34270','30260','34820','30320','30320','30260','30350','30210','34730','34170','30190','30190','30190','30350','34270','30610','30350','34470','34830','34730','30700','30610','34270','34270','30190','30350','34270','30360','34270','30700','30300','30190','30190','34980','34980','30190','30610','34080','34090','34000','34070','30190','30350','34270','30610','30350','34970','30360','30210','30360','34250','30300','30350','30610','34270','30210','30700','30840','30190','30350','30350','30350','30360','30300','30360','34380','30210','34270','34980','30700','30350','30300','13123','13200','13280','13129','13104','30700','30170','30210','30490','30170','30720','34430','34880','30700','30360','30140','30700','30170','30360','30210','30300','30210','30700','34990','30210','34380','34790','30360','34750','34980','30140','30700','13150','30390','30360','34680','30210','30700','34190','13150','34570','30170','34380','30700','30210','34980','30140','30700','30360','34380','30170','30210','30140','30700','30360','30560','34380','30700','34570','30140','30170','34190','13150','30380','13103','30580','30140','30360','34570','34570','30390','30340','30170','30700','30390','30390','30460','30170','34690','34380','30210','34110','30340','34570','30580','34190','30700','34190','34380','30580','30140','30650','34110','30140','34190','30460','13103','34190','30700','30140','30580','30140','30340','34660','34660','30140','30330','30580','30650','13520','13990','34570','30440','30580','30100','30210','30460','13690','30330','34380','34150','34190','30460','30340','30340','30580','34190','13570','34190','13910','30460','13520','34190','13520','30330','30140','30580','30480','30460','34150','30580','30340','30580','30270','30330','30330','30330','30440','30330','34770','34110','30440','34560','30520','34380','13310','30330','30340','13210','30290','30126') AND fami_id='3' AND cate_id='50' AND type_id='1' AND ssrubr_id='600' AND wish_id<>'327463' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

  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='600' 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=303549 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 = 303549 AND W.type_id = 1) OR (W.util_id <> 303549 AND W.type_id = 2)) AND (M.post_util_id = 303549 OR M.dest_util_id = 303549) 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 = 303549

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

  72. 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 = 288388 AND W.type_id = 1) OR (W.util_id <> 288388 AND W.type_id = 2)) AND (M.post_util_id = 288388 OR M.dest_util_id = 288388) 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 = 288388

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

  75. 0.0001

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

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

  77. 0.0002

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

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

  79. 0.0001

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

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

  81. 0.0002

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

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

  83. 0.0001

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

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

  85. 0.0002

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

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

  87. 0.0001

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

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

  89. 0.0002

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

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

  91. 0.0001

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

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

  93. 0.0002

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

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

  95. 0.0001

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

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

  97. 0.0002

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

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

  99. 0.0001

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

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

  101. 0.0002

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

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

  103. 0.0001

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

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

  105. 0.0002

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

  106. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 600

  107. 0

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

  108. 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='3' AND cate_cate_id IS NULL ORDER BY cate_order ASC

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

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

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

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

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

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

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

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

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

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

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

  120. 0.0015

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

  121. 0.0333

    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'

  122. 0.0228

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

122 requetes sql en 0.0878

Taille variable Globale : 63.73 KB