Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Couvreur charpentier

Autres annonces du voisin

Tout voir
Service maconnerie
Service maconnerie
MAçONNERIE GROS OEUVRE ET TOUS CE QUI V
Profil du voisin
Ricky B Voisin vérifié
100% fiable

Conflans-Sainte-Honorine 78700

-- €

Demander ce maçon
100%

Annonces similaires

Tout voir
Service charpentier
Service charpentier
CHARPENTE COUVERTURE
Profil du voisin
Benjamin M

Fontenay-le-Fleury 78330

220€/j

Demander ce couvreur
Service charpentier
Service charpentier
CHARPENTIER, COUVREUR,
Profil du voisin
Davy R

Bezons 95870

35€/h

Demander ce couvreur
Service charpentier
Service charpentier
SERVICE : COUVREUR ZINGUEUR
Profil du voisin
Couvreur Z

Drancy 93700

-- €

Demander ce couvreur
Service charpentier
Service charpentier
NETTOYAGE TOITURE
Profil du voisin
Patrick M

Noisiel 77186

-- €

Demander ce couvreur
Service charpentier
Service charpentier
COUVERTURE- MAçONNERIE-RéNOVATION
Profil du voisin
Voisin #61941

Massy 91300

20€/h

Demander ce couvreur
Service charpentier
Service charpentier
CHARPENTIER COUVREUR
Profil du voisin
Robert B

Chatenay-Malabry 92290

30€/h

Demander ce couvreur
Service charpentier
Service charpentier
SERVICE : BRICOLEUR PRO
Profil du voisin
Edgar augusto M

Courbevoie 92400

30€/h

Demander ce couvreur
Service charpentier
Service charpentier
JE PROPOSE MES SERVICES DE COUVERTURE
Profil du voisin
Bruno B
5.0

Andrésy 78570

-- €

Demander ce couvreur
5.0
Service charpentier
Service charpentier
SERVICE : ISOLATION COUVREUR
Profil du voisin
Brahim L

Nogent-sur-Marne 94130

-- €

Demander ce couvreur
Service charpentier
Service charpentier
RéNOVATION EXTéRIEURE ET INTéRIEURE/C
Profil du voisin
Frederic D

Ermont 95120

30€/h

