Indiquer un code postal ou une ville Indiquer un code postal

Poster une annonce

Se connecter S'inscrire

i18n

Location Drone

Location drône Dji Air 2 S

Lesquin (59810) · publié depuis 3 mois ou +

Location High-tech Drone

Réserver

Alexis W. 1 annonce

-50kgqu'à l'achat

Description

Bonjour,
Je propose mon drône Dji Air 2 S en location.
3 batteries
La télécommande et 2 joysticks supplémentaires de rechange
Un sac de transport
Le chargeur secteur
Hélices de rechange
Les 2 câbles de connection téléphone - télécommande
4 filtres UV : ND 4/8/16/32
L'ensemble est livré dans sa sacoche de transport.
Caractéristiques techniques :
Vidéo 5,4 K 30FPS / 4K 60FPS
Autonomie 30 min
Altitude maximale de vol 5000m
Vitesse maximale 70 km/h
Stabilisation par nacelle
600g
N'hésitez pas si vous avez des questions.
PS : Je peux également réaliser des prises de vues pour vous. #drone

50 € / jour

Paiement 100% sécurisé

Service client réactif
Dépôt remboursé si annulé

Annonces similaires

Tout voir

Il y a + de 30j

Drone dji flip 2h d’autonomie

40€/jour

Lille

Il y a + de 30j

Drone DJI Mini 2 Fly More Combo

40€/jour

Villeneuve-d'Ascq

Il y a + de 30j

Mavic Air 3 avec 3 batteries

50€/jour

Raismes

Il y a + de 30j

Drone dj mini 2 fly combo pack complet

70€/jour

Lille

4,2/5 résa

Il y a + de 30j

Location drone

70€/jour

Hazebrouck

Il y a + de 30j

Location drone djimini2 4k flymore combo

60€/jour

Lille

Il y a + de 30j

Drone dji mavic mini 2

60€/jour

Roncq

4,2/5 résa

Il y a + de 30j

Dji mavic 2 pro - kit fly more - filtres

55€/jour

Lille

Il y a + de 30j

Loue drône avec son pilote

75€/jour

Revin

Il y a + de 30j

Drone dji mavic pro 2 + 3 batteries

50€/jour

Lille

Louer un drone entre particuliers ou proposer un drone en location.

Poster une annonce

Location entre voisins

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Autre chose ?

Contactez-nous

Script : /wiiz-annonce.php

