Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Paysagiste (3h)

Autres annonces du voisin

Tout voir
Service electricien
Service electricien

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE éLECTRICIEN (3H)
Profil du voisin
Rachid G

Pierrelaye 95480

78€

Proposer mes services
Service elagage
Service elagage

Demande il y a + de 30j

Il y a + de 30j

JARDINIER, COUPER UN ARBRE FRUITIER (3H)
Profil du voisin
Rachid G

Pierrelaye 95480

90€

Proposer mes services
Service peintre
Service peintre
BRICOLEUR QUI SAIT FAIRE PEINTURE
Profil du voisin
Rachid G

Pierrelaye 95480

25€/h

Demander ce peintre
Service peintre
Service peintre
SERVICE : BRICOLEUR/PEINTRE
Profil du voisin
Rachid G

Pierrelaye 95480

40€/h

Demander ce peintre

Annonces similaires

Tout voir
Service elagage
Service elagage
ELAGAGES ABATTAGE ETETAGES TAILLE
Profil du voisin
- M Voisin vérifié
3.0

Rambouillet 78120

50€

Demander cet élagueur
3.0
Service elagage
Service elagage
SERVICE éLAGAGE
Profil du voisin
Tony H

Epone 78680

200€/j

Demander cet élagueur
Service elagage
Service elagage
éLAGAGE ABATTAGE D'ARBRE DANGEREUX
Profil du voisin
Voisin #386876

Montlignon 95680

-- €

Demander cet élagueur
Service elagage
Service elagage
ELAGAGE JARDINAGE
Profil du voisin
Youcef K

Ulis 91940

18€/h

Demander cet élagueur
Service elagage
Service elagage
TRONçONNAGE, ABATTAGE, ELAGAGE
Profil du voisin
William D

Gouvieux 60270

35€/h

Demander cet élagueur
Service elagage
Service elagage
éLAGAGE TOUS TYPES DE SITUATION
Profil du voisin
Jhon L

Gonesse 95500

100€/h

Demander cet élagueur
Service elagage
Service elagage
PAYSAGISTE ET éLAGUEUR
Profil du voisin
Tino L

Pontpoint 60700

35€/h

Demander cet élagueur
Service elagage
Service elagage
PROPOSE SERVICES D'éLAGAGE D'ARBRES
Profil du voisin
Alexandre D

Villeparisis 77270

22€/h

Demander cet élagueur
Service elagage
Service elagage
PRESTATIONS SERVICES : éLAGAGE
Profil du voisin
Cindy S

Pontpoint 60700

35€/h

Demander cet élagueur
Service elagage
Service elagage
SERVICE : BUCHERONNAGE
Profil du voisin
Bernard L

Taverny 95150

35€/h

Demander cet élagueur

Demande un service d'elagage entre voisins ou proposer mes services d'elagage.

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

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='elagage' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='526'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'elagage' 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='38'

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

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

  23. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=526 LIMIT 1

  24. 0.0001

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

  25. 0.0001

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

  27. 0

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

  31. 0.0002

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish w INNER JOIN util_info ui ON w.util_id = ui.util_id WHERE wish_visu IN (1,6,10) AND w.util_id='78070' AND wish_id<>'311927' 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='583' 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=78070 AND note_visu IN (1,3,4)

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

  36. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='526' LIMIT 0,1

  37. 0.0001

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

  38. 0.0002

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

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

  40. 0.0001

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

  41. 0.0001

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

  42. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='587' LIMIT 0,1

  43. 0.0001

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

  44. 0.0001

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

  45. 0.0001

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

  46. 0.0062

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.0167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.0167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.16667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.567039197041 AND ville_latitude_deg<49.466360802959 AND ville_longitude_deg>1.4810361764121 AND ville_longitude_deg<2.8523038235879 HAVING distance <= 50 ORDER BY distance ASC

  47. 0.0023

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

  48. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='526' LIMIT 0,1

  49. 0.0001

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

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

  51. 0.0001

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

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

  53. 0.0001

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

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

  55. 0.0002

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

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

  57. 0.0001

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

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

  59. 0.0001

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

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

  61. 0.0001

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

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

  63. 0.0001

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

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

  65. 0.0001

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

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

  67. 0.0002

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

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

  69. 0.0001

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

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

  71. 0.0002

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

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

  73. 0.0001

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

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

  75. 0.0001

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

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

  77. 0.0001

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

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

  79. 0.0001

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

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

  81. 0.0001

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

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

  83. 0.0001

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

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

  85. 0.0001

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

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

  87. 0.0001

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

  88. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 526

  89. 0.0008

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

  90. 0

    SELECT count(*) as nbwish FROM wish

  91. 0.0501

    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

91 requetes sql en 0.069

Taille variable Globale : 57.95 KB