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

Pince à glissement PER

Autres annonces du voisin

Tout voir
Location leve plaques

Il y a + de 30j

Il y a + de 30j

Lève plaque

20€/jour

Inchy-en-Artois
Location echafaudage

Il y a + de 30j

Il y a + de 30j

échafaudage

35€/jour

Inchy-en-Artois
Location pistolet a peinture

Il y a + de 30j

Il y a + de 30j

Pistolet à peinture

30€/jour

Inchy-en-Artois
Location autres outils

Il y a + de 30j

Il y a + de 30j

Coupe parquet stratifié et matériel de p

20€/jour

Inchy-en-Artois

Annonces similaires

Tout voir
Location pince a sertir

Il y a + de 30j

Il y a + de 30j

Location sertisseuse cuivre et multicouc

13€/jour

Faches-Thumesnil
Location pince a sertir
3,9/5 résa

Il y a + de 30j

Il y a + de 30j

Location sertisseuse & déboucheur électr

20€/jour

4,5/5 Lille
Location pince a sertir

Il y a + de 30j

Il y a + de 30j

Pince à sertir per ou multicouche

18€/jour

5/5 Wavrechain-sous-Denain
Location pince a sertir
4,3/5 résa

Il y a + de 30j

Il y a + de 30j

Pince PER et multicouche

20€/jour

Ennevelin
Location pince a sertir
4,6/5 résa

Il y a + de 30j

Il y a + de 30j

Pince a sertir multicouche et per

13€/jour

5/5 Ronchin
Location pince a sertir
5/5 résa

Il y a + de 30j

Il y a + de 30j

Pince a sertir

25€/jour

La Couture
Location pince a sertir

Il y a + de 30j

Il y a + de 30j

Pince à Sertir Multicouches/PER

15€/jour

Saint-Quentin
Location pince a sertir

Il y a + de 30j

Il y a + de 30j

Pince à sertir

8€/jour

Ronchin
Location pince a sertir

Il y a + de 30j

Il y a + de 30j

Pince a sertir PER et Multi Couche

15€/jour

Wattignies
Location pince a sertir
5/5 résa

Il y a + de 30j

Il y a + de 30j

Pince à sertir RJ45

5€/jour

Arras

