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
45 € / jour
Paiement 100% sécurisé
  • Service client réactif
  • Dépôt remboursé si annulé

Autres annonces du voisin

Tout voir
Location plat a paella

Demande il y a + de 30j

Il y a + de 30j

Louer : Poêle spéciale paella

20€

5/5 Flers-en-Escrebieux

Annonces similaires

Tout voir
Location broyeur a vegetaux

Demande il y a + de 30j

Il y a + de 30j

Location broyeuse

-- €

Tourcoing
Location broyeur a vegetaux

Demande il y a + de 30j

Il y a + de 30j

Recherche broyeur branche végétaux

50€/jour

Lens
Location broyeur a vegetaux

Demande il y a + de 30j

Il y a + de 30j

Recherche broyeur de branches

50€/jour

Marcoing
Location broyeur a vegetaux

Demande il y a + de 30j

Il y a + de 30j

Demande de location broyeur à végétaux

30€/jour

Marcoing
Location broyeur a vegetaux

Demande il y a + de 30j

Il y a + de 30j

Recherche broyeur à végétaux Cambrai

50€/jour

Marcoing
Location broyeur a vegetaux

Demande il y a + de 30j

Il y a + de 30j

Broyeur végétaux

50€/jour

Wervicq-Sud
Location broyeur a vegetaux

Demande il y a + de 30j

Il y a + de 30j

Cherche location broyeuse vegetaux

40€/jour

Masny
Location broyeur a vegetaux

Demande il y a + de 30j

Il y a + de 30j

Recherche broyeur à végétaux

50€/jour

Pecquencourt
Location broyeur a vegetaux

Demande il y a + de 30j

Il y a + de 30j

Recherche location broyeur

40€/jour

Mouchin
Location broyeur a vegetaux

Demande il y a + de 30j

Il y a + de 30j

Location 1 jour

50€/jour

Hallennes-lez-Haubourdin

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

    SHOW TABLES LIKE 'pays'

  3. 0.0003

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

  4. 0.0004

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

  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('59' 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='79420' 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` = 79420

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

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=24 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  18. 0.0001

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

  19. 0

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

  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='79420' AND wish_id<>'357076' 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='840' 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=79420 AND note_visu IN (1,3,4)

  26. 0.0001

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

  27. 0.0001

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

  28. 0.0146

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.4*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.4*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.05- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.950339197041 AND ville_latitude_deg<50.849660802959 AND ville_longitude_deg>2.3445583689314 AND ville_longitude_deg<3.7554416310686 HAVING distance <= 50 ORDER BY distance ASC

  29. 0.0072

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

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

  31. 0.0001

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

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

  33. 0.0002

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

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

  35. 0.0001

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

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

  37. 0.0001

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

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

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

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

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

  49. 0.0002

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

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

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

  53. 0.0002

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

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

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

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

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

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

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

  70. 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  90. 0.0009

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

  91. 0.0231

    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'

  92. 0.0168

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

92 requetes sql en 0.0742

Taille variable Globale : 85.14 KB