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

Cherche mini-bus ou camping car (6 jours)

Annonces similaires

Tout voir
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Cherche camping car (3 jours)

200€

Caudry
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Réaliser le rêve de ma maman (7 jours)

595€

Fenain
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Cherche camping car 3 places (11 jours)

700€

Lille
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Recherche camping car à louée (7 jours)

400€

Loos
Location campingcar
4,2/5 résa

Demande il y a + de 30j

Il y a + de 30j

Louer un camping-car en urgence

500€/semaine

Lille
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Louer un camping car

500€/semaine

Sailly-Labourse
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Location camping car

650€/semaine

Tourcoing
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Location de camping car (4 jours)

320€

Beuvrages
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Location Camping Car

560€/semaine

Bondues
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Camping car (15 jours)

1200€

Saint-Saulve

Louer un camping-car entre particuliers ou proposer un camping-car en location.

Poster une annonce
Retour
Fermer

Location 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.0002

    SHOW TABLES LIKE 'pays'

  3. 0.0002

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

  4. 0.0003

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

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

    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.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='590507'

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='campingcar' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='972'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'campingcar' 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='5' AND c.cate_id='173'

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

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

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=972 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  18. 0.0001

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

  19. 0

    SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=456202 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 = 456202 AND W.type_id = 1) OR (W.util_id <> 456202 AND W.type_id = 2)) AND (M.post_util_id = 456202 OR M.dest_util_id = 456202) 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='456202' 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 = '590507'

  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='456202' AND wish_id<>'590507' 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='62970'

  25. 0.0185

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.4167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.4167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.01667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.967039197041 AND ville_latitude_deg<50.866360802959 AND ville_longitude_deg>2.3109797054346 AND ville_longitude_deg<3.7223602945654 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.0337

    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 ('62970','62141','62950','59950','62119','59128','59162','62790','59553','59553','59286','59283','59553','62110','59283','62590','62490','62640','59500','62710','62490','62740','62820','59261','59239','59552','59552','62320','62320','59119','62220','62420','59194','62880','59450','62440','62320','59246','62117','59239','62490','62112','59194','59169','59310','62320','62580','59187','59551','62430','62221','62218','62680','62880','62880','62580','62490','59133','62490','59167','59133','59551','62112','59710','59112','59148','62880','62580','59235','62580','59287','59169','59182','59287','62210','62300','59185','59147','59710','62490','62410','62580','59169','59182','62118','59151','59310','59251','59710','62118','62410','62580','62300','59112','59221','59146','62118','59169','59113','62490','62490','62410','59310','62580','59176','59147','62580','62580','59147','62138','59710','59242','59169','59870','59151','62118','59151','62410','59176','62118','59151','59310','59272','62118','59870','59263','62156','59259','59496','59242','59175','62156','62750','59273','59184','59175','62580','62138','62156','59490','59234','62860','62800','59165','62580','59870','59136','59274','59496','62223','59139','62156','62860','62118','59151','59139','62860','59870','59155','62156','62860','62860','62143','62138','59310','62223','59580','62156','59242','62580','59234','62153','62156','59830','59490','59310','59234','59134','59273','59265','59810','62860','62138','62223','59580','62223','59480','62223','59310','62160','59320','59134','59320','59134','62128','59179','59211','62138','59480','59790','62860','59830','62160','59870','59870','59262','62980','62128','59265','59310','62223','59134','62153','62128','62860','62182','59830','62217','59247','59310','62149','62223','59830','62223','59171','62149','59215','62149','62000','59252','59320','59120','62182','59320','62860','62160','59870','62980','59178','59247','59230','62182','62860','62144','62128','59320','59320','59830','62670','59252','59171','62149','62860','59320','59260','62128','62217','59830','62840','62217','59249','59310','59690','62144','59178','07611','62114','59230','59172','62128','59247','62860','59249','59134','59152','59152','62128','62113','62113','59830','59320','59000','59800','59160','59350','59777','62217','62217','62860','59252','59320','62182','59265','59226','62172','62840','59152','59780','59265','62149','62161','62161','59111','59124','62144','59171','07610','62217','59554','59265','62290','59370','62128','62000','59111','59172','59130','62530','59178','07624','62530','62860','62660','59156','59160','59110','59780','62530','59554','59152','59840','62128','59268','62113','59295','59295','62136','07502','59510','62128','62128','62161','62144','62175','59554','59111','59350','59293','59178','59554','07618','59280','59220','59226','62690','59135','59840','62860','59141','62860','62128','62161','59840','62690','62136','59255','59700','07522','07623','62690','62217','62860','07504','59400','62128','59554','59780','62620','62690','62173','62131','62131','62128','07621','62144','62131','62400','62123','59111','07620','62840','59510','59520','62136','59282','07522','62175','59161','62620','62690','59170','59290','07506','59141','59390','62150','59230','62121','59237','59118','59400','59220','62400','62840','62147','62123','62175','59161','59282','07620','59141','07620','62159','59135','62400','62123','07522','59554','07620','62232','62690','59195','59400','07522','07620','62175','62150','62121','59267','59930','62173','07500','62620','62123','59158','62196','59491','59493','59650','59655','62690','62147','59220','62690','59280','62232','62232','59390','59158','62620','62940','62123','62123','62173','07501','62175','62840','59161','07520','62121','62147','59267','62232','59121','59390','59195','59390','59400','62124','07500','59193','59494','62159','62150','59296','59158','59910','59940','07620','62123','59116','62159','62121','62690','62136','62173','59230','59420','62199','07622','62690','59121','59230','62150','62232','59161','59253','62123','07730','62920','07503','62150','07641','62123','62123','59159','59100','62690','59590','59224','59890','62147','62147','59158','62124','59494','62124','62147','62122','07783','59277','07500','59236','62124','59198','62690','59174','59115','62700','59400','62123','59850','62121','62121','59267','62810','62116','59400','62116','62690','62450','62920','07521','62150','59192','59150','07520','59281','07642','59200','59199','62450','62690','59410','07640','59125','62116','07730','62690','62121','62123','59188','59400','59224','07536','07730','62124','62450','59159','62350','62127','59129','59890','59223','59250','59126','59181','62810','59233','62150','62121','07782','07730','59940','62116','59199','07548','62123','59159','62920','62111','62122','62350','62810','62690','62123','59188','07640','07712','59660','62450','59241','07743','62123','07643','59940','62450','07540','59217','62540','07730','62150','62127','07743','59860','59227','59227','62810','62460','59560','62124','59227','62450','62124','59300','62121','62810','62147','59300','59400','62124','62450','07784','07640','59400','07740','59300','07904','62450','07540','62810','62150','62350','07542','62158','62460','59970','62810','62450','07604','59231','07730','07608','59213','59188','62127','59880','62540','59960','62450','07780','07780','59292','62127','07784','62121','07730','59269','07530','07538','62470','62127','59770','07531','59217','62116','59400','59217','62124','62157','62350','62810','07700','62111','59560','59258','62124','62127','59278','59117','08950','62158','62124','07700','59166','59213','62450','62111','62124','59258','59217','62810','07740','62470','62450','08957','62111','59214','62350','07604','62158','59294','62350','08952','07742','80300','59269','62260','07543','59258','59157','62460','59970','62116','62158','59163','62450','07604','59270','07711','08940','62127','62127','59990','80300','62450','62124','62127','62111','59157','62124','62151','59266','80300','59213','59213','07604','62260','59127','59990','62190','08587','07532','62158','62130','07781','59970','62127','62450','59231','59264','59270','59232','07540','62111','62127','59270','62810','59269','07534','62350','59231','62810','62127','59990','07600','08930','59730','62810','08953','08951','07601','08950','59990','08510','62450','62550','62760','59990','07533','59191','59540','08587','07760','08510','80360','62550','62127','59243','80360','80360','07604','80300','80360','59266','07603','62550','62810','80360','08956','59730','08511','59270','08930','59213','59213','62760','59730','62111','62190','62550','80360','07602','80360','59540','59730','80300','62810','07760','62190','62810','59530','08902','07540','62111','59271','08587','59191','59297','07534','08930','62130','62330','80240','62158','59730','62260','08940','08560','62450','80360','62810','62127','59144','59163','62810','08958','08980','59266','08510','62550','59270','62270','62190','80360','07906','80300','59191','07760','62127','08554','07760','07904','80122','59127','59154','62158','62130','62190','62190','59163','62550','59530','59530','59270','62130','59990','59225','07760','07320','80300','62760','62111','80560','59540','62550','62130','59990','62260','07971','08902','62190','62120','80360','62330','59190','80600','07971','08510','80560','59225','59127','62760','62760','80360','62550','08583','62810','62550','62450','80300','02420','62810','59540','59920','07387','62130','59144','80240','80360','07971','80240','08954','62810','07910','59270','07321','08980','59127','80240','80300','07911','62760','59190','62130','02420','07971','80560','59189','62270','80560','59189','59530','62130','80360','08900','59218','59218','08902','59730','62130','80560','80740','59142','62760','59530','07901','62130','07380','62130','07910','07350','59190','62550','59190','62120','59144','59360','62270','08552','62550','59530','59980','08970','80300','08501','59190','59127','62550','62550','08582','59218','59144','59218','62760','08980','59299','07904','62120','07911','59980','07380','08560','62810','59530','62190','80760','07972','80300','07387','07321','62270','07387','80300','07911','80560','62550','80112','62130','62130','07910','59144','08890','80200','59189','80560','07760','07910','07910','80300','07350','62120','80560','62550','62120','80600','08500','62130','07387','62270','62130','07973','07972','02420','08900','62120','80300','08560','02420','07900','07900','08551','08501','02420','80740','80300','62960','62960','07750','07910','07322','08550','59144','80560','08880','59980','59980','59238','59530','62130','80560','59980','07750','62120','07972','59270','62760','62130','80360','59222','07387','59222') AND fami_id='5' AND cate_id='173' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='972' AND wish_id<>'590507' 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='972' 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=520931 AND note_visu IN (1,3,4)

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

  30. 0.0002

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

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

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

  34. 0.0002

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

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

  38. 0.0002

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

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

  42. 0.0002

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

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

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

  46. 0.0002

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

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

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

  50. 0.0002

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

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

  54. 0.0002

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

  55. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='972' 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=232754 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 = 232754 AND W.type_id = 1) OR (W.util_id <> 232754 AND W.type_id = 2)) AND (M.post_util_id = 232754 OR M.dest_util_id = 232754) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  58. 0.0002

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

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

  62. 0.0002

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

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

  66. 0.0002

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

  67. 0.0001

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 972

  68. 0.0001

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

  69. 0.0001

    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='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC

  70. 0.0004

    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 (87) ORDER BY ssrubr_order ASC

  71. 0.0003

    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 (88) ORDER BY ssrubr_order ASC

  72. 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 (81) ORDER BY ssrubr_order ASC

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

  74. 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 (227) ORDER BY ssrubr_order ASC

  75. 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 (176) ORDER BY ssrubr_order ASC

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

  77. 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 (208) ORDER BY ssrubr_order ASC

  78. 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 (228) ORDER BY ssrubr_order ASC

  79. 0.0003

    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 (207) ORDER BY ssrubr_order ASC

  80. 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 (95) ORDER BY ssrubr_order ASC

  81. 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 (173) ORDER BY ssrubr_order ASC

  82. 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 (83) ORDER BY ssrubr_order ASC

  83. 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 (93) ORDER BY ssrubr_order ASC

  84. 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 (193) ORDER BY ssrubr_order ASC

  85. 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 (91) ORDER BY ssrubr_order ASC

  86. 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 (232) ORDER BY ssrubr_order ASC

  87. 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 (92) ORDER BY ssrubr_order ASC

  88. 0.0013

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

  89. 0.0232

    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'

  90. 0.0168

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

90 requetes sql en 0.1059

Taille variable Globale : 84.72 KB