Quoi faire dans Vieux Port de Montréal - Activités familiales

Explorez le Vieux-Port de Montréal : sensations, découvertes… et Mondes Disparus ! Le Vieux-Port de Montréal est une destination incontournable pour les familles, les curieux et les amateurs de sensations fortes. Commencez votre aventure avec Mondes Disparus, une expérience immersive en réalité virtuelle qui vous plonge au cœur de l'évolution de la vie sur Terre – une sortie aussi spectaculaire qu'éducative. Poursuivez avec les classiques du Vieux-Port, comme MTL Zipline, pour une vue aérienne du bassin Bonsecours, ou encore un saut décoiffant avec Montréal Bungee. Pour les esprits joueurs, cap sur SOS Labyrinthe ou le Mini-Putt Montréal. Et pour les amateurs de vitesse et d'éclaboussures, (Lire la suite)

(afficher les activités de la page 2)

Trouver une activité

DES ACTIVITÉS & ESCAPADES À DÉCOUVRIR

0 offres sur 13 sont affichées

< 1 2

Voir toutes les offres

Quoi faire ce mois-ci: Coup d'oeil sur les sorties du mois

BLOGUES - EXPLOREZ NOS ATTRAITS

Hôtel Ambassadeur Québec

Détails

Au Chalet en Bois Rond - Ste-Christine d'Auvergne

Détails

Kenauk Nature - Glamping - Prêt-à-camper près de Montréal

Détails

Parc régional Beauharnois-Salaberry

Détails

Parc National d'Aiguebelle

Détails

Village historique de Val-Jalbert

Détails

Zükari Centre-amusement intérieur - Sainte-julie

Détails

Ermitage Saint-Antoine - Havre de Paix et de Spiritualité au (…)

Détails

Le Centre Castor, situé sur la Base militaire de Valcartier.

Détails

Découverte des Vignobles du Québec : Un Voyage au Cœur des (…)

Détails

Découvrez Saint-Hyacinthe et sa région - Quoi faire & plus!

Détails

Découvrez les lieux culturels de l'île d'Orléans - Site (…)

Détails

Découvrez le Manoir d’Youville

Détails

Le Camping au Québec - Que l'aventure commence!

Détails

Explorons le monde du vélo de montagne au Québec

Détails

Hôtel Castel

Détails

Faire de la musique est au cœur de la mission de CAMMAC

Détails

Retrouver l'Équilibre : Plongez dans l'Oasis de Détente

Détails

Les meilleurs festivals d'été de Montréal

Détails

Activités à faire en famille pendant la semaine de relâche

Détails

Total (ms)

Load (ms)

App (ms)

Query (ms)

Count

Average (ms)

Template

Order

16.8

C:\sites\passeportvacances.com\www\inc\module\editorial.cfm$QUERYBILLET

14.9

0.004

14.3

0.608

C:\sites\passeportvacances.com\www\inc\module\editorial.cfm

12.9

0.003

2.07

10.9

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

21.9

10.9

C:\sites\passeportvacances.com\www\03_100_qry.cfm$QUERYBILLET

424.6

8.49

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm$VURL2

15.7

7.86

C:\sites\passeportvacances.com\www\inc\nav\filAriane.cfm$VURL2

7.68

0.001

0.448

7.23

C:\sites\passeportvacances.com\www\03_100_qry.cfm

661.1

7.18

C:\sites\passeportvacances.com\www\main.cfm$VURL2

6.76

C:\sites\passeportvacances.com\www\inc\billet\listeBillet.cfm$VURL2

3.33

0.003

2.34

0.987

C:\sites\passeportvacances.com\www\inc\module\big_box.cfm

1.73

0.005

0.123

1.6

C:\sites\passeportvacances.com\www\inc\module\evenement.cfm

1.22

C:\sites\passeportvacances.com\www\Application.cfc$onRequestEnd

1.14

0.005

0.407

0.733

C:\sites\passeportvacances.com\www\inc\module\leaderboard.cfm

30.2

0.687

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm$REPLACESITEVARS

53.8

0.625

C:\sites\passeportvacances.com\www\main.cfm$REPLACESITEVARS

1.12

0.564

C:\sites\passeportvacances.com\www\inc\nav\filAriane.cfm$REPLACESITEVARS

0.476

C:\sites\passeportvacances.com\www\inc\billet\listeBillet.cfm$REPLACESITEVARS

0.443

C:\sites\passeportvacances.com\www\03_100.cfm$HTMLSTRINGFORMAT

0.365

0.004

0.053

0.308

C:\sites\passeportvacances.com\www\inc\module\concours.cfm

0.364

0.004

0.36

C:\sites\passeportvacances.com\www\inc\billet\listeBillet.cfm

0.173

8.38

C:\sites\passeportvacances.com\www\Application.cfc

6.71

0.134

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm$PREPAREURLSTRING

0.112

C:\sites\passeportvacances.com\www\inc\billet\listeBillet.cfm$PREPAREURLSTRING

10.2

0.11

C:\sites\passeportvacances.com\www\main.cfm$PREPAREURLSTRING

0.192

0.096

C:\sites\passeportvacances.com\www\inc\nav\filAriane.cfm$PREPAREURLSTRING

0.089

C:\sites\passeportvacances.com\www\03_100.cfm$replaceAll

0.087

C:\sites\passeportvacances.com\www\Application.cfc$onRequestStart

0.066

0.007

0.059

C:\sites\passeportvacances.com\www\js\includeJs.cfm

0.056

C:\sites\passeportvacances.com\www\03_100.cfm$split

0.055

0.001

0.054

C:\sites\passeportvacances.com\www\inc\nav\filAriane.cfm

0.022

C:\sites\passeportvacances.com\www\Application.cfc$onSessionStart

0.488

0.014

C:\sites\passeportvacances.com\www\inc\module\editorial.cfm$COUPETEXTE

0.014

0.001

1160.6

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

0.013

C:\sites\passeportvacances.com\www\main.cfm$BALISESAFE

0.012

C:\sites\passeportvacances.com\www\partage\date1.cfc

0.01

C:\sites\passeportvacances.com\www\03_100.cfm$REMOVEHTML

0.009

C:\sites\passeportvacances.com\www\partage\date1.cfc$init

0.07

0.008

C:\sites\passeportvacances.com\www\main.cfm$ISDEF

0.01

0.002

37.6

C:\sites\passeportvacances.com\www\inc\fonction.cfm

0.008

0.003

0.005

C:\sites\passeportvacances.com\www\inc\billet\listeALaUne.cfm

0.004

C:\sites\passeportvacances.com\www\main.cfm$ISMOBILE

0.009

0.004

C:\lucee6\tomcat\lucee-server\context\components\org\lucee\cfml\Component.cfc

0.002

C:\sites\passeportvacances.com\www\Application.cfc$init

0.006

12.4

C:\sites\passeportvacances.com\www\main.cfm

0.005

3.16

C:\sites\passeportvacances.com\www\03_100.cfm

C:\sites\passeportvacances.com\www\Application.cfc$onRequest

Name

Open Connections

Max Connections

passeportvacances

100

passeportvacancesLogs

100

Name

Records

Time

Usage

Datasource

Source

Line

Cached

qrNm

0.838 ms

passeportvacances

C:\sites\passeportvacances.com\www\Application.cfc

488

SQL

Select region_id From region WITH (NOLOCK) Where (Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Nom_fr, ' ', '-'), '--', '-'), '--', '-'), '-', ' '), '''', ''), '&', ' '), ' ', ' '), ' ', ' ') = 'vieux montreal vieux port' or (Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Nom_fr, ' ', '-'), '--', '-'), '--', '-'), '-', ' '), '''', ''), '&', ' '), ' ', ' '), ' ', ' ') Collate SQL_Latin1_General_CP1253_CI_AI) = 'vieux montreal vieux port' ) and actif = 1

getAR

0.587 ms

passeportvacances

C:\sites\passeportvacances.com\www\Application.cfc

919

SQL

Select ar_id, region_id, suggestioncat_id From activityRegionPages WITH (NOLOCK) Where actif = 1 and (link_fr = 'quoi-faire-a-vieux-montreal-vieux-port' or link_en = 'quoi-faire-a-vieux-montreal-vieux-port')

getTops

0.345 ms

passeportvacances

C:\sites\passeportvacances.com\www\Application.cfc

930

SQL

Select top_id From tops WITH (NOLOCK) Where actif = 1 and (link_fr = 'quoi-faire-a-vieux-montreal-vieux-port' or link_en = 'quoi-faire-a-vieux-montreal-vieux-port')

getBlog

0.325 ms

passeportvacances

C:\sites\passeportvacances.com\www\Application.cfc

941

SQL

Select blog_id From blog WITH (NOLOCK) Where actif = 1 and (link_fr = 'quoi-faire-a-vieux-montreal-vieux-port' or link_en = 'quoi-faire-a-vieux-montreal-vieux-port')

getEcomBillet

5.25 ms

passeportvacances

C:\sites\passeportvacances.com\www\Application.cfc

952

SQL

Select billet_id From billet WITH (NOLOCK) Where actif = 1 and (link_fr = 'quoi-faire-a-vieux-montreal-vieux-port' or link_en = 'quoi-faire-a-vieux-montreal-vieux-port')

local.dataQuery

5.88 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\fonction.cfm

234

SQL (Merged Parameters)

WITH Billets AS ( SELECT TOP 4 BILLET.BILLET_ID, BILLET.Titre_fr, BILLET.Titre_en, BILLET.titre_fr as BilletTitre, BILLET.Intro_fr as BILLETIntro , BILLET.Descr_fr as BilletDescription, BILLET.PhotoActive, BILLET.PosX, BILLET.PosY, BILLET.RefDescription_fr as RefDescription , BILLET.RefMotsCles_fr as RefMotsCles, BILLET.Direction_fr as Direction, BILLET.Hyperlien_fr as Hyperlien , Billet.Adresse, Billet.FicheProduit, Billet.Coupon_ID, Billet.ActifFicheDetail, BILLET.YoutubeId_fr AS BilletYoutubeID, youtubePoz , Billet.codeSTM_fr AS BilletCodeSTM, Billet.DateDebut, Billet.FicheGratuite , b.ActifAccueil, b.ActifAccueilPrioritaire, b.Surbrillance, b.BANDEAUTYPE_ID, b.PrioritaireRegion, b.PrioritaireCat , CASE WHEN Billet.FicheProduit = 1 THEN CouponFicheProduit.Rabais ELSE CouponFicheEditoriale.Rabais END as Rabais , 0 as Distance , bt.nom_en as bnom_en, bt.nom_fr as bnom_fr, bt.color as bColor , billet.ecomActif, billet.regularPrice, billet.discountPrice, billet.ecomLinkEN, billet.ecomLinkFR, billet.ecomButFR, billet.ecomButEN, billet.bypass , client.titre_fr as clientName, billet.showRegisterButton, billet.fbLink, billet.instaLink, billet.ytLink, billet.isECom , billet.whatGet_fr as whatGet, billet.details_fr as details , billet.link_fr as linkPage FROM Billet Left Outer Join BANDEAUTYPE bt On Billet.BANDEAUTYPE_ID = bt.BANDEAUTYPE_ID Left Outer Join client On client.client_ID = billet.client_id LEFT JOIN dbo.viewCoupon CouponFicheEditoriale ON CouponFicheEditoriale.Coupon_ID = ISNULL(Billet.Coupon_ID,0) OUTER APPLY ( SELECT ISNULL(SUM(Rabais),0) FROM dbo.viewCoupon Coupon INNER JOIN BILLETjctCOUPON ON BILLETjctCOUPON.BILLET_ID = BILLET.BILLET_ID AND BILLETjctCOUPON.COUPON_ID = COUPON.COUPON_ID ) CouponFicheProduit (Rabais) OUTER APPLY ( SELECT CASE WHEN ( b1.ActifAccueil = 1 AND (b1.ActifAccueilDateDebut <= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.ActifAccueilDateFin >= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as ActifAccueil, CASE WHEN ( b1.ActifAccueilPrioritaire = 1 AND (b1.ActifAccueilPrioritaireDateDebut <= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilPrioritaireDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.ActifAccueilPrioritaireDateFin >= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilPrioritaireDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as ActifAccueilPrioritaire, CASE WHEN ( b1.Surbrillance = 1 AND (b1.SurbrillanceDateDebut <= CAST(getDate() as date) OR ISNULL(b1.SurbrillanceDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.SurbrillanceDateFin >= CAST(getDate() as date) OR ISNULL(b1.SurbrillanceDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as Surbrillance, CASE WHEN ( b1.BANDEAUTYPE_ID > 0 AND (b1.BandeauDateDebut <= CAST(getDate() as date) OR ISNULL(b1.BandeauDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.BandeauDateFin >= CAST(getDate() as date) OR ISNULL(b1.BandeauDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN BANDEAUTYPE_ID ELSE 0 END as BANDEAUTYPE_ID, CASE WHEN ( b1.PrioritaireRegion = 1 AND (b1.PrioritaireRegionDateDebut <= CAST(getDate() as date) OR ISNULL(b1.PrioritaireRegionDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.PrioritaireRegionDateFin >= CAST(getDate() as date) OR ISNULL(b1.PrioritaireRegionDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as PrioritaireRegion, CASE WHEN ( b1.PrioritaireCat = 1 AND (b1.PrioritaireCatDateDebut <= CAST(getDate() as date) OR ISNULL(b1.PrioritaireCatDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.PrioritaireCatDateFin >= CAST(getDate() as date) OR ISNULL(b1.PrioritaireCatDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as PrioritaireCat FROM Billet b1 WHERE Billet_ID = Billet.Billet_ID ) b WHERE 1 = 1 and (billet.Actif = 1) AND (billet.FicheInfolettre = 0) AND (billet.DateDebut <= GETDATE()) AND (billet.DateFin >= GETDATE()) AND ( b.PrioritaireRegion = 1 ) AND EXISTS( SELECT 1 FROM BilletjctRegion WHERE BilletjctRegion.Billet_ID = Billet.Billet_ID AND BilletjctRegion.Region_ID = 32 ) ) SELECT Billets.*, REGION.ListeRegion, BILLETCAT.ListeBilletCat, Theme.ListeTheme, Lodg.ListeLodg, CASE WHEN (Billets.FicheGratuite = 0 and Billets.FicheProduit = 1) THEN 0 WHEN (Billets.FicheGratuite = 0) THEN 1 ELSE 2 END as newBilletOrder, CASE WHEN Billets.FicheGratuite = 1 THEN 2 WHEN Billets.Rabais > 0 AND Billets.FicheGratuite = 0 THEN 0 ELSE 1 END as OrdreBillet, CASE WHEN Billets.ActifAccueilPrioritaire = 1 THEN 0 ELSE 1 END as OrdreAccueil, CASE WHEN Billets.PrioritaireRegion = 1 AND Billets.PrioritaireCat = 1 THEN 0 WHEN Billets.PrioritaireRegion = 1 THEN 1 WHEN Billets.PrioritaireCat = 1 THEN 2 ELSE 3 END as OrdreALaUne , bt.nom_en as bnom_en, bt.nom_fr as bnom_fr, bt.color as bColor FROM Billets Left Outer Join BANDEAUTYPE bt On Billets.BANDEAUTYPE_ID = bt.BANDEAUTYPE_ID OUTER APPLY ( SELECT CAST(SuggestionLodging.SuggestionLodg_ID as varchar) + ',' FROM SuggestionLodging INNER JOIN BILLETjctSUGGESTIONLodging ON BILLETjctSUGGESTIONLodging.SuggestionLodg_ID = SuggestionLodging.SuggestionLodg_ID WHERE SuggestionLodging.Actif = 1 AND BILLETjctSUGGESTIONLodging.BILLET_ID = Billets.BILLET_ID ORDER BY Ordre FOR XML PATH ('') ) Lodg (ListeLodg) OUTER APPLY ( SELECT CAST(SuggestionCat.SuggestionCat_ID as varchar) + ',' FROM SuggestionCat INNER JOIN BILLETjctSUGGESTIONCAT ON BILLETjctSUGGESTIONCAT.SuggestionCat_ID = SuggestionCat.SuggestionCat_ID WHERE SuggestionCat.Actif = 1 AND BILLETjctSUGGESTIONCAT.BILLET_ID = Billets.BILLET_ID ORDER BY Ordre FOR XML PATH ('') ) Theme (ListeTheme) OUTER APPLY ( SELECT CAST(REGION.REGION_ID as varchar) + ',' FROM REGION INNER JOIN BILLETjctREGION ON BILLETjctREGION.REGION_ID = REGION.REGION_ID WHERE REGION.Actif = 1 AND BILLETjctREGION.BILLET_ID = Billets.BILLET_ID ORDER BY REGION.Ordre FOR XML PATH ('') ) REGION (ListeRegion) OUTER APPLY ( SELECT CAST(BILLETCAT.BILLETCAT_ID as varchar) + ',' FROM BILLETCAT INNER JOIN BILLETjctBILLETCAT ON BILLETjctBILLETCAT.BILLETCAT_ID = BILLETCAT.BILLETCAT_ID WHERE BILLETCAT.Actif = 1 AND BILLETjctBILLETCAT.BILLET_ID = Billets.BILLET_ID ORDER BY BILLETCAT.Ordre FOR XML PATH ('') ) BILLETCAT (ListeBilletCat) ORDER BY newBilletOrder, OrdreALaUne , NEWID()

SQL (Explicit Parameters)

WITH Billets AS ( SELECT TOP 4 BILLET.BILLET_ID, BILLET.Titre_fr, BILLET.Titre_en, BILLET.titre_fr as BilletTitre, BILLET.Intro_fr as BILLETIntro , BILLET.Descr_fr as BilletDescription, BILLET.PhotoActive, BILLET.PosX, BILLET.PosY, BILLET.RefDescription_fr as RefDescription , BILLET.RefMotsCles_fr as RefMotsCles, BILLET.Direction_fr as Direction, BILLET.Hyperlien_fr as Hyperlien , Billet.Adresse, Billet.FicheProduit, Billet.Coupon_ID, Billet.ActifFicheDetail, BILLET.YoutubeId_fr AS BilletYoutubeID, youtubePoz , Billet.codeSTM_fr AS BilletCodeSTM, Billet.DateDebut, Billet.FicheGratuite , b.ActifAccueil, b.ActifAccueilPrioritaire, b.Surbrillance, b.BANDEAUTYPE_ID, b.PrioritaireRegion, b.PrioritaireCat , CASE WHEN Billet.FicheProduit = 1 THEN CouponFicheProduit.Rabais ELSE CouponFicheEditoriale.Rabais END as Rabais , 0 as Distance , bt.nom_en as bnom_en, bt.nom_fr as bnom_fr, bt.color as bColor , billet.ecomActif, billet.regularPrice, billet.discountPrice, billet.ecomLinkEN, billet.ecomLinkFR, billet.ecomButFR, billet.ecomButEN, billet.bypass , client.titre_fr as clientName, billet.showRegisterButton, billet.fbLink, billet.instaLink, billet.ytLink, billet.isECom , billet.whatGet_fr as whatGet, billet.details_fr as details , billet.link_fr as linkPage FROM Billet Left Outer Join BANDEAUTYPE bt On Billet.BANDEAUTYPE_ID = bt.BANDEAUTYPE_ID Left Outer Join client On client.client_ID = billet.client_id LEFT JOIN dbo.viewCoupon CouponFicheEditoriale ON CouponFicheEditoriale.Coupon_ID = ISNULL(Billet.Coupon_ID,0) OUTER APPLY ( SELECT ISNULL(SUM(Rabais),0) FROM dbo.viewCoupon Coupon INNER JOIN BILLETjctCOUPON ON BILLETjctCOUPON.BILLET_ID = BILLET.BILLET_ID AND BILLETjctCOUPON.COUPON_ID = COUPON.COUPON_ID ) CouponFicheProduit (Rabais) OUTER APPLY ( SELECT CASE WHEN ( b1.ActifAccueil = 1 AND (b1.ActifAccueilDateDebut <= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.ActifAccueilDateFin >= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as ActifAccueil, CASE WHEN ( b1.ActifAccueilPrioritaire = 1 AND (b1.ActifAccueilPrioritaireDateDebut <= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilPrioritaireDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.ActifAccueilPrioritaireDateFin >= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilPrioritaireDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as ActifAccueilPrioritaire, CASE WHEN ( b1.Surbrillance = 1 AND (b1.SurbrillanceDateDebut <= CAST(getDate() as date) OR ISNULL(b1.SurbrillanceDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.SurbrillanceDateFin >= CAST(getDate() as date) OR ISNULL(b1.SurbrillanceDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as Surbrillance, CASE WHEN ( b1.BANDEAUTYPE_ID > 0 AND (b1.BandeauDateDebut <= CAST(getDate() as date) OR ISNULL(b1.BandeauDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.BandeauDateFin >= CAST(getDate() as date) OR ISNULL(b1.BandeauDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN BANDEAUTYPE_ID ELSE 0 END as BANDEAUTYPE_ID, CASE WHEN ( b1.PrioritaireRegion = 1 AND (b1.PrioritaireRegionDateDebut <= CAST(getDate() as date) OR ISNULL(b1.PrioritaireRegionDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.PrioritaireRegionDateFin >= CAST(getDate() as date) OR ISNULL(b1.PrioritaireRegionDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as PrioritaireRegion, CASE WHEN ( b1.PrioritaireCat = 1 AND (b1.PrioritaireCatDateDebut <= CAST(getDate() as date) OR ISNULL(b1.PrioritaireCatDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.PrioritaireCatDateFin >= CAST(getDate() as date) OR ISNULL(b1.PrioritaireCatDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as PrioritaireCat FROM Billet b1 WHERE Billet_ID = Billet.Billet_ID ) b WHERE 1 = 1 and (billet.Actif = 1) AND (billet.FicheInfolettre = 0) AND (billet.DateDebut <= GETDATE()) AND (billet.DateFin >= GETDATE()) AND ( b.PrioritaireRegion = 1 ) AND EXISTS( SELECT 1 FROM BilletjctRegion WHERE BilletjctRegion.Billet_ID = Billet.Billet_ID AND BilletjctRegion.Region_ID = {type: "CF_SQL_INTEGER", value: 32} ) ) SELECT Billets.*, REGION.ListeRegion, BILLETCAT.ListeBilletCat, Theme.ListeTheme, Lodg.ListeLodg, CASE WHEN (Billets.FicheGratuite = 0 and Billets.FicheProduit = 1) THEN 0 WHEN (Billets.FicheGratuite = 0) THEN 1 ELSE 2 END as newBilletOrder, CASE WHEN Billets.FicheGratuite = 1 THEN 2 WHEN Billets.Rabais > 0 AND Billets.FicheGratuite = 0 THEN 0 ELSE 1 END as OrdreBillet, CASE WHEN Billets.ActifAccueilPrioritaire = 1 THEN 0 ELSE 1 END as OrdreAccueil, CASE WHEN Billets.PrioritaireRegion = 1 AND Billets.PrioritaireCat = 1 THEN 0 WHEN Billets.PrioritaireRegion = 1 THEN 1 WHEN Billets.PrioritaireCat = 1 THEN 2 ELSE 3 END as OrdreALaUne , bt.nom_en as bnom_en, bt.nom_fr as bnom_fr, bt.color as bColor FROM Billets Left Outer Join BANDEAUTYPE bt On Billets.BANDEAUTYPE_ID = bt.BANDEAUTYPE_ID OUTER APPLY ( SELECT CAST(SuggestionLodging.SuggestionLodg_ID as varchar) + ',' FROM SuggestionLodging INNER JOIN BILLETjctSUGGESTIONLodging ON BILLETjctSUGGESTIONLodging.SuggestionLodg_ID = SuggestionLodging.SuggestionLodg_ID WHERE SuggestionLodging.Actif = 1 AND BILLETjctSUGGESTIONLodging.BILLET_ID = Billets.BILLET_ID ORDER BY Ordre FOR XML PATH ('') ) Lodg (ListeLodg) OUTER APPLY ( SELECT CAST(SuggestionCat.SuggestionCat_ID as varchar) + ',' FROM SuggestionCat INNER JOIN BILLETjctSUGGESTIONCAT ON BILLETjctSUGGESTIONCAT.SuggestionCat_ID = SuggestionCat.SuggestionCat_ID WHERE SuggestionCat.Actif = 1 AND BILLETjctSUGGESTIONCAT.BILLET_ID = Billets.BILLET_ID ORDER BY Ordre FOR XML PATH ('') ) Theme (ListeTheme) OUTER APPLY ( SELECT CAST(REGION.REGION_ID as varchar) + ',' FROM REGION INNER JOIN BILLETjctREGION ON BILLETjctREGION.REGION_ID = REGION.REGION_ID WHERE REGION.Actif = 1 AND BILLETjctREGION.BILLET_ID = Billets.BILLET_ID ORDER BY REGION.Ordre FOR XML PATH ('') ) REGION (ListeRegion) OUTER APPLY ( SELECT CAST(BILLETCAT.BILLETCAT_ID as varchar) + ',' FROM BILLETCAT INNER JOIN BILLETjctBILLETCAT ON BILLETjctBILLETCAT.BILLETCAT_ID = BILLETCAT.BILLETCAT_ID WHERE BILLETCAT.Actif = 1 AND BILLETjctBILLETCAT.BILLET_ID = Billets.BILLET_ID ORDER BY BILLETCAT.Ordre FOR XML PATH ('') ) BILLETCAT (ListeBilletCat) ORDER BY newBilletOrder, OrdreALaUne , NEWID()

local.dataQuery

15.3 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\fonction.cfm

234

SQL (Merged Parameters)

WITH Billets AS ( SELECT BILLET.BILLET_ID, BILLET.Titre_fr, BILLET.Titre_en, BILLET.titre_fr as BilletTitre, BILLET.Intro_fr as BILLETIntro , BILLET.Descr_fr as BilletDescription, BILLET.PhotoActive, BILLET.PosX, BILLET.PosY, BILLET.RefDescription_fr as RefDescription , BILLET.RefMotsCles_fr as RefMotsCles, BILLET.Direction_fr as Direction, BILLET.Hyperlien_fr as Hyperlien , Billet.Adresse, Billet.FicheProduit, Billet.Coupon_ID, Billet.ActifFicheDetail, BILLET.YoutubeId_fr AS BilletYoutubeID, youtubePoz , Billet.codeSTM_fr AS BilletCodeSTM, Billet.DateDebut, Billet.FicheGratuite , b.ActifAccueil, b.ActifAccueilPrioritaire, b.Surbrillance, b.BANDEAUTYPE_ID, b.PrioritaireRegion, b.PrioritaireCat , CASE WHEN Billet.FicheProduit = 1 THEN CouponFicheProduit.Rabais ELSE CouponFicheEditoriale.Rabais END as Rabais , 0 as Distance , bt.nom_en as bnom_en, bt.nom_fr as bnom_fr, bt.color as bColor , billet.ecomActif, billet.regularPrice, billet.discountPrice, billet.ecomLinkEN, billet.ecomLinkFR, billet.ecomButFR, billet.ecomButEN, billet.bypass , client.titre_fr as clientName, billet.showRegisterButton, billet.fbLink, billet.instaLink, billet.ytLink, billet.isECom , billet.whatGet_fr as whatGet, billet.details_fr as details , billet.link_fr as linkPage FROM Billet Left Outer Join BANDEAUTYPE bt On Billet.BANDEAUTYPE_ID = bt.BANDEAUTYPE_ID Left Outer Join client On client.client_ID = billet.client_id LEFT JOIN dbo.viewCoupon CouponFicheEditoriale ON CouponFicheEditoriale.Coupon_ID = ISNULL(Billet.Coupon_ID,0) OUTER APPLY ( SELECT ISNULL(SUM(Rabais),0) FROM dbo.viewCoupon Coupon INNER JOIN BILLETjctCOUPON ON BILLETjctCOUPON.BILLET_ID = BILLET.BILLET_ID AND BILLETjctCOUPON.COUPON_ID = COUPON.COUPON_ID ) CouponFicheProduit (Rabais) OUTER APPLY ( SELECT CASE WHEN ( b1.ActifAccueil = 1 AND (b1.ActifAccueilDateDebut <= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.ActifAccueilDateFin >= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as ActifAccueil, CASE WHEN ( b1.ActifAccueilPrioritaire = 1 AND (b1.ActifAccueilPrioritaireDateDebut <= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilPrioritaireDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.ActifAccueilPrioritaireDateFin >= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilPrioritaireDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as ActifAccueilPrioritaire, CASE WHEN ( b1.Surbrillance = 1 AND (b1.SurbrillanceDateDebut <= CAST(getDate() as date) OR ISNULL(b1.SurbrillanceDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.SurbrillanceDateFin >= CAST(getDate() as date) OR ISNULL(b1.SurbrillanceDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as Surbrillance, CASE WHEN ( b1.BANDEAUTYPE_ID > 0 AND (b1.BandeauDateDebut <= CAST(getDate() as date) OR ISNULL(b1.BandeauDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.BandeauDateFin >= CAST(getDate() as date) OR ISNULL(b1.BandeauDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN BANDEAUTYPE_ID ELSE 0 END as BANDEAUTYPE_ID, CASE WHEN ( b1.PrioritaireRegion = 1 AND (b1.PrioritaireRegionDateDebut <= CAST(getDate() as date) OR ISNULL(b1.PrioritaireRegionDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.PrioritaireRegionDateFin >= CAST(getDate() as date) OR ISNULL(b1.PrioritaireRegionDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as PrioritaireRegion, CASE WHEN ( b1.PrioritaireCat = 1 AND (b1.PrioritaireCatDateDebut <= CAST(getDate() as date) OR ISNULL(b1.PrioritaireCatDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.PrioritaireCatDateFin >= CAST(getDate() as date) OR ISNULL(b1.PrioritaireCatDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as PrioritaireCat FROM Billet b1 WHERE Billet_ID = Billet.Billet_ID ) b WHERE 1 = 1 and (billet.Actif = 1) AND (billet.FicheInfolettre = 0) AND (billet.DateDebut <= GETDATE()) AND (billet.DateFin >= GETDATE()) AND Billet.FicheProduit = 1 AND EXISTS( SELECT 1 FROM BilletjctRegion WHERE BilletjctRegion.Billet_ID = Billet.Billet_ID AND BilletjctRegion.Region_ID = 32 ) ) SELECT Billets.*, REGION.ListeRegion, BILLETCAT.ListeBilletCat, Theme.ListeTheme, Lodg.ListeLodg, CASE WHEN (Billets.FicheGratuite = 0 and Billets.FicheProduit = 1) THEN 0 WHEN (Billets.FicheGratuite = 0) THEN 1 ELSE 2 END as newBilletOrder, CASE WHEN Billets.FicheGratuite = 1 THEN 2 WHEN Billets.Rabais > 0 AND Billets.FicheGratuite = 0 THEN 0 ELSE 1 END as OrdreBillet, CASE WHEN Billets.ActifAccueilPrioritaire = 1 THEN 0 ELSE 1 END as OrdreAccueil, CASE WHEN Billets.PrioritaireRegion = 1 AND Billets.PrioritaireCat = 1 THEN 0 WHEN Billets.PrioritaireRegion = 1 THEN 1 WHEN Billets.PrioritaireCat = 1 THEN 2 ELSE 3 END as OrdreALaUne , bt.nom_en as bnom_en, bt.nom_fr as bnom_fr, bt.color as bColor FROM Billets Left Outer Join BANDEAUTYPE bt On Billets.BANDEAUTYPE_ID = bt.BANDEAUTYPE_ID OUTER APPLY ( SELECT CAST(SuggestionLodging.SuggestionLodg_ID as varchar) + ',' FROM SuggestionLodging INNER JOIN BILLETjctSUGGESTIONLodging ON BILLETjctSUGGESTIONLodging.SuggestionLodg_ID = SuggestionLodging.SuggestionLodg_ID WHERE SuggestionLodging.Actif = 1 AND BILLETjctSUGGESTIONLodging.BILLET_ID = Billets.BILLET_ID ORDER BY Ordre FOR XML PATH ('') ) Lodg (ListeLodg) OUTER APPLY ( SELECT CAST(SuggestionCat.SuggestionCat_ID as varchar) + ',' FROM SuggestionCat INNER JOIN BILLETjctSUGGESTIONCAT ON BILLETjctSUGGESTIONCAT.SuggestionCat_ID = SuggestionCat.SuggestionCat_ID WHERE SuggestionCat.Actif = 1 AND BILLETjctSUGGESTIONCAT.BILLET_ID = Billets.BILLET_ID ORDER BY Ordre FOR XML PATH ('') ) Theme (ListeTheme) OUTER APPLY ( SELECT CAST(REGION.REGION_ID as varchar) + ',' FROM REGION INNER JOIN BILLETjctREGION ON BILLETjctREGION.REGION_ID = REGION.REGION_ID WHERE REGION.Actif = 1 AND BILLETjctREGION.BILLET_ID = Billets.BILLET_ID ORDER BY REGION.Ordre FOR XML PATH ('') ) REGION (ListeRegion) OUTER APPLY ( SELECT CAST(BILLETCAT.BILLETCAT_ID as varchar) + ',' FROM BILLETCAT INNER JOIN BILLETjctBILLETCAT ON BILLETjctBILLETCAT.BILLETCAT_ID = BILLETCAT.BILLETCAT_ID WHERE BILLETCAT.Actif = 1 AND BILLETjctBILLETCAT.BILLET_ID = Billets.BILLET_ID ORDER BY BILLETCAT.Ordre FOR XML PATH ('') ) BILLETCAT (ListeBilletCat) ORDER BY newBilletOrder

SQL (Explicit Parameters)

WITH Billets AS ( SELECT BILLET.BILLET_ID, BILLET.Titre_fr, BILLET.Titre_en, BILLET.titre_fr as BilletTitre, BILLET.Intro_fr as BILLETIntro , BILLET.Descr_fr as BilletDescription, BILLET.PhotoActive, BILLET.PosX, BILLET.PosY, BILLET.RefDescription_fr as RefDescription , BILLET.RefMotsCles_fr as RefMotsCles, BILLET.Direction_fr as Direction, BILLET.Hyperlien_fr as Hyperlien , Billet.Adresse, Billet.FicheProduit, Billet.Coupon_ID, Billet.ActifFicheDetail, BILLET.YoutubeId_fr AS BilletYoutubeID, youtubePoz , Billet.codeSTM_fr AS BilletCodeSTM, Billet.DateDebut, Billet.FicheGratuite , b.ActifAccueil, b.ActifAccueilPrioritaire, b.Surbrillance, b.BANDEAUTYPE_ID, b.PrioritaireRegion, b.PrioritaireCat , CASE WHEN Billet.FicheProduit = 1 THEN CouponFicheProduit.Rabais ELSE CouponFicheEditoriale.Rabais END as Rabais , 0 as Distance , bt.nom_en as bnom_en, bt.nom_fr as bnom_fr, bt.color as bColor , billet.ecomActif, billet.regularPrice, billet.discountPrice, billet.ecomLinkEN, billet.ecomLinkFR, billet.ecomButFR, billet.ecomButEN, billet.bypass , client.titre_fr as clientName, billet.showRegisterButton, billet.fbLink, billet.instaLink, billet.ytLink, billet.isECom , billet.whatGet_fr as whatGet, billet.details_fr as details , billet.link_fr as linkPage FROM Billet Left Outer Join BANDEAUTYPE bt On Billet.BANDEAUTYPE_ID = bt.BANDEAUTYPE_ID Left Outer Join client On client.client_ID = billet.client_id LEFT JOIN dbo.viewCoupon CouponFicheEditoriale ON CouponFicheEditoriale.Coupon_ID = ISNULL(Billet.Coupon_ID,0) OUTER APPLY ( SELECT ISNULL(SUM(Rabais),0) FROM dbo.viewCoupon Coupon INNER JOIN BILLETjctCOUPON ON BILLETjctCOUPON.BILLET_ID = BILLET.BILLET_ID AND BILLETjctCOUPON.COUPON_ID = COUPON.COUPON_ID ) CouponFicheProduit (Rabais) OUTER APPLY ( SELECT CASE WHEN ( b1.ActifAccueil = 1 AND (b1.ActifAccueilDateDebut <= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.ActifAccueilDateFin >= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as ActifAccueil, CASE WHEN ( b1.ActifAccueilPrioritaire = 1 AND (b1.ActifAccueilPrioritaireDateDebut <= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilPrioritaireDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.ActifAccueilPrioritaireDateFin >= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilPrioritaireDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as ActifAccueilPrioritaire, CASE WHEN ( b1.Surbrillance = 1 AND (b1.SurbrillanceDateDebut <= CAST(getDate() as date) OR ISNULL(b1.SurbrillanceDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.SurbrillanceDateFin >= CAST(getDate() as date) OR ISNULL(b1.SurbrillanceDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as Surbrillance, CASE WHEN ( b1.BANDEAUTYPE_ID > 0 AND (b1.BandeauDateDebut <= CAST(getDate() as date) OR ISNULL(b1.BandeauDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.BandeauDateFin >= CAST(getDate() as date) OR ISNULL(b1.BandeauDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN BANDEAUTYPE_ID ELSE 0 END as BANDEAUTYPE_ID, CASE WHEN ( b1.PrioritaireRegion = 1 AND (b1.PrioritaireRegionDateDebut <= CAST(getDate() as date) OR ISNULL(b1.PrioritaireRegionDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.PrioritaireRegionDateFin >= CAST(getDate() as date) OR ISNULL(b1.PrioritaireRegionDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as PrioritaireRegion, CASE WHEN ( b1.PrioritaireCat = 1 AND (b1.PrioritaireCatDateDebut <= CAST(getDate() as date) OR ISNULL(b1.PrioritaireCatDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.PrioritaireCatDateFin >= CAST(getDate() as date) OR ISNULL(b1.PrioritaireCatDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as PrioritaireCat FROM Billet b1 WHERE Billet_ID = Billet.Billet_ID ) b WHERE 1 = 1 and (billet.Actif = 1) AND (billet.FicheInfolettre = 0) AND (billet.DateDebut <= GETDATE()) AND (billet.DateFin >= GETDATE()) AND Billet.FicheProduit = {type: "CF_SQL_INTEGER", value: 1} AND EXISTS( SELECT 1 FROM BilletjctRegion WHERE BilletjctRegion.Billet_ID = Billet.Billet_ID AND BilletjctRegion.Region_ID = {type: "CF_SQL_INTEGER", value: 32} ) ) SELECT Billets.*, REGION.ListeRegion, BILLETCAT.ListeBilletCat, Theme.ListeTheme, Lodg.ListeLodg, CASE WHEN (Billets.FicheGratuite = 0 and Billets.FicheProduit = 1) THEN 0 WHEN (Billets.FicheGratuite = 0) THEN 1 ELSE 2 END as newBilletOrder, CASE WHEN Billets.FicheGratuite = 1 THEN 2 WHEN Billets.Rabais > 0 AND Billets.FicheGratuite = 0 THEN 0 ELSE 1 END as OrdreBillet, CASE WHEN Billets.ActifAccueilPrioritaire = 1 THEN 0 ELSE 1 END as OrdreAccueil, CASE WHEN Billets.PrioritaireRegion = 1 AND Billets.PrioritaireCat = 1 THEN 0 WHEN Billets.PrioritaireRegion = 1 THEN 1 WHEN Billets.PrioritaireCat = 1 THEN 2 ELSE 3 END as OrdreALaUne , bt.nom_en as bnom_en, bt.nom_fr as bnom_fr, bt.color as bColor FROM Billets Left Outer Join BANDEAUTYPE bt On Billets.BANDEAUTYPE_ID = bt.BANDEAUTYPE_ID OUTER APPLY ( SELECT CAST(SuggestionLodging.SuggestionLodg_ID as varchar) + ',' FROM SuggestionLodging INNER JOIN BILLETjctSUGGESTIONLodging ON BILLETjctSUGGESTIONLodging.SuggestionLodg_ID = SuggestionLodging.SuggestionLodg_ID WHERE SuggestionLodging.Actif = 1 AND BILLETjctSUGGESTIONLodging.BILLET_ID = Billets.BILLET_ID ORDER BY Ordre FOR XML PATH ('') ) Lodg (ListeLodg) OUTER APPLY ( SELECT CAST(SuggestionCat.SuggestionCat_ID as varchar) + ',' FROM SuggestionCat INNER JOIN BILLETjctSUGGESTIONCAT ON BILLETjctSUGGESTIONCAT.SuggestionCat_ID = SuggestionCat.SuggestionCat_ID WHERE SuggestionCat.Actif = 1 AND BILLETjctSUGGESTIONCAT.BILLET_ID = Billets.BILLET_ID ORDER BY Ordre FOR XML PATH ('') ) Theme (ListeTheme) OUTER APPLY ( SELECT CAST(REGION.REGION_ID as varchar) + ',' FROM REGION INNER JOIN BILLETjctREGION ON BILLETjctREGION.REGION_ID = REGION.REGION_ID WHERE REGION.Actif = 1 AND BILLETjctREGION.BILLET_ID = Billets.BILLET_ID ORDER BY REGION.Ordre FOR XML PATH ('') ) REGION (ListeRegion) OUTER APPLY ( SELECT CAST(BILLETCAT.BILLETCAT_ID as varchar) + ',' FROM BILLETCAT INNER JOIN BILLETjctBILLETCAT ON BILLETjctBILLETCAT.BILLETCAT_ID = BILLETCAT.BILLETCAT_ID WHERE BILLETCAT.Actif = 1 AND BILLETjctBILLETCAT.BILLET_ID = Billets.BILLET_ID ORDER BY BILLETCAT.Ordre FOR XML PATH ('') ) BILLETCAT (ListeBilletCat) ORDER BY newBilletOrder

rechTotalRabais

0.238 ms

C:\sites\passeportvacances.com\www\03_100_qry.cfm

SQL

SELECT SUM(Rabais) as TotalRabais FROM rechBillet

rechRegionDetail

0.52 ms

passeportvacances

C:\sites\passeportvacances.com\www\03_100_qry.cfm

SQL (Merged Parameters)

SELECT Region_ID, Region_ID_PARENT, Nom_fr, Nom_en, Nom_fr as RegionNom, Titre_fr as RegionTitre, SousTitre_fr as RegionSousTitre, Descr_fr as RegionDescr, Coordonnees, PhotoActive_fr as PhotoActive, extensionsImg, Lien_fr as RegionLien FROM Region WHERE Region_ID = 32 ORDER BY Nom_fr

SQL (Explicit Parameters)

rechRegionParent

0.394 ms

passeportvacances

C:\sites\passeportvacances.com\www\03_100_qry.cfm

SQL (Merged Parameters)

SELECT Region_ID, Nom_fr as RegionNom FROM Region WHERE Region_ID = 22

SQL (Explicit Parameters)

SELECT Region_ID, Nom_fr as RegionNom FROM Region WHERE Region_ID = {type: "CF_SQL_INTEGER", value: 22}

rechSousRegion

0.407 ms

passeportvacances

C:\sites\passeportvacances.com\www\03_100_qry.cfm

SQL (Merged Parameters)

SELECT Region_ID, Nom_fr as RegionNom FROM Region WHERE Region_ID_PARENT = 32 and Region.Actif = 1 ORDER BY Nom_fr

SQL (Explicit Parameters)

SELECT Region_ID, Nom_fr as RegionNom FROM Region WHERE Region_ID_PARENT = {type: "CF_SQL_INTEGER", value: 32} and Region.Actif = 1 ORDER BY Nom_fr

rechBanniere

5.66 ms

passeportvacances

C:\sites\passeportvacances.com\www\03_100_qry.cfm

SQL (Merged Parameters)

SELECT Photo.Photo_ID, Photo.Nom_fr AS BanniereTitre, Photo.Descr_fr AS BanniereDescription , Photo.Copyright_fr as Copyright, Url_fr AS PhotoUrl, UrlExterne_fr AS PhotoUrlExterne , rabais FROM Photo WHERE Photo.Region_ID = 32 AND Photo.Actif = 1 AND (IsNull(DateDebut, '') = '' OR DateDebut <= GetDate()) AND (IsNull(DateFin, '') = '' OR GetDate() <= DateFin) ORDER BY Photo.Ordre

SQL (Explicit Parameters)

SELECT Photo.Photo_ID, Photo.Nom_fr AS BanniereTitre, Photo.Descr_fr AS BanniereDescription , Photo.Copyright_fr as Copyright, Url_fr AS PhotoUrl, UrlExterne_fr AS PhotoUrlExterne , rabais FROM Photo WHERE Photo.Region_ID = {type: "CF_SQL_INTEGER", value: 32} AND Photo.Actif = 1 AND (IsNull(DateDebut, '') = '' OR DateDebut <= GetDate()) AND (IsNull(DateFin, '') = '' OR GetDate() <= DateFin) ORDER BY Photo.Ordre

getSEO

0.356 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

152

SQL

Select RefDescription_fr as RefDescription, RefMotsCles_fr as RefMotsCles, RefTitre_fr as refTitre From region WITH (NOLOCK) Where region_id = 32

getEcomBillet

7.42 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.291 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 32

getNM

0.432 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

6.82 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.327 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 32

getNM

0.403 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

7.05 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.365 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

rechRegionMenu

0.75 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

612

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT IS NULL ORDER BY Nom_fr

rechThemeMenu

0.719 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

618

SQL

SELECT SuggestionCat_ID, TitreMenu_fr as ThemeNomMenu, Titre_fr as ThemeNom FROM SuggestionCat WITH (NOLOCK) WHERE Actif = 1 ORDER BY Titre_fr

rechLodgingMenu

0.627 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

624

SQL

SELECT SuggestionLODG_ID, TitreMenu_fr as ThemeNomLogMenu, Titre_fr as ThemeNomLog FROM SuggestionLodging WITH (NOLOCK) WHERE Actif = 1 ORDER BY Titre_fr

getEcomBillet

6.8 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.425 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

7.1 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletLodg

0.384 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 4

getEcomBillet

6.91 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletLodg

0.313 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 5

getEcomBillet

7.06 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletLodg

0.33 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 2

getEcomBillet

6.82 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletLodg

0.409 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 3

getEcomBillet

8.27 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletLodg

0.342 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 1

getEcomBillet

7.73 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletLodg

0.333 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 6

getEcomBillet

7 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.287 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 39

getNM

0.325 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'1000 Îles et région' or nom_fr = N'1000 Îles et région'

rechSubRegionMenu

0.557 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 39 ORDER BY Nom_fr

getEcomBillet

7.16 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.291 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 10

getNM

0.363 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Abitibi-Témiscamingue' or nom_fr = N'Abitibi-Témiscamingue'

rechSubRegionMenu

0.631 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 10 ORDER BY Nom_fr

getEcomBillet

7.72 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.353 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 46

getNM

0.37 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'La Vallée-de-l''Or' or nom_fr = N'La Vallée-de-l''Or'

getEcomBillet

6.94 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.282 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 19

getNM

0.383 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Cantons-de-l''Est' or nom_fr = N'Cantons-de-l''Est'

rechSubRegionMenu

0.641 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 19 ORDER BY Nom_fr

getEcomBillet

6.96 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.282 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 43

getNM

0.332 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Magog - Sherbrooke' or nom_fr = N'Magog - Sherbrooke'

getEcomBillet

7.06 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.412 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 18

getNM

0.441 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Centre-du-Québec ' or nom_fr = N'Centre-du-Québec '

rechSubRegionMenu

0.648 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 18 ORDER BY Nom_fr

getEcomBillet

6.78 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.359 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 12

getNM

0.389 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Charlevoix' or nom_fr = N'Charlevoix'

rechSubRegionMenu

0.621 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 12 ORDER BY Nom_fr

getEcomBillet

6.84 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.282 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 9

getNM

0.394 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Chaudière-Appalaches' or nom_fr = N'Chaudière-Appalaches'

rechSubRegionMenu

0.546 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 9 ORDER BY Nom_fr

getEcomBillet

6.98 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.366 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 5

getNM

0.396 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Côte-Nord' or nom_fr = N'Côte-Nord'

rechSubRegionMenu

0.649 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 5 ORDER BY Nom_fr

getEcomBillet

6.38 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.303 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 17

getNM

0.384 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Lanaudière' or nom_fr = N'Lanaudière'

rechSubRegionMenu

0.581 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 17 ORDER BY Nom_fr

getEcomBillet

6.98 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.318 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 16

getNM

0.338 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Laurentides' or nom_fr = N'Laurentides'

rechSubRegionMenu

0.556 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 16 ORDER BY Nom_fr

getEcomBillet

5.78 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.251 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 23

getNM

0.329 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Tremblant' or nom_fr = N'Tremblant'

getEcomBillet

6.41 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.335 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 21

getNM

0.361 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Laval' or nom_fr = N'Laval'

rechSubRegionMenu

0.618 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 21 ORDER BY Nom_fr

getEcomBillet

6.7 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.363 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 11

getNM

0.397 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Mauricie' or nom_fr = N'Mauricie'

rechSubRegionMenu

0.613 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 11 ORDER BY Nom_fr

getEcomBillet

6.79 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.362 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 20

getNM

0.322 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Montérégie' or nom_fr = N'Montérégie'

rechSubRegionMenu

0.663 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 20 ORDER BY Nom_fr

getEcomBillet

6.71 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.311 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 45

getNM

0.391 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Le Haut-Richelieu' or nom_fr = N'Le Haut-Richelieu'

getEcomBillet

6.66 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.36 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 28

getNM

0.39 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Montérégie-Ouest' or nom_fr = N'Montérégie-Ouest'

getEcomBillet

6.63 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.297 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 22

getNM

0.353 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Montréal' or nom_fr = N'Montréal'

rechSubRegionMenu

0.638 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 22 ORDER BY Nom_fr

getEcomBillet

6.6 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.41 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 32

getNM

0.399 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

6.55 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.317 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 15

getNM

0.377 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Outaouais - Ottawa' or nom_fr = N'Outaouais - Ottawa'

rechSubRegionMenu

0.617 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 15 ORDER BY Nom_fr

getEcomBillet

6.58 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.361 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 13

getNM

0.33 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Québec' or nom_fr = N'Québec'

rechSubRegionMenu

0.679 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 13 ORDER BY Nom_fr

getEcomBillet

6.76 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.306 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 41

getNM

0.389 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Île d''Orléans' or nom_fr = N'Île d''Orléans'

getEcomBillet

6.74 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.327 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 44

getNM

0.43 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'La Jacques-Cartier' or nom_fr = N'La Jacques-Cartier'

getEcomBillet

7.12 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.366 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 4

getNM

0.412 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Saguenay - Lac-Saint-Jean' or nom_fr = N'Saguenay - Lac-Saint-Jean'

rechSubRegionMenu

0.693 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 4 ORDER BY Nom_fr

getEcomBillet

6.94 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.298 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 35

getNM

0.402 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Lac St-Jean - Alma - Roberval - St-Félicien' or nom_fr = N'Lac St-Jean - Alma - Roberval - St-Félicien'

getEcomBillet

6.66 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.272 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 42

getNM

0.389 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Saguenay - Le Fjord' or nom_fr = N'Saguenay - Le Fjord'

getEcomBillet

6.72 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.394 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.338 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Activités famille' or titre_fr = N'Activités famille'

getEcomBillet

6.74 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.471 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.316 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Activités plein air' or titre_fr = N'Activités plein air'

getEcomBillet

6.59 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.379 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.334 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Agrotourisme au Québec' or titre_fr = N'Agrotourisme au Québec'

getEcomBillet

6.69 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.355 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.321 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Centres d''amusements' or titre_fr = N'Centres d''amusements'

getEcomBillet

7.01 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.443 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.337 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Croisières' or titre_fr = N'Croisières'

getEcomBillet

7.23 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.472 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.378 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Festivals & spectacles' or titre_fr = N'Festivals & spectacles'

getEcomBillet

7.24 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.458 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.453 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Musées ' or titre_fr = N'Musées '

getEcomBillet

6.87 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.472 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.406 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Parcs aquatiques - Plages' or titre_fr = N'Parcs aquatiques - Plages'

getEcomBillet

6.78 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.466 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.41 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Parcs Nationaux et régionaux du Québec' or titre_fr = N'Parcs Nationaux et régionaux du Québec'

getEcomBillet

7.39 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.405 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.286 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Promotions & Coupons' or titre_fr = N'Promotions & Coupons'

getEcomBillet

8.66 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.418 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.317 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Spas & retraites' or titre_fr = N'Spas & retraites'

getEcomBillet

7.37 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.497 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.451 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Traditions & Cultures Autochtones' or titre_fr = N'Traditions & Cultures Autochtones'

getEcomBillet

7.05 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.448 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.295 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Vélo de montagne au Québec' or titre_fr = N'Vélo de montagne au Québec'

getEcomBillet

6.66 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.411 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.388 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Vignobles & Cidreries du Québec' or titre_fr = N'Vignobles & Cidreries du Québec'

getEcomBillet

7.48 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.468 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.432 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Zoos & Parcs Thématiques - Aquariums' or titre_fr = N'Zoos & Parcs Thématiques - Aquariums'

getEcomBillet

6.84 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.471 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

6.7 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.402 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

6.64 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.355 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

6.63 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.475 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

7.6 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.512 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

7.48 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.406 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

7.4 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.454 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

7.51 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.404 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

7.32 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.371 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

7.27 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.451 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

7.15 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.366 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

6.89 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.409 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

6.77 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.47 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

rechLeaderboard

0.733 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\module\leaderboard.cfm

SQL (Merged Parameters)

SELECT Leaderboard.Leaderboard_ID, Leaderboard.Titre_fr AS TitreLeaderboard, Leaderboard.Url_fr AS Url, Leaderboard.UrlExterne_fr AS UrlExterne, Leaderboard.DateDebut, Leaderboard.DateFin FROM Leaderboard LEFT JOIN LeaderboardjctRegion ON LeaderboardjctRegion.Leaderboard_ID = Leaderboard.Leaderboard_ID AND LeaderboardjctRegion.Region_ID = 32 WHERE Leaderboard.Actif = 1 AND Leaderboard.PhotoActive1 = 1 AND Leaderboard.DateDebut <= getdate() AND Leaderboard.DateFin >= getdate() AND ( EXISTS( SELECT 1 FROM LeaderboardjctRegion WHERE LeaderboardjctRegion.Leaderboard_ID = Leaderboard.Leaderboard_ID AND LeaderboardjctRegion.Region_ID = 32 ) OR ISNULL(Leaderboard.RegionSeulement,0) = 0 ) ORDER BY NEWID()

SQL (Explicit Parameters)

SELECT Leaderboard.Leaderboard_ID, Leaderboard.Titre_fr AS TitreLeaderboard, Leaderboard.Url_fr AS Url, Leaderboard.UrlExterne_fr AS UrlExterne, Leaderboard.DateDebut, Leaderboard.DateFin FROM Leaderboard LEFT JOIN LeaderboardjctRegion ON LeaderboardjctRegion.Leaderboard_ID = Leaderboard.Leaderboard_ID AND LeaderboardjctRegion.Region_ID = {type: "CF_SQL_INTEGER", value: 32} WHERE Leaderboard.Actif = 1 AND Leaderboard.PhotoActive1 = 1 AND Leaderboard.DateDebut <= getdate() AND Leaderboard.DateFin >= getdate() AND ( EXISTS( SELECT 1 FROM LeaderboardjctRegion WHERE LeaderboardjctRegion.Leaderboard_ID = Leaderboard.Leaderboard_ID AND LeaderboardjctRegion.Region_ID = {type: "CF_SQL_INTEGER", value: 32} ) OR ISNULL(Leaderboard.RegionSeulement,0) = 0 ) ORDER BY NEWID()

getEcomBillet

6.83 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.482 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.41 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Activités famille' or titre_fr = N'Activités famille'

getEcomBillet

6.82 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.475 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.35 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Activités plein air' or titre_fr = N'Activités plein air'

getEcomBillet

6.48 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.324 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.299 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Agrotourisme au Québec' or titre_fr = N'Agrotourisme au Québec'

getEcomBillet

5.87 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.4 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.299 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Centres d''amusements' or titre_fr = N'Centres d''amusements'

getEcomBillet

6.26 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.356 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.282 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Croisières' or titre_fr = N'Croisières'

getEcomBillet

6.78 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.425 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.303 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Festivals & spectacles' or titre_fr = N'Festivals & spectacles'

getEcomBillet

6.31 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.461 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.306 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Musées ' or titre_fr = N'Musées '

getEcomBillet

7.62 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.401 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.29 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Parcs aquatiques - Plages' or titre_fr = N'Parcs aquatiques - Plages'

getEcomBillet

7.16 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.419 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.367 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Parcs Nationaux et régionaux du Québec' or titre_fr = N'Parcs Nationaux et régionaux du Québec'

getEcomBillet

7.95 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.579 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.352 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Promotions & Coupons' or titre_fr = N'Promotions & Coupons'

getEcomBillet

6.95 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.414 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.457 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Spas & retraites' or titre_fr = N'Spas & retraites'

getEcomBillet

6.79 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.56 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.423 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Traditions & Cultures Autochtones' or titre_fr = N'Traditions & Cultures Autochtones'

getEcomBillet

12.4 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.559 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.455 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Vélo de montagne au Québec' or titre_fr = N'Vélo de montagne au Québec'

getEcomBillet

12.3 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.579 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.423 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Vignobles & Cidreries du Québec' or titre_fr = N'Vignobles & Cidreries du Québec'

getEcomBillet

10.4 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.609 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.412 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Zoos & Parcs Thématiques - Aquariums' or titre_fr = N'Zoos & Parcs Thématiques - Aquariums'

getEcomBillet

9.64 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletLodg

0.355 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 4

getEcomBillet

7.29 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletLodg

0.286 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 5

getEcomBillet

6.46 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletLodg

0.493 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 2

getEcomBillet

8.41 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletLodg

0.344 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 3

getEcomBillet

8.67 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletLodg

0.329 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 1

getEcomBillet

7.29 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletLodg

0.494 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 6

getEcomBillet

7.25 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.414 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 39

getNM

0.472 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'1000 Îles et région' or nom_fr = N'1000 Îles et région'

rechSubRegionMenu

0.778 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 39 ORDER BY Nom_fr

getEcomBillet

7.56 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.386 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 10

getNM

0.511 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Abitibi-Témiscamingue' or nom_fr = N'Abitibi-Témiscamingue'

rechSubRegionMenu

0.73 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 10 ORDER BY Nom_fr

getEcomBillet

9.06 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.381 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 46

getNM

0.415 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'La Vallée-de-l''Or' or nom_fr = N'La Vallée-de-l''Or'

getEcomBillet

7.75 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.301 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 19

getNM

0.384 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Cantons-de-l''Est' or nom_fr = N'Cantons-de-l''Est'

rechSubRegionMenu

0.734 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 19 ORDER BY Nom_fr

getEcomBillet

9.98 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.368 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 43

getNM

0.524 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Magog - Sherbrooke' or nom_fr = N'Magog - Sherbrooke'

getEcomBillet

10.7 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.363 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 18

getNM

0.43 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Centre-du-Québec ' or nom_fr = N'Centre-du-Québec '

rechSubRegionMenu

0.818 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 18 ORDER BY Nom_fr

getEcomBillet

7.2 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.42 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 12

getNM

0.401 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Charlevoix' or nom_fr = N'Charlevoix'

rechSubRegionMenu

0.544 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 12 ORDER BY Nom_fr

getEcomBillet

5.96 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.302 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 9

getNM

0.473 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Chaudière-Appalaches' or nom_fr = N'Chaudière-Appalaches'

rechSubRegionMenu

0.647 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 9 ORDER BY Nom_fr

getEcomBillet

7.49 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.372 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 5

getNM

0.364 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Côte-Nord' or nom_fr = N'Côte-Nord'

rechSubRegionMenu

0.544 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 5 ORDER BY Nom_fr

getEcomBillet

7.66 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.392 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 17

getNM

0.371 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Lanaudière' or nom_fr = N'Lanaudière'

rechSubRegionMenu

0.55 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 17 ORDER BY Nom_fr

getEcomBillet

6.64 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.31 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 16

getNM

0.359 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Laurentides' or nom_fr = N'Laurentides'

rechSubRegionMenu

0.565 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 16 ORDER BY Nom_fr

getEcomBillet

7.05 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.335 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 23

getNM

0.391 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Tremblant' or nom_fr = N'Tremblant'

getEcomBillet

8 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.373 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 21

getNM

0.473 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Laval' or nom_fr = N'Laval'

rechSubRegionMenu

0.865 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 21 ORDER BY Nom_fr

getEcomBillet

9.34 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.454 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 11

getNM

0.524 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Mauricie' or nom_fr = N'Mauricie'

rechSubRegionMenu

0.732 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 11 ORDER BY Nom_fr

getEcomBillet

12 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.5 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 20

getNM

0.536 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Montérégie' or nom_fr = N'Montérégie'

rechSubRegionMenu

0.806 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 20 ORDER BY Nom_fr

getEcomBillet

6.41 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.361 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 45

getNM

0.334 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Le Haut-Richelieu' or nom_fr = N'Le Haut-Richelieu'

getEcomBillet

11.6 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.347 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 28

getNM

0.476 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Montérégie-Ouest' or nom_fr = N'Montérégie-Ouest'

getEcomBillet

8.64 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.456 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 22

getNM

0.517 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Montréal' or nom_fr = N'Montréal'

rechSubRegionMenu

0.549 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 22 ORDER BY Nom_fr

getEcomBillet

9.55 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.427 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 32

getNM

0.496 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

6.91 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.356 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 15

getNM

0.371 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Outaouais - Ottawa' or nom_fr = N'Outaouais - Ottawa'

rechSubRegionMenu

0.808 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 15 ORDER BY Nom_fr

getEcomBillet

9.03 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.367 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 13

getNM

0.566 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Québec' or nom_fr = N'Québec'

rechSubRegionMenu

0.641 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 13 ORDER BY Nom_fr

getEcomBillet

6.73 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.344 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 41

getNM

0.401 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Île d''Orléans' or nom_fr = N'Île d''Orléans'

getEcomBillet

9.42 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.356 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 44

getNM

0.36 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'La Jacques-Cartier' or nom_fr = N'La Jacques-Cartier'

getEcomBillet

8.87 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.367 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 4

getNM

0.348 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Saguenay - Lac-Saint-Jean' or nom_fr = N'Saguenay - Lac-Saint-Jean'

rechSubRegionMenu

0.589 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_fr as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 4 ORDER BY Nom_fr

getEcomBillet

8.76 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.299 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 35

getNM

0.355 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Lac St-Jean - Alma - Roberval - St-Félicien' or nom_fr = N'Lac St-Jean - Alma - Roberval - St-Félicien'

getEcomBillet

8.42 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.294 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 42

getNM

0.387 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Saguenay - Le Fjord' or nom_fr = N'Saguenay - Le Fjord'

getEcomBillet

7.23 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.41 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

7.14 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.388 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

7.32 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.406 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

7.25 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.534 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

7.95 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.279 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 22

getNM

0.368 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Montréal' or nom_fr = N'Montréal'

rechThemeMenu

0.763 ms

passeportvacances

C:\sites\passeportvacances.com\www\03_100.cfm

164

SQL

SELECT SuggestionCat_ID, TitreMenu_fr as ThemeNomMenu, Titre_fr as ThemeNom FROM SuggestionCat WHERE Actif = 1 ORDER BY Titre_fr

rechRegion

0.723 ms

passeportvacances

C:\sites\passeportvacances.com\www\03_100.cfm

170

SQL

SELECT Region_ID, Nom_fr as RegionNom FROM Region WHERE Actif = 1 ORDER BY Nom_fr

rechLodgingMenu

0.64 ms

passeportvacances

C:\sites\passeportvacances.com\www\03_100.cfm

177

SQL

SELECT SuggestionLODG_ID, TitreMenu_fr as ThemeNomLogMenu, Titre_fr as ThemeNomLog FROM SuggestionLodging WHERE Actif = 1 ORDER BY Titre_fr

getAR

283

1.04 ms

passeportvacances

C:\sites\passeportvacances.com\www\03_100.cfm

220

SQL

Select link_fr as lnk, region_id, SuggestionCat_ID From activityRegionPages WITH (NOLOCK) WHERE actif = 1 AND IsNull(link_fr, '') <> ''

getEcomBillet

6.33 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

rechBilletRegion2

0.298 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 32

getNM

0.4 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

rechBigBox

0.819 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\module\big_box.cfm

SQL (Merged Parameters)

Select * From ( SELECT distinct BigBox.BigBox_ID, BigBox.Titre_fr AS TitreBigBox, BigBox.Url_fr AS Url, BigBox.UrlExterne_fr as UrlExterne, BigBox.DateDebut, BigBox.DateFin, BigBox.AutoPromo FROM BigBox INNER JOIN BigBoxjctRegion ON BigBoxjctRegion.BigBox_ID = BigBox.BigBox_ID AND BigBoxjctRegion.Region_ID = '32' WHERE BigBox.Actif = 1 AND BigBox.PhotoActive1 = 1 AND (getdate() BETWEEN BigBox.DateDebut AND BigBox.DateFin) ) as a ORDER BY AutoPromo, NewID()

SQL (Explicit Parameters)

Select * From ( SELECT distinct BigBox.BigBox_ID, BigBox.Titre_fr AS TitreBigBox, BigBox.Url_fr AS Url, BigBox.UrlExterne_fr as UrlExterne, BigBox.DateDebut, BigBox.DateFin, BigBox.AutoPromo FROM BigBox INNER JOIN BigBoxjctRegion ON BigBoxjctRegion.BigBox_ID = BigBox.BigBox_ID AND BigBoxjctRegion.Region_ID = {type: "CF_SQL_VARCHAR", value: '32'} WHERE BigBox.Actif = 1 AND BigBox.PhotoActive1 = 1 AND (getdate() BETWEEN BigBox.DateDebut AND BigBox.DateFin) ) as a ORDER BY AutoPromo, NewID()

rechBigBoxSorted

0.097 ms

C:\sites\passeportvacances.com\www\inc\module\big_box.cfm

SQL

SELECT * FROM rechBigBox Where AutoPromo = 0

rechBigBoxSortedAutoPromo

0.07 ms

C:\sites\passeportvacances.com\www\inc\module\big_box.cfm

SQL

SELECT * FROM rechBigBox Where AutoPromo = 1

local.dataQuery

16.4 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\fonction.cfm

234

SQL (Merged Parameters)

WITH Billets AS ( SELECT BILLET.BILLET_ID, BILLET.Titre_fr, BILLET.Titre_en, BILLET.titre_fr as BilletTitre, BILLET.Intro_fr as BILLETIntro , BILLET.Descr_fr as BilletDescription, BILLET.PhotoActive, BILLET.PosX, BILLET.PosY, BILLET.RefDescription_fr as RefDescription , BILLET.RefMotsCles_fr as RefMotsCles, BILLET.Direction_fr as Direction, BILLET.Hyperlien_fr as Hyperlien , Billet.Adresse, Billet.FicheProduit, Billet.Coupon_ID, Billet.ActifFicheDetail, BILLET.YoutubeId_fr AS BilletYoutubeID, youtubePoz , Billet.codeSTM_fr AS BilletCodeSTM, Billet.DateDebut, Billet.FicheGratuite , b.ActifAccueil, b.ActifAccueilPrioritaire, b.Surbrillance, b.BANDEAUTYPE_ID, b.PrioritaireRegion, b.PrioritaireCat , CASE WHEN Billet.FicheProduit = 1 THEN CouponFicheProduit.Rabais ELSE CouponFicheEditoriale.Rabais END as Rabais , 0 as Distance , bt.nom_en as bnom_en, bt.nom_fr as bnom_fr, bt.color as bColor , billet.ecomActif, billet.regularPrice, billet.discountPrice, billet.ecomLinkEN, billet.ecomLinkFR, billet.ecomButFR, billet.ecomButEN, billet.bypass , client.titre_fr as clientName, billet.showRegisterButton, billet.fbLink, billet.instaLink, billet.ytLink, billet.isECom , billet.whatGet_fr as whatGet, billet.details_fr as details , billet.link_fr as linkPage FROM Billet Left Outer Join BANDEAUTYPE bt On Billet.BANDEAUTYPE_ID = bt.BANDEAUTYPE_ID Left Outer Join client On client.client_ID = billet.client_id LEFT JOIN dbo.viewCoupon CouponFicheEditoriale ON CouponFicheEditoriale.Coupon_ID = ISNULL(Billet.Coupon_ID,0) OUTER APPLY ( SELECT ISNULL(SUM(Rabais),0) FROM dbo.viewCoupon Coupon INNER JOIN BILLETjctCOUPON ON BILLETjctCOUPON.BILLET_ID = BILLET.BILLET_ID AND BILLETjctCOUPON.COUPON_ID = COUPON.COUPON_ID ) CouponFicheProduit (Rabais) OUTER APPLY ( SELECT CASE WHEN ( b1.ActifAccueil = 1 AND (b1.ActifAccueilDateDebut <= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.ActifAccueilDateFin >= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as ActifAccueil, CASE WHEN ( b1.ActifAccueilPrioritaire = 1 AND (b1.ActifAccueilPrioritaireDateDebut <= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilPrioritaireDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.ActifAccueilPrioritaireDateFin >= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilPrioritaireDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as ActifAccueilPrioritaire, CASE WHEN ( b1.Surbrillance = 1 AND (b1.SurbrillanceDateDebut <= CAST(getDate() as date) OR ISNULL(b1.SurbrillanceDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.SurbrillanceDateFin >= CAST(getDate() as date) OR ISNULL(b1.SurbrillanceDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as Surbrillance, CASE WHEN ( b1.BANDEAUTYPE_ID > 0 AND (b1.BandeauDateDebut <= CAST(getDate() as date) OR ISNULL(b1.BandeauDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.BandeauDateFin >= CAST(getDate() as date) OR ISNULL(b1.BandeauDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN BANDEAUTYPE_ID ELSE 0 END as BANDEAUTYPE_ID, CASE WHEN ( b1.PrioritaireRegion = 1 AND (b1.PrioritaireRegionDateDebut <= CAST(getDate() as date) OR ISNULL(b1.PrioritaireRegionDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.PrioritaireRegionDateFin >= CAST(getDate() as date) OR ISNULL(b1.PrioritaireRegionDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as PrioritaireRegion, CASE WHEN ( b1.PrioritaireCat = 1 AND (b1.PrioritaireCatDateDebut <= CAST(getDate() as date) OR ISNULL(b1.PrioritaireCatDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.PrioritaireCatDateFin >= CAST(getDate() as date) OR ISNULL(b1.PrioritaireCatDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as PrioritaireCat FROM Billet b1 WHERE Billet_ID = Billet.Billet_ID ) b WHERE 1 = 1 and (billet.Actif = 1) AND (billet.FicheInfolettre = 0) AND (billet.DateDebut <= GETDATE()) AND (billet.DateFin >= GETDATE()) AND Billet.FicheProduit = 0 AND EXISTS( SELECT 1 FROM BilletjctRegion WHERE BilletjctRegion.Billet_ID = Billet.Billet_ID AND BilletjctRegion.Region_ID = 32 ) ) SELECT Billets.*, REGION.ListeRegion, BILLETCAT.ListeBilletCat, Theme.ListeTheme, Lodg.ListeLodg, CASE WHEN (Billets.FicheGratuite = 0 and Billets.FicheProduit = 1) THEN 0 WHEN (Billets.FicheGratuite = 0) THEN 1 ELSE 2 END as newBilletOrder, CASE WHEN Billets.FicheGratuite = 1 THEN 2 WHEN Billets.Rabais > 0 AND Billets.FicheGratuite = 0 THEN 0 ELSE 1 END as OrdreBillet, CASE WHEN Billets.ActifAccueilPrioritaire = 1 THEN 0 ELSE 1 END as OrdreAccueil, CASE WHEN Billets.PrioritaireRegion = 1 AND Billets.PrioritaireCat = 1 THEN 0 WHEN Billets.PrioritaireRegion = 1 THEN 1 WHEN Billets.PrioritaireCat = 1 THEN 2 ELSE 3 END as OrdreALaUne , bt.nom_en as bnom_en, bt.nom_fr as bnom_fr, bt.color as bColor FROM Billets Left Outer Join BANDEAUTYPE bt On Billets.BANDEAUTYPE_ID = bt.BANDEAUTYPE_ID OUTER APPLY ( SELECT CAST(SuggestionLodging.SuggestionLodg_ID as varchar) + ',' FROM SuggestionLodging INNER JOIN BILLETjctSUGGESTIONLodging ON BILLETjctSUGGESTIONLodging.SuggestionLodg_ID = SuggestionLodging.SuggestionLodg_ID WHERE SuggestionLodging.Actif = 1 AND BILLETjctSUGGESTIONLodging.BILLET_ID = Billets.BILLET_ID ORDER BY Ordre FOR XML PATH ('') ) Lodg (ListeLodg) OUTER APPLY ( SELECT CAST(SuggestionCat.SuggestionCat_ID as varchar) + ',' FROM SuggestionCat INNER JOIN BILLETjctSUGGESTIONCAT ON BILLETjctSUGGESTIONCAT.SuggestionCat_ID = SuggestionCat.SuggestionCat_ID WHERE SuggestionCat.Actif = 1 AND BILLETjctSUGGESTIONCAT.BILLET_ID = Billets.BILLET_ID ORDER BY Ordre FOR XML PATH ('') ) Theme (ListeTheme) OUTER APPLY ( SELECT CAST(REGION.REGION_ID as varchar) + ',' FROM REGION INNER JOIN BILLETjctREGION ON BILLETjctREGION.REGION_ID = REGION.REGION_ID WHERE REGION.Actif = 1 AND BILLETjctREGION.BILLET_ID = Billets.BILLET_ID ORDER BY REGION.Ordre FOR XML PATH ('') ) REGION (ListeRegion) OUTER APPLY ( SELECT CAST(BILLETCAT.BILLETCAT_ID as varchar) + ',' FROM BILLETCAT INNER JOIN BILLETjctBILLETCAT ON BILLETjctBILLETCAT.BILLETCAT_ID = BILLETCAT.BILLETCAT_ID WHERE BILLETCAT.Actif = 1 AND BILLETjctBILLETCAT.BILLET_ID = Billets.BILLET_ID ORDER BY BILLETCAT.Ordre FOR XML PATH ('') ) BILLETCAT (ListeBilletCat) ORDER BY newBilletOrder

SQL (Explicit Parameters)

WITH Billets AS ( SELECT BILLET.BILLET_ID, BILLET.Titre_fr, BILLET.Titre_en, BILLET.titre_fr as BilletTitre, BILLET.Intro_fr as BILLETIntro , BILLET.Descr_fr as BilletDescription, BILLET.PhotoActive, BILLET.PosX, BILLET.PosY, BILLET.RefDescription_fr as RefDescription , BILLET.RefMotsCles_fr as RefMotsCles, BILLET.Direction_fr as Direction, BILLET.Hyperlien_fr as Hyperlien , Billet.Adresse, Billet.FicheProduit, Billet.Coupon_ID, Billet.ActifFicheDetail, BILLET.YoutubeId_fr AS BilletYoutubeID, youtubePoz , Billet.codeSTM_fr AS BilletCodeSTM, Billet.DateDebut, Billet.FicheGratuite , b.ActifAccueil, b.ActifAccueilPrioritaire, b.Surbrillance, b.BANDEAUTYPE_ID, b.PrioritaireRegion, b.PrioritaireCat , CASE WHEN Billet.FicheProduit = 1 THEN CouponFicheProduit.Rabais ELSE CouponFicheEditoriale.Rabais END as Rabais , 0 as Distance , bt.nom_en as bnom_en, bt.nom_fr as bnom_fr, bt.color as bColor , billet.ecomActif, billet.regularPrice, billet.discountPrice, billet.ecomLinkEN, billet.ecomLinkFR, billet.ecomButFR, billet.ecomButEN, billet.bypass , client.titre_fr as clientName, billet.showRegisterButton, billet.fbLink, billet.instaLink, billet.ytLink, billet.isECom , billet.whatGet_fr as whatGet, billet.details_fr as details , billet.link_fr as linkPage FROM Billet Left Outer Join BANDEAUTYPE bt On Billet.BANDEAUTYPE_ID = bt.BANDEAUTYPE_ID Left Outer Join client On client.client_ID = billet.client_id LEFT JOIN dbo.viewCoupon CouponFicheEditoriale ON CouponFicheEditoriale.Coupon_ID = ISNULL(Billet.Coupon_ID,0) OUTER APPLY ( SELECT ISNULL(SUM(Rabais),0) FROM dbo.viewCoupon Coupon INNER JOIN BILLETjctCOUPON ON BILLETjctCOUPON.BILLET_ID = BILLET.BILLET_ID AND BILLETjctCOUPON.COUPON_ID = COUPON.COUPON_ID ) CouponFicheProduit (Rabais) OUTER APPLY ( SELECT CASE WHEN ( b1.ActifAccueil = 1 AND (b1.ActifAccueilDateDebut <= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.ActifAccueilDateFin >= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as ActifAccueil, CASE WHEN ( b1.ActifAccueilPrioritaire = 1 AND (b1.ActifAccueilPrioritaireDateDebut <= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilPrioritaireDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.ActifAccueilPrioritaireDateFin >= CAST(getDate() as date) OR ISNULL(b1.ActifAccueilPrioritaireDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as ActifAccueilPrioritaire, CASE WHEN ( b1.Surbrillance = 1 AND (b1.SurbrillanceDateDebut <= CAST(getDate() as date) OR ISNULL(b1.SurbrillanceDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.SurbrillanceDateFin >= CAST(getDate() as date) OR ISNULL(b1.SurbrillanceDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as Surbrillance, CASE WHEN ( b1.BANDEAUTYPE_ID > 0 AND (b1.BandeauDateDebut <= CAST(getDate() as date) OR ISNULL(b1.BandeauDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.BandeauDateFin >= CAST(getDate() as date) OR ISNULL(b1.BandeauDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN BANDEAUTYPE_ID ELSE 0 END as BANDEAUTYPE_ID, CASE WHEN ( b1.PrioritaireRegion = 1 AND (b1.PrioritaireRegionDateDebut <= CAST(getDate() as date) OR ISNULL(b1.PrioritaireRegionDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.PrioritaireRegionDateFin >= CAST(getDate() as date) OR ISNULL(b1.PrioritaireRegionDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as PrioritaireRegion, CASE WHEN ( b1.PrioritaireCat = 1 AND (b1.PrioritaireCatDateDebut <= CAST(getDate() as date) OR ISNULL(b1.PrioritaireCatDateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) AND (b1.PrioritaireCatDateFin >= CAST(getDate() as date) OR ISNULL(b1.PrioritaireCatDateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) ) THEN 1 ELSE 0 END as PrioritaireCat FROM Billet b1 WHERE Billet_ID = Billet.Billet_ID ) b WHERE 1 = 1 and (billet.Actif = 1) AND (billet.FicheInfolettre = 0) AND (billet.DateDebut <= GETDATE()) AND (billet.DateFin >= GETDATE()) AND Billet.FicheProduit = {type: "CF_SQL_INTEGER", value: 0} AND EXISTS( SELECT 1 FROM BilletjctRegion WHERE BilletjctRegion.Billet_ID = Billet.Billet_ID AND BilletjctRegion.Region_ID = {type: "CF_SQL_INTEGER", value: 32} ) ) SELECT Billets.*, REGION.ListeRegion, BILLETCAT.ListeBilletCat, Theme.ListeTheme, Lodg.ListeLodg, CASE WHEN (Billets.FicheGratuite = 0 and Billets.FicheProduit = 1) THEN 0 WHEN (Billets.FicheGratuite = 0) THEN 1 ELSE 2 END as newBilletOrder, CASE WHEN Billets.FicheGratuite = 1 THEN 2 WHEN Billets.Rabais > 0 AND Billets.FicheGratuite = 0 THEN 0 ELSE 1 END as OrdreBillet, CASE WHEN Billets.ActifAccueilPrioritaire = 1 THEN 0 ELSE 1 END as OrdreAccueil, CASE WHEN Billets.PrioritaireRegion = 1 AND Billets.PrioritaireCat = 1 THEN 0 WHEN Billets.PrioritaireRegion = 1 THEN 1 WHEN Billets.PrioritaireCat = 1 THEN 2 ELSE 3 END as OrdreALaUne , bt.nom_en as bnom_en, bt.nom_fr as bnom_fr, bt.color as bColor FROM Billets Left Outer Join BANDEAUTYPE bt On Billets.BANDEAUTYPE_ID = bt.BANDEAUTYPE_ID OUTER APPLY ( SELECT CAST(SuggestionLodging.SuggestionLodg_ID as varchar) + ',' FROM SuggestionLodging INNER JOIN BILLETjctSUGGESTIONLodging ON BILLETjctSUGGESTIONLodging.SuggestionLodg_ID = SuggestionLodging.SuggestionLodg_ID WHERE SuggestionLodging.Actif = 1 AND BILLETjctSUGGESTIONLodging.BILLET_ID = Billets.BILLET_ID ORDER BY Ordre FOR XML PATH ('') ) Lodg (ListeLodg) OUTER APPLY ( SELECT CAST(SuggestionCat.SuggestionCat_ID as varchar) + ',' FROM SuggestionCat INNER JOIN BILLETjctSUGGESTIONCAT ON BILLETjctSUGGESTIONCAT.SuggestionCat_ID = SuggestionCat.SuggestionCat_ID WHERE SuggestionCat.Actif = 1 AND BILLETjctSUGGESTIONCAT.BILLET_ID = Billets.BILLET_ID ORDER BY Ordre FOR XML PATH ('') ) Theme (ListeTheme) OUTER APPLY ( SELECT CAST(REGION.REGION_ID as varchar) + ',' FROM REGION INNER JOIN BILLETjctREGION ON BILLETjctREGION.REGION_ID = REGION.REGION_ID WHERE REGION.Actif = 1 AND BILLETjctREGION.BILLET_ID = Billets.BILLET_ID ORDER BY REGION.Ordre FOR XML PATH ('') ) REGION (ListeRegion) OUTER APPLY ( SELECT CAST(BILLETCAT.BILLETCAT_ID as varchar) + ',' FROM BILLETCAT INNER JOIN BILLETjctBILLETCAT ON BILLETjctBILLETCAT.BILLETCAT_ID = BILLETCAT.BILLETCAT_ID WHERE BILLETCAT.Actif = 1 AND BILLETjctBILLETCAT.BILLET_ID = Billets.BILLET_ID ORDER BY BILLETCAT.Ordre FOR XML PATH ('') ) BILLETCAT (ListeBilletCat) ORDER BY newBilletOrder

getTops

0.608 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\module\editorial.cfm

SQL

Select titre_fr as billetTitre, top_id, link_fr as lnk, PhotoActive From tops WITH (NOLOCK) Where actif = 1 and (DateDebut <= CAST(getDate() as date) OR ISNULL(DateDebut,CAST(getDate() as date)) <= CAST(getDate() as date)) and (DateFin >= CAST(getDate() as date) OR ISNULL(DateFin,CAST(getDate() as date)) >= CAST(getDate() as date)) and IsNull(showInWhatToDo, 0) = 1 --Order by NewID() Order by top_id desc

rechEvenement

1.6 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\module\evenement.cfm

SQL (Merged Parameters)

SELECT Evenement.Evenement_ID, DateDebut, DateFin, Titre_fr as EvenementTitre, Lieu_fr as EvenementLieu, PhotoActive FROM Evenement INNER JOIN EvenementjctRegion ON EvenementjctRegion.Evenement_ID = Evenement.Evenement_ID AND EvenementjctRegion.Region_ID = 32 WHERE Actif = 1 AND DateDebutAffichage <= getDate() AND DateFinAffichage >= getDate() ORDER BY DateDebut

SQL (Explicit Parameters)

SELECT Evenement.Evenement_ID, DateDebut, DateFin, Titre_fr as EvenementTitre, Lieu_fr as EvenementLieu, PhotoActive FROM Evenement INNER JOIN EvenementjctRegion ON EvenementjctRegion.Evenement_ID = Evenement.Evenement_ID AND EvenementjctRegion.Region_ID = {type: "CF_SQL_INTEGER", value: 32} WHERE Actif = 1 AND DateDebutAffichage <= getDate() AND DateFinAffichage >= getDate() ORDER BY DateDebut

getConcours

0.308 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\module\concours.cfm

SQL

SELECT TEXTE_ID, Titre_fr AS Titre FROM TEXTE WHERE Actif = 1 and NoPage = '11_111'

getEcomBillet

7.08 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.401 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

7.47 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.448 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

7.5 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.373 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

6.64 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.379 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

6.98 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.499 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

7.58 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.371 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

6.99 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.416 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

6.86 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.407 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

6.83 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.379 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

6.46 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.354 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

6.5 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.344 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

6.69 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.43 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.347 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Activités famille' or titre_fr = N'Activités famille'

getEcomBillet

6.8 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.362 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.301 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Activités plein air' or titre_fr = N'Activités plein air'

getEcomBillet

7.35 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.382 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.351 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Agrotourisme au Québec' or titre_fr = N'Agrotourisme au Québec'

getEcomBillet

7.02 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.412 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.411 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Centres d''amusements' or titre_fr = N'Centres d''amusements'

getEcomBillet

6.48 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.34 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.287 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Croisières' or titre_fr = N'Croisières'

getEcomBillet

6.97 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.431 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.388 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Festivals & spectacles' or titre_fr = N'Festivals & spectacles'

getEcomBillet

6.56 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.345 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.295 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Musées ' or titre_fr = N'Musées '

getEcomBillet

7.21 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.383 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.42 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Parcs aquatiques - Plages' or titre_fr = N'Parcs aquatiques - Plages'

getEcomBillet

6.67 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.459 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.329 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Parcs Nationaux et régionaux du Québec' or titre_fr = N'Parcs Nationaux et régionaux du Québec'

getEcomBillet

6.71 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.412 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.316 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Promotions & Coupons' or titre_fr = N'Promotions & Coupons'

getEcomBillet

7.11 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.358 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.332 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Spas & retraites' or titre_fr = N'Spas & retraites'

getEcomBillet

7.01 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.358 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.34 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Traditions & Cultures Autochtones' or titre_fr = N'Traditions & Cultures Autochtones'

getEcomBillet

7.12 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.386 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.295 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Vélo de montagne au Québec' or titre_fr = N'Vélo de montagne au Québec'

getEcomBillet

5.76 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.371 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.281 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Vignobles & Cidreries du Québec' or titre_fr = N'Vignobles & Cidreries du Québec'

getEcomBillet

6.23 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.355 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getNM

0.287 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Zoos & Parcs Thématiques - Aquariums' or titre_fr = N'Zoos & Parcs Thématiques - Aquariums'

getEcomBillet

7.19 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.357 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

getEcomBillet

6.06 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'quoi-faire-a-vieux-montreal-vieux-port'

getNM

0.348 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

track

1.03 ms

passeportvacancesLogs

C:\sites\passeportvacances.com\www\Application.cfc

1170

SQL

Insert Into tracking (isBot, trackDate, trackDateClean, query_string, page, http_referer, remoteIP, browser, path_info, userID, formStruct, processingTime, request_url, siteName) Values (0, GetDate(), CONVERT(varchar, GetDate(), 102), '/quoi-faire-a-vieux-montreal-vieux-port?Page=2&anchor=colPrincipal', '', '', '216.73.216.122', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 0, '', 1325, 'https://www.passeportvacances.com:443/quoi-faire-a-vieux-montreal-vieux-port?Page=2&anchor=colPrincipal', 'PV')

Quoi faire dans Vieux Port de Montréal - Activités familiales

Trouver une activité

DES ACTIVITÉS & ESCAPADES À DÉCOUVRIR

Quoi faire ce mois-ci: Coup d'oeil sur les sorties du mois

Rencontre des arts - Exploration Culturelle: Spectacles, (…)

Pow Wow International de Wendake - Expérience autochtone

Aquazilla - Soyez prêts à sauter à l’eau!

Festival de la fraise 2025

Parc national d'Aiguebelle

L'Hôtel V - Découvrez nos forfaits

Canyon Sainte-Anne & Spa des Neiges - Forfait

Académie TAG Karting -Préparez-vous à enfiler votre casque (…)

SOS Labyrinthe - 2 km de fun au Vieux-Port de Montréal

Kitigan Zibi Traditional Pow Wow - 31 mai et 1er juin 2025 – (…)

Mine Capelton - Visite guidée de la mine

La Pointe à David Pourvoirie - Camp touristique

Le MEM, votre musée 100% montréalais !

BLOGUES - EXPLOREZ NOS ATTRAITS

Hôtel Ambassadeur Québec

Au Chalet en Bois Rond - Ste-Christine d'Auvergne

Kenauk Nature - Glamping - Prêt-à-camper près de Montréal

Parc régional Beauharnois-Salaberry

Parc National d'Aiguebelle

Village historique de Val-Jalbert

Zükari Centre-amusement intérieur - Sainte-julie

Ermitage Saint-Antoine - Havre de Paix et de Spiritualité au (…)

Le Centre Castor, situé sur la Base militaire de Valcartier.

Découverte des Vignobles du Québec : Un Voyage au Cœur des (…)

Découvrez Saint-Hyacinthe et sa région - Quoi faire & plus!

Découvrez les lieux culturels de l'île d'Orléans - Site (…)

Découvrez le Manoir d’Youville

Le Camping au Québec - Que l'aventure commence!

Explorons le monde du vélo de montagne au Québec

Hôtel Castel

Faire de la musique est au cœur de la mission de CAMMAC

Retrouver l'Équilibre : Plongez dans l'Oasis de Détente

Les meilleurs festivals d'été de Montréal

Activités à faire en famille pendant la semaine de relâche