Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Automatisation de portail

Autres annonces du voisin

Tout voir
Service serrurier
Service : serrurier

Moissy-Cramay... 77550

Serrurier, installateur, dépanneur
Profil du voisin
Jérôme B

Moissy-Cramayel 77550

30€/h

Demander ce serrurier
Service depannage
Service : depannage

Moissy-Cramay... 77550

Service : ouverture de porte
Profil du voisin
Jérôme B

Moissy-Cramayel 77550

30€/h

Demander ce dépanneur
Service depannage
Service : depannage

Moissy-Cramay... 77550

Volet roulant, portail porte de garage
Profil du voisin
Jérôme B

Moissy-Cramayel 77550

30€/h

Demander ce dépanneur
Service multi services
Service : multi services

Moissy-Cramay... 77550

Service : petit bricolage
Profil du voisin
Jérôme B

Moissy-Cramayel 77550

25€/h

Demander ce bricoleur
Service renovation interieure
Service : renovation interieure

Moissy-Cramay... 77550

Rénovation intérieur
Profil du voisin
Jérôme B

Moissy-Cramayel 77550

30€/h

Demander à rénover
Service plomberie
Service : plomberie

Moissy-Cramay... 77550

Service : plomberie
Profil du voisin
Jérôme B

Moissy-Cramayel 77550

35€/h

Demander ce plombier

Annonces similaires

Tout voir
Service domotique
Service : domotique

Colombes 92700

Installation antenne satellite, parabole
Profil du voisin
Voisin #12364

Colombes 92700

-- €

Demander ce service
Service domotique
Service : domotique

Massy 91300

Service : électricité
Profil du voisin
Safio K

Massy 91300

40€/h

Demander ce service
Service domotique
Service : domotique

Viroflay 78220

Automatisation home assitant & wago
Profil du voisin
Jul B

Viroflay 78220

40€/h

Demander ce service
Service domotique
Service : domotique

Bagnolet 93170

Aide domotique
Profil du voisin
Lud

Bagnolet 93170

35€/h

Demander ce service
Service domotique
Service : domotique

Sucy-en-Brie 94370

Dépannage fermetures automatiques
Profil du voisin
A B

Sucy-en-Brie 94370

50€/h

Demander ce service
Service domotique
Service : domotique

Montreuil 93100

Mécanique entretient
Profil du voisin
Christophe G

Montreuil 93100

50€

Demander ce service