Louer une pince a sertir entre particuliers ou proposer une pince a sertir 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.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.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='428554'

  8. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'pince-a-sertir' LIMIT 1

  9. 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='87'

  10. 0

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

  11. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='253440' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  12. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 253440

  13. 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 = 428554

  14. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=49 LIMIT 1

  15. 0.0001

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

  16. 0.0001

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

  17. 0

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

  18. 0

    SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=253440 LIMIT 1

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

  20. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='253440' AND note_visu IN (1,3,4)

  21. 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 = '428554'

  22. 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='253440' AND wish_id<>'428554' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

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

  24. 0.0001

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

  25. 0.0003

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

  26. 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='66' LIMIT 0,1

  27. 0.0002

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

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

  29. 0.0002

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

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

  31. 0.0002

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

  32. 0.0001

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

  33. 0.014

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.25*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.25*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.06667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.800339197041 AND ville_latitude_deg<50.699660802959 AND ville_longitude_deg>2.3634513698918 AND ville_longitude_deg<3.7698886301082 HAVING distance <= 50 ORDER BY distance ASC

  34. 0.0036

    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 ('62860','62860','62860','62860','59259','62860','62860','62156','62860','62860','59151','62860','62860','62490','59151','62156','62182','59151','59151','62860','62490','62490','62182','62860','62156','59169','62156','59265','62860','59265','62112','62490','59169','59265','59151','62156','62156','62118','59554','62182','59169','62112','62860','62156','59247','62860','62860','59554','62117','62118','59234','62182','59234','59265','59169','62860','59247','62128','59265','62490','59169','62147','59552','62128','62118','59268','59552','59400','59187','59400','59247','62118','59554','62118','59234','62147','59554','59554','59287','59500','62128','62128','62128','59182','59287','59267','62118','59267','62490','59553','59450','62147','59252','62159','59554','62128','62118','62128','59161','62128','62490','62128','59252','59176','59252','59400','59553','59553','62147','59159','59580','62147','59165','59400','59119','59267','59161','62580','62490','59176','59295','59295','62124','59111','59141','59182','62147','62223','62124','62580','59580','62128','59167','62124','62128','59128','62159','59281','59159','59141','59159','62128','62580','59400','62223','59172','59161','62124','59194','62217','62217','59141','59111','62580','62124','59111','62128','59161','62320','62320','59146','59241','62580','59490','59950','59286','62147','62128','62124','62970','62320','62580','62450','59215','62121','62159','59400','59400','62217','59231','59194','62580','62121','62175','62124','62950','62320','62223','62450','59172','62580','59490','62217','59111','62124','62790','59283','62124','59870','62000','62141','59870','59400','62110','62124','62175','59277','62124','59179','62121','62121','59400','59293','62450','59258','62119','59148','62450','62450','62217','62217','62223','59156','62223','62680','59258','62580','62580','62420','59171','59258','62223','62175','59124','62121','59217','59283','59162','62640','62124','59266','59296','59231','62121','62450','62450','59282','59171','62121','62740','59400','59217','62124','59231','62450','59282','62175','59129','62223','59870','62430','62124','62210','62450','62223','62173','62121','59188','62580','59217','80360','62710','59310','59266','59870','62217','59220','59870','62175','80360','62450','59127','62450','59310','62450','62590','80360','59297','62221','62218','62450','59198','62450','59171','59157','62121','59217','62000','62173','59188','62440','80240','59266','62116','80360','59246','62300','62450','59292','62580','59239','80122','59157','59261','59255','62820','59191','62116','59188','62300','62880','80360','59870','59220','62116','59214','59235','59310','62220','62153','62121','59135','59870','62161','62161','59121','62116','62173','59227','59227','62880','62880','62173','59310','59220','80360','62161','59127','59224','59178','59239','80240','59551','80240','59191','62880','62450','80360','02420','80240','59710','80300','59310','02420','59540','80740','62800','59121','59191','62144','59195','80360','59127','62123','80300','59178','62123','59224','62450','62153','62161','80300','59127','59135','62143','59178','62116','59540','59230','80360','59142','62111','59195','80360','62123','59551','59227','62123','62123','80112','80360','59294','59133','59710','62144','62750','59230','59225','62116','59225','59233','62410','59310','59133','80300','59112','59242','80760','02420','80740','59125','59271','59730','62410','59310','02420','02420','62410','59310','80360','59127','59213','62123','59494','62123','80300','59540','59730','80360','59178','62144','62123','62123','62410','59185','80200','80240','80240','59710','02420','62144','59174','80240','59730','59710','62160','62123','59213','59147','80240','59310','59690','59540','62160','62144','62111','59269','62450','80300','62123','59242','59494','62111','59221','02110','62123','62123','62160','59251','62690','59226','59300','62138','59112','02420','59980','59980','59230','59590','59213','59213','59242','62111','62690','59310','59410','59730','59238','59113','80240','62111','02110','62123','59730','80240','59273','59226','62690','59147','80200','62172','62138','80300','80360','62111','59980','59980','59147','62530','59300','59192','62111','80300','62123','80300','80200','02420','59213','59213','59496','62810','59360','80360','59830','80300','59269','62158','62530','62690','59300','80300','59980','59272','02420','62980','62690','62114','07624','62138','62158','80300','59175','80240','62690','59175','80240','07611','59184','80200','80240','59830','02420','62670','59263','80240','62810','59496','62810','62158','80360','59730','62690','02490','59269','80300','80300','02110','62138','80200','02420','62980','59273','80200','02490','62690','59770','80360','59274','59830','59990','59860','59158','80200','62149','07623','59880','62810','59480','80200','62760','59530','59136','59830','59530','62158','62530','80560','59155','59139','80300','62810','59990','59218','59218','80560','62149','59139','80200','59810','62149','80300','62111','02420','80300','59137','80300','62138','02490','62690','80360','02110','59360','62111','80560','59360','59218','59830','59230','59262','80200','07621','62690','62690','07610','59990','59222','62149','62150','59134','59830','59830','59360','62113','62113','59158','62810','07620','80560','62690','59218','62158','02110','59134','59222','62290','59230','02420','80300','80200','62690','62760','02110','02110','59158','59480','62620','80240','07618','80240','62150','80560','59790','59990','59199','59530','59320','62150','59134','59780','59530','02420','59320','80340','02420','62810','62690','59990','07620','62760','62690','80340','80560','62113','80200','07502','07620','59144','59211','59199','80300','02110','59360','62690','59278','59152','59152','07620','07620','62760','80200','02420','62660','59158','59530','59530','80300','80240','02110','62810','59134','59152','59530','02490','59360','62810','07622','62840','80340','62810','59264','80300','62158','02490','59222','80200','80560','80240','62620','07504','59970','62149','59120','59260','62127','59530','59780','62150','59320','62620','80810','80560','59320','62131','07620','80300','02110','02110','07506','62760','62760','80200','62131','62131','62810','59360','80200','59530','02420','02230','59243','62150','59249','62760','59550','59320','59320','62158','80560','02490','62620','62940','59970','80560','80560','07522','59144','59320','59152','62840','59970','80200','59530','59249','80200','80980','62127','62127','59530','59288','59000','80200','59800','59160','59350','59777','07500','59530','80200','02490','02490','62810','07500','07641','59134','62810','02110','80200','02100','59163','80200','62127','59990','80560','59550','59144','80300','02110','02490','80600','80560','80340','80340','59320','62196','62127','59144','02100','02100','62136','07522','80340','62127','59320','59510','59990','62127','62232','07522','80200','80560','59360','59370','62760','62400','80340','62810','59530','62150','59530','07608','02760','59144','62810','62400','80560','02110','59360','07501','02110','80300','80560','59780','80200','80300','02100','62232','62127','59144','59110','80200','80200','02100','07640','59130','80340','02100','07522','02110','62136','62760','02110','07642','62232','62232','80200','62700','07387','62150','07604','80340','80200','07640','59160','02490','62810','62150','59920','62810','62127','80300','62400','59360','59840','07521','62136','62199','80200','62810','62150','59154','80560','80300','02630','80300','59510','59390','07643','07387','80340','02110','07640','59350','62127','59163','07387','62760','07500','62760','80560','59360','02630','02760','07536','07503','02100','62810','62122','59144','80560','80300','59280','62127','62760','02590','59700','07520','80300','07387','62270','80600','59840','59530','80340','80300','02630','80320','59170','59290','62127','59570','62460','59840','07604','59550','62920','62460','59163','80300','80200','02100','07600','07538','07380','62760','80200','07380','07548','07603','59520','62920','62810','62840','62760','62232','80800','62810','59390','59144','07604','80200','80200','62840','59360','07387','59390','62540','02100','62127','80300','59390','62122','80300','80560','07530','80800','07601','80320','80400','59118','02590','02590','62127','80340','62460','07350','07320','59237','07387','80121','02110','02110','02110','62127','59491','59493','59650','59655','80200','07730','02590','02590','07520','62760','07387','62130','07604','80600','07382','07904','59570','62470','80113','80320','80320','62270','02590','80800','02110','62136','07387','02110','62130','59570','07540','07540','80600','62760','62840','59940','02450','02720','59570','80600','07531','07602','59930','02680','07604','02100','62130','62270','80800','62470','62270','80340','59570','59280','59115','59253','07730','62810','62540','62920','07350') AND fami_id='5' AND cate_id='87' AND type_id='1' AND ssrubr_id='49' AND wish_id<>'428554' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

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

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

  38. 0.0001

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

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

  41. 0.0004

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

  42. 0.0001

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

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

  46. 0.0001

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

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

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

  50. 0.0001

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

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

  53. 0.0004

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

  54. 0.0001

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

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

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

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

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

  67. 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='49' LIMIT 0,1

  68. 0.0001

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

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

  70. 0.0001

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

  71. 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='49' LIMIT 0,1

  72. 0.0001

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

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

  74. 0.0001

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

  75. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 49

  76. 0

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

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

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

  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 (88) 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 (81) 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 (110) ORDER BY ssrubr_order ASC

  82. 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 (227) 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 (176) 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 (79) 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 (208) 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 (228) 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 (207) 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 (95) 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 (173) ORDER BY ssrubr_order ASC

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

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

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

  95. 0.0002

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

  96. 0.0009

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

  97. 0.0221

    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'

  98. 0.0165

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

98 requetes sql en 0.0691

Taille variable Globale : 85.33 KB