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

Location broyeur à végétaux

Annonces similaires

Tout voir
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

Recherche location broyeur végétaux

-- €

Eppeville
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

Cherche location broyeuse vegetaux

40€/jour

Masny
Location broyeur a vegetaux

Demande il y a + de 30j

Il y a + de 30j

Broyeur végétaux (3 jours)

150€

Peaugres
Location broyeur a vegetaux

Demande il y a + de 30j

Il y a + de 30j

Recherche broyeur de végétaux

50€/jour

Cartignies
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

Broyeur à végétaux à louer

45€/jour

Montigny-en-Gohelle

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

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

  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

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

  12. 0.0001

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

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

  15. 0.0001

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

  17. 0.0001

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

  19. 0

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

  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='10823' AND wish_id<>'370583' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  24. 0.0001

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

  25. 0.0173

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.1333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.1333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.43333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.683639197041 AND ville_latitude_deg<50.582960802959 AND ville_longitude_deg>2.7318278816871 AND ville_longitude_deg<4.1348321183129 HAVING distance <= 50 ORDER BY distance ASC

  26. 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 ('59540','59540','59540','59540','59271','59157','59225','59214','59217','59980','59157','59217','59730','59191','59980','59292','59360','59225','59980','59730','59188','59217','59191','59400','59217','59730','59191','59980','59980','59129','59360','59360','59730','59127','59238','59188','59360','59400','59277','59188','59222','59294','59127','59400','59730','59127','59222','59400','59400','59161','59227','59227','59360','59137','02110','59360','59730','59218','59161','59127','59127','59360','59258','59218','59218','59198','02110','59222','59400','59141','59296','59258','02110','59141','59213','59213','59161','59218','02110','02110','02110','59550','59142','59360','59400','59213','59213','59161','59400','59360','02110','59227','59530','59554','59258','59141','59530','59281','59550','59241','59213','59288','59111','59213','59360','02110','02420','59530','59554','02110','59295','59295','59224','59111','59554','59267','59282','59530','59360','02630','02110','59269','59159','59159','59530','59268','59530','59554','59266','59530','59111','59224','59111','02630','59360','02110','59233','59282','59252','59550','59265','59265','59266','59267','59269','59247','59530','59293','59400','02420','02110','02420','59530','59172','59554','59266','02420','02450','59269','02630','59554','59121','02230','59121','59252','59530','02110','59125','59172','59530','59530','59247','02450','59265','59530','59252','59156','59300','59990','59247','02420','59530','02110','59550','62860','59231','59231','59220','02110','59220','59990','02420','59220','59550','59400','59267','02510','02510','02420','59159','59265','59124','02450','02450','59297','59300','62147','59530','02110','02110','02510','59234','02120','02420','62860','59265','59195','59234','59195','59215','02110','59255','59144','59580','02420','59174','59144','59550','59231','02110','59990','02420','02120','02120','59144','02420','62147','59144','02420','59300','62860','02170','59990','02420','80740','59770','59144','62147','59234','02450','02450','59580','02120','59135','59151','62860','80740','02110','59135','02110','59494','59550','62147','62860','02420','59144','02510','02420','02100','59171','59410','59494','59165','62860','59145','59990','02100','59171','02100','59144','02420','59144','62860','62124','59171','59880','02120','59550','59151','02420','80240','62860','59244','59179','02120','59550','02110','02110','59169','62860','59590','59490','02170','02170','80122','59192','59145','02450','62147','59176','59990','59570','59860','59244','62860','07387','59570','59151','59570','02100','02120','59620','59490','80240','80112','62860','62860','59169','59176','02490','59570','59620','62860','80360','02120','02490','62147','59440','59620','59244','59138','80240','59151','59169','02120','02490','02170','59990','02490','59870','62860','59264','62124','02120','62124','07387','59570','59182','59287','59243','02100','59870','02100','80240','59440','62147','59570','59570','59620','62860','80240','59169','62860','59182','80240','59287','02120','02390','02120','59570','59178','80240','80360','62182','59146','62124','07387','02720','07387','59570','59151','07387','59259','62124','59570','02120','62182','59138','02490','59870','59920','62156','59138','59870','02490','02100','07387','59570','62860','62124','02100','07387','02170','59870','59278','62490','59187','62490','02120','80240','80240','80240','59440','02100','62124','59230','62124','02760','02720','59178','59138','62124','02390','59167','02120','02120','02120','59970','02390','59440','07387','07380','02120','02720','59178','59330','80360','02620','62112','59178','62156','59169','59440','59450','80240','59870','02100','62124','62159','07382','62124','02760','02260','07387','59440','62490','59970','80240','59570','62490','59154','02120','02120','59219','62112','59620','62182','02240','07387','80240','02390','07380','62156','02260','02120','62182','62156','59552','59440','62124','59230','07387','59119','59870','59440','59194','02490','59230','02100','59570','80240','62124','59570','07370','59330','59970','80360','59330','59330','59330','59552','62124','80240','62156','59500','59163','02120','02490','62159','59440','59219','80240','02120','59440','62128','62117','80240','02240','59158','02240','80200','59148','59226','02430','02120','59163','62128','62128','80760','62450','02140','59199','59219','62156','07370','07370','59199','02240','02260','02260','59310','07350','59230','62156','59330','62128','80240','62450','02120','02680','02490','02490','62118','59194','80200','62450','07370','02260','59440','59440','80200','59440','62128','59163','80360','02260','02140','59310','59553','02680','59553','62490','02240','59230','02260','80200','07350','59750','62118','59330','02240','62450','59226','02240','59553','62450','62450','02590','02580','07350','59690','59310','80200','62450','59310','02680','02680','80360','02690','62128','02120','59310','02260','80200','80200','59286','02680','59128','59310','62118','59440','80200','07350','59177','02590','07040','02590','07340','59720','62118','59158','02240','59158','02260','02240','02240','07320','02140','07040','07080','62450','59177','80200','02580','02590','62118','62490','02250','62128','59600','07322','62159','59283','02240','62450','59158','59950','80200','07623','02590','59216','59216','80200','62450','62128','07624','02790','59216','62128','62450','80360','62490','80200','02260','02260','02690','07300','07620','59680','02590','59310','62790','07608','62118','62128','59680','07603','80360','59212','02270','02590','02590','02140','59680','02260','07321','07340','62121','59310','62121','59740','59310','59177','02480','80200','07080','02240','02610','07040','62121','07340','62450','59600','59131','59680','62490','59610','59283','07322','62450','02580','07600','07622','02240','62970','07621','62118','07340','02250','59740','80200','02440','62128','02240','07301','07080','02270','59680','80360','59235','62141','02250','07321','80400','07040','02140','62580','59310','59600','62450','80200','02500','62450','59600','62128','02140','80360','80200','62121','07040','62450','07040','07330','02240','02480','07040','62128','07604','02140','07080','02140','59600','80360','62223','59740','62128','62950','02140','80360','07620','62580','80200','59740','02590','02590','07611','59246','62121','07620','59600','59680','59162','07601','07334','02140','07620','07973','59600','07390','02270','02480','02440','02590','59740','02440','02440','02250','02270','62217','07040','80200','02140','62580','07390','80360','07620','07604','07333','62175','62320','62320','07080','02140','59132','02500','02500','62119','80200','02270','07971','07620','62217','62121','02240','07972','80200','62121','59740','07973','62217','59610','59740','62121','80360','62223','59710','02240','07012','07041','02590','59242','07604','80360','02800','02640','07640','02440','07334','80400','62175','02140','62580','02140','07602','59168','59245','62450','62320','59242','62580','80360','59600','07618','80200','02140','02640','07641','02500','02440','07640','07971','59239','62110','07971','02440','02270','59740','59680','02140','07610','59551','80360','07040','07604','02480','62121','59830','07012','07971','62580','62320','62580','80200','59680','59740','62175','59132','80200','02270','80200','07331','59261','59710','07024','07604','02500','80200','02140','02800','80400','07640','02270','59242','59740','07643','07033','59830','07332','02480','80300','62217','80300','62223','59740','62640','07538','59149','62121','02480','80300','62450','07022','02270','80300','02500','62820','02270','07022','07500','62590','59740','62580','02140','59239','80400','80190','02550','02140','80400','62000','59600','59830','62175','02520','62420','80300','59710','80340','02250','07506','07642','07022','62740','59830','59132','02700','62217','62217','02140','07904','80200','80200','80400','07502','59164','59186','80190','07504','59830','02480','62116','02270','80360') 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<>'370583' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

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

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

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

  30. 0.0002

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

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

  32. 0.0001

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

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

  34. 0.0001

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

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

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

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

  38. 0.0002

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

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

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

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

  42. 0.0002

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

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

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

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

  46. 0.0002

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

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

  48. 0.0001

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

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

  50. 0.0002

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

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

  52. 0.0001

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

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

  54. 0.0002

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

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

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

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

  58. 0.0002

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

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

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

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

  62. 0.0002

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

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

  64. 0.0001

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

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

  66. 0.0002

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

  67. 0.0001

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 24

  68. 0.0001

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

  69. 0.0002

    SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC

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

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

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

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

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

  75. 0.0003

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

  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 (79) 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 (208) 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 (228) ORDER BY ssrubr_order ASC

  79. 0.0003

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

  80. 0.0003

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

  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 (173) 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 (83) 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 (93) 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 (193) 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 (91) 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 (232) 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 (92) ORDER BY ssrubr_order ASC

  88. 0.0015

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

  89. 0.0313

    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'

  90. 0.0228

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

90 requetes sql en 0.0933

Taille variable Globale : 84.67 KB