Trouver près de chez soi
Proposer mon aide
Louer du matériel ou offrir un service
Faire appel à mes voisins
Besoin d'un objet ou d'un service ?
Jobber
Jobber
Jobber
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='babysitting'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=39
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='92'
SELECT ville_nom FROM villes WHERE ville_cp='92270' AND ville_nom like '%bois%colombes%' ORDER BY ville_population_2012 DESC LIMIT 0,1
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='92270'
SELECT ville_cp, ROUND((((acos(sin((48.9167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.26667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.736835678816 AND ville_latitude_deg<49.096564321184 AND ville_longitude_deg>1.992968272488 AND ville_longitude_deg<2.540371727512 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='babysitting' AND ss.fami_id=3 ORDER BY ssrubr_order
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='39' AND wish_visu IN (1,6,10) AND wish_cp like '92270%'
SELECT * FROM texte WHERE cate_id=39
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 (39) 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='39' AND wish_visu IN (1,6,10) AND wish_cp IN (92270,92270,92700,92600,92300,92250,92400,92230,92110,92200,95100,95870,93800,78800,93400,92000,92390,93450,95110,95210,95218,92150,92800,78420,92500,95880,93210,93200,78500,93430,95120,95230,95130,95360,95530,75010,75013,75003,75007,75001,75009,75000,75002,75006,75008,75011,75012,75004,75116,75016,75020,75019,75018,75017,75014,75015,75005,93120,78360,93300,95240,95170,92210,93380,93240,78600,78400,95600,92100,95370,95410,95580,95580,95130,92170,93500,92380,93310,95160,78600,93350,95390,78110,92130,95320,95680,78290,78380,78170,92240,92420,92430,93440,92410,78560,92120,95350,95220,92310,95250,94250,92360,92190,95140,78430,93170,78230,95200,95400,95350,93260,93230,92140,92320,92220,95400,95480,94270,95500,93100,95150,95550,93700,93150,93000,78100,95330,94110,92370,78750,95440,94200,94205,78700,94300,78140,78150,94160,78160,78150,93140,95560,92350,95840,92330,95460,92260,78220,94800,95570,78112,93130,95740,95500,78870,95570,94236,94237,94233,94234,94235,94231,94239,94230,94238,94240,94232,94220,78260,78620,78300,95570,92340,78000,78570,78590,95720,95610,92290,93110,95840,95560,95720,94140,95560,78240,95500,78780,95540,78955,93250,94120,95720,94400,94550,94700,94410,95430,78350,95500,95000,95190,93340,78590,93320,78240,94130,94340,95310,91370,95590,78570,94170,93600,92160,94320,95560,94260,91570,93360,95630,95430,95300,95720,78530,78350,78330,94150,95000,78210,93270,78860,78670,78670,93220,95570,95190,94600)
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='39' AND wish_visu IN (1,6,10) AND wish_cp IN (92270,92270,92700,92600,92300,92250,92400,92230,92110,92200,95100,95870,93800,78800,93400,92000,92390,93450,95110,95210,95218,92150,92800,78420,92500,95880,93210,93200,78500,93430,95120,95230,95130,95360,95530,75010,75013,75003,75007,75001,75009,75000,75002,75006,75008,75011,75012,75004,75116,75016,75020,75019,75018,75017,75014,75015,75005,93120,78360,93300,95240,95170,92210,93380,93240,78600,78400,95600,92100,95370,95410,95580,95580,95130,92170,93500,92380,93310,95160,78600,93350,95390,78110,92130,95320,95680,78290,78380,78170,92240,92420,92430,93440,92410,78560,92120,95350,95220,92310,95250,94250,92360,92190,95140,78430,93170,78230,95200,95400,95350,93260,93230,92140,92320,92220,95400,95480,94270,95500,93100,95150,95550,93700,93150,93000,78100,95330,94110,92370,78750,95440,94200,94205,78700,94300,78140,78150,94160,78160,78150,93140,95560,92350,95840,92330,95460,92260,78220,94800,95570,78112,93130,95740,95500,78870,95570,94236,94237,94233,94234,94235,94231,94239,94230,94238,94240,94232,94220,78260,78620,78300,95570,92340,78000,78570,78590,95720,95610,92290,93110,95840,95560,95720,94140,95560,78240,95500,78780,95540,78955,93250,94120,95720,94400,94550,94700,94410,95430,78350,95500,95000,95190,93340,78590,93320,78240,94130,94340,95310,91370,95590,78570,94170,93600,92160,94320,95560,94260,91570,93360,95630,95430,95300,95720,78530,78350,78330,94150,95000,78210,93270,78860,78670,78670,93220,95570,95190,94600) AND type_id=1 GROUP BY wish_id ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 421,60
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='149304' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 149304
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='153583' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 153583
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='30781' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 30781
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='118045' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 118045
SELECT ssrubr_slug, 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='1031' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='86370' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 86370
SELECT ssrubr_slug, 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='942' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='153162' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 153162
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='153162' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 153162
SELECT ssrubr_slug, 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='942' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='152597' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 152597
SELECT ssrubr_slug, 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='1031' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='149247' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 149247
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='149720' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 149720
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='123630' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 123630
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='137393' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 137393
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='150431' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 150431
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='149125' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 149125
SELECT ssrubr_slug, 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='1031' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='69187' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 69187
SELECT ssrubr_slug, 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='939' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='148662' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 148662
SELECT ssrubr_slug, 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='939' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='148662' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 148662
SELECT ssrubr_slug, 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='942' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='148618' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 148618
SELECT ssrubr_slug, 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='1031' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='147969' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 147969
SELECT ssrubr_slug, 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='1031' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='147969' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 147969
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='147908' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 147908
SELECT ssrubr_slug, 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='1031' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='147658' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 147658
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='109273' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 109273
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='146878' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 146878
SELECT ssrubr_slug, 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='1031' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='145919' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 145919
SELECT ssrubr_slug, 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='939' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='145745' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 145745
SELECT ssrubr_slug, 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='1031' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='119425' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 119425
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='143790' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 143790
SELECT ssrubr_slug, 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='939' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='142514' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 142514
SELECT ssrubr_slug, 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='1031' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='101333' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 101333
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='141426' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 141426
SELECT ssrubr_slug, 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='1031' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='141295' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 141295
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='141090' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 141090
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='140668' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 140668
SELECT ssrubr_slug, 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='942' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='115057' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 115057
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='139767' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 139767
SELECT ssrubr_slug, 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='939' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='139264' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 139264
SELECT ssrubr_slug, 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='1031' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='138138' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 138138
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='137836' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 137836
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='137639' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 137639
SELECT ssrubr_slug, 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='942' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='137393' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 137393
SELECT ssrubr_slug, 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='941' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='53841' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 53841
SELECT ssrubr_slug, 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='1031' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='130323' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 130323
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='134505' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 134505
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='135179' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 135179
SELECT ssrubr_slug, 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='939' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='135162' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 135162
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='63067' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 63067
SELECT ssrubr_slug, 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='1031' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='135052' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 135052
SELECT ssrubr_slug, 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='939' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='134970' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 134970
SELECT ssrubr_slug, 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='942' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='134822' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 134822
SELECT ssrubr_slug, 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='939' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='134420' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 134420
SELECT ssrubr_slug, 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='942' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='134077' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 134077
SELECT ssrubr_slug, 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='939' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='133322' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 133322
SELECT ssrubr_slug, 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='1031' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='132903' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 132903
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='132984' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 132984
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='81989' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 81989
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='115251' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 115251
SELECT ssrubr_slug, 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='1008' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='131446' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 131446
SELECT ssrubr_slug, 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='1031' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='119170' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 119170
SELECT ssrubr_slug, 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='1031' LIMIT 0,1
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='130978' AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 130978
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=39 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