hey mods or adminners. - DiscussWorldIssues - Socio-Economic Religion and Political Uncensored Debate

**Janarealiti** · 07-23-2010, 07:10 AM

Is there a way you guys could see how many posts Ive made in this forum,inc the amount Ive posted in here,even though its not recorded ?

Just intrigued

**bapimporb** · 07-23-2010, 07:15 AM

Is there a way you guys could see how many posts Ive made in this forum,inc the amount Ive posted in here,even though its not recorded ?

Just intrigued

no clue, hope the admins can help you

**nasxbrtyol** · 07-23-2010, 07:16 AM

You're the only one who is intrigued, so PM them and you little attention whoring rimmer.

**Janarealiti** · 07-23-2010, 07:18 AM

You're the only one who is intrigued, so PM them and you little attention whoring rimmer.

pfft...

**wp6Eg2Fm** · 07-23-2010, 07:40 AM

SELECT COUNT(uid) FROM posts_table WHERE creating_user = OHP

It would need joining to the users table to get the username etc etc but that's the general idea.

**bapimporb** · 07-23-2010, 07:41 AM

SELECT COUNT(uid) FROM posts_table WHERE creating_user = OHP

It would need joining to the users table to get the username etc etc but that's the general idea.

Phew, I wish I knew SQL!

**Janarealiti** · 07-23-2010, 07:44 AM

SELECT COUNT(uid) FROM posts_table WHERE creating_user = OHP

It would need joining to the users table to get the username etc etc but that's the general idea.

I need my post count you chomper, not some gobbledy gook

**wp6Eg2Fm** · 07-23-2010, 07:45 AM

I need my post count you chomper, not some gobbledy gook

Listen sausage, you can run SQL queries into vBulletin software in the backend. Anyone with admin rights can do it, but they might not know SQL. The post was for them.

**bapimporb** · 07-23-2010, 07:47 AM

Listen sausage, you can run SQL queries into vBulletin software in the backend. Anyone with admin rights can do it, but they might not know SQL. The post was for them.

I don't think there are people on the internets that don't know SQL.

**wp6Eg2Fm** · 07-23-2010, 07:48 AM

I don't think there are people on the internets that don't know SQL.

That's SQL at the most basic level possible. See if you can figure out what this one I wrote earlier is pulling out...