Demander ce couvreur

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

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

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

  7. 0.0001

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

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

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

  25. 0.0001

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

  27. 0

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

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

  36. 0.0001

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

  37. 0.0065

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.1- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.533639197041 AND ville_latitude_deg<49.432960802959 AND ville_longitude_deg>1.4148258054235 AND ville_longitude_deg<2.7851741945765 HAVING distance <= 50 ORDER BY distance ASC

  38. 0.0028

    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 (78700,78570,78260,78780,95610,95000,78570,78600,95220,78600,95000,95370,78955,95280,95480,95530,78300,78500,78510,95240,95490,95300,95310,78670,78670,95000,95250,78360,78480,78540,95800,78230,95300,95180,78110,78100,78420,95650,95520,95130,95130,95150,95550,95870,78800,78740,78240,95430,95650,78240,95110,78560,78750,78630,95740,78112,95650,95100,78740,95320,78400,92000,95540,95120,95450,78130,95390,95300,78160,78430,78290,78620,78380,95300,92700,95450,95840,92500,95430,95650,95650,95630,78630,95840,78130,95600,95210,95218,78250,95680,78920,95450,95560,92270,92250,95230,92400,78410,78250,95580,95580,78870,95760,78590,95810,78250,78170,95450,78580,92230,93800,92600,78250,95880,78860,95830,78250,95450,78810,92800,92150,92300,95570,95450,78121,92200,95830,78150,95810,92380,95170,78590,95810,95690,78450,95620,95160,78410,95560,92110,95590,92430,92420,78150,95290,95690,78450,78810,93430,92210,95450,95330,78580,92390,93450,95410,95560,78820,78580,78410,95360,95450,95810,95570,95350,95810,92410,78330,95690,78250,78126,95690,95450,95560,95450,78124,93400,95640,95350,93380,93200,93210,78440,95570,78580,78410,78410,92310,95640,95660,95640,92100,95450,78850,95460,95450,78124,78340,95640,78210,78000,95260,78440,95400,95200,95450,95590,78440,78220,95440,78680,93240,78440,78390,78140,95640,95260,95450,78370,92370,95640,93120,93300,78970,92190,92360,95340,95640,95590,95340,92130,78640,92170,95810,95270,95810,95570,75001,75000,75002,75003,75004,75005,75006,75007,75008,75009,75010,75011,75012,75013,75014,75015,75016,75017,75018,75019,75020,75116,95640,78440,78650,78440,95720,95400,60230,78440,95140,95420,78440,60240,78190,93440,95270,78770,78640,92240,95750,92140,95720,95720,93350,93500,95270,60110,78350,78280,78530,78580,95750,78640,92120,60119,92320,78440,95500,78770,78180,78350,93310,95720,95420,95270,95450,78990,60119,95510,78930,95340,92220,78640,94250,92350,78440,78930,78770,95500,60540,60540,95270,95270,78650,95820,60530,78117,92260,92330,95850,78440,93700,93150,78960,60110,95270,78770,95420,95420,78770,93170,95420,94110,95190,60240,78770,78760,60119,78520,78770,93260,93230,95500,78490,94270,60540,60530,60240,92290,95190,95510,95190,93000,60240,91570,60240,78930,60820,95420,95270,78310,93100,60540,94200,94205,78117,60175,95850,78114,60110,78200,78490,94240,94230,94231,94232,94233,94234,94235,94236,94237,94238,94239,95500,78470,78200,78711,92340,60530,78320,94800,78520,91400,60173,78930,95510,78790,78790,93140,78470,95270,95420,94300,94160,60240,78930,95270,95270,60240,91370,78490,91430,78490,78490,93130,60540,91430,60530,78310,95380,78320,60240,95420,94220,60110,91190,78520,95380,95270,95510,78930,78930,91190,92160,60530,78490,60570,78790,94550,60530,78490,78490,78690,94260,95700,78200,95420,60260,95420,95780,78910,93600,95470,60240,94140,91300,78910,93110,60460,60240,60240,95670,94400,93250,60240,78790,60530,78470,78910,78890,60240,60149,78320,91120,78200,93420,94120,78460,95420,94150,94320,78940,94700,78790,93320,93340,78200,91440,60790,60270,91400,94410,60570,93270,78720,78720,60240,95510,78490,95380,78200,60580,60240,60460,95420,94340,94130,91320,94170,78200,78200,78840,78790,60730,78490,78690,78200,78910,93360,60730,95380,78200,91140,60110,94600,91940,91190,95780,93220,60790,91470,78270,95380,78910,78940,93190,93390,91160,95710,91940,78460,60340,94310,94390,78710,60240,60730,60240,78520,78720,78270,93410,95710,60560,78790,60240,60340,78910,94360,91380,91160,60240,91140,95420,78200,60240,94000,93290,93330,60240,91400,60790,60240,78610,95470,95470,95510,91470,60430,78790,93370,60570,60790,60240,78270,60790,91550,91160,91940,94100,94210,94340,94500,77990,60520,78980,95470,95780,91420,60730,60240,60500,27630,77181,93470,60240,94290,60240,60740,78610,78910,93460,78111,78720,94430,77990,78200,95710,60660,94350,60500,60730,91200,60250,60240,94380,60660,60660,60790,91470,93160,78840,91640,91470,60240,60240,78490,94460,60128,94480,78910,77230,95770,60520,60660,60660,60240,91160,78550,77290,78610,60240,78200,94190,78550,78270,60240,27620,78270,77270,77500,60160,91620,78610,77230,77181,78980,78125,60240,60590,27630,91360,27630,95770,95770,94420,91620,60250,60430,91270,91360,91560,27620,91260,77230,78270,78790,60128,77420,94450,60390,60430,60590,27630,91390,91600,27420,60300,60300,94490,94880,94880,60160,27630,60520,78950,94370,94380,91700,27720,78790,94470,60240,91460,78980,78550,60590,60250,60240,60250,78720,78270,77177,27140,78910,91230,91210,91470,91640,91310,91310,78550,60390,77410,60390,91170,91640,60430,78113,78830,60390,78270,60300,91310,78980,60390,60590,77185,60180,60250,77290,77410,78830,60430,60660,77230,78270,78980,27720,91240,91330,77186,78980,94510,78120,77230,78270,78125,77184,60100,78113,91310,77360,77340,27620,28260,91350,91700,60250,78270,91640,60300,60430,27630,27830,27420,78550,91680,27630,60300,60430,78550,27630,28560,77200,28260,60390,60590,27870,91800,94440,28410,77230,28260,91680,60390,60250,60590,94440,60290,60870,91700,78120,60590,27420,91000,91130,60370,91220,91220,77410,77230,77410,78980,27620,27640,77410,77280,28560,60370,91180,77400,77230,60590,60250,60290,27140,78113,60390,28260,60950,91530,60000,91470,77400,60290,77090,77183,60370,60290,78270,91450,60550,60134,77680,77600,60330,77230,78270,60250,91860,94440,27510,60134,78730,78730,91520,91340,27420,94520,94520,78270,77410,60140,27660,27660,60590,60300,60300,77400,91070,91290,27510,28410,60290,60250,77230,78125,77400,28410,60700,91800,27510,91290,77170,78113,27120,60290,77600,77600,91080,27200,77230,60000,91530,28260,77400,60430,60390,60870,77410,91650,91410,91090,91000,91650,60155,27420,60950,27150,78125,28410,77400,60300,77150,27420,28410,60940,60300,60300,60140,78120,27150,91450,91650,60390,60930,77600,78113,91480,60590,27510,27120,27540,77400,60650,91630,77230,27510,77164,28260,78125,27730,91480,27140,60940,78730,91630,77150,77330,28260,60140,60870,91530,78125,27510,78113,60510,28410,77135,60000,91090,60510,91630,60140,28260,77165,60330,27640,77410,91250,60650,60810,60810,77165,78125,77600,91790,60850,27120,91630,28410,60600,60600,77380,78125,27950,77230,77144,27780,77450,60950,27150,60510,60940,91250,60600,27950,91630,27510,27150,60700,27420,27120,77410,27120,77165,77165,28410,77144,77700,27150,60810,60650) AND fami_id='3' AND cate_id='50' AND type_id='1' AND ssrubr_id='603' AND wish_id<>'318597' 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=343849 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 = 343849 AND W.type_id = 1) OR (W.util_id != 343849 AND W.type_id = 2)) AND (`post_util_id` = 343849 OR `dest_util_id` = 343849) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  42. 0.0002

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

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

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

  50. 0.0002

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

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

  54. 0.0002

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

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

  58. 0.0002

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

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

  62. 0.0002

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

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

  66. 0.0002

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

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

  70. 0.0002

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

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

  74. 0.0002

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

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

  78. 0.0002

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

  79. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 603

  80. 0.0016

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

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

Taille variable Globale : 58.01 KB