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

Loue broyeur à végétaux

Autres annonces du voisin

Tout voir
Location minibus

Il y a + de 30j

Il y a + de 30j

Loue Renault trafic 9 places

80€/jour

Libercourt
Location tondeuse

Il y a + de 30j

Il y a + de 30j

Loue tondeuse essence

30€/jour

Libercourt
Location scie circulaire

Il y a + de 30j

Il y a + de 30j

Loue scie circulaire

30€/jour

Libercourt
Location motobineuse

Il y a + de 30j

Il y a + de 30j

Loue motobineuse

50€/jour

Libercourt
Location elagueuse

Il y a + de 30j

Il y a + de 30j

élagueuse ou tronçonneuse

30€/jour

Libercourt

Annonces similaires

Tout voir
Location broyeur a vegetaux

Il y a + de 30j

Il y a + de 30j

Location broyeur vegetaux

15€/jour

Faches-Thumesnil
Location broyeur a vegetaux

Il y a + de 30j

Il y a + de 30j

Location broyeur à végétaux

30€/jour

Saint-Saulve
Location broyeur a vegetaux
5/5 résa

Il y a + de 30j

Il y a + de 30j

Broyeur Ryobi 2500w

37€/jour

Proville
Location broyeur a vegetaux

Il y a + de 30j

Il y a + de 30j

Loue broyeur de végétaux

50€/jour

Ronchin
Location broyeur a vegetaux
4,6/5 résa

Il y a + de 30j

Il y a + de 30j

Broyeur à vegetaux

27€/jour

5/5 Ronchin
Location broyeur a vegetaux
4,2/5 résa

Il y a + de 30j

Il y a + de 30j

Broyeur végétaux

20€/jour

Wingles
Location broyeur a vegetaux
4,5/5 résa

Il y a + de 30j

Il y a + de 30j

Broyeur a végétaux

30€/jour

5/5 Tourcoing
Location broyeur a vegetaux

Il y a + de 30j

Il y a + de 30j

Location Broyeur végétaux

25€/jour

Hem
Location broyeur a vegetaux

Il y a + de 30j

Il y a + de 30j

Location broyeur à végétaux

40€/jour

Ramillies
Location broyeur a vegetaux

Il y a + de 30j

Il y a + de 30j

Broyeur de végétaux

50€/jour

Noyelles-sous-Lens

