à tous mes voisins
... pour louer un objet
ou pour un service
Trouver près de chez soi
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='repas-fait-maison'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=80
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='78'
SELECT ville_nom FROM villes WHERE ville_cp='78280' AND ville_nom like '%guyancourt%' ORDER BY ville_population_2012 DESC LIMIT 0,1
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='78280'
SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.06667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.586835678816 AND ville_latitude_deg<48.946564321184 AND ville_longitude_deg>1.7937867581343 AND ville_longitude_deg<2.3395532418657 HAVING distance <= 20 ORDER BY distance ASC
SELECT ssrubr_id, ssrubr_title, ssrubr_slug, ssrubr_photo, cate_title_slug, ssrubr_mail FROM ssrubr ss, category c WHERE ss.cate_id=c.cate_id AND ssrubr_visu=1 AND c.cate_title_slug='repas-fait-maison' AND ss.fami_id=3 ORDER BY ssrubr_order
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='80' AND wish_visu IN (1,6,10) AND wish_cp like '78280%'
SELECT * FROM texte WHERE cate_id=80
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 count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='80' AND wish_visu IN (1,6,10) AND wish_cp IN (78280,78280,78960,78180,78210,78114,78470,78117,78117,78350,78530,78390,78470,78190,78330,78000,91190,78350,91190,78590,78460,78470,78150,78220,91400,78320,78450,78150,78340,78990,78320,78720,78720,78590,78140,78870,91470,78860,78460,78320,78370,91440,92370,91430,91190,91940,92420,92430,78310,78450,78170,78720,91470,78620,91570,78310,78160,92410,92310,91400,91430,78430,91400,92380,91940,78380,78290,78760,78112,78750,91470,91470,78810,78720,91940,78640,78690,78560,78690,92360,92190,92210,78640,78400,91640,78850,78640,91120,92290,78490,92350,91370,78810,78100,78240,78230,92140,78110,78240,92100,91140,91140,78610,78640,92130,92260,92330,78490,78490,78121,92500,92320,91300,91160,92150,92800,78830,91470,91640,78720,78490,92160,78650,91160,78830,92220,78610,78125,92000,91640,78360,78630,91620,78490,92240,92340,78490,78490,94260,78300,92170,78650,91380,91160,78420,91640,92120,91460,78800,91160,78600,91680,92200,78124,91620,94234,94235,94239,94238,94237,94240,94230,94231,94233,94236,94232,78770,78610,94110,92400,78490,91320,78580,92250,78580)
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='80' AND wish_visu IN (1,6,10) AND wish_cp IN (78280,78280,78960,78180,78210,78114,78470,78117,78117,78350,78530,78390,78470,78190,78330,78000,91190,78350,91190,78590,78460,78470,78150,78220,91400,78320,78450,78150,78340,78990,78320,78720,78720,78590,78140,78870,91470,78860,78460,78320,78370,91440,92370,91430,91190,91940,92420,92430,78310,78450,78170,78720,91470,78620,91570,78310,78160,92410,92310,91400,91430,78430,91400,92380,91940,78380,78290,78760,78112,78750,91470,91470,78810,78720,91940,78640,78690,78560,78690,92360,92190,92210,78640,78400,91640,78850,78640,91120,92290,78490,92350,91370,78810,78100,78240,78230,92140,78110,78240,92100,91140,91140,78610,78640,92130,92260,92330,78490,78490,78121,92500,92320,91300,91160,92150,92800,78830,91470,91640,78720,78490,92160,78650,91160,78830,92220,78610,78125,92000,91640,78360,78630,91620,78490,92240,92340,78490,78490,94260,78300,92170,78650,91380,91160,78420,91640,92120,91460,78800,91160,78600,91680,92200,78124,91620,94234,94235,94239,94238,94237,94240,94230,94231,94233,94236,94232,78770,78610,94110,92400,78490,91320,78580,92250,78580) AND type_id=1 GROUP BY wish_id ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 121,60
SELECT ssrubr_id, ssrubr_title, ssrubr_slug, ssrubr_photo, cate_title_slug FROM ssrubr ss, category c WHERE ss.cate_id=c.cate_id AND ssrubr_visu=1 AND ss.cate_id=80 AND ss.fami_id=3 ORDER BY ssrubr_order LIMIT 6,100
SELECT ss.fami_id, fami_url, ss.cate_id, cate_title_slug, keywords_title FROM `ssrubr_keywords` sk, ssrubr ss, category c, family f WHERE sk.ssrubr_id=ss.ssrubr_id AND ss.cate_id=c.cate_id AND c.fami_id=f.fami_id AND (ssrubr_slug='' OR ssrubr_slug like '%%' OR MATCH (ssrubr_slug) AGAINST ('(+)')) AND sk.ssrubr_id='' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10
SELECT * FROM actu WHERE ssrubr_id='' AND actu_niveau=0 ORDER BY actu_ordre DESC
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish
Contactez-nous