Demande un service de domotique (bricolage) entre voisins ou proposer mes services de domotique (bricolage).

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

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='domotique' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='585'

  4. 0.0001

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

  5. 0.0001

    SELECT c.cate_id, cate_title_aff, cate_title_slug, c.fami_id, f.fami_title, f.fami_url FROM category c, family f WHERE c.fami_id=f.fami_id AND c.fami_id='3' AND c.cate_id='50'

  6. 0

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

  9. 0

    SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`

  10. 0.0002

    SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='3' AND cate_cate_id IS NULL ORDER BY cate_order ASC

  11. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (50) ORDER BY ssrubr_order ASC

  12. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (38) ORDER BY ssrubr_order ASC

  13. 0.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.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 = 487190

  23. 0.0001

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

  24. 0.0001

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

  25. 0

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

  26. 0

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

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

  28. 0.0001

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

  29. 0.0001

    SELECT `empreinte_carbone`,s.prix_leroymerlin, s.prix_loxam, s.prix_kiloutou FROM `ssrubr` as s INNER JOIN wish as w ON w.ssrubr_id = s.ssrubr_id WHERE w.wish_id = '487190'

  30. 0.0001

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish w INNER JOIN util_info ui ON w.util_id = ui.util_id WHERE wish_visu IN (1,6,10) AND w.util_id='319724' AND wish_id<>'487190' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  31. 0.0001

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

  32. 0.0001

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

  33. 0.0001

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

  34. 0.0003

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

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

  36. 0.0001

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

  37. 0.0002

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

  38. 0.0001

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

  39. 0.0001

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

  40. 0.0002

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

  41. 0.0001

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

  42. 0.0001

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

  43. 0.0002

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

  44. 0.0001

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

  45. 0.0001

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

  46. 0.0002

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

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

  48. 0.0001

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

  49. 0.0002

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

  50. 0.0001

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

  51. 0.0061

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.6167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.6167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.68333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.167039197041 AND ville_latitude_deg<49.066360802959 AND ville_longitude_deg>2.0031453945676 AND ville_longitude_deg<3.3635146054324 HAVING distance <= 50 ORDER BY distance ASC

  52. 0.0006

    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 (77550,77550,77390,77111,77950,77950,77111,77550,77390,77950,77166,77170,77950,77550,77390,77390,77240,77166,77950,77390,77240,77950,77390,77170,77390,77115,77176,77720,77000,77176,77000,77127,77390,77350,77380,77115,77220,77000,77390,77173,77720,91480,77190,77220,77350,77240,91480,77820,77310,77000,91800,77350,77170,77390,77720,77220,77150,94520,94520,91280,77610,91250,77390,91250,77310,77150,77390,94440,77310,91860,77220,91830,91250,91250,77720,91100,77590,77720,77820,77720,94440,91450,77190,77590,94440,77610,91800,77390,77330,77590,77610,91000,91090,91830,91330,91450,91100,77720,77930,77820,77930,77220,77930,77610,77720,91750,77920,91540,91540,94470,91230,77630,77850,94450,91090,77540,94510,91000,91130,77540,77610,94380,94370,77610,77135,77133,91560,91750,77680,91750,77930,77930,91080,77720,91210,94490,94880,94880,77930,77370,77340,77720,77870,94190,91540,77133,91270,77610,94460,91070,77540,91540,77630,94380,91840,91350,77540,94480,91170,77184,77210,77164,77830,91260,91700,94290,91200,77370,94430,77540,94420,77174,91810,77183,77090,77300,91610,77210,77630,94000,77540,94210,94100,94340,91710,77370,91490,77370,77370,77185,77600,91590,77174,91890,77370,91390,91600,77830,77810,77163,94500,94390,94310,77131,77430,94600,77830,91550,91700,91490,77600,77600,77600,94350,77700,77200,77186,91360,91490,77420,77515,77600,77600,91220,91220,77700,94360,93160,91420,94340,91770,94700,91360,91630,94320,94410,77131,91590,77670,77400,77400,94400,77400,77360,77540,91760,77670,93330,94130,77144,91240,94140,91700,77370,94150,77154,91590,91630,91320,77163,91490,93460,77250,77370,94170,91590,91310,77700,77250,77163,94550,94220,77970,77400,91380,91160,77130,77400,94120,77400,77177,77760,91160,91820,91490,77500,77700,77144,77141,91850,93360,77580,77515,77580,77130,77120,91310,91310,77370,77120,94260,77154,91620,91290,77370,77760,77123,77515,94800,94160,91630,77250,94200,94205,77148,93110,91820,91160,77370,91720,91630,77780,77580,77400,77450,93220,94239,94238,94237,94236,94235,94233,94232,94231,94230,77515,94234,94240,91590,77690,91590,94300,92160,91310,91180,91160,77580,77580,77860,91290,77760,91300,77250,77123,92340,94270,77450,91630,77250,77130,93250,77860,77520,91510,91510,93370,77700,91720,77130,77520,94110,77120,77450,77515,91460,77148,91140,91620,93100,77370,77450,77880,77410,77760,77410,77970,77130,93130,77123,77181,91120,77690,93340,93320,77250,91590,91140,77450,94250,77120,93170,91370,77181,93470,77760,77580,91730,91520,91340,92330,92260,92220,77860,93390,93190,91590,91880,92290,93230,93260,92120,77520,77370,77450,91790,91720,77140,93140,77130,77410,77120,77270,91680,92320,92350,77126,93000,92240,77130,77410,77760,91580,91730,77580,93310,77580,93410,77940,91580,77520,77580,77120,77940,77450,77130,91430,77520,75005,75003,75002,75000,75006,75116,75001,75013,75007,75014,75012,75020,75016,75004,75011,75010,75017,75018,75019,75009,75008,75015,92140,91720,77120,77120,93270,77250,77160,77130,91720,92170,77580,77410,77320,91650,77520,91570,77520,91720,77160,77940,77760,77580,77100,93500,91430,77410,77140,92130,91580,91400,77126,77126,77650,91910,91730,77970,77160,77450,77470,77710,91940,91650,93290,91940,77100,77760,77760,77130,92190,92360,77140,77410,77410,77140,93600,91150,77320,91440,77140,77650,93150,93700,91640,91720,91680,77130,77470,91640,91650,77410,77124,77100,77650,77520,77169,77970,92100,77160,93120,77470,93300,77940,77118,77120,77940,77120,77320,91400,91150,91150,91580,77470,93350,91580,45330,77520,77520,93420,77130,77580,93400,77410,77520,92370,77118,77520,77290,91940,77970,77760,91190,77710,77760,77760,77410,78350,77124,91640,77160,91640,91530,92310,91190,93440,77470,77760,77710,77156,78140,91400,91150,77710,92110,89340,91530,92210,93210,93200,77650,77940,77320,92200,77320,77230,77290,77167,77167,91150,77167,77650,77167,92410,77160,91470,77169,77124,77169,77760,77470,95500,92300,78220,77169,77160,77165,91190,93240,77470,92800,92150,91580,77650,77480,77940,77165,77165,91150,77124,95140,92390,93450,78350,78530,77890,77134,92600,89340,77118,77510,77560,78117,95500,91470,91150,77650,95700,77890,77710,77660,92380,92420,92430,45330,92400,77560,89140,77230,91150,89720,91150,77230,77230,45390,92250,77320,77320,77570,77167,78117,45330,77760,77320,77165,77990,77157,78470,77560,77640,92230,95500,91530,77160,45330,77710,91150,95400,78000,92270,77710,77890,93380,91150,89370,45330,77910,95500,93430,91470,77710,91470,91530,91150,77122,45330,77230,95360,77510,77160,92700,91150,93800,92500,77480,77480,77480,77230,77570,77910,77570,45390,45390,77230,89340,77114,77660,77260,91470,77650,77910,77560,77910,77990,77160,78170,45390,78150,78114,77165,91470,91870,95190,77260,77260,95880,95380,77890,77460,77320,92000,78460,77160,95410,77440,89140,77940,78830,77560,77560,29830,45300,95400,95200,77510,45330,78150,77510,95720,89140,91410,91690,95170,77710,77230,77230,95380,77640,78280,91150,78470,77460,77570,77440,77480,77230,95350,77230,77139,78800,95218,91410,95210,77320,78960,95100,77320,78290,78380,45390,78400,95870,77440,95380,77480,77890,91690,77750,95380,91690,77890,95230,78460,77320,77560,78420,77750,95440,77260,78210,45300,77165,77165,95160,91780,91780,77139,45300,77710,91410,77171,77320,78430) AND fami_id='3' AND cate_id='50' AND type_id='1' AND ssrubr_id='585' AND wish_id<>'487190' AND wish_url='' ORDER BY rand() LIMIT 0,10

  53. 0.0001

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

  54. 0.0001

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

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

  56. 0.0002

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

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

  58. 0.0001

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

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

  60. 0.0002

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

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

  62. 0.0001

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

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

  64. 0.0002

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

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

  66. 0.0001

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

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

  68. 0.0002

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

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

  70. 0.0001

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

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

  72. 0.0002

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

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

  74. 0.0001

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

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

  76. 0.0002

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

  77. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 585

  78. 0.0009

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

  79. 0

    SELECT count(*) as nbwish FROM wish

  80. 0.0498

    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

80 requetes sql en 0.0662

Taille variable Globale : 56.07 KB