Kiwiiz : service & location entre voisins.
Utiliser ma position
Logo recherche

Indiquer un code postal ou une ville Indiquer un code postal

Flèche vers le champ lieu

Poster une annonce

Service à la personne

Autres annonces du voisin

Tout voir
Service cap petite enfance

Il y a + de 30j

Il y a + de 30j

Service : Garde d enfants

15€/heure

Ajaccio
Service aide menagere

Il y a + de 30j

Il y a + de 30j

Service : Aide ménagère

15€/heure

Ajaccio
Service aide menagere

Il y a + de 30j

Il y a + de 30j

Service : Aide ménagère

15€/heure

Ajaccio
Service aide aux courses

Il y a + de 30j

Il y a + de 30j

Service : Aide aux courses

15€/heure

Ajaccio

Annonces similaires

Tout voir
Service service a personne

Il y a + de 30j

Il y a + de 30j

Auxiliaire de vie (2h)

30€

Dreux
Service service a personne

Il y a + de 30j

Il y a + de 30j

élaboration d'un article

11€/heure

Dreux
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Repassage

15€/heure

Fozzano
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Micro entrepreneur

25€/heure

Bergerac
Service service a personne

Il y a + de 30j

Il y a + de 30j

Soudeur inox ou acier

25€/heure

Dinan

Demande un service de service a la personne entre voisins ou proposer mes services de service a la personne.

Poster une annonce
Retour
Fermer

Services entre voisins

