Indiquer un code postal ou une ville

Flèche vers le champ lieu

Service réparateur divers à 77184 Émerainville


Service réparateur divers : 2 annonces de réparateur divers entre particuliers à 77184 Émerainville Des réparateurs particuliers proposent leur aide pour des prestations de réparation : réparation d'électroménager, réparation de matériels informatique, réparation de télévision ... Chaque réparateur particulier ayant ses spécialités en réparation il convient de vérifier ce qu'il peut réparer ou déposer une demande en précisant son besoin de réparation pour recevoir les propositions de réparateurs particuliers à proximité.
 ... voir la suite
<
1
2
3
4
>  >>
Demander un service / jobbing de reparation ou proposer un service de reparation entre particuliers.
Poster une annonce

Trouver

Trouver
Demandes des voisins

Demandes

 créer une annonce
Messagerie

Messages

 Mon profil

Profil

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wall.php

  1. 0.0001

    SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='depanneur-reparateur'

  2. 0.0001

    SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=231

  3. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='77'

  4. 0.0001

    SELECT ville_nom FROM villes WHERE ville_cp='77184' AND ville_nom like '%emerainville%' ORDER BY ville_population_2012 DESC LIMIT 0,1

  5. 0.0001

    SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%reparation%' OR ssrubr_title like '%reparation%' OR ssrubr_slug like '%reparation%') AND cate_id='231' ORDER BY ssrubr_id LIMIT 0,1

  6. 0.0001

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

  7. 0.002

    SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.61667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.636835678816 AND ville_latitude_deg<48.996564321184 AND ville_longitude_deg>2.3435146819952 AND ville_longitude_deg<2.8898253180048 HAVING distance <= 20 ORDER BY distance ASC

  8. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='réparation'

  9. 0.0002

    SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='231'AND MATCH (wish_title,wish_desc) AGAINST ('+réparation*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '77184%'

  10. 0

    SELECT * FROM texte WHERE cate_id=231

  11. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='réparation' OR ssrubr_slug='réparation' OR (ssrubr_title like '%réparation%')) AND cate_id='231' ORDER BY ssrubr_id LIMIT 0,1

  12. 0.0001

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

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

  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_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='reparation' AND cate_id='231'

  16. 0.0001

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

  17. 0.0019

    SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.61667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.636835678816 AND ville_latitude_deg<48.996564321184 AND ville_longitude_deg>2.3435146819952 AND ville_longitude_deg<2.8898253180048 HAVING distance <= 20 ORDER BY distance ASC

  18. 0.006

    SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.61667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.367039197041 AND ville_latitude_deg<49.266360802959 AND ville_longitude_deg>1.9337758163378 AND ville_longitude_deg<3.2995641836622 HAVING distance <= 50 ORDER BY distance ASC

  19. 0.0376

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='231' AND MATCH (wish_desc) AGAINST ('(+réparation*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (77184,77184,77185,77340,77680,94420,77186,77420,77183,77090,77200,94510,93160,94350,77360,77600,94880,94490,94880,77135,77164,93460,77330,77600,77600,93330,94500,77400,77177,77500,94360,94430,77400,94370,94380,77600,94340,94100,94210,77400,93360,77400,77150,94170,77150,93220,77600,77600,94130,93370,77400,94470,94120,94440,94340,77181,93110,77144,94380,77400,93250,77181,93470,77170,77410,94410,94000,94440,77173,93320,77400,93340,93390,93190,77220,94440,77700,77270,77144,93130,77700,94460,77410,77220,77174,94450,93410,94700,94520,94520,94300,91330,93270,93140,77220,93100,94220,94140,94160,77700,77220,77170,77166,77450,93000,93260,93230,94190,77410,91800,77450,93170,77700,94600,93290,77174,91480,77410,91800,94400,77700,91560,93600,91860,77610,77220,77410,94200,94205,77380,77450,94290,93310,77450,94390,94310,77170,93420,77390,77410,91480,93700,77410,93150,91230,77580,94320,77166,94270,77450,93500,77610,94480,94800,77290,77860,77111,77410,77450,91200,77410,77450,93350,77610,91270,77860,77610,77111,77410,77450)

  20. 0.0278

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.61667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='231' AND MATCH (wish_desc) AGAINST ('(+réparation*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (77184,77184,77185,77340,77680,94420,77186,77420,77183,77090,77200,94510,93160,94350,77360,77600,94880,94490,94880,77135,77164,93460,77330,77600,77600,93330,94500,77400,77177,77500,94360,94430,77400,94370,94380,77600,94340,94100,94210,77400,93360,77400,77150,94170,77150,93220,77600,77600,94130,93370,77400,94470,94120,94440,94340,77181,93110,77144,94380,77400,93250,77181,93470,77170,77410,94410,94000,94440,77173,93320,77400,93340,93390,93190,77220,94440,77700,77270,77144,93130,77700,94460,77410,77220,77174,94450,93410,94700,94520,94520,94300,91330,93270,93140,77220,93100,94220,94140,94160,77700,77220,77170,77166,77450,93000,93260,93230,94190,77410,91800,77450,93170,77700,94600,93290,77174,91480,77410,91800,94400,77700,91560,93600,91860,77610,77220,77410,94200,94205,77380,77450,94290,93310,77450,94390,94310,77170,93420,77390,77410,91480,93700,77410,93150,91230,77580,94320,77166,94270,77450,93500,77610,94480,94800,77290,77860,77111,77410,77450,91200,77410,77450,93350,77610,91270,77860,77610,77111,77410,77450) AND type_id=1 GROUP BY wish_id

  21. 0.0001

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

  22. 0.0016

    SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.61667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.636835678816 AND ville_latitude_deg<48.996564321184 AND ville_longitude_deg>2.3435146819952 AND ville_longitude_deg<2.8898253180048 HAVING distance <= 20 ORDER BY distance ASC

  23. 0.0055

    SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.61667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.367039197041 AND ville_latitude_deg<49.266360802959 AND ville_longitude_deg>1.9337758163378 AND ville_longitude_deg<3.2995641836622 HAVING distance <= 50 ORDER BY distance ASC

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

  25. 0.0001

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

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

  27. 0.0001

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

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

  29. 0.0001

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

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

  31. 0.0001

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

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

  33. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=12540 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 = 114973 AND W.type_id = 1) OR (W.util_id != 114973 AND W.type_id = 2)) AND (`post_util_id` = 114973 OR `dest_util_id` = 114973) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  35. 0.0001

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

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

  37. 0.0001

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

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

  39. 0.0001

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

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

  41. 0.0001

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

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

  43. 0.0001

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

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

  45. 0.0001

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

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

  47. 0.0001

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

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

  49. 0.0001

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

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

  51. 0.0001

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

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

  53. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=265473 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 = 88046 AND W.type_id = 1) OR (W.util_id != 88046 AND W.type_id = 2)) AND (`post_util_id` = 88046 OR `dest_util_id` = 88046) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  55. 0.0001

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

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

  57. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=294294 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 = 296741 AND W.type_id = 1) OR (W.util_id != 296741 AND W.type_id = 2)) AND (`post_util_id` = 296741 OR `dest_util_id` = 296741) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  59. 0.0001

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

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

  61. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=306262 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 = 307897 AND W.type_id = 1) OR (W.util_id != 307897 AND W.type_id = 2)) AND (`post_util_id` = 307897 OR `dest_util_id` = 307897) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  63. 0.0001

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

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

  65. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=258058 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 = 328498 AND W.type_id = 1) OR (W.util_id != 328498 AND W.type_id = 2)) AND (`post_util_id` = 328498 OR `dest_util_id` = 328498) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  67. 0.0001

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

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

  69. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=354413 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 = 361252 AND W.type_id = 1) OR (W.util_id != 361252 AND W.type_id = 2)) AND (`post_util_id` = 361252 OR `dest_util_id` = 361252) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  71. 0.0001

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

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

  73. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=363877 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 = 365299 AND W.type_id = 1) OR (W.util_id != 365299 AND W.type_id = 2)) AND (`post_util_id` = 365299 OR `dest_util_id` = 365299) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  75. 0.0001

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

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

  77. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=367227 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 = 100949 AND W.type_id = 1) OR (W.util_id != 100949 AND W.type_id = 2)) AND (`post_util_id` = 100949 OR `dest_util_id` = 100949) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  79. 0.0001

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

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

  81. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=370877 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 = 389038 AND W.type_id = 1) OR (W.util_id != 389038 AND W.type_id = 2)) AND (`post_util_id` = 389038 OR `dest_util_id` = 389038) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  83. 0.0001

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

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

  85. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=254358 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 = 399184 AND W.type_id = 1) OR (W.util_id != 399184 AND W.type_id = 2)) AND (`post_util_id` = 399184 OR `dest_util_id` = 399184) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  87. 0.0001

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

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

  89. 0.0001

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

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

  91. 0.0001

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

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

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

  94. 0.0001

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

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

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

  97. 0.0001

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

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

  99. 0.0001

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

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

  101. 0.0001

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

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

  103. 0.0001

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

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

  105. 0.0001

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

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

  107. 0.0001

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

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

  109. 0.0001

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

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

  111. 0.0001

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

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

  113. 0.0001

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

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

  115. 0.0001

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

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

  117. 0.0001

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

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

  119. 0.0001

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

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

  121. 0.0001

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

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

  123. 0.0001

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

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

  125. 0.0001

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

  126. 0.0002

    SELECT ssrubr_id, ssrubr_title, ssrubr_slug, ssrubr_photo, cate_title_slug FROM ssrubr ss, category c WHERE ss.cate_id=c.cate_id AND ssrubr_visu=1 AND ss.cate_id=231 AND ss.fami_id=3 ORDER BY ssrubr_order LIMIT 6,100

  127. 0.0001

    SELECT ss.fami_id, fami_url, ss.cate_id, cate_title_slug, keywords_title FROM `ssrubr_keywords` sk, ssrubr ss, category c, family f WHERE sk.ssrubr_id=ss.ssrubr_id AND ss.cate_id=c.cate_id AND c.fami_id=f.fami_id AND (ssrubr_slug='réparation' OR ssrubr_slug like '%réparation%' OR MATCH (ssrubr_slug) AGAINST ('(+réparation)')) AND sk.ssrubr_id='581' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

  128. 0.0001

    SELECT * FROM actu WHERE ssrubr_id='581' AND actu_niveau=0 ORDER BY actu_ordre DESC

  129. 0.0009

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

  130. 0

    SELECT count(*) as nbwish FROM wish

  131. 0.0489

    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

131 requetes sql en 0.1448

Taille variable Globale : 76.29 KB