Organisation Details

eg: +60-12345678

eg: +60-12345678

Person In Charge Details

eg: +60-12345678

 

Donation
 
Donation to be distributed as follows: Amount (RM)
Dignity For Children Foundation 
Hospis Malaysia 
Standard Chartered Foundation 
The National Cancer Society of Malaysia 
Total

* Required field.


(default) 57 queries took 15 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `register_scklm17`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '53eca7e5080c3f834e63fb96fa5ced9c' LIMIT 1001
2SELECT `Charity`.`id`, `Charity`.`name` FROM `register_scklm17`.`charities` AS `Charity` WHERE 1 = 1440
3SELECT `Tshirt`.`id`, CONCAT(Tshirt.name, " - ", Tshirt.alias) AS title FROM `register_scklm17`.`tshirts` AS `Tshirt` WHERE `Tshirt`.`event_id` = 121 AND `Tshirt`.`disabled` = 0 ORDER BY `Tshirt`.`sorting` ASC, `Tshirt`.`alias` ASC38380
4SELECT `CountryCode`.`id`, `CountryCode`.`title` FROM `register_scklm17`.`country_codes` AS `CountryCode` WHERE 1 = 1 ORDER BY `CountryCode`.`title` ASC2322321
5SELECT `EventCategory`.`id`, `EventCategory`.`event_id`, `EventCategory`.`batch`, `EventCategory`.`alias`, `EventCategory`.`categories`, `EventCategory`.`competitions` FROM `register_scklm17`.`event_categories` AS `EventCategory` WHERE `EventCategory`.`event_id` = 121 AND LOWER(`EventCategory`.`batch`) = 'corporates_donate' LIMIT 1000
6SELECT `Category`.`id`, `Category`.`name`, `Category`.`alias`, `Category`.`limit` FROM `register_scklm17`.`categories` AS `Category` WHERE `Category`.`event_id` = 121 AND `Category`.`id` = -1 ORDER BY `Category`.`sorting` ASC000
7SELECT `Charity`.`id`, `Charity`.`name` FROM `register_scklm17`.`charities` AS `Charity` WHERE 1 = 1 ORDER BY `Charity`.`name` ASC440
8SELECT `Scklm16PastGroup`.`name` FROM `register_scklm17`.`scklm16_past_groups` AS `Scklm16PastGroup` WHERE 1 = 1 ORDER BY `Scklm16PastGroup`.`name` ASC50500
9SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = '6a ren' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
10SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'adrianyeo plt' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
11SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'aecom ' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
12SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'alpha automation (kl) sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
13SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'area management sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121111
14SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'arifin & partners' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
15SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'bakri runners club' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121111
16SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'bear hill' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121111
17SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'canon/doremon' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
18SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'carigali hess operating company sdn bhd ' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
19SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'chin hin group berhad' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
20SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'cogdev malaysia sdn bhd (911560-m)' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
21SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'conocophillips asia pacific sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
22SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'dexon electrical engineering sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
23SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'dutch lady milk industries berhad' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121111
24SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'everfine management sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121111
25SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'fujikura federal cables s/b' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
26SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'gct' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
27SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'geohan' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
28SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'gs net ' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
29SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'innity sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121111
30SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'kelantan@n9' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
31SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'kone asc' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
32SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'kpmg' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
33SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'malaysian technology development corporation' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
34SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'maxi stone marketing sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
35SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'mirage club' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
36SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'paramount pes engineering sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
37SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'pentago group of companies' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
38SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'persatuan alumni sekolah seri puteri malaysia' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
39SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'petroliam nasional berhad' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
40SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'petronas chemicals group berhad' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121111
41SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'positive engineering' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121111
42SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'psi runners' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121111
43SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'pwc' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
44SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'rabbit' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
45SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'renesas semiconductor kl sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121111
46SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'royal selangor international sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121111
47SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'running colony' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121111
48SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'secm sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
49SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'sunway shared services sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
50SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 't y lin international sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121111
51SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'taman bukit jalil runner' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
52SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'tdh running club' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
53SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'technave.com' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
54SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'themed attractions resorts & hotels sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
55SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'uda' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
56SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'underdog' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
57SELECT COUNT(*) AS `count` FROM `register_scklm17`.`organisations` AS `Organisation` LEFT JOIN `register_scklm17`.`users` AS `User` ON (`Organisation`.`user_id` = `User`.`id`) LEFT JOIN `register_scklm17`.`countries` AS `Country` ON (`Organisation`.`country_id` = `Country`.`id`) WHERE LOWER(`Organisation`.`company_name`) = 'zaid ibrahim & co. (a member of zicolaw)' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110