Lancez votre recherche pour voir les annonces.

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wiiz-annonce.php

  1. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

  2. 0.0001

    SHOW TABLES LIKE 'pays'

  3. 0.0002

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

  4. 0.0002

    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

  5. 0.0001

    SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL

  6. 0.0004

    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<>''

  7. 0.0001

    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='436629'

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='service-a-personne' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='1092'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'service-a-personne' LIMIT 1

  10. 0.0001

    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='229'

  11. 0

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='20'

  12. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='227094' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  13. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 227094

  14. 0.0001

    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 = 436629

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1092 LIMIT 1

  16. 0.0001

    SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='436629'

  17. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='436629' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')

  18. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 227094 AND util_tel != ''

  19. 0

    SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=227094 LIMIT 1

  20. 0.0001

    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 = 227094 AND W.type_id = 1) OR (W.util_id <> 227094 AND W.type_id = 2)) AND (M.post_util_id = 227094 OR M.dest_util_id = 227094) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  21. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='227094' AND note_visu IN (1,3,4)

  22. 0.0001

    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 = '436629'

  23. 0.0001

    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='227094' AND wish_id<>'436629' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  24. 0.0001

    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='940' LIMIT 0,1

  25. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=227094 AND note_visu IN (1,3,4)

  26. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 227094

  27. 0.0001

    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='1080' LIMIT 0,1

  28. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 227094

  29. 0.0001

    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='1080' LIMIT 0,1

  30. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 227094

  31. 0.0001

    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='958' LIMIT 0,1

  32. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 227094

  33. 0.0001

    SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='20090'

  34. 0.008

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((45.4384*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((45.4384*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((9.2341- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.988739197041 AND ville_latitude_deg<45.888060802959 AND ville_longitude_deg>8.5932549132416 AND ville_longitude_deg<9.8749450867584 HAVING distance <= 50 ORDER BY distance ASC

  35. 0.0168

    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_cp IN ('20090','20090','20090','20138','20068','20068','20097','20097','20097','20097','20121','20122','20123','20124','20125','20126','20127','20128','20129','20131','20132','20133','20134','20135','20136','20137','20138','20139','20139','20141','20142','20143','20144','20145','20146','20147','20148','20149','20151','20152','20153','20154','20155','20156','20157','20158','20159','20161','20162','20162','20068','20098','20134','20090','20090','20090','20090','20098','20125','20125','20142','20068','20068','20143','20098','20068','20090','20089','20125','20073','20068','20161','20054','20127','20157','20090','20060','20089','20090','20096','20096','20076','20153','20020','20057','20085','20048','20055','20060','20094','20090','20075','20072','20053','20090','20096','20060','20090','20099','20079','20093','20093','20080','20090','20161','20151','20074','20152','20077','20060','20067','20070','20157','20090','20091','20032','20049','20070','20090','20070','20063','20032','20026','20070','20080','20058','26831','20052','20051','20067','20095','20095','26837','20092','20090','20021','20153','20032','20861','27010','20016','20016','20021','27015','26831','20019','20070','20050','26837','26858','20084','20061','20021','20060','20070','20090','20041','26833','20047','20060','20060','20060','20060','20037','20037','20070','26839','20082','20066','20083','27010','20900','20900','20082','20019','27018','26832','20082','20835','20064','20042','20080','26837','20059','20834','27010','20083','26852','20083','20080','20030','20044','20864','26838','20007','26838','26833','20867','27010','26838','20017','20863','20814','27010','20010','20017','20017','20017','26832','26852','20008','20060','20854','27010','20017','20040','20080','20060','27010','20046','20851','20024','20024','20852','20088','20088','20006','26857','20812','27010','20060','20861','20864','20865','20040','27010','20813','20813','20813','26853','20060','20832','26016','27010','20071','20080','20071','20068','27010','26855','20080','20060','20060','20020','20040','20875','27010','20080','20873','20018','20043','20853','20060','26836','20031','27010','27012','26859','27010','20005','20851','20811','20811','20811','20812','20814','20010','20812','20812','20855','27020','20045','27012','27012','20010','26027','27022','20862','20811','20871','26811','20065','27016','20846','27010','20009','20033','20060','21042','27010','20876','27010','20845','27020','20080','26866','20871','26025','27010','20014','20014','20831','20081','26851','20004','27020','20060','20062','27016','20855','26866','26866','20847','20062','20822','20816','20062','21040','27020','20015','20844','20871','20872','20882','20011','20011','20011','20080','20844','27020','26020','20023','27010','20857','20877','26025','20081','27010','27010','20086','26900','26900','20060','20865','20010','20080','20825','20821','20881','26010','20816','20081','20060','27021','21047','20866','27010','20856','27100','20815','26854','26854','20087','24040','26854','20015','23880','26866','20841','27019','20886','21040','20056','22060','20874','20833','20835','26020','26020','20883','20881','20822','20823','24040','20844','24045','27100','20884','26834','20087','27100','20826','20069','20013','20013','27020','26010','20841','20826','20003','24045','26818','23880','23880','23880','20056','20002','27010','23871','27010','26815','26815','20023','20843','20039','20823','27100','27020','20028','27010','20872','22070','26017','20842','24040','20087','26835','20020','20020','26020','20824','26010','20885','20056','20010','20010','23880','24047','21040','20010','20842','26019','22066','22066','26834','20823','23875','20833','27010','20833','20034','26817','22069','23880','24040','27010','23873','24047','27010','24042','24042','26017','26818','26834','24047','27010','23879','23879','20842','23887','24040','20038','27010','20027','20027','26017','24042','27014','23878','22074','22060','22060','22078','20836','20010','24040','27010','20025','20035','21040','26017','23874','23876','26010','27010','23873','23870','24040','27020','26010','26813','24041','23887','20001','20872','24041','22060','22060','23877','27010','27010','23807','22060','26834','27028','27020','22072','20010','27011','20836','22070','26010','23874','27029','22070','21040','26010','23899','20838','26010','20836','24040','20020','26816','20036','20010','24040','24043','26812','21053','24068','23897','24040','22074','21014','27020','22060','27029','22063','22063','20010','26010','21050','20837','22070','27014','27011','24030','24040','24043','27026','22070','27020','22063','22063','23891','22044','22044','22044','26824','24033','24030','22063','27030','24040','24040','24040','20012','23893','27020','23894','22070','26825','26010','23898','26825','21052','27010','24046','23896','23896','24053','27023','22076','24040','26812','27028','22040','22070','24040','27026','22070','26010','21055','24040','23895','22070','24040','22063','27027','27051','27040','27040','24050','23885','23880','22071','23807','20078','23888','21052','22040','23888','20010','23888','22040','27040','23892','23887','26010','22071','26013','24040','22060','21057','21057','24030','27025','28065','26010','24030','24043','23895','23895','22070','22071','23885','21052','22045','24040','27010','24040','24050','23889','23890','24049','22070','27048','27051','27051','27010','24030','24040','26013','22073','22073','21058','26010','26010','26010','22070','22040','24039','27026','26826','24039','23884','23884','21050','27030','26010','22070','26822','23845','22070','27040','26814','23884','22073','27043','24040','23846','27040','24044','23845','23883','23883','22040','26828','22040','24040','20020','24044','27040','26010','27010','24044','22070','23886','24050','27020','23886','23843','26010','20020','22070','24050','26828','23846','27013','22070','26010','23844','26010','20022','22040','27030','27030','22040','27010','22030','23881','23847','27020','24050','27041','24040','27040','23849','23849','22070','26010','27040','26010','24034','24030','22070','21017','20020','27017','22070','27020','27013','22046','28069','23847','21054','21054','22070','22070','22070','22070','22070','22070','22070','24030','24040','22070','22070','21049','21049','22030','24048','24030','22100','27033','26010','26020','27040','24040','27030','26863','21050','24030','27010','26010','26841','23848','27017','24030','22032','24055','24059','20029','24040','24040','28060','24030','27042','23848','26010','27020','26864','24035','28068','27041','23857','22030','24030','22031','23842','21010','22070','21017','24058','24058','24058','24036','27024','26013','21050','27049','21017','22075','22079','27042','27050','23804','26010','26821','22038','22038','21050','21012','24030','23851','24030','22070','24040','23841','22036','22036','22070','22020','22100','21015','27040','27030','28070','22030','26010','26010','20020','24058','27020','26010','26010','26010','27042','26827','27043','23806','24050','23854','24030','24030','24030','24030','24030','24030','22030','24030','23806','23806','24052','22030','24030','28066','21010','27030','22030','22030','21050','21040','21013','21013','27040','27040','23861','24050','21015','22100','22100','22100','22100','22100','22100','22100','27010','23867','24040','26856','22070','28070','24030','27040','23801','23801','22070','21040','22100','27050','26014','22070','24030','27040','26867','22037','27020','21010','24059','27044','27044','27020','26020','22030','27049','26841','28100','21017','26823','23852','23851','24030','21015','26010','23851','21040','22020','22077','26856','26014','23808','24051','22030','28071','22034','27042','21044','26010','21040','21040','21040','26012','23806','23802','22070','22042','23862','24057','22041','22041','22041','24050','22070','24100','24121','24122','24123','24124','24125','24125','24126','24127','24128','24128','24129','24129','24050','27020','21040','27040','21048','27036','24056','21040','22030','27030','27050','24050','24030','24031','24011','22020','26867','21043','28100','27020','22020','29015','28070','24126','27040','28062','28062','27040','27046','22030','21040','24010','28079','21048','22070','22020','27053','27039','27050','24050','27040','27020','24050','21040','22043','21043','29015','27040','29015','24030','23855','28070','22035','24123','27053','22020','24030','27040','23805','22020','21011','24010','24010','22020','21010','21019','27032','21040','06832','22020','22100','24050','27040','23868','23868','24030','21041','21010','26823','24030','06830','06830','27040','27050','27050','27050','22012','27050','21010','22070','06830','26018','23864','26020','27050','06832','22020','22033','27030','24068','24010','26029','22020','29010','22026','22020','24038','27020','22070','24020','21040','24038','24038','27020','29015','21040','27040','24038','22030','27040','21010','29010','26845','28100','22029','27050','26020','22027','24050','27045','06833','27030','27058','22010','26861','21040','22070','21046','23900','22030','24020','22043','28100','28100','28100','24050','21040','28043','26020','27050','29010','06828','24037','24050','24066','26844','28100','27030','24060','26861','21040','24010','24054','06836','28100','06834','24010','24010','27040','22039','21045','27030','22030','24020','22010','22010','21045','24037','24037','22039','21019','21045','06883','21100','06839','29010','24060','27034','28047','24030','24020','24020','27040','22030','27020','21019','22020','22020','21019','22070','21059','24050','21020','26029','22010','27050','21020','24050','24061','24030','24030','26020','29011','27034','21020','06835') AND fami_id='3' AND cate_id='229' AND type_id='1' AND ssrubr_id='1092' AND wish_id<>'436629' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

  36. 0.0001

    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='1092' LIMIT 0,1

  37. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=501258 AND note_visu IN (1,3,4)

  38. 0.0002

    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 = 501258 AND W.type_id = 1) OR (W.util_id <> 501258 AND W.type_id = 2)) AND (M.post_util_id = 501258 OR M.dest_util_id = 501258) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  39. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 501258

  40. 0.0001

    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='1092' LIMIT 0,1

  41. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=126058 AND note_visu IN (1,3,4)

  42. 0.0001

    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 = 126058 AND W.type_id = 1) OR (W.util_id <> 126058 AND W.type_id = 2)) AND (M.post_util_id = 126058 OR M.dest_util_id = 126058) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  43. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 126058

  44. 0.0001

    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='1092' LIMIT 0,1

  45. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=501865 AND note_visu IN (1,3,4)

  46. 0.0001

    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 = 501865 AND W.type_id = 1) OR (W.util_id <> 501865 AND W.type_id = 2)) AND (M.post_util_id = 501865 OR M.dest_util_id = 501865) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  47. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 501865

  48. 0.0001

    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='1092' LIMIT 0,1

  49. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=385549 AND note_visu IN (1,3,4)

  50. 0.0001

    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 = 385549 AND W.type_id = 1) OR (W.util_id <> 385549 AND W.type_id = 2)) AND (M.post_util_id = 385549 OR M.dest_util_id = 385549) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  51. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 385549

  52. 0.0001

    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='1092' LIMIT 0,1

  53. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=191310 AND note_visu IN (1,3,4)

  54. 0.0001

    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 = 191310 AND W.type_id = 1) OR (W.util_id <> 191310 AND W.type_id = 2)) AND (M.post_util_id = 191310 OR M.dest_util_id = 191310) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  55. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 191310

  56. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1092

  57. 0

    SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`

  58. 0.0002

    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

  59. 0.0002

    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

  60. 0.0001

    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

  61. 0.0001

    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

  62. 0.0001

    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

  63. 0.0001

    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

  64. 0.0001

    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

  65. 0.0001

    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

  66. 0.0001

    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

  67. 0.0001

    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

  68. 0.0001

    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

  69. 0.0001

    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

  70. 0.0009

    SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7

  71. 0.0239

    SELECT COUNT(*) AS nbavis FROM note n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'

  72. 0.0175

    SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

72 requetes sql en 0.074

Taille variable Globale : 58.94 KB