Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Referral Dates Nightmare Expand / Collapse
Author
Message
Posted Wednesday, January 29, 2014 6:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 06, 2014 2:48 AM
Points: 8, Visits: 13
/****Child Table ****/

/****** Object: Table [dbo].[ChildDetails] Script Date: 01/29/2014 08:21:30 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ChildDetails]') AND type in (N'U'))
DROP TABLE [dbo].[ChildDetails]
GO

/****** Object: Table [dbo].[ChildDetails] Script Date: 01/29/2014 08:21:30 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ChildDetails](
[PER_ID] [numeric](8, 0) NULL,
[NAM_TITLE] [varchar](10) NULL,
[NAM_FORE1] [varchar](35) NULL,
[NAM_SURNAME] [varchar](35) NULL,
[PER_DOB] [datetime] NULL,
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

/****Referral Table ****/

/****** Object: Table [dbo].[ChildReferrals] Script Date: 01/29/2014 08:22:27 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ChildReferrals]') AND type in (N'U'))
DROP TABLE [dbo].[ChildReferrals]
GO

/****** Object: Table [dbo].[ChildReferrals] Script Date: 01/29/2014 08:22:27 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ChildReferrals](
[CLI_PER_ID] [numeric](8, 0) NULL,
[REF_ID] [numeric](8, 0) NULL,
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

/****Referral Action Table ****/

/****** Object: Table [dbo].[ChildReferralAction] Script Date: 01/29/2014 08:22:51 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ChildReferralAction]') AND type in (N'U'))
DROP TABLE [dbo].[ChildReferralAction]
GO

/****** Object: Table [dbo].[ChildReferralAction] Script Date: 01/29/2014 08:22:51 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ChildReferralAction](
[CLI_PER_ID] [numeric](8, 0) NULL,
[RAC_ID] [numeric](8, 0) NULL,
[RAC_REF_ID] [numeric](8, 0) NULL,
[RAC_TYPE] [varchar](10) NULL,
[RAC_DATE] [datetime2](7) NULL,
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

/****Populate Referral Action Table ****/

--===== All Inserts into the IDENTITY column
SET IDENTITY_INSERT ChildReferrals ON

--===== Insert the test data into the test table
INSERT INTO ChildReferrals

(CLI_PER_ID,REF_ID)
SELECT '27429','619' UNION ALL
SELECT '27429','620' UNION ALL
SELECT '27429','621' UNION ALL
SELECT '27429','622' UNION ALL
SELECT '27429','624' UNION ALL
SELECT '27429','860729'

--===== Set the identity insert back to normal
SET IDENTITY_INSERT ChildReferrals OFF



/****Populate Child Table ****/

--===== All Inserts into the IDENTITY column
SET IDENTITY_INSERT ChildDetails ON

--===== Insert the test data into the test table
INSERT INTO ChildDetails

(PER_ID,NAM_TITLE,NAM_FORE1,NAM_SURNAME,PER_DOB)
SELECT '27429','MR','ROBERT','OAKES','Jul 6 1956 12:00AM'

--===== Set the identity insert back to normal
SET IDENTITY_INSERT ChildDetails OFF



/****Populate Referral Action ****/

--===== All Inserts into the IDENTITY column
SET IDENTITY_INSERT ChildReferralAction ON

--===== Insert the test data into the test table
INSERT INTO ChildReferralAction

(CLI_PER_ID,RAC_ID,RAC_REF_ID,RAC_TYPE,RAC_DATE)
SELECT '27429','719','619','ALLOCATE ','1990-03-22 00:00:00.0000000' UNION ALL
SELECT '27429','720','619','CLOS ','1999-06-03 00:00:00.0000000' UNION ALL
SELECT '27429','721','620','ALLOCATE ','1988-07-04 00:00:00.0000000' UNION ALL
SELECT '27429','722','620','CLOS ','1990-03-22 00:00:00.0000000' UNION ALL
SELECT '27429','723','621','ALLOCATE ','1991-11-14 00:00:00.0000000' UNION ALL
SELECT '27429','724','621','CLOS ','1999-04-14 00:00:00.0000000' UNION ALL
SELECT '27429','725','622','ALLOCATE ','1999-04-14 00:00:00.0000000' UNION ALL
SELECT '27429','726','622','CLOS ','2000-10-10 00:00:00.0000000' UNION ALL
SELECT '27429','729','624','ALLOCATE ','2001-04-25 00:00:00.0000000' UNION ALL
SELECT '27429','730','624','CLOS ','2002-06-17 00:00:00.0000000' UNION ALL
SELECT '27429','1392816','860729','REQT ','2009-01-12 00:00:00.0000000' UNION ALL
SELECT '27429','1394845','860729','ACCT ','2009-01-12 00:00:00.0000000' UNION ALL
SELECT '27429','1397310','860729','ALLOCATE ','2009-01-13 00:00:00.0000000' UNION ALL
SELECT '27429','1443476','860729','ALLOCATE ','2009-02-23 00:00:00.0000000' UNION ALL
SELECT '27429','2121498','860729','ALLOCATE ','2011-01-31 00:00:00.0000000' UNION ALL
SELECT '27429','2688764','860729','CLOS ','2013-08-16 00:00:00.0000000'