SELECT
reg.region_name REGION,
(SELECT u.name FROM fe_users u WHERE u.uid = reg.fe_user) DIRECTORNAME,
IFNULL((SELECT sum(tx_loginusertrack_pagestat.hits) FROM `tx_loginusertrack_pagestat` INNER JOIN fe_users on fe_users.uid = tx_loginusertrack_pagestat.fe_user WHERE page_id =82 AND fe_user = (SELECT uid FROM fe_users WHERE fe_users.tx_lsysfeusersimport_sales_rep_id = rep.rep_id) AND tx_loginusertrack_pagestat.tstamp > 1262307600),0) PORTALYTD,
IFNULL((SELECT sum(tx_loginusertrack_pagestat.hits) FROM `tx_loginusertrack_pagestat` INNER JOIN fe_users on fe_users.uid = tx_loginusertrack_pagestat.fe_user WHERE page_id =82 AND fe_user = (SELECT uid FROM fe_users WHERE fe_users.tx_lsysfeusersimport_sales_rep_id = rep.rep_id) AND tx_loginusertrack_pagestat.tstamp > UNIX_TIMESTAMP(CONCAT(YEAR(NOW()),'-',MONTH(NOW()),'-','1 02:00:00'))),0) PORTALMTD,
SUM(1) TOTALACCOUNTS,
SUM(IF(u.tx_lsysfeusersimport_target1 = 999999999, 1, IF((ROUND((IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.year = YEAR(NOW())),0) / (u.tx_lsysfeusersimport_target1 * ((MONTH(NOW()) - 1) + ROUND(DAY(NOW()) / DAY(LAST_DAY(NOW())),2))) * 100),2)) > '100.00', 1, 0))) YTDTARGETACHIEVED,
(SUM(1) - SUM(IF(u.tx_lsysfeusersimport_target1 = 999999999, 1, IF((ROUND((IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.year = YEAR(NOW())),0) / (u.tx_lsysfeusersimport_target1 * ((MONTH(NOW()) - 1) + ROUND(DAY(NOW()) / DAY(LAST_DAY(NOW())),2))) * 100),2)) > '100.00', 1, 0)))) YTDTARGETNOTACHIEVED,
SUM(IF(u.tx_lsysfeusersimport_target1 = 999999999, 1, IF(ROUND((IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.month = MONTH(NOW()) AND s.year = YEAR(NOW())),0) / (u.tx_lsysfeusersimport_target1 * ROUND((DAY(NOW()) / DAY(LAST_DAY(NOW()))),2)) * 100),2) >= '100.00', 1, 0))) MTDTARGETACHIEVED,
(SUM(1) - SUM(IF(u.tx_lsysfeusersimport_target1 = 999999999, 1, IF(ROUND((IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.month = MONTH(NOW()) AND s.year = YEAR(NOW())),0) / (u.tx_lsysfeusersimport_target1 * ROUND((DAY(NOW()) / DAY(LAST_DAY(NOW()))),2)) * 100),2) >= '100.00', 1, 0)))) MTDTARGETNOTACHIEVED,
#u.company COMPANY,
SUM(IF(u.tx_lsysfeusersimport_target1 != 999999999, (u.tx_lsysfeusersimport_target1 * ROUND((DAY(NOW()) / DAY(LAST_DAY(NOW()))),2)), IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.month = MONTH(NOW()) AND s.year = YEAR(NOW())),0))) MTDTARGET,
SUM(IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.month = MONTH(NOW()) AND s.year = YEAR(NOW())),0)) MTDACTUAL,
SUM(IF(u.tx_lsysfeusersimport_target1 != 999999999, (u.tx_lsysfeusersimport_target1 * ((MONTH(NOW()) - 1) + ROUND(DAY(NOW()) / DAY(LAST_DAY(NOW())),2))), IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.year = YEAR(NOW())),0))) YTDTARGET,
SUM(IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.year = YEAR(NOW())),0)) YTDACTUAL,
SUM(IF(u.tx_lsysfeusersimport_target1 = 999999999, 0, (IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.month = MONTH(NOW()) AND s.year = YEAR(NOW())),0) - (u.tx_lsysfeusersimport_target1 * ROUND((DAY(NOW()) / DAY(LAST_DAY(NOW()))),2))))) MTDVARIANCE,
SUM(IF(u.tx_lsysfeusersimport_target1 = 999999999, 0, (IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.year = YEAR(NOW())),0) - (u.tx_lsysfeusersimport_target1 * ((MONTH(NOW()) - 1) + ROUND(DAY(NOW()) / DAY(LAST_DAY(NOW())),2)))))) YTDVARIANCE,
ROUND(((SUM(IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.month = MONTH(NOW()) AND s.year = YEAR(NOW())),0)) / SUM(IF(u.tx_lsysfeusersimport_target1 != 999999999, (u.tx_lsysfeusersimport_target1 * ROUND((DAY(NOW()) / DAY(LAST_DAY(NOW()))),2)), IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.month = MONTH(NOW()) AND s.year = YEAR(NOW())),0)))) * 100),2) MTDPERCENT,
ROUND(((SUM(IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.year = YEAR(NOW())),0)) / SUM(IF(u.tx_lsysfeusersimport_target1 != 999999999, (u.tx_lsysfeusersimport_target1 * ((MONTH(NOW()) - 1) + ROUND(DAY(NOW()) / DAY(LAST_DAY(NOW())),2))), IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.year = YEAR(NOW())),0)))) * 100),2) YTDPERCENT
FROM fe_users u
INNER JOIN tx_lsysfeusersimport_sales_rep rep ON rep.rep_id = u.tx_lsysfeusersimport_rep_id
INNER JOIN tx_lsysfeusersimport_regions reg ON reg.region_codes = rep.region
WHERE
u.usergroup = 2
AND u.deleted = 0
AND u.disable = 0
AND u.tx_lsysfeusersimport_target1 NOT LIKE 999999
AND u.tx_lsysfeusersimport_account_number > 0
AND rep.deleted = 0
AND rep.hidden = 0
AND reg.region_name NOT LIKE ''
AND reg.region_codes IN (8)
#AND reg.region_codes IN (1,2,3,4,5,6,7,8)
#AND u.tx_lsysfeusersimport_rep_id = 874
GROUP BY REGION
ORDER BY REGION
LIMIT 0,60

