INSERT INTO Client_Page_Stats(
PageID,
ViewDate)
VALUES (
3,
#CreateODBCDateTime(TodaysDate)#)
SELECT Distinct(City)
FROM RIUnitListings
WHERE OrgID = 3 AND Active = 2
SELECT DISTINCT RIUnitListings.Bedrooms, RIBedrooms.BedroomText
FROM (RIUnitListings
INNER JOIN RIBedrooms
ON RIBedrooms.BedroomID = RIUnitListings.Bedrooms)
WHERE RIUnitListings.OrgID = 3 AND RIUnitListings.Active = 2
SELECT RIUnitListings.ListingID, RIUnitListings.City, RIUnitListings.UnitType, RIUnitListings.ComplexID, RIUnitListings.Available, RIUnitListings.RIActive, RIUnitListings.Bedrooms, RIUnitListings.Rent, RIUnitListings.SquareFt, RIBathrooms.BathroomText, RIBedrooms.BedroomText, RIBathrooms.BathroomText, RILeases.LeaseText, RIUnitTypes.UnitTypeText,
RIUnitListings.Dog, RIUnitListings.Cat, RIUnitListings.Caged, RIComplexes.Dog AS CDog, RIComplexes.Cat AS CCat, RIComplexes.Caged AS CCaged,
(SELECT Count(*)
FROM Unit_Images
WHERE Unit_Images.ListingID = RIUnitListings.ListingID) AS TotalImages,
(SELECT Count(*)
FROM Unit_VirtualTours
WHERE Unit_VirtualTours.ListingID = RIUnitListings.ListingID) AS TotalVTs,
(SELECT Count(*)
FROM Unit_FloorPlans
WHERE Unit_FloorPlans.ListingID = RIUnitListings.ListingID) AS TotalFPs
FROM (RIUnitListings
INNER JOIN RIBedrooms
ON RIBedrooms.BedroomID = RIUnitListings.Bedrooms)
INNER JOIN RILeases
ON RILeases.LeaseID = RIUnitListings.Lease
INNER JOIN RIBathrooms
ON RIBathrooms.BathroomID = RIUnitListings.Bathrooms
INNER JOIN RIUnitTypes
ON RIUnitTypes.UnitTypeID = RIUnitListings.UnitType
LEFT OUTER JOIN RIComplexes
ON RIComplexes.ComplexID = RIUnitListings.ComplexID
WHERE RIUnitListings.OrgID = 3 AND RIUnitListings.Active = 2 AND RIUnitListings.Bedrooms = #Form.BedroomStart#
AND (RIUnitListings.Cat = 1 OR RIComplexes.Cat = 1) AND (RIUnitListings.Caged = 1 OR RIComplexes.Caged = 1)
AND (RIUnitListings.Dog = 1 OR RIComplexes.Dog = 1)
ORDER BY RIUnitListings.Rent asc, RIUnitListings.Available asc
SELECT RIUnitListings.ListingID, RIUnitListings.City, RIUnitListings.UnitType, RIUnitListings.ComplexID, RIUnitListings.Available, RIUnitListings.RIActive, RIUnitListings.Bedrooms, RIUnitListings.Rent, RIBathrooms.BathroomText, RIUnitListings.SquareFt, RIBedrooms.BedroomText, RILeases.LeaseText, RIUnitTypes.UnitTypeText,
RIUnitListings.Dog, RIUnitListings.Cat, RIUnitListings.Caged, RIComplexes.Dog AS CDog, RIComplexes.Cat AS CCat, RIComplexes.Caged AS CCaged,
(SELECT Count(*)
FROM Unit_Images
WHERE Unit_Images.ListingID = RIUnitListings.ListingID) AS TotalImages,
(SELECT Count(*)
FROM Unit_VirtualTours
WHERE Unit_VirtualTours.ListingID = RIUnitListings.ListingID) AS TotalVTs,
(SELECT Count(*)
FROM Unit_FloorPlans
WHERE Unit_FloorPlans.ListingID = RIUnitListings.ListingID) AS TotalFPs
FROM (RIUnitListings
INNER JOIN RIBedrooms
ON RIBedrooms.BedroomID = RIUnitListings.Bedrooms)
INNER JOIN RILeases
ON RILeases.LeaseID = RIUnitListings.Lease
INNER JOIN RIBathrooms
ON RIBathrooms.BathroomID = RIUnitListings.Bathrooms
INNER JOIN RIUnitTypes
ON RIUnitTypes.UnitTypeID = RIUnitListings.UnitType
LEFT OUTER JOIN RIComplexes
ON RIComplexes.ComplexID = RIUnitListings.ComplexID
WHERE RIUnitListings.OrgID = 3 AND RIUnitListings.Active = 2 AND RIUnitListings.Bedrooms = #Form.Bedrooms#AND (RIUnitListings.Cat = 1 OR RIComplexes.Cat = 1) AND (RIUnitListings.Caged = 1 OR RIComplexes.Caged = 1)
AND (RIUnitListings.Dog = 1 OR RIComplexes.Dog = 1)
ORDER BY RIUnitListings.Rent asc, RIUnitListings.Available asc