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

Recherche location camping-car

Annonces similaires

Tout voir
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Demande camping-car aménagé (2 semaines)

1290€

Thonon-les-Bains
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Location camping car (2 jours)

250€

Chamonix-Mont-Blanc
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Location camping car

180€/weekend

Sallanches
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Location camping car vacances (15 jours)

1200€

La Roche-sur-Foron
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Cherche à  louer camping car (5 jours)

400€

Lugrin
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Recherche camping car en location

500€/mois

Annemasse
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Cherche location camping-car 3 semaines

1470€

Thonon-les-Bains
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Recherche une location de camping-car

70€/jour

Thonon-les-Bains
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Location d'un camping-car fin juillet

348€

Thyez
Location campingcar

Demande il y a + de 30j

Il y a + de 30j

Demande location camping car 6m maxi

-- €

Thonon-les-Bains

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

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

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

  12. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='55587' 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` = 55587

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

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

  17. 0.0001

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

  19. 0

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

  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='55587' AND wish_id<>'271121' 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='74360'

  25. 0.0069

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((46.3*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((46.3*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.66667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>45.850339197041 AND ville_latitude_deg<46.749660802959 AND ville_longitude_deg>6.015813339299 AND ville_longitude_deg<7.317526660701 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.0132

    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 ('74360','74360','74500','74200','74430','74430','74360','74200','74500','74430','74500','74430','74200','74360','74470','74500','74500','74500','74500','74500','74470','74200','74110','74110','74500','74500','74500','74470','74500','74500','74500','74500','74200','74500','74550','74390','74110','01896','74110','74200','01898','01899','74420','74200','74200','01897','74550','74550','74260','01875','74490','01897','74420','01873','01895','74550','01873','01893','74200','01896','01846','01870','01870','74490','74890','74200','01071','01096','74890','01096','74440','01845','74420','01071','01872','74420','01094','01802','74890','01874','01095','01852','01009','74440','01847','74250','01800','74420','74420','01007','01006','01803','01868','01814','01853','74140','01815','01873','01025','01091','74440','01071','74440','74490','01098','01871','01820','01800','01811','01811','01870','01870','01097','74890','01091','01070','74420','01091','01860','01867','01871','01093','01820','01028','01162','74440','01001','01002','01804','01816','01164','01801','01131','01003','74340','01005','01000','01000','01000','01000','01000','01000','01014','01014','01019','01019','01090','01822','74300','74140','01110','01805','01817','74970','01011','01092','01012','01015','01869','74250','74250','01820','74140','74300','74140','01891','01809','01004','01832','01823','74250','01856','01867','01165','01844','01068','74300','74140','01022','74300','01010','01018','74140','01026','01024','01020','01020','01000','01820','01820','01818','01818','01008','01854','01884','01616','01110','01110','01832','01902','01890','01072','01073','01806','01880','01808','01614','01132','01867','01166','01163','01824','01807','01066','74460','74140','01167','01027','01134','01880','74140','74140','01026','01026','74740','01000','01008','74250','01833','74140','01890','01112','01885','01607','74950','74250','74130','01615','01892','74140','74380','01052','01135','01880','01168','01023','01892','01134','01073','74250','01030','01023','01180','01125','74250','74300','01617','01195','01121','01032','01175','74130','01173','01884','01607','01607','01170','74300','01863','01000','74380','01923','01195','01113','01254','01126','01029','74130','74130','01078','74100','74140','01122','01251','01136','01610','01607','74380','01080','01617','01892','74130','01880','01612','01196','74130','01077','01081','01172','74300','01053','01033','01031','01610','01185','01922','01128','01866','01039','01123','01169','01302','01114','74140','01127','01884','74130','01610','01619','01243','01176','01174','01054','01197','01925','01669','01862','01903','74930','74380','01083','01180','01613','01608','01174','01055','01183','01904','01036','01673','01922','01618','01248','01076','01053','01608','01182','01115','01923','74950','01608','01252','01037','01082','74380','01184','74100','74100','01124','74800','01184','74100','01247','01186','01143','01660','01673','01034','01260','01905','01303','01608','01246','01116','01084','01609','01141','01925','01241','01658','01299','01880','01244','74800','01267','01041','01260','01260','01088','01035','01862','01864','01882','01304','01699','01042','01658','01609','01187','01189','01673','01266','01268','01267','01058','74100','01298','01144','01296','74930','01042','01669','74800','74930','01268','74100','01299','01041','01669','01304','74660','74800','01297','01117','01222','01305','01245','74800','01609','01609','01928','01262','01673','01675','01253','01042','01142','01274','74240','01274','01059','01699','01699','01623','01624','01624','01085','01509','01304','01295','01660','01226','74800','01272','01624','01277','01040','01306','01040','01926','01911','01673','01669','01041','01295','74800','01920','01225','01675','01274','01513','01148','01041','01223','01145','01921','74800','01188','01919','01919','01920','01270','01279','01277','01624','01307','01041','01261','01224','01675','01061','01148','74560','01699','01291','01308','01669','01271','01294','01261','01510','01146','01263','01377','01611','01376','74130','01670','01290','01955','01865','01043','01304','01929','01148','01149','01674','01279','01062','01663','01231','01188','01670','01208','01041','01932','01207','01660','01312','01292','01513','01040','01376','01697','01261','01927','01293','01255','01666','01063','01677','01674','01670','01290','01063','01148','74700','01211','01316','01206','01688','01147','74930','01201','01202','01906','01911','74800','74560','01315','01376','01912','01063','01234','01044','01204','01932','74310','01200','01240','01269','01220','01660','01674','01512','01275','01211','01211','01211','01697','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01148','01913','01913','01688','74160','01239','01955','01205','74700','01912','01220','01912','01676','01063','01666','01220','01317','01148','01510','01667','01218','01313','01227','01148','01210','01687','74700','74480','01256','01209','01211','01215','01635','01227','01375','01276','74450','01372','01933','01418','01627','01976','01663','01625','01203','01628','01678','01630','01318','01955','01683','01410','01210','01264','01683','01038','01912','01215','01210','01661','01220','01907','74160','01278','01216','01942','01687','01219','01213','01955','01212','01955','01212','01213','01211','01273','01626','01679','01046','01938','01416','74920','01957','74130','74190','74570','01148','01663','01683','01514','01170','01228','01933','01321','01631','01219','01908','01941','74160','01374','01341','01933','01322','01148','01515','01219','01170','01280','01257','74400','01941','01346','01626','01213','74350','01681','01410','01659','01685','01373','01045','01625','01211','01323','01217','01663','01955','03784','01626','01344','01665','01417','01217','01170','03785','01214','01933','01682','01170','01047','01326','74350','01232','01684','01687','01521','01522','01353','01681','01341','01410','01433','01914','01515','01348','01258','01682','74450','01659','01522','01413','74310','01265','03783','01943','74350','01407','01686','01996','74570','01632','01937','74160','01410','01409','01233','01325','01996','01686','01352','01342','01963','74160','01435','01976','01934','01636','01412','74120','01996','01417','01350','01918','74220','01680','74230','39220','01345','01682','74160','74350','01638','01329','01324','01936','01170','01170','01689','74570','01432','01408','01633','03792','01347','01526','01526','01486','01407','01680','01410','01652','74160','01914','01975','74120','01242','01965','01412','01288','01976','01964','01434','01345','01354','01347','73590','01945','01653','01945','01934') 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<>'271121' 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=499413 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 = 499413 AND W.type_id = 1) OR (W.util_id <> 499413 AND W.type_id = 2)) AND (M.post_util_id = 499413 OR M.dest_util_id = 499413) 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 = 499413

  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=188162 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 = 188162 AND W.type_id = 1) OR (W.util_id <> 188162 AND W.type_id = 2)) AND (M.post_util_id = 188162 OR M.dest_util_id = 188162) 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 = 188162

  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=185019 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 = 185019 AND W.type_id = 1) OR (W.util_id <> 185019 AND W.type_id = 2)) AND (M.post_util_id = 185019 OR M.dest_util_id = 185019) 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 = 185019

  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=168280 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 = 168280 AND W.type_id = 1) OR (W.util_id <> 168280 AND W.type_id = 2)) AND (M.post_util_id = 168280 OR M.dest_util_id = 168280) 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 = 168280

  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=130037 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 = 130037 AND W.type_id = 1) OR (W.util_id <> 130037 AND W.type_id = 2)) AND (M.post_util_id = 130037 OR M.dest_util_id = 130037) 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 = 130037

  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=55753 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 = 55753 AND W.type_id = 1) OR (W.util_id <> 55753 AND W.type_id = 2)) AND (M.post_util_id = 55753 OR M.dest_util_id = 55753) 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 = 55753

  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=35746 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 = 35746 AND W.type_id = 1) OR (W.util_id <> 35746 AND W.type_id = 2)) AND (M.post_util_id = 35746 OR M.dest_util_id = 35746) 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 = 35746

  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=28452 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 = 28452 AND W.type_id = 1) OR (W.util_id <> 28452 AND W.type_id = 2)) AND (M.post_util_id = 28452 OR M.dest_util_id = 28452) 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 = 28452

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

  61. 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 = 28288 AND W.type_id = 1) OR (W.util_id <> 28288 AND W.type_id = 2)) AND (M.post_util_id = 28288 OR M.dest_util_id = 28288) 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 = 28288

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

  65. 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 = 12080 AND W.type_id = 1) OR (W.util_id <> 12080 AND W.type_id = 2)) AND (M.post_util_id = 12080 OR M.dest_util_id = 12080) 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 = 12080

  67. 0

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

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

  83. 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 (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.0009

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

  89. 0.0314

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

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

90 requetes sql en 0.0874

Taille variable Globale : 84.55 KB