Louer un broyeur a vegetaux entre particuliers ou proposer un broyeur a vegetaux 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 CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci

  2. 0.0001

    SHOW TABLES LIKE 'pays'

  3. 0.0002

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

  4. 0.0002

    SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC

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

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='broyeur-a-vegetaux' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='24'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'broyeur-a-vegetaux' 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='88'

  11. 0.0001

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('62' USING utf8mb4) COLLATE utf8mb4_general_ci

  12. 0.0001

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

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

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=24 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  18. 0

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

  19. 0

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

  23. 0.0001

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish w INNER JOIN util_info ui ON w.util_id = ui.util_id WHERE wish_visu IN (1,6,10) AND w.util_id='307482' AND wish_id<>'474521' 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='863' 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=307482 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 = 307482

  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='5' 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 = 307482

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

  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='4' 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 = 307482

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

  35. 0.0001

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

  36. 0.0179

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.4833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.4833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.01667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.033639197041 AND ville_latitude_deg<50.932960802959 AND ville_longitude_deg>2.3099856856277 AND ville_longitude_deg<3.7233543143723 HAVING distance <= 50 ORDER BY distance ASC

  37. 0.0067

    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 ('62820','59261','59239','62590','59239','62220','59133','59162','59133','59551','59551','59112','62141','59283','59147','62119','59246','62790','62710','59251','59283','59710','62880','59710','62970','59113','62950','59950','59147','59185','59710','59112','62640','59147','59310','59286','62740','62440','59263','59235','62110','59128','59175','62880','62410','62880','59175','59710','59221','59272','62880','59184','62420','59273','59194','59139','62138','59242','59139','59553','59553','59136','59155','62410','59496','59242','62221','62218','59274','62430','59553','62410','59310','59320','62320','62320','62490','59119','59810','59320','59194','59148','59500','62138','59310','59211','62490','62320','59134','62680','59273','59496','62300','62410','59790','59134','62320','59134','59450','59120','59552','59830','59134','59552','59320','59320','59242','59262','59167','59310','62138','59480','62210','59320','59320','62300','62580','59830','59480','59320','62580','59260','59187','59310','62117','62580','62490','62112','59830','62138','62750','59830','59320','59000','59169','59800','59160','59350','59777','59320','62138','59870','59249','59134','62580','59287','59182','62490','59870','59146','59182','59287','59249','59152','59152','62490','59130','62112','59370','59160','59110','59310','62840','59830','62580','62149','59840','62580','59169','59830','62800','59152','62580','62149','59310','59310','59169','62580','59176','59350','62840','59780','59830','62980','59310','62149','62143','62160','59510','59840','62580','59152','59176','62490','59870','62118','59151','59840','07611','59280','62580','59870','62118','59700','59780','59490','62980','62149','62580','62149','59169','62118','59169','59520','07610','62153','62160','59870','59237','62490','62490','62136','62118','59118','59310','59690','59170','59290','62118','59151','62113','62113','62670','62840','59510','59780','59165','07502','59230','59151','59490','59151','59178','62580','59870','62118','59390','07522','59580','59234','59226','62160','59870','59930','62660','62114','59230','59179','59491','59493','59650','59655','62136','62153','07522','62156','59259','07624','59280','62223','62156','59178','07618','62840','62223','07504','62156','62290','59910','62860','59390','62113','62223','59234','59580','59171','62136','62144','59116','59390','59193','62223','59151','59420','62118','59390','07522','07522','62223','62840','07506','59234','07520','62400','62172','59171','62156','62860','59890','07620','62860','59215','62156','62860','62860','62530','59100','59265','62156','62400','62223','07623','07621','59236','62156','62223','07783','62144','62860','59940','07730','62530','59178','62223','07501','07500','62131','62131','59226','07620','59850','62131','62530','62128','59200','62400','59115','59178','62000','59252','07620','62136','59253','59150','62217','59247','62144','59171','62128','59265','07620','59890','59223','59250','59126','07620','62620','62860','07503','59252','07500','62232','62620','59172','62128','62860','07782','62232','62232','07730','59124','62182','59247','62161','62161','59181','62217','07520','62196','59158','07712','62217','62182','07620','62232','59560','07500','07730','62860','62232','62128','62690','62217','62217','59252','62144','62860','59230','62182','62860','07730','59156','62690','59135','59247','07641','07784','59172','07730','62920','62150','62690','62128','62128','59111','62128','59940','59158','62620','62940','59158','07622','62000','59111','07780','07780','62199','59220','07521','62620','59940','62690','59255','07784','07743','59960','62161','59265','07642','59293','59265','59560','62860','62150','07743','59117','07536','62860','62217','59554','59660','07730','59230','62182','59166','62144','59230','62350','59158','07540','62690','07640','07740','07548','07700','62122','59295','59295','62161','59111','62350','08950','59135','62920','59265','07700','07730','08957','62690','62128','59268','62128','59220','08952','62690','59282','59195','62150','08940','07542','62920','62700','62150','59554','62123','62175','59554','62860','62690','07640','59141','07643','59111','07540','07740','62150','07904','59494','62217','59220','07781','62123','59195','62128','62128','59554','59282','59270','07711','59199','62173','62350','07742','62122','62150','62690','59400','62128','62123','59121','62690','07531','59590','62123','62123','08953','08930','59141','62350','59554','62860','07640','62860','08950','07530','62128','62540','59199','62123','08951','08587','59494','62150','62175','59161','07543','59270','08930','62860','07538','59141','59270','62690','59121','08510','62123','62128','08956','59192','08511','62350','62175','59161','07604','08510','08902','62690','59232','59174','62121','62173','62173','08940','62127','62460','62690','59410','08930','08587','08980','62540','59554','59296','62175','07608','08560','59400','59224','62157','62150','62690','62350','62123','62147','62690','62159','62175','59161','08958','07760','59270','62121','59267','08510','07540','07532','62470','59400','62127','62121','08587','59125','62173','62460','62810','07604','59970','59270','62350','62123','62123','62147','59860','08902','07604','59400','59198','62150','59267','07533','08554','07604','62190','59233','62810','62123','59224','62159','62470','62121','62147','62690','62260','59161','07534','07760','08510','07760','08980','62124','62151','59270','59277','59300','62159','07540','08902','59278','08954','08900','62127','59880','62810','59300','59159','59300','62260','59270','07760','62123','62116','62123','59188','59163','08583','07534','62190','59190','62330','62460','59970','62116','59400','08980','62127','59400','59770','07601','07760','07604','08501','08970','62147','62147','62124','62810','59129','62810','07600','62124','59227','08560','62127','62123','62121','62121','62147','59188','62190','62810','62116','62124','08890','62550','62127','59190','07602','59267','59281','59227','59227','08552','62111','62450','62123','59400','07906','59299','59190','62121','62450','59269','07603','59213','62810','08900','62130','59970','62810','08560','08500','62116','62127','08582','62190','62121','07910','62127','62158','08880','08501','59217','62550','62450','59159','07904','62550','62260','62550','62330','59190','62124','59264','62127','59189','62810','59190','59213','07910','59269','59189','62190','62190','08550','07911','62127','59990','62450','08900','59241','59159','07760','08980','08551','59188','62190','62120','59990','08908','59292','62550','62450','59270','62550','59400','08880','07971','62127','59990','62127','59243','62260','62121','62158','59163','59400','07750','07901','62127','62450','07971','08900','08580','07910','62158','59294','59114','62124','62111','62124','62450','07910','07910','59990','62111','59217','62130','07911','62147','07320','62550','62124','62810','59269','07911','59213','59213','59189','07750','62450','62550','62116','62121','59400','59217','62120','59163','07971','08520','62450','07910','59990','07971','07750','07750','08880','62111','59214','59231','59217','62158','59154','62120','62450','08890','07321','59114','07910','59258','62158','62130','09690','62810','08553','62810','07904','62810','08970','62120','08530','62810','62550','62124','59258','59157','07900','07900','62550','08980','62450','62124','62550','62127','59144','62124','07750','62190','62116','62120','59114','62120','80300','62450','62130','59173','62124','59990','07911','62127','59190','08906','62111','59157','62810','59530','62120','59213','59213','62810','59730','59258','07910','80300','59730','62270','62550','07972','07972','62550','62130','59990','59190','07912','07911','07903','59920','08904','08860','62550','07387','62111','62130','62450','08540','62760','08581','07350','08570','59127','62960','62960','07972','62120','62120','80300','62760','59730','07321','62810','07912','08570','62450','62130','07903','07380','59530','62120','62130','59266','07973','59540','62124','62120','08531','08920','62124','62158','59730','59730','09690','08531','62550','08920','08573','59670','62130','59144','62130','07903','62450','59231','09690','09690','59191','62145','59530','59540','62111','59271','08640','62130','59114','62111','08581','07350','62810','08920','59231','62450','08791','62158','07380','07322','62270','80300','08800','62130','07911','62134','07973','59144','62130','59173','08904','59173','62270','59190','62960','59191','07387','62810','62810','08870','08840','08572','80360','59266','59530') AND fami_id='5' AND cate_id='88' AND type_id='1' AND ssrubr_id='24' AND wish_id<>'474521' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

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

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

  41. 0.0002

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

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

  43. 0.0001

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

  44. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 532803 AND W.type_id = 1) OR (W.util_id <> 532803 AND W.type_id = 2)) AND (M.post_util_id = 532803 OR M.dest_util_id = 532803) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  45. 0.0001

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

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

  47. 0.0001

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

  48. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 480260 AND W.type_id = 1) OR (W.util_id <> 480260 AND W.type_id = 2)) AND (M.post_util_id = 480260 OR M.dest_util_id = 480260) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  49. 0.0001

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

  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 ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=53075 AND note_visu IN (1,3,4)

  52. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 53075 AND W.type_id = 1) OR (W.util_id <> 53075 AND W.type_id = 2)) AND (M.post_util_id = 53075 OR M.dest_util_id = 53075) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  53. 0.0001

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

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

  55. 0.0001

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

  56. 0.0005

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

  57. 0.0001

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

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

  59. 0.0001

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

  60. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 368323 AND W.type_id = 1) OR (W.util_id <> 368323 AND W.type_id = 2)) AND (M.post_util_id = 368323 OR M.dest_util_id = 368323) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  61. 0.0001

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

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

  63. 0.0001

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

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

  65. 0.0001

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

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

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

  69. 0.0001

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

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

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

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

  77. 0.0001

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

  78. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 24

  79. 0.0001

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

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

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

  82. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (88) ORDER BY ssrubr_order ASC

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

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

  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 (227) 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 (176) 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 (79) ORDER BY ssrubr_order ASC

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

  89. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (228) ORDER BY ssrubr_order ASC

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

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

  93. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (83) ORDER BY ssrubr_order ASC

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

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

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

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

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

  99. 0.0009

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

  100. 0.0236

    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'

  101. 0.0179

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

101 requetes sql en 0.0793

Taille variable Globale : 85.29 KB