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

Annonces similaires

Tout voir
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Recherche chaîne 215/65 16

20€/semaine

Lille
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Louer des chaînes neige 255/40 20

50€

Bourlon
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Cherche chaines neige 255 40 19 (3 jours

45€

Ronchin
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Recherche à louer chaînes neige (DS7)

50€/semaine

Arras
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Recherche chaînes à neige à louer

80€/semaine

Mons-en-Baroeul
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Location chaine voiture 215/65R17

30€/semaine

Wavrin
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Location chaîne frontal

50€/semaine

Orchies
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Louer des chaines à  neige (225-60 R17)

60€/semaine

Orchies
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Chaîne montage frontal 225/55 R19

60€/semaine

Villers-Pol
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Location chaines neige

61€/semaine

Ercheu

Louer des chaines a neige entre particuliers ou proposer des chaines a neige 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.0001

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

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

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='chaine-a-neige' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='725'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'chaine-a-neige' 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='227'

  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='58879' 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` = 58879

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

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=725 LIMIT 1

  16. 0

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

  17. 0.0001

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

  18. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='273386' 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=58879 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 = 58879 AND W.type_id = 1) OR (W.util_id <> 58879 AND W.type_id = 2)) AND (M.post_util_id = 58879 OR M.dest_util_id = 58879) 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='58879' 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 = '273386'

  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='58879' AND wish_id<>'273386' 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='59554'

  25. 0.0141

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.2167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.2167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.23333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.767039197041 AND ville_latitude_deg<50.666360802959 AND ville_longitude_deg>2.5306023247262 AND ville_longitude_deg<3.9360576752738 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.0043

    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 ('59554','59268','59554','59265','59161','59265','59400','59554','59161','59247','59554','59141','59247','59265','59141','59554','59161','59295','59295','62860','59554','59400','59247','59265','59161','59267','59252','59141','59111','59265','59400','59400','59252','59400','59234','59252','59111','59400','62860','59277','59267','59151','62860','59234','59281','59159','59111','62860','59234','59217','59111','59172','59400','62860','59129','59400','62860','59151','62860','59400','59241','59580','59296','59159','59172','59400','59217','59188','62147','62860','59151','59217','59169','62860','62860','59169','59293','59165','59151','59282','59217','59580','59258','62860','59188','59258','59157','59292','62860','59198','59215','59188','59156','59267','62147','59282','59157','62860','59214','59169','59127','62860','59169','62860','59258','59176','59176','59151','59259','59124','59159','59191','62147','59227','59227','59182','59287','62156','62182','59287','62490','59540','62490','59231','62182','59191','59490','59220','59266','59187','59540','59182','59490','62112','59179','62156','62860','59169','59191','59171','59294','59224','59127','62147','62490','59121','62147','59171','62490','59224','62860','59730','59271','62147','62112','59220','59225','59146','59450','62156','59227','59730','59870','59266','59255','59121','59225','59540','59167','59171','59552','59220','62156','59730','59231','59127','59552','59213','59127','62147','59540','59233','62117','62182','59266','62182','59119','59231','59870','59500','59135','62124','62156','02420','59195','59127','62156','59213','59142','59125','62124','59980','62118','59194','59870','59297','59730','59195','62124','59980','59730','59269','62159','59870','62156','59213','59213','59135','62490','62124','62118','62124','59360','02420','62124','62128','62128','59213','59213','59553','59553','59238','59553','59980','59980','62128','62128','62124','59300','59174','62124','59980','62128','59730','59194','59870','59494','62124','59148','62118','02420','62124','59870','02420','59128','02110','80360','62118','59269','62118','62490','59494','62159','02110','59300','59286','59178','80122','59870','59269','59530','62128','59218','59218','62490','59178','80740','59360','80240','62128','59360','59218','59410','59178','59222','59530','80360','62118','59590','62124','59950','59300','02420','59222','62124','59310','62490','62128','59218','59990','59360','62450','59137','59283','62128','80240','02110','02420','80740','59192','62118','62124','59990','62790','59178','59230','62580','59770','62450','62970','80360','62124','59230','59310','62450','59530','80240','62128','80112','59310','62128','02110','62141','59230','59880','02420','59283','62580','59990','62450','59360','59860','62223','59530','62159','59222','02110','59360','80240','62950','62128','59530','02420','80240','59310','59530','80360','59530','62580','59530','62121','62450','02110','59990','62320','62320','59360','62450','59144','59550','62450','59162','62128','02420','59530','02420','62128','59310','02110','59310','62217','02420','62450','62121','59530','62223','62119','62580','62121','62121','59990','59310','02420','02110','02110','62320','62217','62580','59288','02110','59226','62450','59235','80360','59310','59690','02110','59550','59530','59246','80240','80240','59226','62110','62175','62217','62580','62450','62320','62580','59530','02110','80240','62450','59360','59310','59144','62450','02420','59158','80240','02490','59264','59360','62580','59530','02490','02420','62175','62450','62640','62223','80760','59144','62121','80240','59239','62450','02230','62420','62217','59278','59530','62121','02110','59710','80240','59144','62000','59144','59261','59230','59243','62740','62590','80360','59360','62680','59990','62450','80360','62450','59551','62175','62121','02420','07624','62820','62121','59310','02420','62710','59199','62217','62217','80240','59242','62223','59144','62223','62121','59230','62580','59990','80360','80240','59239','59360','02490','02420','80240','07623','62580','62430','59970','59199','80360','59970','02630','59710','80200','02630','62175','62223','59530','59550','59158','59970','80200','02110','02110','59144','62210','80360','59158','80360','80200','02110','62440','07611','62220','02490','59242','02490','07620','07387','59360','02110','62221','62218','59242','07621','07387','62223','62173','62175','62880','59551','07387','02630','80200','59710','59163','59920','02100','02100','62116','62223','59570','62450','80360','62121','62217','59158','59144','62580','62116','02100','59133','62173','80200','59710','07387','80300','80200','80240','80300','62300','59154','59830','02100','59830','59830','02490','80240','02110','07622','02450','62116','62300','80360','62880','62880','62000','02100','07620','59273','59133','07620','59570','80300','07610','59550','07380','07387','59550','62580','59163','62880','02450','07620','80200','02110','02110','62116','07618','07620','80300','80240','59112','07380','59570','80200','07387','07387','80240','80360','07620','59570','80200','07608','02760','59830','02100','59830','59570','59830','02510','62153','62450','80300','62116','62173','62173','59273','07382','07387','80200','59163','02490','02100','59147','80360','02510','02110','62161','62161','59570','02120','62116','59113','80300','02110','80360','02510','62800','07502','07350','02450','02450','02490','02490','59570','62410','80300','02110','62161','59570','59185','02120','02120','62410','80200','80200','07641','07604','62111','59145','59251','07506','59570','07504','59175','62123','62144','80360','80200','02760','59780','59550','62143','59830','02100','62123','59570','80200','59550','59175','62410','59262','02490','07603','59147','62153','59112','62750','07320','07500','02100','07600','62161','07370','07387','62123','62123','59145','59221','59810','59147','07350','80200','02120','07500','07387','07640','07640','02120','62123','62410','02720','07640','80300','80300','80300','02170','59570','62144','59550','07370','80300','59263','62138','07604','80200','80200','59155','80360','02450','02450','02120','62111','07643','07642','59152','59780','59152','59152','07387','62123','59138','62123','62123','59620','59139','07601','80200','02510','07522','59620','07604','80300','02100','62111','07350','80200','80300','80340','59272','02120','80300','80200','07521','02120','02720','07370','59244','59139','62144','80200','07322','62123','59790','07538','62111','07321','07501','59496','62138','07522','07321','02120','62123','62160','62160','59184','62160','02590','62144','80300','59138','02390','80300','62111','07370','62123','07536','62111','59620','02720','07522','07602','07604','59550','02680','59152','80200','02430','62144','59570','80340','02590','07350','59244','80200','07604','07500','62123','62123','02590','02590','59440','59136','80340','02450','02100','59138','02170','02170','62690','07530','59138','59496','59570','62111','59260','07522','80300','07322','59274','07971','80200','02120','62138','59620','02590','02590','80300','80200','59570','07548','59320','62690','07971','59244','59440','07503','07973','62123','62172','80980','80400','80200','80300','59320','62138','02390','07971','62980','07972','62690','07971','59330','62158','59780','02680','02680','62530','02680','02240','80560','62123','02680','62158','59510','02590','07300','07340','02390','02590','07534','59480','62810','59134','07904','62114','80560','62670','07904','62530','80300','59120','02240','59211','02170','62980','80200','07973','07540','07531','62690','62149','62158','59134','02390','62138','62690','80200','62690','02120','62810','80200','62111','80560','07520','80340','02120','59134','62810','59330','62760','59000','59800','59160','59350','59777','62149','59390','59320','07334','80340','80810','62111','62690','80300','80560','80560','59370','59480','59134','59320','02790','59510','80200','80200','80200','62690','02480','62149','07540','59440','62149','80320','02120','80400','02240','80340','80340','07301','02690','62158','59330','59620','07080','62810','80300','07340','62530','07330','07532','02590','02590','07520','07340','59440','02590','62113','62113','80400','02240','80300','59320','59320','80340','07040','07340','80320','07972','62810','59750','07906','07904','02170','59110','07040','07334','02240','80400','80190','02120','62690','59440','07333','07534','59320','59330','59330','80560','59330','62290','62760') AND fami_id='5' AND cate_id='227' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='725' AND wish_id<>'273386' 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='725' 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=359487 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 = 359487 AND W.type_id = 1) OR (W.util_id <> 359487 AND W.type_id = 2)) AND (M.post_util_id = 359487 OR M.dest_util_id = 359487) 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 = 359487

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

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

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

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

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

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

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

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

  59. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='725' LIMIT 0,1

  60. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=128273 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 = 128273 AND W.type_id = 1) OR (W.util_id <> 128273 AND W.type_id = 2)) AND (M.post_util_id = 128273 OR M.dest_util_id = 128273) 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 = 128273

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

  66. 0.0001

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

  67. 0

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

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

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

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

  71. 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 (81) ORDER BY ssrubr_order ASC

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

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

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

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

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

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

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

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

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

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

  87. 0.0009

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

  88. 0.024

    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'

  89. 0.0161

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

89 requetes sql en 0.0692

Taille variable Globale : 84.65 KB