0.0001
SELECT filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci
0.0002
SHOW TABLES LIKE 'pays'
0.0002
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
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
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
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<>''
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='386565'
0.0001
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'drone' LIMIT 1
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='208'
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
0.0001
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='37628' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0.0001
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 37628
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 = 386565
0.0001
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=652 LIMIT 1
0.0001
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 37628 AND util_tel != ''
0.0001
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='386565'
0.0001
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='386565' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
0.0001
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=37628 LIMIT 1
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 = 37628 AND W.type_id = 1) OR (W.util_id <> 37628 AND W.type_id = 2)) AND (M.post_util_id = 37628 OR M.dest_util_id = 37628) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='37628' AND note_visu IN (1,3,4)
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 = '386565'
0.0001
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 652
0.0004
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='37628' AND wish_id<>'386565' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0.0001
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='59810'
0.0377
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.5833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.5833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.11667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.133639197041 AND ville_latitude_deg<51.032960802959 AND ville_longitude_deg>2.4084860928827 AND ville_longitude_deg<3.8248539071173 HAVING distance <= 50 ORDER BY distance ASC
0.0035
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 ('59810','59790','59155','59262','59260','59273','59175','59273','59830','59139','59175','59710','59710','59152','59152','59370','59160','59350','59000','59777','59800','59242','59830','59113','59139','59510','59830','59152','59710','59152','59120','59242','59110','59320','59263','59551','59242','59830','59710','59780','59510','59130','59551','59170','59700','59290','59830','59780','59320','59780','59350','59147','59320','59133','59390','59239','59830','59520','59147','59830','59147','59655','59650','59493','59491','59235','59320','59246','59390','59211','59320','59133','59390','59118','59239','59390','59840','07522','59310','59261','07522','59160','59112','59320','59310','59251','59910','59420','62820','59310','07502','07520','59100','59320','59320','07610','59237','59840','59310','07522','59840','07730','59112','59134','59136','07611','59115','59320','59272','07522','59150','59283','59200','07504','62220','59310','59184','07730','59185','59162','59310','62590','59310','07618','07712','59134','07506','07501','59126','59223','59283','59250','59134','59890','62790','59310','07730','07730','07730','07520','07503','62141','07500','59134','59148','59274','59280','59221','59310','07620','59496','59194','59286','59960','07730','07743','59930','62410','59134','59249','59690','59310','07624','07700','59950','62138','62119','59116','59870','62880','07700','07740','07500','07730','07743','07620','07500','59236','62710','62970','59280','59226','59480','59249','07621','59890','59194','59166','07620','07540','59496','62950','07620','59128','59117','62880','62880','07623','07740','07711','62640','59230','62840','07780','07780','62440','62138','07783','07521','07542','59560','59560','07742','59193','59870','62740','07548','62410','62880','59870','07536','07641','59230','07784','59119','07620','07620','07784','07642','59167','08930','62110','08940','08587','59178','59553','59870','59553','08510','62410','59480','07782','08510','08511','59146','07540','59178','62840','07640','62138','62840','07904','08930','59850','08587','59226','62410','08930','59870','62420','59450','62138','59158','62221','62218','59500','07622','08560','08510','07543','59182','59870','62138','07531','59870','07781','08587','59553','07643','59158','07760','62840','08940','08957','07640','62430','08554','62840','59552','59490','62490','59187','59287','62149','62300','59178','59158','59287','08510','59182','07530','62320','62320','07760','59552','59178','59176','62136','07540','62490','59490','59181','59158','59176','62149','62680','62320','08952','59230','08980','08950','62149','59179','07538','08583','07640','07532','59230','62320','08902','07760','62750','08501','59169','08953','59230','59171','07760','59169','62300','62112','62136','07533','59171','08552','62210','62149','62117','59940','08560','07540','59165','08500','62580','07604','62980','08980','59580','62490','08582','62136','08560','08501','62580','07760','59169','62149','08950','08890','59169','59171','62580','08550','59253','62112','59199','07534','08980','08956','62490','59940','08551','62980','08880','07760','07604','07608','59215','07534','62580','62490','62136','07604','62113','62113','62160','07604','62800','08902','08951','08902','59580','59199','07910','59135','62660','59169','07910','08580','59151','07750','59151','59270','08880','62400','62490','59234','62143','62400','08520','62580','62580','62670','59234','62580','59124','07906','59940','62580','08958','59255','08553','07750','62160','08880','07750','07750','59135','08530','07604','07911','62113','09690','62118','07910','07910','07910','62580','08900','59151','08980','59151','07910','62580','59220','62118','62290','07601','59270','62490','59234','08900','59156','07910','59494','07602','59970','62114','59172','59590','62153','59195','62580','07750','07904','08540','62490','07911','07911','08570','08890','62118','59660','62400','59252','08900','07901','07600','08581','08860','08570','59270','62160','59220','59252','59270','59172','59195','59192','08531','59151','62860','08954','62232','59265','62131','62131','62118','59494','08970','62350','08531','62118','08573','59259','59220','59293','62232','62232','07912','08980','62131','09690','62580','59247','62153','07603','62232','08791','62156','09690','09690','59163','62530','08581','59111','62118','07910','59410','07911','62156','59232','07912','07971','07900','07900','62920','59174','08908','59282','07911','59252','62172','59278','59270','07971','08900','62144','59860','59970','08572','62620','62860','62156','59111','59270','59121','62350','62860','62860','59265','62223','62232','08800','62223','62860','08870','62860','59247','62196','62156','07904','59270','08792','08710','62530','59121','62223','07971','59111','59247','59299','08570','07903','07971','08570','62223','59282','62620','62118','62199','62156','09600','62530','62223','08870','08770','08920','62350','62920','59970','59111','62156','59295','59295','62860','62860','62350','08800','59880','07911','08920','07903','62920','62156','59300','62144','08870','07972','08710','59224','62223','59125','62860','08904','08840','09690','07321','07972','62122','59265','07320','08906','62223','59554','09790','08840','62620','62940','08710','62144','59163','08920','59190','62223','62350','59770','07903','07812','08800','08790','59300','59163','62620','07972','62128','08780','59141','08970','09700','59270','59264','62690','59233','62182','62860','59190','09790','62000','59265','62150','59300','62860','62128','62217','59190','09681','59265','59268','59141','62128','62350','59224','62182','59554','59296','09790','62690','62700','59243','07812','62161','62161','62690','07973','62122','08904','08793','09790','62144','62150','59154','08640','59400','08920','07812','62350','07321','62217','62182','59114','08760','59198','62217','62128','62860','59554','59141','62150','62690','59990','07812','62860','62217','62217','07890','07973','62128','59990','09790','07911','08800','62540','07350','59990','09771','07812','08720','59161','62128','59554','59190','59554','59227','62000','59269','62128','62690','07970','62150','09680','07812','62690','62157','62150','59161','59269','62161','08850','59990','62144','09870','08840','62150','62540','07322','62182','59190','09790','09700','09700','59213','08830','59161','07380','59114','07350','07890','62190','59990','62161','09700','59920','62690','59114','07802','62330','62217','62150','07801','08720','07387','08650','07322','07950','59213','08720','59554','62690','09680','08650','59188','07950','09700','62860','62460','08640','59227','59227','09770','59189','09770','59990','62128','59277','09700','62690','59990','09772','62690','62190','62128','59188','08830','09660','09870','62470','59269','62123','59144','62151','07803','59161','62860','09688','07380','08978','59189','59400','62123','07804','62175','62860','07951','08647','59129','08647','62128','08740','62128','62150','07950','09700','59267','09680','62260','07890','59190','07800','08972','08640','62217','59400','08851','62860','62127','07880','62190','62460','62330','07334','07350','62470','08720','09700','59213','59213','62123','62123','62173','08640','62123','07950','07387','08972','62128','59114','59190','09700','62690','59670','07804','62690','59189','62690','59144','62260','09700','09700','59400','62127','59400','07387','08650','07382','07332','62123','62123','07332','62190','59530','59267','62147','62128','59294','62128','62150','08700','09750','59188','07810','59670','59530','62175','07950','62147','62690','59173','08647','09700','62690','07334','09800','59144','09700','07350','07387','08740','59400','07800','62550','59292','59217','09667','07370','07862','62121','62175','59470','07811','09667','09870','62120','62190','09800','07387','59213','62173','09667','07387','59213','62190','62190','59400','62159','08600','62173','08610','07861','59159','09660','08610','59670','59144','08610','07387','62175','09750','62123','09700') AND fami_id='5' AND cate_id='208' AND type_id='1' AND ssrubr_id='652' AND wish_id<>'386565' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
0.0015
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='652' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=534220 AND note_visu IN (1,3,4)
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 = 534220 AND W.type_id = 1) OR (W.util_id <> 534220 AND W.type_id = 2)) AND (M.post_util_id = 534220 OR M.dest_util_id = 534220) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 534220
0.0041
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='652' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=384761 AND note_visu IN (1,3,4)
0.0007
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 = 384761 AND W.type_id = 1) OR (W.util_id <> 384761 AND W.type_id = 2)) AND (M.post_util_id = 384761 OR M.dest_util_id = 384761) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 384761
0.0004
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='652' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=372568 AND note_visu IN (1,3,4)
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 = 372568 AND W.type_id = 1) OR (W.util_id <> 372568 AND W.type_id = 2)) AND (M.post_util_id = 372568 OR M.dest_util_id = 372568) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 372568
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='652' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=346926 AND note_visu IN (1,3,4)
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 = 346926 AND W.type_id = 1) OR (W.util_id <> 346926 AND W.type_id = 2)) AND (M.post_util_id = 346926 OR M.dest_util_id = 346926) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 346926
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='652' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=286555 AND note_visu IN (1,3,4)
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 = 286555 AND W.type_id = 1) OR (W.util_id <> 286555 AND W.type_id = 2)) AND (M.post_util_id = 286555 OR M.dest_util_id = 286555) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 286555
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='652' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=276899 AND note_visu IN (1,3,4)
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 = 276899 AND W.type_id = 1) OR (W.util_id <> 276899 AND W.type_id = 2)) AND (M.post_util_id = 276899 OR M.dest_util_id = 276899) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 276899
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='652' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=237741 AND note_visu IN (1,3,4)
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 = 237741 AND W.type_id = 1) OR (W.util_id <> 237741 AND W.type_id = 2)) AND (M.post_util_id = 237741 OR M.dest_util_id = 237741) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 237741
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='652' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=176520 AND note_visu IN (1,3,4)
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 = 176520 AND W.type_id = 1) OR (W.util_id <> 176520 AND W.type_id = 2)) AND (M.post_util_id = 176520 OR M.dest_util_id = 176520) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 176520
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='652' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=147364 AND note_visu IN (1,3,4)
0.001
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 = 147364 AND W.type_id = 1) OR (W.util_id <> 147364 AND W.type_id = 2)) AND (M.post_util_id = 147364 OR M.dest_util_id = 147364) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0014
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 147364
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='652' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=30183 AND note_visu IN (1,3,4)
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 = 30183 AND W.type_id = 1) OR (W.util_id <> 30183 AND W.type_id = 2)) AND (M.post_util_id = 30183 OR M.dest_util_id = 30183) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 30183
0.0001
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 652
0.0014
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
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
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
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
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
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
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
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
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 (79) ORDER BY ssrubr_order ASC
0.0007
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
0.0009
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
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
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
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 (173) ORDER BY ssrubr_order ASC
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
0.0013
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
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
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
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
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 (92) ORDER BY ssrubr_order ASC
0.0017
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
0.1231
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'
0.0486
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

90 requetes sql en 0.2423

Taille variable Globale : 84.71 KB