Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Ménage /repassage /course

Autres annonces du voisin

Tout voir
Service aide aux courses
Service aide aux courses
SERVICE : AIDE AUX COURSES
Profil du voisin
Ilyane I

Chambly 60230

13€/h

Demander une course
Service aide aux courses
Service aide aux courses
AIDE AUX COURSES/ MéNAGE /REPASSAGE
Profil du voisin
Ilyane I

Chambly 60230

13€/h

Demander une course
Service aide aux courses
Service aide aux courses
COURSES /MéNAGE / REPASSAGE/ COMPAGNIE
Profil du voisin
Ilyane I

Chambly 60230

13€/h

Demander une course
Service service a personne
Service service a personne
MéNAGE /REPASSAGE /COURSE
Profil du voisin
Ilyane I

Chambly 60230

13€/h

Demander un service
Service pose de lino
Service pose de lino

Demande il y a + de 30j

Il y a + de 30j

SERVICE : POSE DE SOL SOUPLE
Profil du voisin
Ilyane I

Chambly 60230

40€

Proposer mes services
Service montage de meubles
Service montage de meubles

Demande il y a + de 30j

Il y a + de 30j

SERVICE : MONTAGE MEUBLE IKEA
Profil du voisin
Ilyane I

Chambly 60230

50€

Proposer mes services
Service livraison
Service livraison

Demande il y a + de 30j

Il y a + de 30j

LIVRAISON D’UN STORE BANNE
Profil du voisin
Ilyane I

Goussainville 95190

30€

Proposer mes services

Annonces similaires

Tout voir
Service service a personne
Service service a personne
VOTRE AVENIR , VOTRE BIEN ETRE
Profil du voisin
André M

Paris 75015

30€/h

Demander un service
Service service a personne
Service service a personne
CUISINE MAISON ET LIVRAISON à DOMICILE
Profil du voisin
Soumia F

Juvisy-sur-Orge 91260

30€/h

Demander un service
Service service a personne
Service service a personne
MONTAGE DE MEUBLES à DOMICILE
Profil du voisin
Adem

Paris 75000

40€/h

Demander un service
Service service a personne
Service service a personne
REPASSAGE à MON DOMICILE
Profil du voisin
Dida D

Gennevilliers 92230

15€/h

Demander un service
Service service a personne
Service service a personne
SERVICE : CUISINE à DOMICILE
Profil du voisin
Marine C

Paris 75004

20€/h

Demander un service
Service service a personne
Service service a personne
DYNAMIQUE ET COURTOIS (2H)
Profil du voisin
Voisin #310243

Paris 75016

50€

Demander un service
Service service a personne
Service service a personne
TERRASSEMENT LOCATION MINI PELLE AVEC CH
Profil du voisin
John J

Ris-Orangis 91130

350€

Demander un service
Service service a personne
Service service a personne
SERVICE : CUISINE ORIENTALE
Profil du voisin
Torkia A

Bezons 95870

25€/h

Demander un service
Service service a personne
Service service a personne
BESOIN D'UN PETIT COUP DE MAIN, N'HéSIT
Profil du voisin
Emilie B

Esbly 77450

25€/h

Demander un service
Service service a personne
Service service a personne
TRANSPORT DE PERSONNES
Profil du voisin
Badreddine G

Aubervilliers 93300

25€/h

Demander un service

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

Poster une annonce

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

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

  3. 0.0001

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

  4. 0.0001

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

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

  6. 0

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

  7. 0.0001

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

  8. 0

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

  9. 0

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

  10. 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

  11. 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

  12. 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 (38) ORDER BY ssrubr_order ASC

  13. 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

  14. 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 (231) ORDER BY ssrubr_order ASC

  15. 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

  16. 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

  17. 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 (37) ORDER BY ssrubr_order ASC

  18. 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 (43) ORDER BY ssrubr_order ASC

  19. 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

  20. 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 (229) ORDER BY ssrubr_order ASC

  21. 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

  22. 0.0001

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

  23. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1092 LIMIT 1

  24. 0.0001

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

  25. 0.0001

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

  26. 0

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

  27. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 147792 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''

  28. 0.0002

    SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 147792 AND W.type_id = 1) OR (W.util_id != 147792 AND W.type_id = 2)) AND (`post_util_id` = 147792 OR `dest_util_id` = 147792) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  29. 0.0001

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

  30. 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 = '354716'

  31. 0.0002

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id 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='147792' AND wish_id<>'354716' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  32. 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

  33. 0.0001

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

  34. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 147792 AND W.type_id = 1) OR (W.util_id != 147792 AND W.type_id = 2)) AND (`post_util_id` = 147792 OR `dest_util_id` = 147792) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  35. 0.0001

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

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

  37. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 147792 AND W.type_id = 1) OR (W.util_id != 147792 AND W.type_id = 2)) AND (`post_util_id` = 147792 OR `dest_util_id` = 147792) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  38. 0.0001

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

  39. 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

  40. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 147792 AND W.type_id = 1) OR (W.util_id != 147792 AND W.type_id = 2)) AND (`post_util_id` = 147792 OR `dest_util_id` = 147792) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  41. 0.0001

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

  42. 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

  43. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 147792 AND W.type_id = 1) OR (W.util_id != 147792 AND W.type_id = 2)) AND (`post_util_id` = 147792 OR `dest_util_id` = 147792) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  44. 0.0001

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

  45. 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='1107' LIMIT 0,1

  46. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 147792 AND W.type_id = 1) OR (W.util_id != 147792 AND W.type_id = 2)) AND (`post_util_id` = 147792 OR `dest_util_id` = 147792) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  47. 0.0001

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

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

  49. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 147792 AND W.type_id = 1) OR (W.util_id != 147792 AND W.type_id = 2)) AND (`post_util_id` = 147792 OR `dest_util_id` = 147792) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  50. 0.0001

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

  51. 0

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

  52. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 147792 AND W.type_id = 1) OR (W.util_id != 147792 AND W.type_id = 2)) AND (`post_util_id` = 147792 OR `dest_util_id` = 147792) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  53. 0.0001

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

  54. 0.0001

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

  55. 0.0059

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.0667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.0667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.45- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.617039197041 AND ville_latitude_deg<49.516360802959 AND ville_longitude_deg>1.7636765190362 AND ville_longitude_deg<3.1363234809638 HAVING distance <= 50 ORDER BY distance ASC

  56. 0.0084

    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_visu IN (1,6,10) AND wish_cp IN (95190,95850,95850,95190,95380,95270,95720,95270,95270,95270,95670,95720,95470,95720,95380,95270,95190,95720,95270,95270,95570,95380,95270,95460,95440,95500,95380,95570,95500,95470,95270,95380,95470,95570,95470,60560,95700,95400,95200,95350,95500,95330,60580,60260,60520,95270,95400,95350,95560,95560,95270,60128,77990,77230,95560,95570,95500,95270,95160,95140,60520,95410,60128,95590,77990,77230,95590,95170,93420,93380,95590,60270,93440,95580,95580,60820,95360,95680,60520,95560,93600,93240,77230,95260,95600,95230,93430,95390,95840,95820,95880,93700,93150,60500,60500,93350,95260,77290,93290,95340,95320,95840,77230,60300,60300,60460,93270,95340,93200,93210,95120,95660,95210,95218,93800,60740,95290,77230,60340,60340,92390,93410,93450,77230,95740,77280,93120,93300,60950,95150,95550,77290,95130,60300,60530,95620,93190,93390,95540,60330,95430,95630,95130,60230,95110,60530,92230,93000,93140,95760,77230,60460,93500,95250,60300,93320,93340,77270,60530,77181,93470,77410,77230,95100,60300,60950,77230,60530,60300,77230,60300,60300,95340,93370,93400,60300,60160,93260,93230,93130,77410,95240,60300,60530,77181,95430,60660,93250,93310,95690,92600,93220,77410,92270,77230,95480,60530,92110,95370,60330,95220,60950,77410,92700,92300,93100,60180,60160,77230,93170,93110,60100,77410,95530,60540,60540,60700,95870,95690,93360,60660,60660,60810,60540,60660,60660,95690,77500,77230,60330,95300,78500,60300,60810,60530,92250,95690,92400,77165,93460,94300,60870,94120,75001,75000,75002,75003,75004,75005,75006,75007,75008,75009,75010,75011,75012,75013,75014,75015,75016,75017,75018,75019,75020,75116,77165,95310,94170,77177,92200,60550,60540,60810,78800,93330,60440,60540,95810,77165,77165,77410,78600,77178,95300,93160,95300,77410,78420,77410,60330,95300,77165,60810,60290,60250,60290,92000,77410,94160,94130,95610,60660,60870,94360,77420,60110,60440,77400,77360,77178,77400,60870,94350,60730,95810,78700,60730,92800,92150,60250,92500,60440,78360,77186,77410,60440,78600,60700,60810,94410,60290,94340,60140,94220,95520,60810,95650,77400,60940,60700,92170,77200,95000,77400,94500,94200,94205,60940,60110,60800,94270,95810,77410,60730,77122,95000,77450,95810,77450,77185,60250,60940,77400,78780,60570,77400,94420,94250,77165,77165,95810,60250,92120,78570,60410,60570,60810,77600,77400,60110,60440,60140,60290,94700,60700,60730,94140,92100,60700,60290,60140,94100,94210,94340,92240,78400,94430,95810,78260,77124,60730,77600,77600,94800,92210,77184,95650,77090,77183,60440,60800,77600,77450,78110,77450,95490,95810,77144,77700,94110,92130,95280,60410,60440,77144,60140,94000,77700,78230,77139,60800,92220,77600,95650,60410,92380,60290,60140,94400,78560,77124,78570,77139,95640,77340,95830,92320,77910,78290,78380,60250,60440,60700,94490,94880,94880,60175,92190,92360,92140,77450,78100,78170,77450,60110,60800,60250,94240,94230,94231,94232,94233,94234,94235,94236,94237,94238,94239,60119,78300,92430,92420,92410,95650,95650,95640,77124,78430,94510,95800,77164,60250,77100,77124,78955,77680,60410,95830,92310,95000,60250,60700,60600,94600,94380,77450,77910,78750,94320,60140,60700,92260,92330,77100,92340,60570,94370,94380,77600,77139,95450,78510,94550,60320,60250,92350,77700,60250,95180,95640,60800,60410,77450,78112,60430,60410,60710,60800,60430,77700,78160,77135,92370,60119,60110,60600,60840,60620,95640,60240,94460,78480,78670,78670,60600,95450,60600,60600,94310,94390,77139,78140,60790,60370,60173,60800,60600,94470,78150,77860,78240,60620,60149,78740,60119,78620,95640,60710,78540,78150,60190,92290,94150,77910,78870,77100,78220,60430,60370,60680,95450,60190,60190,94260,60620,77860,60800,60129,95450,77860,78240,77580,60430,78740,60320,92160,60370,77330,78590,77470,60126,60800,94190,60600,60790,94450,94290,95640,95640,60320,60320,77910,60190,77700,60620,60790,78000,60800,60126,95450,91370,77139,95450,60790,77440,60790,77174,60190,94440,60620,60240,78630,95450,91320,60430,60129,77470,77440,91560,60600,60790,94480,60600,77470,77150,91300,78590,60134,91330,91200,91570,60880,95750,60600,60620,95450,78350,78250,78130,77470,91550,94440,77150,77174,95640,60240,78130,60134,60680,60680,60129,77580,77580,77580,60610,78860,60620,60240,60510,94440,77580,60430,60620,60117,77440,60620,95450,60190,77170,60930,78330,60620,60240,60510,95450,78250,78630,78350,78530,77580,60240,60240,60190,91230,78250,78210,60600,60129,91430,60600,60600,78250,91270,78450,77580,60620,91800,77470,78920,60240,60600,77470,60430,60390,77220,91430,60190,60190,94520,94520,60190,60510,91120,60800,60127,78410,60510,91420,60240,78810,78450,60620,77440,77173,60390,60880,60880,60240,60620,78250,91380,91160,77580,95750,77470,78580,77440,60680,77220,91400,77145,95450,95450,60240,95450,60130,95450,91210,60240,60117,60130,78117,77163,78121,77440,77440,91860,91260,91160,60240,60117,91800,60240,60190,91140,77660,78390,60190,60510,77610,78280,60240,60430,60127,60390,77220,78440,78810,60141,60890,78250,60890,91480,77660,78410,78340,60190,60190,60390,60000,60000,95420,95450,60510,77170,77440,77440,78820,60130,60130,60390,60510,60510,77220,91160,60240,91170,60130,91480,77163,77840,78440,77580,78117,78580,95420,95420,60190,91390,91600,77440,60190,78410,60240,78180,91400,60890,60130,91190,77380,91360,78580,77166,91140,60890,91360,78190,60240,60890,60240,60240,91440,60117,78960,78850,60190,78370,77580,91190,60240,78440,60141,91160,78440,78126,60890,60350,60117,91450,60130,60130,91000,91130,77163,77580,78124,60130,77610,78114,60200,77610,91350,60123,95420,60390,60240,78440,60510,78410,78410,60240,78580,77580,77515,77220,60190,60510,78470,78124,60190,60190,77640,77440,02600,91940,78440,60510,91700,02810,60240,77166,77440,78640,60200,77390,77260,77260,78680,60190,77170,60240,77610,91090,91000,60130,91450,91620,78990,60130,91250,91940,91190,60510,60420,60130,91700,95510,60890,60155,60240,60280,60155,60000,78970,95420,95420,60130,77127,78470,60123,77610,78470,78640,78440,77120,78650,91700,02600,91620,60510,60190,91940,95420,60190,60130,78440,77840,60240,60000,60190,77111,95420,91240,60113,60113,60240,60420,77260,02600,91310,60350,02460,78440,02600,77515,78640,77515,60390,60350) AND fami_id='3' AND cate_id='229' AND type_id='1' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='1092' AND wish_id<>'354716' AND wish_url='' ORDER BY rand() LIMIT 0,10

  57. 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

  58. 0.0001

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

  59. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 135687 AND W.type_id = 1) OR (W.util_id != 135687 AND W.type_id = 2)) AND (`post_util_id` = 135687 OR `dest_util_id` = 135687) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  60. 0.0001

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

  61. 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

  62. 0.0001

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

  63. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 314242 AND W.type_id = 1) OR (W.util_id != 314242 AND W.type_id = 2)) AND (`post_util_id` = 314242 OR `dest_util_id` = 314242) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  64. 0.0001

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

  65. 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

  66. 0.0001

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

  67. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 152516 AND W.type_id = 1) OR (W.util_id != 152516 AND W.type_id = 2)) AND (`post_util_id` = 152516 OR `dest_util_id` = 152516) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  68. 0.0001

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

  69. 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

  70. 0.0001

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

  71. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 363176 AND W.type_id = 1) OR (W.util_id != 363176 AND W.type_id = 2)) AND (`post_util_id` = 363176 OR `dest_util_id` = 363176) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  72. 0.0001

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

  73. 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

  74. 0.0001

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

  75. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 242563 AND W.type_id = 1) OR (W.util_id != 242563 AND W.type_id = 2)) AND (`post_util_id` = 242563 OR `dest_util_id` = 242563) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  76. 0.0001

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

  77. 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

  78. 0.0001

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

  79. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 310243 AND W.type_id = 1) OR (W.util_id != 310243 AND W.type_id = 2)) AND (`post_util_id` = 310243 OR `dest_util_id` = 310243) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  80. 0.0001

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

  81. 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

  82. 0.0001

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

  83. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 306342 AND W.type_id = 1) OR (W.util_id != 306342 AND W.type_id = 2)) AND (`post_util_id` = 306342 OR `dest_util_id` = 306342) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  84. 0.0001

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

  85. 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

  86. 0.0001

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

  87. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 269129 AND W.type_id = 1) OR (W.util_id != 269129 AND W.type_id = 2)) AND (`post_util_id` = 269129 OR `dest_util_id` = 269129) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  88. 0.0001

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

  89. 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

  90. 0.0001

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

  91. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 359393 AND W.type_id = 1) OR (W.util_id != 359393 AND W.type_id = 2)) AND (`post_util_id` = 359393 OR `dest_util_id` = 359393) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  92. 0.0001

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

  93. 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

  94. 0.0001

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

  95. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 149913 AND W.type_id = 1) OR (W.util_id != 149913 AND W.type_id = 2)) AND (`post_util_id` = 149913 OR `dest_util_id` = 149913) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  96. 0.0001

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

  97. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1092

  98. 0.0008

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

  99. 0

    SELECT count(*) as nbwish FROM wish

  100. 0.0468

    SELECT note.*, post.util_prenom as postp, post.util_nom as postn, dest.util_prenom as destp, dest.util_nom as destn, w.wish_id, w.wish_desc, w.fami_id FROM note, util_info dest, util_info post, wish w WHERE note.wish_id=w.wish_id AND note.post_util_id=post.util_id AND note.dest_util_id=dest.util_id AND note_visu IN (1,2,3,4) AND post_util_id<>'7' ORDER BY note_date DESC, note_hour DESC

100 requetes sql en 0.0715

Taille variable Globale : 57.99 KB