Description de l'annonce
Je donne une quantité d'affaires, vêtements ,vaisselle et autres objets divers qui m'encombrent
#Dj
Voir les annonces autour de moi Géolocaliser
Poster une annonce
Je donne une quantité d'affaires, vêtements ,vaisselle et autres objets divers qui m'encombrent
#Dj
Demande un service dj entre voisins ou proposer mes services dj.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
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='316592'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='dj' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='1147'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'dj' 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='3' AND c.cate_id='230'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('72' 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='115726' 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` = 115726
SELECT util_cp FROM utilisateur WHERE util_id=115726 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 = 316592
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1147 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 115726 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='316592'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='316592' 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=115726 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=115726 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 = 115726 AND W.type_id = 1) OR (W.util_id <> 115726 AND W.type_id = 2)) AND (M.post_util_id = 115726 OR M.dest_util_id = 115726) 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 = '316592'
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='115726' AND wish_id<>'316592' 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 ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='72430'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.033333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.417039197041 AND ville_latitude_deg<48.316360802959 AND ville_longitude_deg>-0.70361731436647 AND ville_longitude_deg<0.63695131436647 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 ('72430','72430','72270','72430','72210','72270','72430','72210','72430','72330','72210','72270','72210','72210','72270','72210','72330','72270','72270','72330','72540','72430','72330','72270','72430','72270','72430','72300','72230','72700','72210','72540','72210','72540','72350','72350','72200','72700','72330','72700','72510','72430','72540','72200','72300','72540','72350','72550','72200','72540','72200','72540','72550','72540','72510','72550','72510','72700','72230','72230','72300','72540','72510','72350','72700','72350','72350','72300','72220','72200','72220','72700','72540','72540','35660','72550','72220','72300','72540','72800','72220','72550','72300','72300','72800','72230','72650','72550','72510','72200','72240','72220','72240','72220','72300','72200','72000','72100','72240','72350','72540','72300','72300','72240','72190','72230','72650','72650','53340','72360','72240','72190','72650','72350','72530','72800','72650','72300','72300','72240','72360','72240','72300','53340','72560','53340','49430','72190','49150','72220','53290','49430','72800','72240','72250','49150','72240','72220','49150','72190','72800','53290','53270','72360','72240','72140','72650','35131','53340','49150','72140','53290','53270','53340','49490','72800','49430','72250','53270','72800','49640','53290','72380','49430','49640','72240','35320','49150','72240','49150','53270','49430','53270','72500','72140','72380','53290','53290','53340','49640','35390','49490','72800','72380','72470','53340','72380','72380','72140','49150','35230','49140','72500','72500','72250','72460','72500','49490','72150','53270','72470','49430','49150','72380','49330','72140','49140','53270','72170','72140','72290','72380','53290','72470','72460','49330','72170','72500','53170','49150','53170','53600','49150','72370','72140','72140','72500','49490','72150','72170','72500','72170','49490','72500','49150','53290','72140','72290','53600','49140','72440','72170','53480','49490','49140','72450','72500','72500','49330','72150','53170','72290','72150','53600','72290','53170','53170','72500','49330','49140','49490','72440','72500','49330','49490','72370','72290','53160','53480','53170','72370','72460','72500','72170','53290','49140','53480','37370','49150','53160','72170','49490','53290','49150','72170','72170','37330','37330','35520','53160','49150','49140','72290','49140','53150','72500','72150','53170','72370','72370','53600','53290','72450','49490','53200','72500','49330','37330','49330','72130','72290','53200','49490','49125','72140','49150','49250','53600','49140','49330','72110','72170','72500','53200','72340','35410','53150','37330','49140','49140','72290','49140','37330','72170','72170','49250','53170','72170','37330','72340','53150','72160','53170','72110','49150','53600','72130','49390','72160','72110','72110','49125','72150','49490','72260','72440','72440','53150','53170','72150','72170','72130','49490','72440','53210','49140','49140','72340','53700','49330','37330','53200','53160','37330','49140','72160','53600','72150','72130','49490','72160','53200','49330','72110','35235','49250','53200','53170','72130','72160','72260','53170','37370','49112','72440','72260','53160','53150','49330','37330','53200','72110','49125','72340','53700','72130','49800','72340','72120','53150','72130','49460','49250','37370','37370','53200','72170','72110','53160','37330','72110','53260','72160','49250','72390','49220','72160','72110','53700','72130','72110','72120','49460','53200','53210','72260','72260') AND fami_id='3' AND cate_id='230' AND type_id='1' AND ssrubr_id='1147' AND wish_id<>'316592' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
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='3' 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 (50) 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 (38) 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 (45) 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 (231) 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 (47) 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 (42) 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 (37) 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 (43) 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 (39) 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 (229) 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 (230) 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