Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Rénovation petit toit (2h)

Autres annonces du voisin

Tout voir
Service debroussaillage
Service debroussaillage

Demande il y a + de 30j

Il y a + de 30j

ENLEVAGE A  LA DéCHèTERIE DE BRANCHA
Profil du voisin
Marc A

Nesles-la-Vallee 95690

40€/h

Annonces similaires

Tout voir
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE COUVREUR (POUR 15 JOURS)
Profil du voisin
Laurent D

Reuil-sur-Brêche 60480

3300€

Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

ENLEVER UN NID DE PIGEON DANS GOUTTIERE
Profil du voisin
Laurent B

Senlis 60300

35€/h

Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

INSTALLER : CHAPEAU DE CHEMINéE INOX
Profil du voisin
Alain D

Lamorlaye 60260

25€/h

Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE COUVREUR ZINC
Profil du voisin
Ghost G

Sarcelles 95200

-- €

Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE COUVREUR ZINGUEUR (33 M2)
Profil du voisin
Voisin #12587

Sarcelles 95200

-- €

Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

SERVICE : TUBAGE CHEMINéE
Profil du voisin
Henri A

Morgny 27150

35€/h

Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

RéPARATION FUITE SOLIN CHEMINéE (3H)
Profil du voisin
Sophie H

Clermont 60600

90€

Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

BESOIN D'UN COUVREUR POUR POSE DE TUILES
Profil du voisin
Voisin #125738

Verneuil-sur-Seine 78480

150€

Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE COUVREUR/ZINGUEUR/VITRIER
Profil du voisin
Svetlana D

Paris 75005

40€/h

Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

