à tous mes voisins
... pour louer un objet
ou pour un service
Voir les annonces autour de moi Géolocaliser
Poster une annonce
Voir les annonces autour de moi Géolocaliser
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wall.php
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
SELECT cate_id FROM category WHERE fami_id='5' AND cate_title_slug='high-tech'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=208
SELECT filtre_dptnom, filtre_villes, dpt_url FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('10' USING utf8mb4) COLLATE utf8mb4_general_ci
SELECT ville_nom FROM villes WHERE ville_cp='10120' AND ville_nom like '%saint%pouange%' ORDER BY ville_population_2012 DESC LIMIT 0,1
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 ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE ssrubr_slug='sono' AND cate_id='208' LIMIT 0,1
SELECT COUNT(wish_id) AS nb FROM wish WHERE ssrubr_id=1111 AND type_id=1 AND wish_visu IN (1,6,10)
SELECT ssrubr_meta_title, sssrubr_h1 FROM ssrubr WHERE ssrubr_id=1111 LIMIT 1
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 ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='10120'
SELECT ville_cp, ROUND((((acos(sin((48.2333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.2333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.98333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.053435678816 AND ville_latitude_deg<48.413164321184 AND ville_longitude_deg>3.7133031841369 AND ville_longitude_deg<4.2533568158631 HAVING distance <= 20 ORDER BY distance ASC
SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='Sono'
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='208' AND ssrubr_id='1111' AND wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp like '10120%'
SELECT * FROM texte WHERE cate_id=208
SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='sono' OR ssrubr_slug='sono' OR (ssrubr_title like '%sono%')) AND cate_id='208' ORDER BY ssrubr_id LIMIT 0,1
SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='sono' AND cate_id='208'
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='10120'
SELECT ville_cp, ROUND((((acos(sin((48.2333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.2333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.98333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.783639197041 AND ville_latitude_deg<48.682960802959 AND ville_longitude_deg>3.308257139136 AND ville_longitude_deg<4.658402860864 HAVING distance <= 50 ORDER BY distance ASC
SELECT COUNT(*) AS cnt FROM (SELECT wish.wish_id FROM wish LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='208' AND ssrubr_id='1111' AND wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('10120','10120','10190','10120','10320','10320','10440','10120','10190','29190','29590','10320','10440','10430','10190','10800','10120','10320','10320','10300','10190','10320','10800','10420','10320','10800','10450','10800','10320','10300','10300','10800','10800','10190','10800','10190','10190','10000','10320','10320','10800','10800','10800','10320','10320','10800','10600','10320','10150','10600','10320','10390','10160','10800','10410','10150','10320','10190','10800','10130','10130','10800','10150','10190','10600','10180','10130','10130','10190','10410','10160','10600','10410','10260','10160','10130','10190','10150','10410','10260','10350','10270','10160','10390','10600','10600','10350','10270','10190','10150','10130','10600','10190','10160','10270','10260','10270','10270','10260','10130','10210','10260','10160','10130') AND type_id=1 GROUP BY wish_id) t
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify, ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.2333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.2333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.98333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='208' AND ssrubr_id='1111' AND wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('10120','10120','10190','10120','10320','10320','10440','10120','10190','29190','29590','10320','10440','10430','10190','10800','10120','10320','10320','10300','10190','10320','10800','10420','10320','10800','10450','10800','10320','10300','10300','10800','10800','10190','10800','10190','10190','10000','10320','10320','10800','10800','10800','10320','10320','10800','10600','10320','10150','10600','10320','10390','10160','10800','10410','10150','10320','10190','10800','10130','10130','10800','10150','10190','10600','10180','10130','10130','10190','10410','10160','10600','10410','10260','10160','10130','10190','10150','10410','10260','10350','10270','10160','10390','10600','10600','10350','10270','10190','10150','10130','10600','10190','10160','10270','10260','10270','10270','10260','10130','10210','10260','10160','10130') AND type_id=1 GROUP BY wish_id ORDER BY distance ASC, wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 600
SELECT cate_title_slug, cate_title FROM category WHERE cate_id=208 LIMIT 1
SELECT ss.ssrubr_id, ss.ssrubr_slug, ss.ssrubr_title, ss.ssrubr_mail, c.cate_title_slug FROM ssrubr ss INNER JOIN category c ON ss.cate_id = c.cate_id WHERE ss.ssrubr_id = 1111 LIMIT 1
SELECT ssrubr_filtre_1, ssrubr_filtre_2, ssrubr_filtre_3, ssrubr_filtre_4, ssrubr_filtre_5, ssrubr_filtre_6, ssrubr_filtre_7, ssrubr_filtre_8, ssrubr_filtre_9 FROM ssrubr WHERE ssrubr_id=1111 LIMIT 1
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 (208) 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