Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Isolation toiture (10h)

Annonces similaires

Tout voir
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

Proposer mes services
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

FUITE SOLIN BéTON (2H)
Profil du voisin
Voisin #113749

Rozay-en-Brie 77540

50€

Proposer mes services
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

POTEAU EN BOIS à  CHANGER PAR IPN
Profil du voisin
Lanfranco A

Touquin 77131

-- €

Proposer mes services
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

-- €

Proposer mes services
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

Proposer mes services
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
100% fiable

Roissy-en-France 95700

90€

Proposer mes services
100%
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

SERVICE : COUVERTURE
Profil du voisin
Humberto R

Croissy-Beaubourg 77183

130€/j

Proposer mes services
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

TOITURE TERRASSE (8H)
Profil du voisin
Monzon D

Paris 75012

200€

Proposer mes services
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

Proposer mes services
Service charpentier
Service charpentier

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE UN CHARPENTIER/COUVREUR
Profil du voisin
Voisin #105113

Mitry-Mory 77290

25€/h

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

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

  7. 0.0001

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

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

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

  25. 0.0001

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

  27. 0

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

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

  29. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='200578' 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 = '382824'

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

  32. 0.0001

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

  33. 0.0055

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.0333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.0333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.93333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.583639197041 AND ville_latitude_deg<49.482960802959 AND ville_longitude_deg>2.2474674218189 AND ville_longitude_deg<3.6191925781811 HAVING distance <= 50 ORDER BY distance ASC

  34. 0.0026

    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 (77139,77440,77139,77910,77910,77139,77910,77440,77910,77139,77139,77440,77165,77165,77124,77440,60620,60440,77124,77470,60620,77122,77440,77440,60620,77145,77440,60620,77440,77178,77440,77470,77124,77440,77165,77470,60620,77660,77178,77124,77100,60440,60620,77660,60440,77840,77470,60890,77100,77165,77165,77100,60330,77410,77230,77165,77440,77440,60620,77165,77470,60620,60620,77470,77230,60890,77450,77470,60620,77450,60330,77410,77410,77260,77260,60330,77840,77230,60440,60890,77640,77580,77580,77450,77860,02810,77410,60440,77230,60440,77230,77580,77260,77580,77450,60890,60890,77580,77260,60620,77440,77230,60620,77450,77260,77580,77860,77840,77230,02810,77260,60890,77700,77860,77450,60950,60330,77410,77260,77450,77230,77410,77640,77450,77410,60800,77580,77580,60620,60440,77280,77580,60890,77410,77580,77580,60141,77230,77230,02310,02810,60950,77138,77290,60800,60440,02460,60950,77700,60141,60117,77410,77144,77700,60300,77730,77410,60800,02810,02810,02810,77730,77120,77400,77230,02310,77730,77400,77163,60800,77750,60117,60800,02810,60800,77144,77400,77700,02310,77230,02470,60117,60300,60300,60800,02810,77120,02810,77290,02600,77700,77163,77515,77580,60117,77730,02310,02460,77510,77400,02470,77990,77600,77410,02470,77750,77750,77230,77400,02460,02310,77515,02810,02600,77400,77174,77120,77600,02810,77990,02400,60300,02470,02310,77270,77169,60800,77600,60800,77174,02810,60128,77400,77515,60117,02470,02310,77750,02600,77120,77181,02470,60810,60128,77600,77600,60810,60800,60129,02470,02400,95470,02310,95470,02600,60800,02310,77600,93290,77177,02600,02400,02400,02600,77360,77163,60127,77750,95380,95380,60129,60810,77169,60123,60129,02470,77750,77510,60520,60300,77181,93470,60123,77515,02600,77164,95470,02470,02310,93410,02600,77200,02600,95380,02400,77500,77090,77183,02210,60127,02400,02310,77515,02600,60320,60129,77186,77510,93420,77169,60810,60810,77510,02210,77120,77610,93370,02400,95700,60300,02210,60520,93390,93190,60320,60320,77120,77135,60520,93270,02400,60300,77510,02400,95380,77610,77220,77510,60810,02600,77420,93600,02400,77610,60410,02600,95670,77510,02570,77185,02600,60560,02600,77169,02210,93460,77120,77120,95380,02210,95500,02600,60410,77540,02600,77680,60410,02600,60320,77120,77184,02210,77131,02600,02210,95470,93220,93160,02210,93340,93320,60810,77131,02400,95190,02400,02570,77610,60410,95500,60300,60300,77320,02210,77510,60410,02600,02210,02600,60410,95270,02400,60700,02400,60350,02210,95190,60300,02400,77610,60350,95190,02400,77340,77330,02600,77220,02210,77320,77510,93330,93360,95850,95500,60350,94350,93250,77540,60350,95270,95270,94420,02570,60700,77320,60580,02600,77120,77220,02400,02400,95720,02210,95850,77510,02210,60610,02600,93700,93150,93140,02540,95500,77610,95270,60300,02210,60500,94170,02400,95720,77220,02210,94360,93110,94510,93130,77610,95270,95400,60126,02210,93000,60700,60350,02400,95140,02540,60126,77320,77320,02210,60260,94120,02210,60500,95270,94500,93440,02540,60350,95720,02400,77540,02290,77220,95720,02600,60700,77320,02600,77540,93350,94880,94490,94880,02210,60710,02600,94130,77540,02200,60700,77320,60880,60350,60350,02540,02210,77150,95270,02210,94430,02130,93230,93260,02650,95440,77173,02400,95400,95200,77141,95270,02200,77150,60740,60870,60880,02290,60880,60710,77320,60350,94100,94340,94210,93100,60350,60550,60270,77390,93240,60350,77390,02540,95460,77320,77320,02650,60350,02650,02330,95350,02210,02210,94380,94370,93500,95570,02400,94340,60100,77320,94300,77320,02290,93380,02540,93170,60940,60700,02130,93300,93120,02540,94410,02130,93310,60870,60680,60680,60680,95570,95350,77540,60153,77390,02200,02210,60180,60700,95270,77320,60340,77540,02290,77390,95410,02210,60870,02290,77320,77320,60190,60350,95270,02540,95360,60200,60680,77970,93200,93210,02200,60350,02540,77170,77166,94440,60160,02200,02130,77320,60940,02200,60200,95330,02330,77970,95570,02330,94160,94470,60340,95160,95270,93430,60350,94000,77970,02850,77970,95170,77320,77170,02200,94440,94380,77390,02330,60940,02200,60750,60170,60190,60160,77970,77390,94220,94700,02210,77720,77370,02200,60700,02130,77320,60820,02330,77560,77320,02290,02200,02200,60290,02200,77390,02850,02850,95270,95560,02330,93450,92390,60460,60190,77390,02850,95560,60280,77170,51210,02290,77111,95880,02200,60660,02130,02290,94440,60350,94140,02850,60140,02330,60290,02200,77390,51210,95570,02330,93400,02200,60140,95560,02850,02130,95580,95580,02330,77111,94460,94520,94520,02200,60190,60190,95230,02330,93800,60150,02220,02130,02130,51210,02290,94450,94200,94205,60200,60200,60460,95590,02200,02200,75004,75003,75013,75002,75000,75001,75005,75006,75019,75017,75020,75016,75018,75015,75014,75007,75012,75011,75116,75010,75009,75008,60190,60290,60140,95820,60190,91330,77166,02200,95680,95590,02130,92230,95600,51210,60140,60660,60660,95590,77370,60140,94400,94270,02130,95210,95218,51310,94600,91480,60350,77560,60350,77720,60150,77720,95340,60150,60170,02200,02290,60190,92110,77390,94190,77320,95260,95560,51700,95390,02330,91800,60660,02200,60660,91800,77380,60660,94800,77390,60150,60150,95120,60190,02130,51310,92600,02200,60530,02200,02850,60290,60190,77320,91860,02200,77560,02200,77560,02290,77320,60190,60530,77370,92300,60140,02200,60190,02290,02220,77550,95260,95840,02130,95320,51210,91560,94320,60113,60113) 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<>'382824' AND wish_url='' ORDER BY rand() LIMIT 0,10

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

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

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

  38. 0.0001

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

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

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

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

  50. 0.0001

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

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

  54. 0.0001

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

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

  58. 0.0001

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

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

  62. 0.0001

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

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

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

  70. 0.0001

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

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

  75. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 603

  76. 0.0008

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

  77. 0

    SELECT count(*) as nbwish FROM wish

  78. 0.0459

    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

78 requetes sql en 0.0625

Taille variable Globale : 57.51 KB