POSE CHAPEAU VMC ET CHAPEAU CHEMINéE (3
Profil du voisin
Fabrice M

Roissy-en-France 95700

90€

100%

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

  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, 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='50'

  6. 0

    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='103245' 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` = 103245

  9. 0.0001

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

  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.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 (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 = 306916

  23. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=603 LIMIT 1

  24. 0.0001

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

  25. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='306916' 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` = 103245 AND util_tel != ''

  27. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 103245 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 = 103245 AND W.type_id = 1) OR (W.util_id != 103245 AND W.type_id = 2)) AND (`post_util_id` = 103245 OR `dest_util_id` = 103245) 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='103245' 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 = '306916'

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

  35. 0.0002

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

  36. 0.0001

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

  37. 0.0061

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.15*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.15*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.15- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.700339197041 AND ville_latitude_deg<49.599660802959 AND ville_longitude_deg>1.4625232991832 AND ville_longitude_deg<2.8374767008168 HAVING distance <= 50 ORDER BY distance ASC

  38. 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 (95690,95690,95690,95810,95690,95810,95340,95810,95300,95810,60110,95620,95300,95760,95810,95290,95810,60540,60540,60230,95810,95660,60110,95640,95430,95630,60540,95340,95260,60119,95430,60110,95650,60540,95640,95260,95300,95540,60530,95830,60530,60175,60540,95640,95340,95520,95840,95590,60119,60570,95310,95590,95830,60240,95300,60110,60530,95640,95740,60530,60119,95590,60530,95820,95640,60173,95650,95650,95650,60570,95840,95270,95150,95550,95560,60240,60530,95450,95560,60730,60530,95000,95560,60730,60149,95450,60820,95640,95270,95640,95650,95480,95610,95250,95560,60110,60730,60790,95490,95570,95270,95750,95270,95000,95450,95320,60790,60570,60460,60240,95220,60430,60240,60790,60240,95800,60460,95640,95280,95390,60240,95570,95450,60240,95570,95450,60790,60730,95680,78780,95130,60790,60730,95450,60240,95450,95570,60240,95000,95270,60240,95450,95270,95330,95370,78700,95240,60790,60250,95180,95600,60240,95750,78570,95130,95450,60340,95450,60270,60240,95270,60240,95580,95580,78740,60430,78570,95120,60660,60660,95720,95460,95530,60260,60240,60430,60340,60240,78740,95350,95270,95270,78260,60660,95720,60250,95450,60660,60660,60240,95160,78510,95230,95110,60250,60240,95420,60240,95420,95450,95450,60250,78480,78600,60430,78500,95270,95270,60430,78250,95440,95210,95218,95850,95450,60390,95170,60240,60240,95350,60580,60740,60390,95850,60390,78250,60240,60240,95720,95100,60160,78250,60250,95410,60500,95270,95420,78540,95880,95190,78600,60390,60250,78955,78130,95400,95200,60430,60430,60390,95420,60160,60240,95450,60240,78440,95190,95870,60660,60240,78250,60250,78670,78670,60370,60500,95470,93800,95360,60370,78300,95720,78250,93430,60240,60240,78250,78440,78130,93380,60250,78360,60370,78440,95380,60240,78420,60134,78800,60000,60134,60180,60390,92230,95670,60240,95420,60560,95420,95400,92700,60250,95420,95420,60290,92270,78410,60590,95190,78440,60590,60290,60240,60100,78820,60250,92390,93450,60240,60430,95420,78110,60000,60520,95420,60390,78920,93240,78230,92000,95140,60300,78100,95510,92600,60870,60300,60300,60590,60290,60930,95500,93200,93210,78440,95380,60290,78630,95500,60290,60590,92250,60390,78630,60290,78410,95500,92400,78240,60520,95420,60240,60155,78240,92300,78440,95500,60590,93440,60140,95470,78400,60510,78560,60510,60590,92110,92500,78410,78440,95380,78750,78112,60590,27140,60550,60300,60240,95420,60510,78440,95510,60140,60240,95510,60390,93400,60000,92200,93350,60390,60600,78580,93120,93300,60140,95380,95470,60650,60870,60940,78440,95700,60520,78290,78380,95420,78430,60510,60650,60600,60600,95470,95510,60510,78580,78160,60155,60000,78440,95380,60300,60128,78410,78410,60240,78620,92800,92150,60000,60590,60940,60510,78126,93700,93150,60140,60000,78970,95710,60590,78680,60128,93500,60650,78170,60700,27140,60870,78121,27830,78870,60140,60600,60840,60850,78590,78580,78580,77230,95780,77990,95770,60650,95710,60510,78810,92380,95770,95770,60940,27720,60600,78440,93420,92210,78124,27720,60300,60510,78860,93600,95510,93310,78520,60650,60600,75001,75000,75002,75003,75004,75005,75006,75007,75008,75009,75010,75011,75012,75013,75014,75015,75016,75017,75018,75019,75020,75116,60510,78810,78520,92430,92420,78150,60000,27630,93000,60600,60650,78450,60510,78520,27420,60300,60700,60590,77230,60140,95780,60510,60000,78590,92100,77990,78124,93260,93230,93140,78150,92410,60600,78840,27630,95710,78450,27630,60700,78200,27660,27660,60700,60600,95510,92170,78930,93270,60650,60600,93170,60510,60510,60480,60590,92310,78580,60810,78850,27140,27870,60810,77230,60850,60700,93130,78200,78711,60650,27630,60650,60130,93100,60300,60510,60112,78330,93290,60510,92130,78270,78930,60112,60600,27420,60810,95780,78770,27150,93320,93340,92190,92360,78930,92240,77290,78930,78930,93410,27630,60300,60300,78000,78220,60480,60510,60600,60850,78140,78340,92120,93190,93390,60130,92370,93250,60130,60950,77230,60510,78650,94300,78210,94250,60112,60700,77280,60650,78200,78640,60600,27150,78770,93110,78200,78270,60112,78370,60850,60600,92140,27140,60590,60700,60950,60112,78390,92320,27630,60190,94160,60650,94270,27420,77230,60112,92220,77230,78520,27420,27150,60700,78770,27860,60810,78930,78930,27620,60330,78270,78770,93220,60130,60190,60190,60650,94200,94205,60480,60112,27150,60810,78200,77181,93470,60112,60480,94110,77290,78710,78790,78790,93370,27630,60650,94120,78640,78770,93360,60410,27420,60130,78840,27150,78270,60480,92350,78200,77270,78200,78640,94220,27620,60130,92260,92330,60130,94800,78770,94170,60130,60130,77230,78650,27150,60410,60480,27420,78190,77230,60130,60650,60130,78640,60300,60480,60190,60710,78350,78530,78350,60480,60190,60850,78200,27510,60480,77181,78790,78770,94130,77410,60190,60190,27630,60950,27150,60112,94240,94230,94231,94232,94233,94234,94235,94236,94237,94238,94239,60650,78280,60810,60190,78270,60410,78990,78790,94410,77230,60810,92340,78180,92290,94140,93330,60680,27150,78490,94340,78200,60112,60112,60860,78200,93460,27510,78200,60850,76220,60130,77230,78790,60860,60130,94700,77410,94360,77500,27510,60330,60480,27150,78270,60480,78117,60360,78910,60440,60710,60860,78760,94400,91570,77410,60480,27150,27510,78790,78270,60130,77410,77230,27420,60190,78490,27620,94550,60860,78960,60650,78910,93160,60650,60330,27150,60480,91370,60800,60480,60860,60410,78270,27150,60190,94500,78490,94350,78980,77230,27510,92160,60650,27620,77410,78200,78310,94320,27150,78200,77177,94260,60440,60130,60380,60410,77230,78270,78490,78490,60112,91400,78910,60650,60130,78117,91430,78910,78490,94100,94210,94340,60480,91430,27420,60190,60190,78114,60126,60112,77420,78320,94150,78790,60190,94600,94000,78470,27150,27150,78790,76220,60130,78890,27150,94430,27510,77165,78270,27510,60380,60440,78470,91300,78490,78490,78980,60480,60680,60680,76220,60330,78310,60190,76220,60410,27480,78111,76220,60420,60800,60126,60380,60130,77165,78940,94420,60130,60190,94310,94390,78910,60480,91190,77360,77178,78320,91320,91190,60360,60480,27420,60320,76220,60480,60360,60130,60800,77186,60690,78690,60480,60190,27150,60880,91120,77410,78980,77410,77400,77185,78910,60380,60380,77165,77165,78270,77165,94380,27200,78910,60380,77410,78940,60480,60690,60690,77178,77200,60440,78490,27150,60130,27150,60320,60480,76220,27700,77410,60120,60380,27150,78270,77400,27700,60800,27150) 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<>'306916' AND wish_url='' ORDER BY rand() LIMIT 0,10

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

  40. 0.0001

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

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

  42. 0.0001

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

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

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

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

  46. 0.0001

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

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

  48. 0.0001

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

  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 = 112282 AND W.type_id = 1) OR (W.util_id != 112282 AND W.type_id = 2)) AND (`post_util_id` = 112282 OR `dest_util_id` = 112282) 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 = 112282

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

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

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

  54. 0.0001

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

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

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

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

  58. 0.0001

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

  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=482053 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 = 482053 AND W.type_id = 1) OR (W.util_id != 482053 AND W.type_id = 2)) AND (`post_util_id` = 482053 OR `dest_util_id` = 482053) 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 = 482053

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

  66. 0.0001

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

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

  70. 0.0001

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

  71. 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='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=328341 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 = 328341 AND W.type_id = 1) OR (W.util_id != 328341 AND W.type_id = 2)) AND (`post_util_id` = 328341 OR `dest_util_id` = 328341) 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 = 328341

  75. 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='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=80512 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 = 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

  78. 0.0001

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

  79. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 603

  80. 0.0008

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

  81. 0

    SELECT count(*) as nbwish FROM wish

  82. 0.0583

    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

82 requetes sql en 0.0757

Taille variable Globale : 57.98 KB