--===== Set the identity insert back to normal
SET IDENTITY_INSERT ChildReferralAction OFF


Fully tested... Again sorry :)
Post #1535864
Posted Wednesday, January 29, 2014 6:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:12 AM
Points: 6,783, Visits: 12,893
Msg 8106, Level 16, State 1, Line 5
Table 'ChildReferrals' does not have the identity property. Cannot perform SET operation.

Jon - I suspect you will learn as much from this exercise as you will from having the primary problem solved


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1535869
Posted Wednesday, January 29, 2014 6:32 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:55 PM
Points: 41,570, Visits: 34,495
jsayerweb (1/29/2014)
Fully tested... Again sorry :)


Msg 8106, Level 16, State 1, Line 5
Table 'ChildReferrals' does not have the identity property. Cannot perform SET operation.

Msg 8106, Level 16, State 1, Line 19
Table 'ChildDetails' does not have the identity property. Cannot perform SET operation.

Msg 8106, Level 16, State 1, Line 29
Table 'ChildReferralAction' does not have the identity property. Cannot perform SET operation.



This runs without error:

/****Child Table ****/

/****** Object: Table [dbo].[ChildDetails] Script Date: 01/29/2014 08:21:30 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ChildDetails]') AND type in (N'U'))
DROP TABLE [dbo].[ChildDetails]
GO

/****** Object: Table [dbo].[ChildDetails] Script Date: 01/29/2014 08:21:30 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ChildDetails](
[PER_ID] [numeric](8, 0) NULL,
[NAM_TITLE] [varchar](10) NULL,
[NAM_FORE1] [varchar](35) NULL,
[NAM_SURNAME] [varchar](35) NULL,
[PER_DOB] [datetime] NULL,
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

/****Referral Table ****/

/****** Object: Table [dbo].[ChildReferrals] Script Date: 01/29/2014 08:22:27 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ChildReferrals]') AND type in (N'U'))
DROP TABLE [dbo].[ChildReferrals]
GO

/****** Object: Table [dbo].[ChildReferrals] Script Date: 01/29/2014 08:22:27 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ChildReferrals](
[CLI_PER_ID] [numeric](8, 0) NULL,
[REF_ID] [numeric](8, 0) NULL,
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

/****Referral Action Table ****/

/****** Object: Table [dbo].[ChildReferralAction] Script Date: 01/29/2014 08:22:51 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ChildReferralAction]') AND type in (N'U'))
DROP TABLE [dbo].[ChildReferralAction]
GO

/****** Object: Table [dbo].[ChildReferralAction] Script Date: 01/29/2014 08:22:51 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ChildReferralAction](
[CLI_PER_ID] [numeric](8, 0) NULL,
[RAC_ID] [numeric](8, 0) NULL,
[RAC_REF_ID] [numeric](8, 0) NULL,
[RAC_TYPE] [varchar](10) NULL,
[RAC_DATE] [datetime2](7) NULL,
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

/****Populate Referral Action Table ****/

--===== Insert the test data into the test table
INSERT INTO ChildReferrals

(CLI_PER_ID,REF_ID)
SELECT '27429','619' UNION ALL
SELECT '27429','620' UNION ALL
SELECT '27429','621' UNION ALL
SELECT '27429','622' UNION ALL
SELECT '27429','624' UNION ALL
SELECT '27429','860729'


/****Populate Child Table ****/

--===== Insert the test data into the test table
INSERT INTO ChildDetails

(PER_ID,NAM_TITLE,NAM_FORE1,NAM_SURNAME,PER_DOB)
SELECT '27429','MR','ROBERT','OAKES','Jul 6 1956 12:00AM'



/****Populate Referral Action ****/

--===== Insert the test data into the test table
INSERT INTO ChildReferralAction

