à 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='salle'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=176
SELECT filtre_dptnom, filtre_villes, dpt_url FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('03' USING utf8mb4) COLLATE utf8mb4_general_ci
SELECT ville_nom FROM villes WHERE ville_cp='03000' AND ville_nom like '%moulins%' 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='tente-de-reception' AND cate_id='176' LIMIT 0,1
SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_title like '%tente%de%reception%' OR ssrubr_slug like '%tente%de%reception%') AND cate_id='176' ORDER BY ssrubr_id LIMIT 0,1
SELECT cate_title_form, cate_title FROM category WHERE cate_title='tente%de%reception' OR cate_title_aff='tente%de%reception' LIMIT 0,1
SELECT sk.ssrubr_id, sk.keywords_title, sk.keywords_visu, ss.ssrubr_visu, ss.ssrubr_slug FROM `ssrubr_keywords` sk INNER JOIN ssrubr ss ON sk.ssrubr_id=ss.ssrubr_id WHERE ss.cate_id='176' AND (LOWER(sk.keywords_title) = LOWER('tente de reception') OR REPLACE(LOWER(sk.keywords_title), ' ', '-') = 'tente-de-reception' OR sk.keywords_title LIKE '%tente%de%reception%') ORDER BY LENGTH(sk.keywords_title) ASC LIMIT 0,30
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='03000'
SELECT ville_cp, ROUND((((acos(sin((46.5667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((46.5667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.33333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>46.386835678816 AND ville_latitude_deg<46.746564321184 AND ville_longitude_deg>3.0717124215538 AND ville_longitude_deg<3.5949475784462 HAVING distance <= 20 ORDER BY distance ASC
SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='tente de reception'
SELECT ssrubr_slug, ssrubr_title FROM ssrubr WHERE ssrubr_id=889 LIMIT 1
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='176' AND ssrubr_id='889' AND MATCH (wish_title, wish_desc) AGAINST ('(+tente +de +reception*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp like '03000%'
SELECT * FROM texte WHERE cate_id=176
SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='tente de reception' OR ssrubr_slug='tente-de-reception' OR (ssrubr_title like '%tente de reception%')) AND cate_id='176' ORDER BY ssrubr_id LIMIT 0,1
SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='tente-de-reception' AND cate_id='176'
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='03000'
SELECT ville_cp, ROUND((((acos(sin((46.5667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((46.5667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.33333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>46.117039197041 AND ville_latitude_deg<47.016360802959 AND ville_longitude_deg>2.6792804139637 AND ville_longitude_deg<3.9873795860363 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='176' AND ssrubr_id='889' AND MATCH (wish_title, wish_desc) AGAINST ('(+tente +de +reception*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('03000','03000','03400','03000','03000','03000','03400','03000','03460','03000','03210','03400','03210','03460','03230','03230','03210','03340','03210','03400','03460','03460','03210','03210','03340','03210','03340','03210','58390','03340','03230','58380','03460','03240','03340','03340','03500','58240','03230','03210','03160','03210','03340','58300','58240','03230') 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((46.5667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((46.5667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.33333- 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='176' AND ssrubr_id='889' AND MATCH (wish_title, wish_desc) AGAINST ('(+tente +de +reception*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('03000','03000','03400','03000','03000','03000','03400','03000','03460','03000','03210','03400','03210','03460','03230','03230','03210','03340','03210','03400','03460','03460','03210','03210','03340','03210','03340','03210','58390','03340','03230','58380','03460','03240','03340','03340','03500','58240','03230','03210','03160','03210','03340','58300','58240','03230') AND type_id=1 GROUP BY wish_id ORDER BY distance ASC, wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 600
SELECT ss.ssrubr_id, ss.ssrubr_title, ss.ssrubr_slug, ss.ssrubr_photo, ss.ssrubr_mail, ss.cate_id, ss.fami_id, c.cate_title_slug FROM ssrubr ss, category c WHERE ss.cate_id=c.cate_id AND ssrubr_visu=1 AND ss.cate_id=176 AND ss.fami_id=5 ORDER BY ssrubr_order
SELECT cate_title_slug, cate_title FROM category WHERE cate_id=176 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 = 889 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 (176) 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