EDIT: unfortunately though, this one proves the problem I asked about on a different thread earlier actually exists :-(((

**bapimporb** · 07-23-2010, 07:53 AM

Uhm, yeah just because you take a long SQL querry with zounds of nested selects won't make the language less simple...

I find assembly code a lot more intimidating for example...

**wp6Eg2Fm** · 07-23-2010, 07:58 AM

Uhm, yeah just because you take a long SQL querry with zounds of nested selects won't make the language less simple... I find assembly code a lot more intimidating for example...

LOL, the whole point of SQL is that it is simple. And of course you will find a true programming language more intimidating....what's your point?

**bapimporb** · 07-23-2010, 08:01 AM

LOL, the whole point of SQL is that it is simple. And of course you will find a true programming language more intimidating....what's your point?

Well you did just paste a huge SQL querry to show how intimidating it can look in it's non basic form, was simply a response to that. Your initial post seemed to imply that we don't tell OHP his post count in GD because we can't figure out a simple SQL statement

Also, I don't find a true programing language very intimidating, just assembly really...

**teodaschwartia** · 07-23-2010, 10:07 AM

Well you did just paste a huge SQL querry to show how intimidating it can look in it's non basic form, was simply a response to that. Your initial post seemed to imply that we don't tell OHP his post count in GD because we can't figure out a simple SQL statement

Also, I don't find a true programing language very intimidating, just assembly really...

Iggie, did you know that you are messing with a PROJECT MANAGER? Did you see that SQL string? Holy ****... super cool d00d. Just saying...

**Maserati** · 07-23-2010, 10:47 AM

Iggie, did you know that you are messing with a PROJECT MANAGER? Did you see that SQL string? Holy ****... super cool d00d. Just saying...

LMAO @ ^

**sPncEjF7** · 07-23-2010, 10:54 AM

Iggie, did you know that you are messing with a PROJECT MANAGER? Did you see that SQL string? Holy ****... super cool d00d. Just saying...

[rofl]

That's all i have to [emote]...

**WrigleyMike** · 07-24-2010, 12:38 AM

Iggie, did you know that you are messing with a PROJECT MANAGER? Did you see that SQL string? Holy ****... super cool d00d. Just saying...

Not only that but DM's a very successful FEMALE project manager. I mean really DM, no man from any area of the UK I know uses the term "sausage" except when describing meaty goodness of pork or spam dagger variety.

**wp6Eg2Fm** · 07-24-2010, 02:09 AM

Not only that but DM's a very successful FEMALE project manager. I mean really DM, no man from any area of the UK I know uses the term "sausage" except when describing meaty goodness of pork or spam dagger variety.

I have no defence for this.

**teodaschwartia** · 07-24-2010, 10:32 AM

I have no defence for this.

Looks like you got burned up in this thread, buddy.

**wp6Eg2Fm** · 07-24-2010, 10:39 AM

Looks like you got burned up in this thread, buddy.

If you listen very carefully you can hear captain obvious landing the SS obvious on your head.

07-23-2010, 07:10 AM	#1
Janarealiti Join Date Oct 2005 Posts 569 Senior Member	hey mods or adminners. Is there a way you guys could see how many posts Ive made in this forum,inc the amount Ive posted in here,even though its not recorded ? Just intrigued Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-23-2010, 07:15 AM	#2
bapimporb Join Date Nov 2005 Posts 532 Senior Member	Is there a way you guys could see how many posts Ive made in this forum,inc the amount Ive posted in here,even though its not recorded ? Just intrigued no clue, hope the admins can help you Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-23-2010, 07:16 AM	#3
nasxbrtyol Join Date Oct 2005 Posts 389 Senior Member	You're the only one who is intrigued, so PM them and you little attention whoring rimmer. Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-23-2010, 07:18 AM	#4
Janarealiti Join Date Oct 2005 Posts 569 Senior Member	You're the only one who is intrigued, so PM them and you little attention whoring rimmer. pfft... Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-23-2010, 07:40 AM	#5
wp6Eg2Fm Join Date Oct 2005 Posts 531 Senior Member	SELECT COUNT(uid) FROM posts_table WHERE creating_user = OHP It would need joining to the users table to get the username etc etc but that's the general idea. Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-23-2010, 07:41 AM	#6
bapimporb Join Date Nov 2005 Posts 532 Senior Member	SELECT COUNT(uid) FROM posts_table WHERE creating_user = OHP It would need joining to the users table to get the username etc etc but that's the general idea. Phew, I wish I knew SQL! Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-23-2010, 07:44 AM	#7
Janarealiti Join Date Oct 2005 Posts 569 Senior Member	SELECT COUNT(uid) FROM posts_table WHERE creating_user = OHP It would need joining to the users table to get the username etc etc but that's the general idea. I need my post count you chomper, not some gobbledy gook Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-23-2010, 07:45 AM	#8
wp6Eg2Fm Join Date Oct 2005 Posts 531 Senior Member	I need my post count you chomper, not some gobbledy gook Listen sausage, you can run SQL queries into vBulletin software in the backend. Anyone with admin rights can do it, but they might not know SQL. The post was for them. Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-23-2010, 07:47 AM	#9
bapimporb Join Date Nov 2005 Posts 532 Senior Member	Listen sausage, you can run SQL queries into vBulletin software in the backend. Anyone with admin rights can do it, but they might not know SQL. The post was for them. I don't think there are people on the internets that don't know SQL. Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-23-2010, 07:48 AM	#10
wp6Eg2Fm Join Date Oct 2005 Posts 531 Senior Member	I don't think there are people on the internets that don't know SQL. That's SQL at the most basic level possible. See if you can figure out what this one I wrote earlier is pulling out... SELECT reg.region_name REGION, (SELECT u.name FROM fe_users u WHERE u.uid = reg.fe_user) DIRECTORNAME, IFNULL((SELECT sum(tx_loginusertrack_pagestat.hits) FROM `tx_loginusertrack_pagestat` INNER JOIN fe_users on fe_users.uid = tx_loginusertrack_pagestat.fe_user WHERE page_id =82 AND fe_user = (SELECT uid FROM fe_users WHERE fe_users.tx_lsysfeusersimport_sales_rep_id = rep.rep_id) AND tx_loginusertrack_pagestat.tstamp > 1262307600),0) PORTALYTD, IFNULL((SELECT sum(tx_loginusertrack_pagestat.hits) FROM `tx_loginusertrack_pagestat` INNER JOIN fe_users on fe_users.uid = tx_loginusertrack_pagestat.fe_user WHERE page_id =82 AND fe_user = (SELECT uid FROM fe_users WHERE fe_users.tx_lsysfeusersimport_sales_rep_id = rep.rep_id) AND tx_loginusertrack_pagestat.tstamp > UNIX_TIMESTAMP(CONCAT(YEAR(NOW()),'-',MONTH(NOW()),'-','1 02:00:00'))),0) PORTALMTD, SUM(1) TOTALACCOUNTS, SUM(IF(u.tx_lsysfeusersimport_target1 = 999999999, 1, IF((ROUND((IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.year = YEAR(NOW())),0) / (u.tx_lsysfeusersimport_target1 * ((MONTH(NOW()) - 1) + ROUND(DAY(NOW()) / DAY(LAST_DAY(NOW())),2))) * 100),2)) > '100.00', 1, 0))) YTDTARGETACHIEVED, (SUM(1) - SUM(IF(u.tx_lsysfeusersimport_target1 = 999999999, 1, IF((ROUND((IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.year = YEAR(NOW())),0) / (u.tx_lsysfeusersimport_target1 * ((MONTH(NOW()) - 1) + ROUND(DAY(NOW()) / DAY(LAST_DAY(NOW())),2))) * 100),2)) > '100.00', 1, 0)))) YTDTARGETNOTACHIEVED, SUM(IF(u.tx_lsysfeusersimport_target1 = 999999999, 1, IF(ROUND((IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.month = MONTH(NOW()) AND s.year = YEAR(NOW())),0) / (u.tx_lsysfeusersimport_target1 * ROUND((DAY(NOW()) / DAY(LAST_DAY(NOW()))),2)) * 100),2) >= '100.00', 1, 0))) MTDTARGETACHIEVED, (SUM(1) - SUM(IF(u.tx_lsysfeusersimport_target1 = 999999999, 1, IF(ROUND((IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.month = MONTH(NOW()) AND s.year = YEAR(NOW())),0) / (u.tx_lsysfeusersimport_target1 * ROUND((DAY(NOW()) / DAY(LAST_DAY(NOW()))),2)) * 100),2) >= '100.00', 1, 0)))) MTDTARGETNOTACHIEVED, #u.company COMPANY, SUM(IF(u.tx_lsysfeusersimport_target1 != 999999999, (u.tx_lsysfeusersimport_target1 * ROUND((DAY(NOW()) / DAY(LAST_DAY(NOW()))),2)), IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.month = MONTH(NOW()) AND s.year = YEAR(NOW())),0))) MTDTARGET, SUM(IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.month = MONTH(NOW()) AND s.year = YEAR(NOW())),0)) MTDACTUAL, SUM(IF(u.tx_lsysfeusersimport_target1 != 999999999, (u.tx_lsysfeusersimport_target1 * ((MONTH(NOW()) - 1) + ROUND(DAY(NOW()) / DAY(LAST_DAY(NOW())),2))), IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.year = YEAR(NOW())),0))) YTDTARGET, SUM(IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.year = YEAR(NOW())),0)) YTDACTUAL, SUM(IF(u.tx_lsysfeusersimport_target1 = 999999999, 0, (IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.month = MONTH(NOW()) AND s.year = YEAR(NOW())),0) - (u.tx_lsysfeusersimport_target1 * ROUND((DAY(NOW()) / DAY(LAST_DAY(NOW()))),2))))) MTDVARIANCE, SUM(IF(u.tx_lsysfeusersimport_target1 = 999999999, 0, (IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.year = YEAR(NOW())),0) - (u.tx_lsysfeusersimport_target1 * ((MONTH(NOW()) - 1) + ROUND(DAY(NOW()) / DAY(LAST_DAY(NOW())),2)))))) YTDVARIANCE, ROUND(((SUM(IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.month = MONTH(NOW()) AND s.year = YEAR(NOW())),0)) / SUM(IF(u.tx_lsysfeusersimport_target1 != 999999999, (u.tx_lsysfeusersimport_target1 * ROUND((DAY(NOW()) / DAY(LAST_DAY(NOW()))),2)), IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.month = MONTH(NOW()) AND s.year = YEAR(NOW())),0)))) * 100),2) MTDPERCENT, ROUND(((SUM(IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.year = YEAR(NOW())),0)) / SUM(IF(u.tx_lsysfeusersimport_target1 != 999999999, (u.tx_lsysfeusersimport_target1 * ((MONTH(NOW()) - 1) + ROUND(DAY(NOW()) / DAY(LAST_DAY(NOW())),2))), IFNULL((SELECT SUM(value) FROM tx_lsysfeusersimport_sales s WHERE s.customer_account_number = u.tx_lsysfeusersimport_account_number AND s.year = YEAR(NOW())),0)))) * 100),2) YTDPERCENT FROM fe_users u INNER JOIN tx_lsysfeusersimport_sales_rep rep ON rep.rep_id = u.tx_lsysfeusersimport_rep_id INNER JOIN tx_lsysfeusersimport_regions reg ON reg.region_codes = rep.region WHERE u.usergroup = 2 AND u.deleted = 0 AND u.disable = 0 AND u.tx_lsysfeusersimport_target1 NOT LIKE 999999 AND u.tx_lsysfeusersimport_account_number > 0 AND rep.deleted = 0 AND rep.hidden = 0 AND reg.region_name NOT LIKE '' AND reg.region_codes IN (8) #AND reg.region_codes IN (1,2,3,4,5,6,7,8) #AND u.tx_lsysfeusersimport_rep_id = 874 GROUP BY REGION ORDER BY REGION LIMIT 0,60 EDIT: unfortunately though, this one proves the problem I asked about on a different thread earlier actually exists :-((( Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-23-2010, 07:53 AM	#11
bapimporb Join Date Nov 2005 Posts 532 Senior Member	Uhm, yeah just because you take a long SQL querry with zounds of nested selects won't make the language less simple... I find assembly code a lot more intimidating for example... Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-23-2010, 07:58 AM	#12
wp6Eg2Fm Join Date Oct 2005 Posts 531 Senior Member	Uhm, yeah just because you take a long SQL querry with zounds of nested selects won't make the language less simple... I find assembly code a lot more intimidating for example... LOL, the whole point of SQL is that it is simple. And of course you will find a true programming language more intimidating....what's your point? Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-23-2010, 08:01 AM	#13
bapimporb Join Date Nov 2005 Posts 532 Senior Member	LOL, the whole point of SQL is that it is simple. And of course you will find a true programming language more intimidating....what's your point? Well you did just paste a huge SQL querry to show how intimidating it can look in it's non basic form, was simply a response to that. Your initial post seemed to imply that we don't tell OHP his post count in GD because we can't figure out a simple SQL statement Also, I don't find a true programing language very intimidating, just assembly really... Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-23-2010, 10:07 AM	#14
teodaschwartia Join Date Oct 2005 Posts 431 Senior Member	Well you did just paste a huge SQL querry to show how intimidating it can look in it's non basic form, was simply a response to that. Your initial post seemed to imply that we don't tell OHP his post count in GD because we can't figure out a simple SQL statement Also, I don't find a true programing language very intimidating, just assembly really... Iggie, did you know that you are messing with a PROJECT MANAGER? Did you see that SQL string? Holy ****... super cool d00d. Just saying... Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-23-2010, 10:47 AM	#15
Maserati Join Date Oct 2005 Posts 436 Senior Member	Iggie, did you know that you are messing with a PROJECT MANAGER? Did you see that SQL string? Holy ****... super cool d00d. Just saying... LMAO @ ^ Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

Currently Active Users Viewing This Thread: 2 (0 members and 2 guests)

07-23-2010, 10:54 AM	#16
sPncEjF7 Join Date Oct 2005 Posts 557 Senior Member	Iggie, did you know that you are messing with a PROJECT MANAGER? Did you see that SQL string? Holy ****... super cool d00d. Just saying... [rofl] That's all i have to [emote]... Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-24-2010, 12:38 AM	#17
WrigleyMike Join Date Oct 2005 Posts 398 Senior Member	Iggie, did you know that you are messing with a PROJECT MANAGER? Did you see that SQL string? Holy ****... super cool d00d. Just saying... Not only that but DM's a very successful FEMALE project manager. I mean really DM, no man from any area of the UK I know uses the term "sausage" except when describing meaty goodness of pork or spam dagger variety. Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-24-2010, 02:09 AM	#18
wp6Eg2Fm Join Date Oct 2005 Posts 531 Senior Member	Not only that but DM's a very successful FEMALE project manager. I mean really DM, no man from any area of the UK I know uses the term "sausage" except when describing meaty goodness of pork or spam dagger variety. I have no defence for this. Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-24-2010, 10:32 AM	#19
teodaschwartia Join Date Oct 2005 Posts 431 Senior Member	I have no defence for this. Looks like you got burned up in this thread, buddy. Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

07-24-2010, 10:39 AM	#20
wp6Eg2Fm Join Date Oct 2005 Posts 531 Senior Member	Looks like you got burned up in this thread, buddy. If you listen very carefully you can hear captain obvious landing the SS obvious on your head. Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote