Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Pose chapeau VMC et chapeau cheminée (3h)

Autres annonces du voisin

Tout voir
Location aspirateur souffleur
Location : aspirateur souffleur

Viarmes 95270

Aspirateur souffleur
Profil du voisin
Fabrice M

Viarmes 95270

15€/jr

Louer le souffleur
Location taille haie
Location : taille haie

Viarmes 95270

Location : taille haie
Profil du voisin
Fabrice M

Viarmes 95270

15€/jr

Louer le taille-haies
Location tronconneuse
Location : tronconneuse

Viarmes 95270

Tronçonneuse thermique
Profil du voisin
Fabrice M

Viarmes 95270

25€/jr

Louer la tronçonneuse
Location tondeuse
Location : tondeuse

Viarmes 95270

Tondeuse électrique
Profil du voisin
Fabrice M

Viarmes 95270

15€/jr

Louer la tondeuse
Location scie circulaire
Location : scie circulaire

Viarmes 95270

Scie circulaire a  onglet
Profil du voisin
Fabrice M

Viarmes 95270

15€/jr

Louer la scie
Location motobineuse
Location : motobineuse

Viarmes 95270

Location : motobineuse
Profil du voisin
Fabrice M

Viarmes 95270

25€/jr

Louer la motobineuse
Location scarificateur
Location : scarificateur

Viarmes 95270

Scarificateur électrique
Profil du voisin
Fabrice M

Viarmes 95270

25€/jr

Louer le scarificateur
Service peintre
Service : peintre

Demande il y a + de 30j

Il y a + de 30j • 95270

Service : travaux de peinture
Profil du voisin
Fabrice M

Viarmes 95270

25€/h

Proposer mes services

Annonces similaires

Tout voir
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 95200

Recherche couvreur zingueur (33 m2)
Profil du voisin
Voisin #12587

Sarcelles 95200

-- €

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 78750

Pose d'un velux
Profil du voisin
Vincent V

Mareil-Marly 78750

-- €

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 60600

Réparation fuite solin cheminée (3h)
Profil du voisin
Sophie H

Clermont 60600

90€

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 78480

Besoin d'un couvreur pour pose de tuiles
Profil du voisin
Voisin #125738

Verneuil-sur-Seine 78480

150€

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 92500

Tubage de cheminée (8h)
Profil du voisin
Patrick M

Rueil-Malmaison 92500

240€

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 95200

Recherche couvreur zinc
Profil du voisin
Ghost G

Sarcelles 95200

-- €

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 60300

Enlever un nid de pigeon dans gouttiere
Profil du voisin
Laurent B

Senlis 60300

35€/h

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 77139

Isolation toiture (10h)
Profil du voisin
Voisin #200578

Etrepilly 77139

300€

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 77183

Service : couverture
Profil du voisin
Humberto R

Croissy-Beaubourg 77183

130€/jr

Proposer mes services
Service charpentier
Service : charpentier

Demande il y a + de 30j

Il y a + de 30j • 91210

Rénovation charpente et pose bac acier
Profil du voisin
Franck M

Draveil 91210

2760€

Proposer mes services

Demande un service de couvreur entre voisins ou proposer mes services de couvreur.

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

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='charpentier' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='603'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'charpentier' LIMIT 1

  5. 0.0001

    SELECT c.cate_id, 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='50'

  6. 0.0001

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

  7. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='80512' 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` = 80512

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

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

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

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

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

  23. 0.0001

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

  24. 0.0001

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

  25. 0

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

  26. 0

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

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

  28. 0.0001

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

  29. 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 = '473562'

  30. 0.0001

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

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

  32. 0.0001

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

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

  34. 0.0001

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

  35. 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='14' LIMIT 0,1

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

  37. 0.0001

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

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

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

  40. 0.0001

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

  41. 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='5' LIMIT 0,1

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

  43. 0.0001

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

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

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

  46. 0.0001

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

  47. 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='4' LIMIT 0,1

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

  49. 0.0001

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

  50. 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='15' LIMIT 0,1

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

  52. 0.0001

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

  53. 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='587' LIMIT 0,1

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

  55. 0.0001

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

  56. 0.0001

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

  57. 0.0062

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.0833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.0833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.633639197041 AND ville_latitude_deg<49.532960802959 AND ville_longitude_deg>1.7301171302414 AND ville_longitude_deg<3.1032228697586 HAVING distance <= 50 ORDER BY distance ASC

  58. 0.0027

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

  59. 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='603' LIMIT 0,1

  60. 0.0001

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

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

  62. 0.0001

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

  63. 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='603' LIMIT 0,1

  64. 0.0001

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

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

  66. 0.0001

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

  67. 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='603' LIMIT 0,1

  68. 0.0001

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

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

  70. 0.0001

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

  71. 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='603' LIMIT 0,1

  72. 0.0001

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

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

  74. 0.0001

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

  75. 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='603' LIMIT 0,1

  76. 0.0001

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

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

  78. 0.0001

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

  79. 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='603' LIMIT 0,1

  80. 0.0001

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

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

  82. 0.0001

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

  83. 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='603' LIMIT 0,1

  84. 0.0001

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

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

  86. 0.0001

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

  87. 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='603' LIMIT 0,1

  88. 0.0001

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

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

  90. 0.0001

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

  91. 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='603' LIMIT 0,1

  92. 0.0001

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

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

  94. 0.0002

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

  95. 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='603' LIMIT 0,1

  96. 0.0001

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

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

  98. 0.0001

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

  99. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 603

  100. 0.0009

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

  101. 0

    SELECT count(*) as nbwish FROM wish

  102. 0.0463

    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

102 requetes sql en 0.0659

Taille variable Globale : 57.93 KB