Hi,
I'm just wondering if someone can help me with some SQL syntax stuff.I want to take this sql statement:
"SELECT TOP 50 tblProfile.chName, tblProfile.intCount FROM tblProfile, tblLinks WHERE (tblLinks.MemberID = tblProfile.MemberID) ORDER BY tblLinks.dtDateAdded DESC;"
and select only unique "chName's" records
I have a table contains information related to sales:
SO number Order Date Customer SellingPerson
1001 2012/07/02 ABC Andy
1002 2012/07/02 XYZ Alan
1003 2012/07/02 EFG Almelia
1004 2012/07/02 ABC John
1005 2012/07/02 XYZ Oliver
1006 2012/07/02 HIJ Dorthy
1007 2012/07/02 KLM Andy
1008 2012/07/02 NOP Rowan
1009 2012/07/02 QRS David
1010 2012/07/02 ABC Joey
Now, i want to write a query using CTE that gives me first five distinct customer in result set:
SO number Order Date Customer SellingPerson
1001 2012/07/02 ABC Andy
1002 2012/07/02 XYZ Alan
1003 2012/07/02 EFG Almelia
1006 2012/07/02 HIJ Dorthy
1007 2012/07/02 KLM Andy
I wrote this query :
With t(so_number,order date,customer, SellingPerson)
as
(select top 5 so_number,order date,customer, SellingPerson from t)
select distinct billingcontactperson from t order by so_id
And getting this error:
Msg 252, Level 16, State 1, Line 1
Recursive common table expression 't' does not contain a top-level UNION ALL operator.
Good day,
I have a table of approximately 10 million rows. The table has 3 field making up the key, namely:
ID, Date, Program
I need to extract all the distinct Program's from the table.
I have don so with:
Select distinct Program from table
This unfortunately takes roughly 2 minutes which is far to long. Is there something I can do to help speed this process up?
Thanks in advance.
I have the following Table:DataIDuserIDTimeStampI need to create a query that selects the "newest" records for all distinct users. I'm hoping to get this done in one query. I know I could write multiple queries to find all distinct users, and then the newest records based on that... and so on... but I'm not sure that's the most efficient. I have the following so far, but is it the most efficient (I have indexing on most of my columns)? SELECT DATA.DataID, DATA.UserID, UN.vchName, UN.vchImage, U.vchFirstName + ' ' + U.vchLastName AS 'FullName' FROM [tblData] DATA INNER JOIN [tblUnits] UN ON DATA.UserID = Un.UserID INNER JOIN [tblusers] U ON U.UserID = UN.UserID WHERE GPS.intGPSDataID IN (SELECT MAX([tbLData].DataID) FROM [tbLData] GROUP BY [tbLData].UserID)
View 4 Replies View Relatedhi, I have a table that contains 11,169,000 rows that was downloaded from the main frame. There are alot of duplicate records in that table. I ran a query select * from tbl.... it still running and running and running ... it never stoped.... what seems to be the problem.... There are no primary keys or index in that table...
so my question , how would I deal with such table ... I want to run certain reports from that table and it seems that all my attempts failed? anyone can help
Hi, This is quite an obvious problem, but for some reason I can't think through the solution. I have two columns, a datetime (datecreated) and an id (FK) othertableid (id)what I would like to be able to do is select a list of id and datecreated, but only chose the latest row for each id.So I guess it's a bit like a distinct on the id column, but ensuring the date returned is the top date. Please help
View 1 Replies View RelatedI know "select distinct ProductId from Product " selects one product only one time how can i apply the same logic in a query like give bellow SELECT I.QuoteRequestItemId, I.ProductId ,P.StorePartNumber from QuoteRequestItem I left join Product P on I.ProductId = P.ProductId ie product with same productId should be considered only oncethere should not be more than one row with same productId
View 2 Replies View RelatedHi,
I want to select the 8 most saled products from large orders table... the problem is that when i use the "distinct" sentence (something like this- "SELECT TOP 8 distinct id, products, productid FROM tbl_orders ORDER BY id") I get back the distinct of any columns.... (and any ID is distinct, of course), but if i don't include the id's in the distinct sentence, i can't order by id's.
can i get the last orders, only by distinct product, and not by distinct id, and order them by the id's?
I have an SQL statement that looks like the following:
SELECT [Docs-Entities].entityID, entityName, COUNT([Docs-DocsEntities].filename) AS numDocs
FROM [Docs-Entities] LEFT JOIN [Docs-DocsEntities]
ON [Docs-Entities].entityID = [Docs-DocsEntities].entityID
GROUP BY [Docs-Entities].entityID, entityName
but the problem is that numDocs (the COUNT) is not returning a distinct count. In the DocEntities table, a particular document can actually have multiple entries with the same entityID so that produces inflated numbers for numDocs. But when I do a SELECT DISTINCT on a particular entityID, the results are less and don't match the numDocs number because I only need to list the document one time. This is not a huge issue, but it looks bad on my site.
Is there a way that I can make COUNT count distinctly?
Thanks for the help and I hope I worded that cllearly...
I am trying to append data from a source table to a destination table, the only difference between the tables is that a primary key has been established on the destination table. Problem is, the source table has a handful of duplicate values in the column that corresponds to primary on destination table; so when I run the query I get a primary key conflict. What I'd like to do is select distinct values from the source table to avoid the conflict, but am having trouble getting it to run. Here is the statement-
INSERT INTO cust_master
SELECT DISTINCT cust_master_temp.*
FROM cust_mast_temp LEFT OUTER JOIN
cust_master ON cust_master.temp.CUST_NUMBER = cust_master.CUST_NUMBER
Doesn't seem to be understanding "Distinct"
Any Ideas?
I have an action log table which records when a registrant record was viewed by a compnay employee. I have an sql query like this:
SELECT [ID]
,[RegistrantID]
,[EmployeeID]
,[UserID]
,[CompanyID]
[Code] ....
and data is like this:
IDRegistrantID EmployeeIDUserID CompanyID VacancyID Action ActionDate
17931629515163213NULL 42013-08-04 16:45:40.457
17921629215163213NULL 42013-08-04 16:45:33.003
1791NULL15163213NULL 32013-08-04 16:45:23.660
1790162959162893NULL 42013-08-04 16:45:09.543
[Code] ....
I want to select distinct views to a registrantid record ( the first ones) in one year. if a registrant was viewed 10 tmes a year then it will show only first time it was viewed. If it was viewed 10 times by an employeed in 2 years then it will show first time it was viewed. if it was viewed by 2 employees of same company 10 times in one year then it first time viewed record will be shown. if it was seen 10 times by 2 employees of two different companies in one year then first record of two companies will be shown. do i need to use group by or what ?
Hi, I think you can do this in oracle but I'm trying to figure a way to do it in ms sql.. I need to select a distinct combination of columns, like so...
select distinct(ItemName,ItemData,FID) from tblSIFups
Does anyone know how to achieve that? I have multiple data where I shouldn't and I don't have any control over the application so I need to clean it this way.
thanks, nicki
Hi All,
I'm a beginner in SQL and would like some help with writing a query that needs to:
a) Return the latest time that an event happened (along with the event), and also
b) Determine if this event occurred more than 30mins ago.
For example, Table EVENT consists of the following data:
EVENT DateTime,
A 16/1/08, 14:03:55
B 16/1/08, 14:30:27
A 16/1/08, 17:42:18
I would like the results for the first part of query to be:
EVENT DateTime,
A 16/1/08, 17:42:18
B 16/1/08, 14:30:27
I have tried creating a query based off this thread, but for some reason it kept complaining that the EVENT column in Table EVENT didn't exist.
For the part b), I have no clue as to what I should do apart from that I would need to use NOW().
Any help would be appreciated.
MonkeyMark
Hi guys,
Just trying to select a set of Articles from a SQL Server Database. The Articles all have a Category ID which is stored in another table (as an Article could be in more than one Category). I want to select the Top 3 Articles in a Category. At the moment I have as my SQL;
"SELECT TOP 3 f.ArticleID, f.Heading, f.Summary, f.WrittenDate, f.ArticleURL FROM feedTable f LEFT JOIN Categories c ON f.ArticleID = c.ArticleID WHERE c.CategoryID=" + CategoryID + " AND c.ArticleID<>" + id + " ORDER BY c.CategoryID"
Which seems to work to an extent in that I do get three articles in the same Category appearing. However, there are sometimes duplicates appearing, so I need to incorporate a DISTINCT clause to the above. I'm not sure where to put this in though. Any ideas?
Thanks.
I am trying to write a SQL DataSource Statement that will do the following:
Select the Distinct Dates, count up the number of rows with that date
So for example:
Date Number with that Date
12/12/2007 3
14/12/2007 2
Database:
12/12/2007 Content 1
14/12/2007 Content 2
12/12/2007 Content 3
14/12/2007 Content 4
12/12/2007 Content 5
I have 3 tables:
News:
bigint NewId
nvarchar NewTitle
datetime NewDate
nvarchar NewBrief
--------------------------
Category:
int CatId
nvarchar CatName
--------------------------
NewsRelCategory:
bigint Id
int CategoryIdFk
bigint NewsIdFk
--------------------------
I want to select NewId, NewDate and Distinct NewTitle
I tried this but NewTitle doesn't distinct:
SELECT
FROM dbo.Category INNER JOIN
NewsRelCategory ON dbo.Category.CatId = NewsRelCategory.NrcCategoryIdFk INNER JOIN
dbo.News ON NewsRelCategory.NrcNewsIdFk = dbo.News.NewId
I have a DB with the fields: Id, Date, Name, Status.
Now I want to select all distinct names with the most recent corresponding status.
With the SELECT DISTINCT Name, I get only one record per different name which is ok.
Now I want to add next to each different name, the most recent added status.
Can I combine those 2 in 1 query? I want to show them using PHP on a website.
Now I get a table with a row for each different name, but I can't add a second column where the most recent Status is showed for that name.
Greetings.I'm having a little trouble with a query. The idea is simple I need todisplay a list of recently unique visited URLs and the last time Ivisited.I have 2 table one stores the user and time/date and another has theURL.So all I need is the URL (no duplicates) and the last visit.Below is the SQL to create the tables and data to help with the query.Thank you for your help.CREATE TABLE [stat_hits] ([hit_id] [int] (1, 1) NOT NULL ,[hit_date] [datetime] NOT NULL CONSTRAINT [DF_stat_hits_hit_date]DEFAULT (getdate()),[user_id] [varchar] (12) NOT NULL ,[hit_ip] [varchar] (15) NOT NULL ,[shp_id] [int] NOT NULL ,CONSTRAINT [PK_stat_hits] PRIMARY KEY CLUSTERED([hit_id]) ON [PRIMARY]) ON [PRIMARY]GOCREATE TABLE [stat_hit_pages] ([shp_id] [int] (1, 1) NOT NULL ,[shp_url] [varchar] (1000) NULL ,[shp_count] [int] NULL ,CONSTRAINT [PK_stat_hit_pages] PRIMARY KEY CLUSTERED([shp_id]) ON [PRIMARY]) ON [PRIMARY]GOINSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37878,'2005-06-01 16:07:35','ADMIN','0.0.0.0',7323)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37877,'2005-06-01 16:07:13','ADMIN','0.0.0.0',7323)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37876,'2005-06-01 15:41:17','ADMIN','0.0.0.0',7339)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37875,'2005-06-01 15:41:03','ADMIN','0.0.0.0',7323)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37874,'2005-06-01 15:20:31','ADMIN','0.0.0.0',7330)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37873,'2005-06-01 15:20:28','ADMIN','0.0.0.0',7338)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37872,'2005-06-01 14:45:46','ADMIN','0.0.0.0',7338)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37871,'2005-06-01 14:35:51','ADMIN','0.0.0.0',7338)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37870,'2005-06-01 14:30:25','ADMIN','0.0.0.0',7338)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37869,'2005-06-01 14:28:28','ADMIN','0.0.0.0',7338)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37868,'2005-06-01 14:28:23','ADMIN','0.0.0.0',7325)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37867,'2005-06-01 14:28:17','ADMIN','0.0.0.0',7322)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37866,'2005-06-01 14:28:15','ADMIN','0.0.0.0',7321)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37861,'2005-06-01 14:27:09','ADMIN','0.0.0.0',7339)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37860,'2005-06-01 14:27:05','ADMIN','0.0.0.0',7323)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37859,'2005-06-01 14:26:59','ADMIN','0.0.0.0',7322)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37858,'2005-06-01 14:26:58','ADMIN','0.0.0.0',7321)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37853,'2005-06-01 14:25:59','ADMIN','0.0.0.0',7338)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37852,'2005-06-01 14:23:51','ADMIN','0.0.0.0',7338)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37851,'2005-06-01 13:58:49','ADMIN','0.0.0.0',7338)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37850,'2005-06-01 13:44:06','ADMIN','0.0.0.0',7330)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37849,'2005-06-01 13:44:04','ADMIN','0.0.0.0',7321)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37848,'2005-06-01 13:44:04','ADMIN','0.0.0.0',7340)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37847,'2005-06-01 13:43:58','ADMIN','0.0.0.0',7330)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37846,'2005-06-01 13:43:53','ADMIN','0.0.0.0',7338)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37845,'2005-06-01 13:26:29','ADMIN','0.0.0.0',7325)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37844,'2005-06-01 13:22:34','ADMIN','0.0.0.0',7338)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37843,'2005-06-01 13:22:29','ADMIN','0.0.0.0',7325)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37842,'2005-06-01 13:21:15','ADMIN','0.0.0.0',7338)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37841,'2005-06-01 13:19:17','ADMIN','0.0.0.0',7338)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37840,'2005-06-01 13:17:20','ADMIN','0.0.0.0',7321)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37839,'2005-06-01 13:17:20','ADMIN','0.0.0.0',7320)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37838,'2005-06-01 11:55:15','ADMIN','0.0.0.0',7339)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37837,'2005-06-01 11:55:09','ADMIN','0.0.0.0',7323)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37836,'2005-06-01 11:53:08','ADMIN','0.0.0.0',7338)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37835,'2005-06-01 11:53:01','ADMIN','0.0.0.0',7325)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37834,'2005-06-01 11:34:34','ADMIN','0.0.0.0',7337)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37833,'2005-06-01 11:34:24','ADMIN','0.0.0.0',7336)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37832,'2005-06-01 11:02:59','ADMIN','0.0.0.0',7335)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37831,'2005-06-01 11:02:53','ADMIN','0.0.0.0',7334)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37830,'2005-06-01 11:02:46','ADMIN','0.0.0.0',7324)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37829,'2005-06-01 11:02:40','ADMIN','0.0.0.0',7333)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37828,'2005-06-01 11:02:31','ADMIN','0.0.0.0',7332)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37827,'2005-06-01 11:02:25','ADMIN','0.0.0.0',7323)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37826,'2005-06-01 11:02:21','ADMIN','0.0.0.0',7331)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37825,'2005-06-01 11:02:12','ADMIN','0.0.0.0',7323)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37824,'2005-06-01 11:01:23','ADMIN','0.0.0.0',7330)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37823,'2005-06-01 11:01:21','ADMIN','0.0.0.0',7328)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37822,'2005-06-01 11:01:20','ADMIN','0.0.0.0',7327)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37821,'2005-06-01 10:58:23','ADMIN','0.0.0.0',7330)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37820,'2005-06-01 10:58:10','ADMIN','0.0.0.0',7328)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37819,'2005-06-01 10:58:09','ADMIN','0.0.0.0',7327)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37818,'2005-06-01 10:55:27','ADMIN','0.0.0.0',7326)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37817,'2005-06-01 10:55:23','ADMIN','0.0.0.0',7325)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37816,'2005-06-01 10:55:17','ADMIN','0.0.0.0',7322)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37815,'2005-06-01 10:55:16','ADMIN','0.0.0.0',7321)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37810,'2005-06-01 10:54:20','ADMIN','0.0.0.0',7330)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37809,'2005-06-01 10:54:12','ADMIN','0.0.0.0',7329)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37808,'2005-06-01 10:51:30','ADMIN','0.0.0.0',7328)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37807,'2005-06-01 10:51:29','ADMIN','0.0.0.0',7327)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37806,'2005-06-01 10:51:10','ADMIN','0.0.0.0',7328)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37805,'2005-06-01 10:51:09','ADMIN','0.0.0.0',7327)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37804,'2005-06-01 10:35:46','ADMIN','0.0.0.0',7326)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37803,'2005-06-01 10:35:41','ADMIN','0.0.0.0',7325)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37802,'2005-06-01 10:35:29','ADMIN','0.0.0.0',7323)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37801,'2005-06-01 10:35:21','ADMIN','0.0.0.0',7321)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37800,'2005-06-01 10:35:20','ADMIN','0.0.0.0',7320)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37799,'2005-06-01 10:33:58','ADMIN','0.0.0.0',7321)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37798,'2005-06-01 10:33:50','ADMIN','0.0.0.0',7328)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37797,'2005-06-01 10:33:50','ADMIN','0.0.0.0',7327)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37796,'2005-06-01 10:33:09','ADMIN','0.0.0.0',7326)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37795,'2005-06-01 10:33:05','ADMIN','0.0.0.0',7325)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37794,'2005-06-01 10:32:45','ADMIN','0.0.0.0',7324)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37793,'2005-06-01 10:32:18','ADMIN','0.0.0.0',7323)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37792,'2005-06-01 10:31:47','ADMIN','0.0.0.0',7322)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37791,'2005-06-01 10:31:31','ADMIN','0.0.0.0',7321)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37790,'2005-06-01 10:31:31','ADMIN','0.0.0.0',7320)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37789,'2005-06-01 10:30:04','ADMIN','0.0.0.0',7320)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37788,'2005-05-31 20:49:56','ADMIN','0.0.0.0',7311)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37787,'2005-05-31 20:49:54','ADMIN','0.0.0.0',5942)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37786,'2005-05-31 20:49:54','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37785,'2005-05-31 20:49:02','ADMIN','0.0.0.0',5942)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37784,'2005-05-31 20:48:54','ADMIN','0.0.0.0',7311)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37783,'2005-05-31 20:48:53','ADMIN','0.0.0.0',5942)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37782,'2005-05-31 20:48:52','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37781,'2005-05-31 20:48:41','ADMIN','0.0.0.0',5941)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37780,'2005-05-31 20:48:37','ADMIN','0.0.0.0',215)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37779,'2005-05-31 20:48:30','ADMIN','0.0.0.0',4)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37775,'2005-05-31 20:46:44','ADMIN','0.0.0.0',7311)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37774,'2005-05-31 20:46:40','ADMIN','0.0.0.0',7319)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37773,'2005-05-31 20:46:39','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37772,'2005-05-31 20:46:12','ADMIN','0.0.0.0',7311)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37771,'2005-05-31 20:46:09','ADMIN','0.0.0.0',7319)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37770,'2005-05-31 20:46:08','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37769,'2005-05-31 20:45:55','ADMIN','0.0.0.0',7311)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37768,'2005-05-31 20:45:52','ADMIN','0.0.0.0',7319)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37767,'2005-05-31 20:45:51','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37766,'2005-05-31 20:45:33','ADMIN','0.0.0.0',7311)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37765,'2005-05-31 20:45:29','ADMIN','0.0.0.0',7319)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37764,'2005-05-31 20:45:29','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37763,'2005-05-31 20:45:28','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37762,'2005-05-31 20:44:52','ADMIN','0.0.0.0',7311)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37761,'2005-05-31 20:44:48','ADMIN','0.0.0.0',7319)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37760,'2005-05-31 20:44:47','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37759,'2005-05-31 20:44:23','ADMIN','0.0.0.0',7311)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37758,'2005-05-31 20:44:18','ADMIN','0.0.0.0',7319)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37757,'2005-05-31 20:44:18','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37756,'2005-05-31 20:43:50','ADMIN','0.0.0.0',6258)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37755,'2005-05-31 20:43:41','ADMIN','0.0.0.0',7311)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37754,'2005-05-31 20:43:37','ADMIN','0.0.0.0',7318)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37753,'2005-05-31 20:43:36','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37752,'2005-05-31 20:43:31','ADMIN','0.0.0.0',7317)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37751,'2005-05-31 20:43:16','ADMIN','0.0.0.0',7311)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37750,'2005-05-31 20:43:10','ADMIN','0.0.0.0',6684)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37749,'2005-05-31 20:43:10','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37748,'2005-05-31 20:40:04','ADMIN','0.0.0.0',7318)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37747,'2005-05-31 20:40:00','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37746,'2005-05-31 20:39:52','ADMIN','0.0.0.0',7317)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37745,'2005-05-31 20:39:24','ADMIN','0.0.0.0',7316)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37744,'2005-05-31 20:39:23','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37743,'2005-05-31 20:35:56','ADMIN','0.0.0.0',7315)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37742,'2005-05-31 20:35:43','ADMIN','0.0.0.0',7311)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37741,'2005-05-31 20:34:17','ADMIN','0.0.0.0',7314)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37740,'2005-05-31 20:34:17','ADMIN','0.0.0.0',1449)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37739,'2005-05-31 20:34:01','ADMIN','0.0.0.0',7313)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37738,'2005-05-31 20:33:54','ADMIN','0.0.0.0',7312)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37737,'2005-05-31 20:12:57','ADMIN','0.0.0.0',6681)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37736,'2005-05-31 20:09:40','ADMIN','0.0.0.0',6681)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37735,'2005-05-31 20:09:33','ADMIN','0.0.0.0',6258)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37734,'2005-05-31 20:09:03','ADMIN','0.0.0.0',6681)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37733,'2005-05-31 20:08:49','ADMIN','0.0.0.0',7289)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37732,'2005-05-31 20:08:44','ADMIN','0.0.0.0',6254)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37731,'2005-05-31 20:08:42','ADMIN','0.0.0.0',3443)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37730,'2005-05-31 20:08:40','ADMIN','0.0.0.0',7282)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37729,'2005-05-31 20:08:32','ADMIN','0.0.0.0',5983)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37728,'2005-05-31 20:08:24','ADMIN','0.0.0.0',6960)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37727,'2005-05-31 20:08:22','ADMIN','0.0.0.0',5918)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37726,'2005-05-31 20:08:18','ADMIN','0.0.0.0',25)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37725,'2005-05-31 20:08:15','ADMIN','0.0.0.0',5740)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37724,'2005-05-31 20:08:11','ADMIN','0.0.0.0',4)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37723,'2005-05-31 20:08:09','ADMIN','0.0.0.0',3)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37720,'2005-05-31 20:08:03','ADMIN','0.0.0.0',4)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37617,'2005-05-31 18:51:08','ADMIN','0.0.0.0',7290)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37615,'2005-05-31 18:51:00','ADMIN','0.0.0.0',7289)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37598,'2005-05-31 18:48:08','ADMIN','0.0.0.0',7282)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37597,'2005-05-31 18:48:04','ADMIN','0.0.0.0',6103)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37596,'2005-05-31 18:48:03','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37595,'2005-05-31 18:47:21','ADMIN','0.0.0.0',7282)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37594,'2005-05-31 18:47:12','ADMIN','0.0.0.0',6960)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37593,'2005-05-31 18:47:09','ADMIN','0.0.0.0',5918)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37592,'2005-05-31 18:47:02','ADMIN','0.0.0.0',5740)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37590,'2005-05-31 18:46:59','ADMIN','0.0.0.0',6587)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37583,'2005-05-31 18:46:40','ADMIN','0.0.0.0',9)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37582,'2005-05-31 18:46:31','ADMIN','0.0.0.0',1691)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37580,'2005-05-31 18:46:18','ADMIN','0.0.0.0',9)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37576,'2005-05-31 18:46:04','ADMIN','0.0.0.0',6979)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37575,'2005-05-31 18:46:02','ADMIN','0.0.0.0',5942)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37574,'2005-05-31 18:46:01','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37569,'2005-05-31 18:45:24','ADMIN','0.0.0.0',6979)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37568,'2005-05-31 18:45:16','ADMIN','0.0.0.0',6103)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37567,'2005-05-31 18:45:16','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37563,'2005-05-31 18:44:07','ADMIN','0.0.0.0',6979)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37562,'2005-05-31 18:44:05','ADMIN','0.0.0.0',6103)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37561,'2005-05-31 18:44:04','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37545,'2005-05-31 18:40:30','ADMIN','0.0.0.0',6979)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37544,'2005-05-31 18:40:30','ADMIN','0.0.0.0',6103)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37543,'2005-05-31 18:40:12','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37536,'2005-05-31 18:34:19','ADMIN','0.0.0.0',6979)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37535,'2005-05-31 18:34:15','ADMIN','0.0.0.0',6103)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37534,'2005-05-31 18:34:14','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37532,'2005-05-31 18:27:02','ADMIN','0.0.0.0',6979)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37531,'2005-05-31 18:27:00','ADMIN','0.0.0.0',6103)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37530,'2005-05-31 18:27:00','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37518,'2005-05-31 18:00:34','ADMIN','0.0.0.0',6979)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37517,'2005-05-31 18:00:31','ADMIN','0.0.0.0',6103)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37516,'2005-05-31 18:00:31','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37515,'2005-05-31 17:59:41','ADMIN','0.0.0.0',6979)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37514,'2005-05-31 17:59:37','ADMIN','0.0.0.0',6103)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37513,'2005-05-31 17:59:37','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37512,'2005-05-31 17:59:01','ADMIN','0.0.0.0',6979)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37511,'2005-05-31 17:58:58','ADMIN','0.0.0.0',6103)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37510,'2005-05-31 17:58:57','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37509,'2005-05-31 17:56:16','ADMIN','0.0.0.0',6610)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37508,'2005-05-31 17:56:07','ADMIN','0.0.0.0',6989)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37507,'2005-05-31 17:56:01','ADMIN','0.0.0.0',6610)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37506,'2005-05-31 17:55:56','ADMIN','0.0.0.0',7271)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37505,'2005-05-31 17:55:52','ADMIN','0.0.0.0',7199)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37504,'2005-05-31 17:55:43','ADMIN','0.0.0.0',7271)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37503,'2005-05-31 17:55:41','ADMIN','0.0.0.0',7199)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37502,'2005-05-31 17:53:57','ADMIN','0.0.0.0',7269)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37501,'2005-05-31 17:53:44','ADMIN','0.0.0.0',6979)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37500,'2005-05-31 17:53:40','ADMIN','0.0.0.0',6103)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37499,'2005-05-31 17:53:40','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37498,'2005-05-31 17:52:18','ADMIN','0.0.0.0',7269)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37497,'2005-05-31 17:52:06','ADMIN','0.0.0.0',7271)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37496,'2005-05-31 17:51:28','ADMIN','0.0.0.0',6979)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37495,'2005-05-31 17:51:22','ADMIN','0.0.0.0',6103)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37494,'2005-05-31 17:51:22','ADMIN','0.0.0.0',31)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37493,'2005-05-31 17:51:01','ADMIN','0.0.0.0',6979)INSERT INTO [stat_hits]([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES(37492,'2005-05-31 17:50:57','ADMIN','0.0.0.0',6103)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(3,'/scripts/iMenu.asp?_Ref=450493&_XID=40000000&ParentID=',2245)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(4,'/scripts/objects/MyZBF.asp?_XID=19999900&_Ref=450493&_Ref2=',2917)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7329,'/scripts/objects/list.asp?_XID=70000005&_Ref=1398186089&_reset=true&_table=2002000&|MenuID=40000000',0)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7330,'/scripts/objects/edit.asp?_XID=70000005&_Ref=1398186089&_table=2002000&_item=ADAMDOUG',5)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7331,'/scripts/objects/edit.asp?_XID=70000028&_Ref=1398186089&_table=1002009&_item=225000000',0)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7332,'/scripts/objects/edit.asp?_XID=70000028&_Ref=1398186089&_table=1002009&_item=215000000',0)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7333,'/scripts/objects/list.asp?_XID=70000028&_Ref=1398186089&_table=1002009&',0)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7334,'/scripts/objects/list.asp?_XID=70000028&_Ref=1398186089&_table=1001000&_parenturl=1',0)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7335,'/scripts/objects/edit.asp?_XID=70000028&_Ref=1398186089&_table=1001000&_item=1002009&_parenturl=1',0)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7336,'/scripts/objects/edit.asp?_XID=70000028&_Ref=1398186089&_table=1001054&_item=1000006&_parenturl=3',0)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7337,'/scripts/objects/edit.asp?_xid=70000028&_ref=1398186089&_table=1001054&&_parenturl=3',0)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7338,'/scripts/objects/navigator.asp?_xid=70000030&_ref=1398186089',12)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7339,'/scripts/objects/navigator.asp?_xid=70000028&_ref=1398186089',2)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7340,'/scripts/iKnow.asp?_ref=1398186089&_deep=http%3A//ZBFw2kdev01/scripts/objects/edit.asp%3F_XID%3D70000005%26_Ref%3D1398186089%26_ table%3D2002000%26_item%3DADAMDOUG',0)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(9,'/scripts/objects/list.asp?_XID=70000052&_Ref=450493&_reset=true&_table=215000001&|MenuID=40000000',1532)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(25,'/scripts/objects/list.asp?_XID=70000028&_Ref=450493&_reset=true&_table=1002009&|MenuID=40000000',144)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(31,'/scripts/objects/save.asp?',3986)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(215,'/scripts/objects/list.asp?_XID=70000030&_Ref=450493&_reset=true&_table=3001062&|MenuID=40000000',138)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(1449,'/scripts/objects/mappings.asp?',17)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(1691,'/scripts/objects/edit.asp?_XID=70000052&_Ref=450493&_table=215000001&_item=11',26)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(3443,'/scripts/objects/list.asp?_XID=70000028&_Ref=450493&_table=1001000&_parenturl=2',16)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(5740,'/scripts/objects/consolemaster.asp?_XID=80000003&_Ref=450493&_reset=true&showall=false&page_id=215000002&|MenuID=40000000',177)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(5918,'/scripts/objects/consolemaster.asp?_XID=80000003&_Ref=450493&showall=false&mode=listitself&item=215000006&page_id=215000002',15)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(5941,'/scripts/objects/edit.asp?_XID=70000030&_Ref=450493&_table=3001062&_item=12',9)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(5942,'/scripts/objects/edit.asp?_XID=70000030&_Ref=450493&_table=3001062&_item=12&_formtab=&process=&step=&elem=',62)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(5983,'/scripts/objects/edit.asp?_XID=70000028&_Ref=450493&_table=1002009&_item=225000000',15)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(6103,'/scripts/objects/edit.asp?_XID=70000028&_Ref=450493&_table=1001002&_parenturl=3&_item=215000018&_formtab=&process=&step=&elem=',21)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(6254,'/scripts/objects/edit.asp?_XID=70000028&_Ref=450493&_table=1001000&_item=225000001&_parenturl=2',4)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(6258,'/scripts/objects/edit.asp?_XID=70000028&_Ref=450493&_table=1001000&_item=225000001&_parenturl=2&',4)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(6587,'/scripts/objects/consolemaster.asp?_XID=80000004&_Ref=450493&_reset=true&showall=false&page_id=215000003&|MenuID=40000000',81)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(6610,'/scripts/objects/consolemaster.asp?_XID=80000004&_Ref=450493&showall=false&page_id=215000003',88)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(6681,'/scripts/objects/edit.asp?_XID=70000028&_Ref=450493&_table=1001054&_item=225000175&_parenturl=4',3)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(6684,'/scripts/objects/edit.asp?_XID=70000028&_Ref=450493&_table=1001054&_parenturl=4&_item=225000175&_formtab=&process=&step=&elem=',7)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(6960,'/scripts/objects/edit.asp?_XID=80000003&_Ref=450493&_table=215000001&_item=68',3)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(6979,'/scripts/objects/edit.asp?_XID=70000052&_Ref=450493&_table=215000001&_item=161&process=215000001&step=215000003&elem=215000018',25)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(6989,'/scripts/objects/consolemaster.asp?_XID=80000004&_Ref=450493&showall=false&mode=drill&item=215000120&drill_id=215000005&page_id=215000003&group=1&desc=BTFG',54)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7199,'/scripts/objects/consolemaster.asp?_XID=80000004&_Ref=450493&showall=false&page_id=215000006',24)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7269,'/scripts/objects/consolemaster.asp?_XID=80000004&_Ref=450493&showall=false&page_id=215000010',3)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7271,'/scripts/objects/consolemaster.asp?_XID=80000004&_Ref=450493&showall=false&mode=listitself&item=215000200&page_id=215000006&group=1&desc=Operations%20Executive',3)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7282,'/scripts/objects/edit.asp?_XID=80000003&_Ref=450493&_table=215000001&_item=68&process=215000001&step=215000003&elem=215000018',2)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7289,'/scripts/objects/edit.asp?_xid=80000003&_ref=450493&_table=225000001&_item=75&_parenturl=1',1)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7290,'/scripts/objects/edit.asp?_xid=80000003&_ref=450493&_table=215000016&_item=86&_parenturl=1',0)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7311,'/scripts/objects/edit.asp?_XID=80000003&_Ref=450493&_table=225000001&_item=75',11)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7312,'/scripts/objects/showpopup.asp?_XID=80000003&_Ref=450493&_table=225000001&_item=75&destable=225000001&_mode=mappings&_seed=72528.66',0)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7313,'/scripts/objects/mappings.asp?_XID=80000003&_Ref=450493&_table=225000001&_item=75&destable=225000001&_mode=mappings&_seed=72528.66&_popup=true',0)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7314,'/scripts/objects/edit.asp?_XID=80000003&_Ref=450493&_table=225000001&_item=90&process=&step=&elem=',0)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7315,'/scripts/objects/edit.asp?_xid=80000003&_ref=450493&_table=225000001&_item=90',0)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7316,'/scripts/objects/edit.asp?_xid=80000003&_ref=450493&_table=225000001&_item=90&_formtab=0&process=&step=&elem=',0)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7317,'/scripts/objects/edit.asp?_xid=80000003&_ref=450493&_table=215000016&_item=86',1)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7318,'/scripts/objects/edit.asp?_xid=80000003&_ref=450493&_table=215000016&_item=86&_formtab=&process=&step=&elem=',1)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7319,'/scripts/objects/edit.asp?_XID=70000028&_Ref=450493&_table=1001000&_parenturl=2&_item=225000001&_formtab=&process=&step=&elem=',5)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7320,'/scripts/iknow.asp?_Ref=1398186089',6)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7321,'/scripts/iMenu.asp?_Ref=1398186089&_XID=40000000&ParentID=',10)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7322,'/scripts/objects/MyZBF.asp?_XID=19999900&_Ref=1398186089&_Ref2=',9)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7323,'/scripts/objects/list.asp?_XID=70000028&_Ref=1398186089&_reset=true&_table=1002009&|MenuID=40000000',8)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7324,'/scripts/objects/edit.asp?_XID=70000028&_Ref=1398186089&_table=1002009&_item=1000001',1)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7325,'/scripts/objects/list.asp?_XID=70000030&_Ref=1398186089&_reset=true&_table=3001062&|MenuID=40000000',6)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7326,'/scripts/objects/edit.asp?_XID=70000030&_Ref=1398186089&_table=3001062&_item=12',2)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7327,'/scripts/objects/save.asp?',4)INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES(7328,'/scripts/objects/edit.asp?_XID=70000030&_Ref=1398186089&_table=3001062&_item=12&_formtab=&process=&step=&elem=',4)
View 2 Replies View RelatedI have the following code, which returns a list of nearby cities based on a city name as input. Most cities have multiple zipcodes per city name, thus it can list multiple rows with the same city name, but with different zipcodes like below:
Zip | Cityname
111 belmont
112 belmont
113 belmont
114 san francisco
115 san francisco
---------------- etc----------------
I do not really care about each group of zipcodes. I only need one pair of zipcode/city name like the following:
ZIP | City name
111 belmont
114 San Francisco
How do I change my select to only return a distinct city name. I do not care which if the city/zipcodes it returns from the similar city.
The select statement is below:
CREATE PROCEDURE ZipSearchByCity
@city varchar(40),
@State varchar(5),
@distance int
AS
SELECT distinct o.City AS City, o.zip_code, o.State AS State,
(3956 * (2 * ASIN(SQRT(
POWER(SIN((z.RADlatitude-o.RADlatitude)/2),2) +
COS(z.RADlatitude) *
COS(o.RADlatitude) *
POWER(SIN((z.RADlongitude-o.RADlongitude)/2),2)
)))) dist
FROM zipcodes z,
zipcodes o,
zipcodes a
WHERE z.city = @city AND
z.State = @State AND
z.zip_code=a.zip_code AND
(3956 * (2 * ASIN(SQRT(
POWER(SIN((z.RADlatitude-o.RADlatitude)/2),2) +
COS(z.RADlatitude) *
COS(o.RADlatitude) *
POWER(SIN((z.RADlongitude-o.RADlongitude)/2),2)
)))) < @distance
GO
Thanks,
Christian
Table1 contains fields Groupid, UserName,Category, Dimension
Table2 contains fields Group, Name,Category, Dimension (Group and Name are not in Table1)
So basically I need to read the records in Table1 using Groupid and each time there is a Groupid then select records from Table2 where Table2.Category in (Select Catergory from Table1)
and Table2.Dimension in (Select Dimension from Table1)
In Table1 There might be 10 Groupid records all of which are different.
I have a database which has a field called fldTimes. basically this field records the number of hits a file gets. How can I choose the most 5 popular files with the greatest hits. Thanks
View 2 Replies View RelatedIs it possible to use a SELECT to retrieve a Next 50 set of records?
Initial Query
Select top 50 email from table
What would the Query look like to retrieve the Next 50 records?
Thanks in advance.
This might be a simple question. I have a LIKE statement that is working fine, however I am not sure if something else is possible.
I can pull all records on a query for a person's name with a parameter value of "MARTIN". It will also pull records for "LYNN MARTIN". However, what if I would like to have that search also pull "LYNN M MARTIN"? Currently "LYNN MARTIN" is not finding "LYNN M MARTIN".
When the end user wants to search on LYNN MARTIN and that is what they input, I want SQL to find all records that match LYNN MARTIN and also find records that HAVE LYNN % MARTIN.
I hope this make sense? I guess I need to build my select statement using a WHERE LIKE statement, but I am not sure of the syntax.
How do I get distinct TitleID and Titles? Right now I'm still getting duplicates on them both. Here's my stored procedure.
select Distinct (Titles.Titleid), Titles.Title as TITLE, classifications.[description]as TOPIC,Titles.descriptions,media.[description] as MEDIA
from Titlesjoin resources on resources.Titleid = Titles.Titleidjoin media on media.mediaid = resources.mediaidjoin titleclassification on titleclassification.titleid = titles.titleidjoin classifications on classifications.classificationid = titleclassification.classificationid WHERE Title LIKE 'p' + '%' GROUP BY Titles.titleid, titles.title,classifications.[description],Titles.[descriptions],media.[description]
Thanks!
hi,
i want to ask a simple question,
i have a sql server relational tables named "tbl_Contact" (w/c has a field of ID & ContactName) and "tbl_reviews" (w/c has ID,ContactCode & Reviews).
the tables relationship is one-to-many, now my question is, how can i display a single record per 'ContactCode' from 'tbl_review'??
thanks..
I am trying to write a query that will only return the non distinct records
what i have is a bunch of line items that have an order id and a rate
there may be 10 line items with the same orderid, I need to get the orderid and rates for the orderids that have more than one rate
how would i do this?
how do i get an entire record returned when looking for only column to be unique?
basically i have 3 columns
id, tranid, appliedtranid
tranid can have multiple appliedtranids
i need to grab the top 10 distinct tranids but i need the entire record
hi I am trying to write a query that will return the most recent status of an event
my query is below
SELECT DISTINCT eventname, MIN(Status) AS Expr1, MIN(RecordUpdated) AS Expr2
FROM EventQueue
GROUP BY AuditName
does this query always result with the most recent distinct eventname record?
I need to make sure that the recordupdated is the most recent for the eventname
Hello Everyone and thanks for your help in advance. I have a SQL Server Table wtih approximately 100,000 records. I need to determine if there are duplicate records in this table. My probelm is that there is a unique ID column that was added for each row, so I'm not exactly sure how to filter the rows. Any help on this would be greatly appreciated. Thanks.
View 4 Replies View RelatedI'm looking for a bit of SQL code that will select some entries randomly from an SQL table.
For instance I'd like to feed a parameter in that contains the number
20, and the returned record contains 20 randomly and distinct selected
records.
Anyone know how this can be done? (never came across randomly select records) Appreciate any help
hi again,
i just want to ask if how can i randomly select 5 distinct records from a table w/ a hundreds of records everytime i exec a stored procedure??
thanks
I have a reviews table where all reviews are submitted. On the main page I want to display the 10 most reviewed products. I have a Product_ID column in this table which identifys the product. How can i write a query which will select the product_ID of records which have the most frequent product_ID's?
I came up with something like this:
"Select Top 10 Product_ID, COUNT(*) AS Occurances FROM reviews GROUP BY Product_ID ORDER BY occurances DESC"
But it does not work.?? It says "Declaration expected" as error