Kiwiiz : service & location entre voisins.
Utiliser ma position
Logo recherche

Indiquer un code postal ou une ville Indiquer un code postal

Flèche vers le champ lieu

Poster une annonce

Service : Aide au ménage

Annonces similaires

Tout voir
Service aide personne

Il y a + de 30j

Il y a + de 30j

Aide pour les personnes agées

15€/heure

Lille
Service aide personne
5/5 résa

Il y a + de 30j

Il y a + de 30j

Service : Aide a la personne

15€/heure

Saint-Venant
Service aide personne

Il y a + de 30j

Il y a + de 30j

Compagnie personnes âgées

15€/heure

Neuville-en-Ferrain
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Aide a la personne

20€/heure

Tourcoing
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Aide à la personne

20€/heure

Perenchies
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Ménage et autre

10€/heure

Lambersart
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Service personne

20€/heure

Bourg-Saint-Andeol
Service aide personne

Il y a + de 30j

Il y a + de 30j

Repassage à mon domicile

12€/heure

Nieppe
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Petit travaux

20€/heure

Tourcoing
Service aide personne

Il y a + de 30j

Il y a + de 30j

Aide à la personne véhicule électrique M

30€/heure

Marcq-en-Baroeul

Demande un service d'aide a la personne entre voisins ou proposer mes services d'aide a la personne.

Poster une annonce
Retour
Fermer

Services entre voisins

Lancez votre recherche pour voir les annonces.

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

    SHOW TABLES LIKE 'pays'

  3. 0.0002

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

  4. 0.0002

    SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC

  5. 0.0001

    SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL

  6. 0.0004

    SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''

  7. 0.0002

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

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='aide-personne' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='1020'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'aide-personne' LIMIT 1

  10. 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='229'

  11. 0.0001

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

  12. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='293840' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  13. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 293840

  14. 0.0001

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 552998

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1020 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  18. 0

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

  19. 0

    SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=293840 LIMIT 1

  20. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 293840 AND W.type_id = 1) OR (W.util_id <> 293840 AND W.type_id = 2)) AND (M.post_util_id = 293840 OR M.dest_util_id = 293840) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  21. 0.0001

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

  22. 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 = '552998'

  23. 0.0001

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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='293840' AND wish_id<>'552998' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  24. 0.0001

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

  25. 0.0142

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.4833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.4833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.66667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.033639197041 AND ville_latitude_deg<50.932960802959 AND ville_longitude_deg>1.9599856856277 AND ville_longitude_deg<3.3733543143723 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.0059

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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 ('62290','62113','62131','62670','62131','62131','62113','62113','62620','62980','62530','62114','62660','62149','62980','62196','62149','62620','62232','62232','62160','62400','62620','62940','62232','62232','62160','62620','62199','62149','62172','62400','62530','62160','62122','62149','62700','62150','62920','62149','62920','62530','62138','62750','62400','62150','62150','62143','62232','62690','62138','62138','62122','62150','62800','62410','62540','59480','62150','62150','62144','62136','62920','62150','62690','62153','62136','62410','62136','62460','62540','62138','62350','62840','62690','62153','62300','62144','62470','62410','62157','59496','62150','62300','62690','62580','62460','62840','62690','62127','62470','62260','62880','62138','62690','62350','62144','62136','62150','59480','62127','62210','62690','62144','62151','59496','62221','62218','62690','62350','62350','62260','62880','62410','62880','62690','62690','59221','62190','59134','59274','62430','62690','62460','62350','62580','62550','62580','59660','62144','59253','59134','62680','62440','62350','62690','59940','59249','62690','62580','62550','62550','62880','62190','62190','62260','59185','62550','59184','62130','62420','62840','62223','59249','62127','59940','62740','62690','62161','62161','62550','62190','59134','62127','62580','62320','62350','62190','62190','59272','62580','62550','62710','62690','62223','62260','59112','62640','62330','62127','62580','62840','62320','62190','62120','59136','62550','62127','62580','62110','62223','62550','62161','62161','62123','62123','62123','59251','62690','62127','62320','62320','62123','62130','62127','62580','62220','59134','62330','62127','62580','62550','59112','62223','62223','62120','59134','62550','62550','62840','62127','62810','62130','62127','62123','62550','62190','62223','59147','62550','62590','59940','62000','62580','59133','62120','62810','62810','59320','62550','59147','62119','62130','62580','62120','59189','62127','62810','62223','59147','62960','62960','62950','62000','62120','59211','62550','62130','62490','62120','59320','59320','59280','62127','62123','62123','59189','62810','59232','62130','62123','62130','62820','62134','62120','62120','62130','62130','59133','62490','62810','62217','62217','62120','62810','62127','59320','59263','62960','59181','62217','59189','62118','62127','59193','62223','62970','62145','62120','59320','62490','59261','59270','62134','59320','59270','62130','62134','59162','62810','62118','59190','62217','62810','62130','62141','62123','59850','59320','62810','59320','59113','59320','59280','62270','62118','62130','62810','62145','59139','59239','62130','62217','59239','62810','59840','62130','59551','62130','59190','59930','62810','62120','62123','62123','62173','62120','62130','62123','59270','62490','62130','59553','62217','62960','62130','59950','59160','59190','59270','62173','62134','62134','62270','59190','62118','59173','62810','62270','62118','59175','59128','62158','59120','62120','62134','62790','62810','62130','62810','62118','59139','62145','59553','59553','62217','07783','59840','62130','62118','62134','59551','62134','62128','62173','59270','62134','59283','62123','59175','62130','62123','62173','59116','62117','62130','62960','59710','59283','59190','62128','62810','62128','62120','59155','59286','62134','59173','62128','59190','62134','62270','62158','59246','62130','62130','59552','07782','62175','62960','59840','62130','59500','62145','62810','62128','62156','59173','62810','62960','08950','62128','62130','62123','62158','59270','62120','62175','59130','62270','62112','62134','59552','59710','62490','62960','59710','62158','62175','62134','59236','62120','62156','62270','62270','62270','62175','62134','62810','62120','59237','62490','08951','59114','62175','62129','62156','59000','59800','59160','59350','59777','62112','59169','62270','62156','62128','62310','62130','62130','59310','59350','62130','62134','59190','62128','59790','62130','59190','62111','59270','62116','08952','59710','62156','59173','62810','62158','59114','62111','59810','62156','59119','59110','59273','62129','59194','62158','62129','62270','62490','08958','62270','62158','62130','62121','62310','59235','62490','59890','62310','62120','08950','62310','62130','59450','62128','80600','62310','62760','62270','62130','59151','59173','59670','62121','62120','59890','59118','62128','59260','59187','08956','59270','62111','59299','08954','62111','62116','08957','62560','59520','59259','62770','59194','62116','59242','59560','59114','07784','59670','59242','62129','62128','59700','59370','80600','62182','62270','59169','62156','62760','62310','62129','80600','62121','62770','59670','62270','62575','62270','59114','62810','62310','62560','59273','62310','62310','62860','62129','62770','62310','62270','59151','08953','07784','59262','59148','62770','59167','62760','62760','62121','59287','62770','62116','62182','62310','59670','62860','08970','62560','62111','59310','62128','62128','62310','62270','62182','59169','62310','80600','62182','62270','59151','59310','62760','62380','62570','59169','59830','62770','62760','62575','59670','59182','59287','62310','62310','59830','62860','62860','62570','62510','62380','62270','07780','07780','59670','62760','62310','62760','62111','59910','62310','80600','62111','62116','62560','62860','59182','62270','59670','08900','62159','59242','62270','62770','62760','62128','62770','62770','07781','59170','59290','59670','62121','59152','59152','62390','59151','59670','08902','62770','59830','62270','62770','59169','59560','62760','62121','62310','62570','80600','62560','59510','59310','62270','62860','62860','59491','59493','59650','59655','59670','62310','59223','59250','59126','59146','08902','59176','62121','62121','59830','62380','62500','59420','62111','62116','62860','59151','59152','62570','62860','62770','59870','62111','80560','62121','62770','62770','59310','62310','62219','08970','62760','62860','59117','59670','62560','59152','80560','62121','62770','59870','59176','62500','62380','59670','62760','08978','62860','59234','62219','62380','59510','62390','62560','80560','62450','62159','62770','08940','59830','62390','62860','59285','80600','62860','62860','80560','62500','59780','08908','59285','59100','62159','62450','08980','62390','59200','59265','80560','80300','59143','08902','80560','80300','59830','59166','62770','80560','80600','62560','59780','62760','59490','59390','80600','59780','59830','59165','62760','62450','62310','59310','62310','08900','62380','62380','59310','80600','62140','62124','62560','62390','62390','59234','59390','62500','62770','62140','62450','59870','59265','59470','59390','59310','59234','62760','62450','62390','80560','62450','62500','80600','59870','62760','80300','80300','62860','80300','62450','59580','80600','80560','80300','08900','62380','59470','62380','59310','59285','59390','62500','62124','80560','62390','62860','07611','59960','08972','80600','80560','59580','62450','62140','80600','08980','59470','62140','62140','62500','59490','08900','59150','80370','62560','80560','62450','62140','59247','07610','59143','59247','59143','08906','80600','62310','80600','62124','62560','62450','07522','59470','07502','62147','62140','59265','62380','07522','62140','59870','62390','08940','80560','62124','80370','59470','62147','07712','62140','80300','59179','59470','62860','62140','62500','59115','07520','59870','59252','62390','62500','07730','59470','62450','62450','08640','62147','62390','59310','59690','62990','62650','80560','59230','59470','08930','59554','59178','80560','07522','62124','62910','62380','08980','62140','59870','62140','08904','59247','59171','62380','59215','62450','62390','59265','07700','59252','07504','08972','59265','80560','59554','80600','80600','80300','62910','07522','80300','07730','80370','80600','62124','59226','62990','62147','62140','07618','62990','62650','80300','08930','59122','08972','62450','59230','62140','62140','59470','59178','80370','80560','80560','59143','80630','62390','62390','08980','07624','59554','62650','59252','08640','59400','59171','62380','59268','62147','62910','07730','80560','59470','62380','62140','80600','07700','62140','59172','80360','07506','08640','62990','62650','08904','59380','80600','80360','62140','62500','62450','62910','08560','80150','62124','59111','59554','80370','59400') AND fami_id='3' AND cate_id='229' AND type_id='1' AND ssrubr_id='1020' AND wish_id<>'552998' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

  27. 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='1020' LIMIT 0,1

  28. 0.0001

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

  29. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 549402 AND W.type_id = 1) OR (W.util_id <> 549402 AND W.type_id = 2)) AND (M.post_util_id = 549402 OR M.dest_util_id = 549402) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  30. 0.0001

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

  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='1020' 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=184906 AND note_visu IN (1,3,4)

  33. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 184906 AND W.type_id = 1) OR (W.util_id <> 184906 AND W.type_id = 2)) AND (M.post_util_id = 184906 OR M.dest_util_id = 184906) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  34. 0.0001

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

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

  36. 0.0001

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

  37. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 485391 AND W.type_id = 1) OR (W.util_id <> 485391 AND W.type_id = 2)) AND (M.post_util_id = 485391 OR M.dest_util_id = 485391) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  38. 0.0001

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

  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='1020' 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=481827 AND note_visu IN (1,3,4)

  41. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 481827 AND W.type_id = 1) OR (W.util_id <> 481827 AND W.type_id = 2)) AND (M.post_util_id = 481827 OR M.dest_util_id = 481827) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  42. 0.0001

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

  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='1020' 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=467191 AND note_visu IN (1,3,4)

  45. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 467191 AND W.type_id = 1) OR (W.util_id <> 467191 AND W.type_id = 2)) AND (M.post_util_id = 467191 OR M.dest_util_id = 467191) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  46. 0.0001

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

  47. 0

    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='1020' 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=463245 AND note_visu IN (1,3,4)

  49. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 463245 AND W.type_id = 1) OR (W.util_id <> 463245 AND W.type_id = 2)) AND (M.post_util_id = 463245 OR M.dest_util_id = 463245) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  50. 0.0001

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

  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='1020' 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=286756 AND note_visu IN (1,3,4)

  53. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 286756 AND W.type_id = 1) OR (W.util_id <> 286756 AND W.type_id = 2)) AND (M.post_util_id = 286756 OR M.dest_util_id = 286756) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  54. 0.0001

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

  55. 0

    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='1020' 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=451678 AND note_visu IN (1,3,4)

  57. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 451678 AND W.type_id = 1) OR (W.util_id <> 451678 AND W.type_id = 2)) AND (M.post_util_id = 451678 OR M.dest_util_id = 451678) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  58. 0.0001

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

  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='1020' 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=447782 AND note_visu IN (1,3,4)

  61. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 447782 AND W.type_id = 1) OR (W.util_id <> 447782 AND W.type_id = 2)) AND (M.post_util_id = 447782 OR M.dest_util_id = 447782) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  62. 0.0001

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

  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='1020' 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=363458 AND note_visu IN (1,3,4)

  65. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 363458 AND W.type_id = 1) OR (W.util_id <> 363458 AND W.type_id = 2)) AND (M.post_util_id = 363458 OR M.dest_util_id = 363458) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  66. 0.0001

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

  67. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1020

  68. 0

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

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

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

  71. 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 (38) ORDER BY ssrubr_order ASC

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

  73. 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 (231) ORDER BY ssrubr_order ASC

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

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

  76. 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 (37) ORDER BY ssrubr_order ASC

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

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

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

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

  81. 0.0009

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

  82. 0.0217

    SELECT COUNT(*) AS nbavis FROM note n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'

  83. 0.0162

    SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

83 requetes sql en 0.0668

Taille variable Globale : 63.24 KB