-40kg
qu'à l'achat
Description de l'annonce
A louer à personnes sérieuses et qui saura prendre soin de l'appareil
#Appareil photo numerique
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-40kg
qu'à l'achat
A louer à personnes sérieuses et qui saura prendre soin de l'appareil
#Appareil photo numerique
Louer un appareil photo entre particuliers ou proposer un appareil photo en location.
Poster une annonce
-40kg
qu'à l'achat
Envoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
-40kg
qu'à l'achat
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom, filtre_villes, dpt_url FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci
SHOW TABLES LIKE 'pays'
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
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
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
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<>''
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='340854'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='appareil-photo-numerique' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='643'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'appareil-photo-numerique' LIMIT 1
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='232'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('02' USING utf8mb4) COLLATE utf8mb4_general_ci
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='145046' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 145046
SELECT util_cp FROM utilisateur WHERE util_id=145046 LIMIT 1
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 = 340854
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=643 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 145046 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='340854'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='340854' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=145046 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=145046 AND note_visu IN (1,3,4)
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 = 145046 AND W.type_id = 1) OR (W.util_id <> 145046 AND W.type_id = 2)) AND (M.post_util_id = 145046 OR M.dest_util_id = 145046) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
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 = '340854'
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='145046' AND wish_id<>'340854' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (w.wish_area IS NULL OR w.wish_area='' OR w.wish_area='FR')
SELECT ssrubr_slug, ssrubr_title, 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='1050' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 145046
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='02760'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.21667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.417039197041 AND ville_latitude_deg<50.316360802959 AND ville_longitude_deg>2.5190471629903 AND ville_longitude_deg<3.9142928370097 HAVING distance <= 50 ORDER BY distance ASC
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_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('02760','02490','02760','02100','02100','02490','02490','02490','02490','02100','02680','02590','02420','02430','02100','02590','02590','02420','02100','02100','02680','02680','02680','02590','02100','02490','02490','02680','02490','02490','80240','02490','02420','02590','02100','02100','02790','02420','80240','02420','02420','02480','02590','02590','02420','02100','80240','02720','02590','80240','02420','80200','02720','02420','02420','80240','80240','02480','02100','02590','02590','02690','80200','80200','02480','80240','02420','02690','02240','02110','80400','80240','02110','02590','02420','80240','02590','02420','80740','02640','02110','02720','02640','80240','02110','02480','02440','02110','02440','02440','02420','80200','80400','02420','80200','02240','80112','02480','02240','80200','02440','02440','02110','80740','02110','02240','80200','80240','80240','02110','80400','02240','02480','02420','02520','02480','02110','80200','80400','02240','02610','02480','02230','80400','80400','02240','02240','02440','80240','02480','02440','80200','02240','02390','80240','80240','02240','02110','80400','80190','80400','80400','80200','02390','02420','02700','59266','80240','02110','80400','80200','59297','02480','80400','80122','02800','80200','80190','02240','59142','02110','80200','02300','02390','02110','02240','80400','02120','59266','80200','80190','80240','02390','59231','02300','02700','80190','80240','02110','80200','02110','80190','80190','60640','02120','59127','80200','80200','59231','59127','60640','80200','80200','80400','80360','02800','80760','80190','80200','59266','02240','80400','02700','02240','02300','02800','80200','80190','59127','80360','02240','80400','60640','02800','02240','02110','02110','60640','80200','02120','59127','59258','02300','02120','80320','80190','80190','80400','80190','02110','62124','60640','02800','59231','02700','59238','80360','80320','80200','02300','80320','80190','80190','02120','80200','80400','02800','80200','02800','80200','80320','59137','60640','62147','59258','02300','80360','59258','02300','80200','80400','02630','80200','62124','59191','02240','02800','62124','80360','02270','80200','60640','02800','02800','59159','59127','62124','62124','60640','02630','02800','02110','02110','80190','80190','60640','02120','02120','59225','80190','80930','80400','60640','59191','02700','80200','02300','59241','59980','59980','80200','60640','02300','59159','62124','80320','02120','02800','02300','02300','02700','02270','80360','59191','80320','80320','80320','02300','80190','60640','02800','59267','80200','59400','02120','80700','80700','80190','02270','62124','59980','02270','62147','02700','80340','02120','62450','80360','59225','59281','02800','02300','02300','80980','02300','80200','02300','02120','80360','62124','02110','80320','80700','80190','59400','02700','60310','60640','02800','02270','59159','80360','80700','80320','02120','80700','02110','59360','60310','02270','02270','60640','80360','59980','02510','62147','59400','59217','60400','59360','80200','80320','02120','62450','80360','60400','02270','80700','80340','80320','60400','02800','80360','62124','80700','62124','59980','02300','59157','62450','02300','59400','80340','59267','62147','02510','62147','59400','80340','59157','02410','80360','02630','02120','62450','59400','02120','60310','60400','60400','02270','60640','60310','02270','62124','60400','59540','80320','62147','59540','60400','02410','80360','02700','80700','62124','59540','80360','60400','80700','02270','02110','62147','59217','80700','02270','59267','59400','02300','59540','62450','80340','80340','02510','02300','59400','80170','02510','80340','02120','59217','60400','60310','60400','59400','80340','62450','02300','60400','59360','80170','80700','80360','59360','02270','80700','80300','62860','62124','60400','80360','80700','02870','59217','02120','80700','02270','60310','80340','02120','02120','80360','60400','60310','80700','02870','02450','02450','59554','62450','62124','59360','80170','02270','02300','62860','60400','02410','80170','02670','59161','80300','62450','02250','02270','80131','02870','59271','02270','02450','60400','60400','80170','59214','59554','80700','80700','02450','02380','62450','80300','80340','80340','59554','62159','59360','60310','02000','62450','59360','80700','60310','62860','80700','62159','60400','62450','59360','02250','80121','02120','80131','02300','62450','80300','59161','02670','59360','60400','02120','02120','02120','59554','59161','02300','60400','60400','62450','02250','02870','60400','59161','80170','02320','62450','59360','02380','59292','60400','02380','62450','02870','62450','02270','02140','80700','59277','02270','02450','80300','02450','59730','02000','02320','02300','60400','62860','62450','02120','80300','60310','02870','80340','59268','59129','59265','02300','59554','62860','02380','02300','59265','02300','59400','02000','59188','02300','80700','02380','62860','80700','80170','59141','80131','59360','02320','80340','80700','02250','02250','60310','02140','60310','62128','59222','02870','02120','80170','62450','02250','60310','59730','02250','62860','02380','60400','60400','80300','02320','02270','02270','80300','02450','80300','80700','02000','02170','62121','62121','60400','02000','60310','80700','80910','02000','62860','59730','02140','80340','62860','60138','02380','59265','59554','02300','02170','80800','62159','59222','59730','80170','80170','80300','59141','02380','59188','60310','60310','59360','02320','62128','62128','02140','80700','62860','59141','80300','80810','59188','60170','02320','80170','62860','62121','80800','62182','80170','80170','80700','60310','62182','60310','02120','62121','60310','02260','02250','02380','80300','62182','80700','80300','02250','80500','80700','02170','02140','59222','02000','59247','59247','80300','59265','80300','02140','62121','02320','59295','59295','02000','02140','02000','02260','80170','02300','80300','02260','62121','80300','80300','62860','80300','02380','80700','02350','02000','80910','62182','59294','59550','60170','62121','59730','60400','02380','80300','80500','02140','02250','02250','02170','02140','62128','59218','02000','02000','62860','62860','80300','59227','59227','02140','60310','02000','62128','02320','02000','59550','02140','62860','59296','80500','02000','80700','60310','02140','62128','80118','02140','59247','02840','02290','02000','80800','80800','02290','60170','80720','62860','59265','59252','02320','80500','02290','02290','59111','59151','60170','62156','59198','60170','59730','59111','02000','59550','60310','62860','62121','80300','59218','59218','59111','02000','62121','59288','59550','02620','02580','60490','80500','80800','02250','02320','62128','80300','59218','59530','80134','80300','59550','62156','62116','60490','80500','80300','59234','59259','80110','02140','59252','02350','02290','59550','59252','02290','60490','80800','80720','02140','62156','02250','80300','60170','80720','62116','60170','80110','62128','60350','59111','59530','80500','60350','02880','60490','60157','02140','02000','59151','62156','60170','80300','02260','80300','62156','59213','59213','59151','02000','02350','60490','02840','62116','80113','62156','02320','02140','02880','62121','02350','80300','60490','80800','02000','62128','59282','60150','80110','80500','62116','80800','80800','80110','62490','59234','02880','02290','02290','59234','59213','59213','62128','62175','59550','80300','80500','60150','62156','59227','60490','02860','59151','02250','02320','59530','80500','02880','59172','60150','60150','02880','80300','62128','60490','60490','59169','02840','80110','02140','62128','80300','62490','59213','62116','59172','60150','02880','02250','80500','62175','02140','60490','62175','80800','80500','62128','02140','60350','59293','80560','80500','02860','02580','02350','80110','59151','59213','02880','02880','80560','62128','02350','02260','02000','62490','59282','59224','02880','59530','59530','80113','80500','62175','60490','02860','80110','62118','02140','02860','02880','60150','02000') AND fami_id='5' AND cate_id='232' AND type_id='1' AND ssrubr_id='643' AND wish_id<>'340854' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_slug, ssrubr_title, 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='643' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=204306 AND note_visu IN (1,3,4)
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 = 204306 AND W.type_id = 1) OR (W.util_id <> 204306 AND W.type_id = 2)) AND (M.post_util_id = 204306 OR M.dest_util_id = 204306) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 204306
SELECT ssrubr_slug, ssrubr_title, 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='643' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=110167 AND note_visu IN (1,3,4)
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 = 110167 AND W.type_id = 1) OR (W.util_id <> 110167 AND W.type_id = 2)) AND (M.post_util_id = 110167 OR M.dest_util_id = 110167) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 110167
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 643
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 643
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT COUNT(*) AS nbavis FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
Contactez-nous