[wp6Eg2Fm]

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 :-(((