(CLI_PER_ID,RAC_ID,RAC_REF_ID,RAC_TYPE,RAC_DATE)
SELECT '27429','719','619','ALLOCATE ','1990-03-22 00:00:00.0000000' UNION ALL
SELECT '27429','720','619','CLOS ','1999-06-03 00:00:00.0000000' UNION ALL
SELECT '27429','721','620','ALLOCATE ','1988-07-04 00:00:00.0000000' UNION ALL
SELECT '27429','722','620','CLOS ','1990-03-22 00:00:00.0000000' UNION ALL
SELECT '27429','723','621','ALLOCATE ','1991-11-14 00:00:00.0000000' UNION ALL
SELECT '27429','724','621','CLOS ','1999-04-14 00:00:00.0000000' UNION ALL
SELECT '27429','725','622','ALLOCATE ','1999-04-14 00:00:00.0000000' UNION ALL
SELECT '27429','726','622','CLOS ','2000-10-10 00:00:00.0000000' UNION ALL
SELECT '27429','729','624','ALLOCATE ','2001-04-25 00:00:00.0000000' UNION ALL
SELECT '27429','730','624','CLOS ','2002-06-17 00:00:00.0000000' UNION ALL
SELECT '27429','1392816','860729','REQT ','2009-01-12 00:00:00.0000000' UNION ALL
SELECT '27429','1394845','860729','ACCT ','2009-01-12 00:00:00.0000000' UNION ALL
SELECT '27429','1397310','860729','ALLOCATE ','2009-01-13 00:00:00.0000000' UNION ALL
SELECT '27429','1443476','860729','ALLOCATE ','2009-02-23 00:00:00.0000000' UNION ALL
SELECT '27429','2121498','860729','ALLOCATE ','2011-01-31 00:00:00.0000000' UNION ALL
SELECT '27429','2688764','860729','CLOS ','2013-08-16 00:00:00.0000000'


Could you edit previous posts and wrap the commands on one of the code tags (see panel on the left)?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1535872
Posted Wednesday, January 29, 2014 6:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 06, 2014 2:48 AM
Points: 8, Visits: 13
Huge Learning curve...
I have got to start somewhere:

See below:

/****Child Table ****/

/****** Object: Table [dbo].[ChildDetails] Script Date: 01/29/2014 08:21:30 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ChildDetails2]') AND type in (N'U'))
DROP TABLE [dbo].[ChildDetails2]
GO

/****** Object: Table [dbo].[ChildDetails] Script Date: 01/29/2014 08:21:30 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ChildDetails2](
[PER_ID] [numeric](8, 0) NULL,
[NAM_TITLE] [varchar](10) NULL,
[NAM_FORE1] [varchar](35) NULL,
[NAM_SURNAME] [varchar](35) NULL,
[PER_DOB] [datetime] NULL,
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

/****Referral Table ****/

/****** Object: Table [dbo].[ChildReferrals] Script Date: 01/29/2014 08:22:27 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ChildReferrals2]') AND type in (N'U'))
DROP TABLE [dbo].[ChildReferrals2]
GO

/****** Object: Table [dbo].[ChildReferrals] Script Date: 01/29/2014 08:22:27 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ChildReferrals2](
[CLI_PER_ID] [numeric](8, 0) NULL,
[REF_ID] [numeric](8, 0) NULL,
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

/****Referral Action Table ****/

/****** Object: Table [dbo].[ChildReferralAction] Script Date: 01/29/2014 08:22:51 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ChildReferralAction2]') AND type in (N'U'))
DROP TABLE [dbo].[ChildReferralAction2]
GO

/****** Object: Table [dbo].[ChildReferralAction] Script Date: 01/29/2014 08:22:51 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ChildReferralAction2](
[CLI_PER_ID] [numeric](8, 0) NULL,
[RAC_ID] [numeric](8, 0) NULL,
[RAC_REF_ID] [numeric](8, 0) NULL,
[RAC_TYPE] [varchar](10) NULL,
[RAC_DATE] [datetime2](7) NULL,
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

/****Populate Referral Action Table ****/

--===== Insert the test data into the test table
INSERT INTO ChildReferrals2

(CLI_PER_ID,REF_ID)
SELECT '27429','619' UNION ALL
SELECT '27429','620' UNION ALL
SELECT '27429','621' UNION ALL
SELECT '27429','622' UNION ALL
SELECT '27429','624' UNION ALL
SELECT '27429','860729'


/****Populate Child Table ****/

--===== Insert the test data into the test table
INSERT INTO ChildDetails2

(PER_ID,NAM_TITLE,NAM_FORE1,NAM_SURNAME,PER_DOB)
SELECT '27429','MR','ROBERT','OAKES','Jul 6 1956 12:00AM'



/****Populate Referral Action ****/

--===== Insert the test data into the test table
INSERT INTO ChildReferralAction2

(CLI_PER_ID,RAC_ID,RAC_REF_ID,RAC_TYPE,RAC_DATE)
SELECT '27429','719','619','ALLOCATE ','1990-03-22 00:00:00.0000000' UNION ALL
SELECT '27429','720','619','CLOS ','1999-06-03 00:00:00.0000000' UNION ALL
SELECT '27429','721','620','ALLOCATE ','1988-07-04 00:00:00.0000000' UNION ALL
SELECT '27429','722','620','CLOS ','1990-03-22 00:00:00.0000000' UNION ALL
SELECT '27429','723','621','ALLOCATE ','1991-11-14 00:00:00.0000000' UNION ALL
SELECT '27429','724','621','CLOS ','1999-04-14 00:00:00.0000000' UNION ALL
SELECT '27429','725','622','ALLOCATE ','1999-04-14 00:00:00.0000000' UNION ALL
SELECT '27429','726','622','CLOS ','2000-10-10 00:00:00.0000000' UNION ALL
SELECT '27429','729','624','ALLOCATE ','2001-04-25 00:00:00.0000000' UNION ALL
SELECT '27429','730','624','CLOS ','2002-06-17 00:00:00.0000000' UNION ALL
SELECT '27429','1392816','860729','REQT ','2009-01-12 00:00:00.0000000' UNION ALL
SELECT '27429','1394845','860729','ACCT ','2009-01-12 00:00:00.0000000' UNION ALL
SELECT '27429','1397310','860729','ALLOCATE ','2009-01-13 00:00:00.0000000' UNION ALL
SELECT '27429','1443476','860729','ALLOCATE ','2009-02-23 00:00:00.0000000' UNION ALL
SELECT '27429','2121498','860729','ALLOCATE ','2011-01-31 00:00:00.0000000' UNION ALL
SELECT '27429','2688764','860729','CLOS ','2013-08-16 00:00:00.0000000'

Post #1535879
Posted Wednesday, January 29, 2014 7:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:12 AM
Points: 6,783, Visits: 12,893
Using Gail's script:

/*
I need to get the list of referrals, per client, in chronological order using the dates from the referralaction table.
A allocations status will be given once a referral is open.
A status of NFA or Closed means that referral is closed.
A client can have many referrals, i need to identify the current one and have the others with their open and closed dates.
I have tried pivoting the data and just cannot get it to work due to the various dates following on.
*/

-- Have a look at the data
SELECT
cd.*, '#' '#',
cr.*, '#' '#',
x.*
FROM dbo.ChildDetails cd
INNER JOIN dbo.ChildReferrals cr
ON cr.CLI_PER_ID = cd.PER_ID
CROSS APPLY (
SELECT *
FROM dbo.ChildReferralAction cra
WHERE cra.CLI_PER_ID = cr.CLI_PER_ID
AND cra.RAC_REF_ID = cr.REF_ID
) x
ORDER BY cd.PER_ID

-- possible solution
SELECT
cd.*, '#' '#',
cr.*, '#' '#',
x.*
FROM dbo.ChildDetails cd
INNER JOIN dbo.ChildReferrals cr
ON cr.CLI_PER_ID = cd.PER_ID
CROSS APPLY (
SELECT
[OpenDate] = MAX(CASE WHEN RAC_TYPE = 'ALLOCATE' THEN RAC_DATE ELSE NULL END),
[CloseDate] = MAX(CASE WHEN RAC_TYPE IN ('CLOS', 'NFA') THEN RAC_DATE ELSE NULL END)
FROM dbo.ChildReferralAction cra
WHERE cra.CLI_PER_ID = cr.CLI_PER_ID
AND cra.RAC_REF_ID = cr.REF_ID
) x
ORDER BY cd.PER_ID, x.CloseDate



“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1535895
Posted Wednesday, January 29, 2014 10:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 06, 2014 2:48 AM
Points: 8, Visits: 13
Hello,

Thankyou for the bottom solution, it seems to work well, there are just a few instances were there is still a null start date and null end date. Its turns out that only a status of 'nfa' can be applied therefore closing the referal thus giving us no start date to play with. We can how ever use a field in the referral table 'refstartdate' as the start date?
Could this be built into the query suggested?
and just focus on the end date issue?

Cheers
Jon
Post #1536010
Posted Thursday, January 30, 2014 1:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:12 AM
Points: 6,783, Visits: 12,893
jsayerweb (1/29/2014)
Hello,

Thankyou for the bottom solution, it seems to work well, there are just a few instances were there is still a null start date and null end date. Its turns out that only a status of 'nfa' can be applied therefore closing the referal thus giving us no start date to play with. We can how ever use a field in the referral table 'refstartdate' as the start date?
Could this be built into the query suggested?
and just focus on the end date issue?

Cheers
Jon


Hi Jon

Can you modify the sample data to reflect this please? Use Gail's cut and add a few extra rows. If you can set up a table of expected results too please, that would be very helpful.


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1536195
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse