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) 60 queries took 6 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Event`.`id`, `Event`.`code`, `Event`.`name`, `EventDetail`.`id`, `EventDetail`.`event_id`, `EventDetail`.`short_name`, `EventDetail`.`long_name`, `EventDetail`.`description`, `EventDetail`.`company`, `EventDetail`.`address`, `EventDetail`.`phone`, `EventDetail`.`fax`, `EventDetail`.`email1`, `EventDetail`.`email2`, `EventDetail`.`website`, `EventDetail`.`facebook`, `EventDetail`.`twitter`, `EventDetail`.`instagram`, `EventDetail`.`youtube`, `EventPreference`.`id`, `EventPreference`.`event_id`, `EventPreference`.`theme`, `EventPreference`.`country_id`, `EventPreference`.`currency`, `EventPreference`.`offline`, `EventPreference`.`multiple_currency`, `EventPreference`.`merchandise`, `EventPreference`.`paypal_sandbox`, `EventPreference`.`event_date`, `EventPreference`.`code_expiry`, `EventPreference`.`chiper`, `EventPreference`.`ssl` FROM `register_scklm17`.`events` AS `Event` LEFT JOIN `register_scklm17`.`event_details` AS `EventDetail` ON (`EventDetail`.`event_id` = `Event`.`id`) LEFT JOIN `register_scklm17`.`event_preferences` AS `EventPreference` ON (`EventPreference`.`event_id` = `Event`.`id`) WHERE `Event`.`code` = 'scklm17' ORDER BY `Event`.`id` ASC LIMIT 1111
2SELECT `Event`.`code`, `Event`.`name` FROM `register_scklm17`.`events` AS `Event` WHERE 1 = 1 ORDER BY `Event`.`id` ASC110
3SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `register_scklm17`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '2d6752614137e89be75afcfc916b3eec' LIMIT 1001
4SELECT `Charity`.`id`, `Charity`.`name` FROM `register_scklm17`.`charities` AS `Charity` WHERE 1 = 1440
5SELECT `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
6SELECT `CountryCode`.`id`, `CountryCode`.`title` FROM `register_scklm17`.`country_codes` AS `CountryCode` WHERE 1 = 1 ORDER BY `CountryCode`.`title` ASC2322321
7SELECT `Country`.`id`, `Country`.`name` FROM `register_scklm17`.`countries` AS `Country` WHERE 1 = 1 ORDER BY `Country`.`name` ASC2342341
8SELECT `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
9SELECT `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
10SELECT `Charity`.`id`, `Charity`.`name` FROM `register_scklm17`.`charities` AS `Charity` WHERE 1 = 1 ORDER BY `Charity`.`name` ASC440
11SELECT `Scklm16PastGroup`.`name` FROM `register_scklm17`.`scklm16_past_groups` AS `Scklm16PastGroup` WHERE 1 = 1 ORDER BY `Scklm16PastGroup`.`name` ASC50500
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`) = '6a ren' 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`) = 'adrianyeo plt' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
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`) = 'aecom ' 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`) = 'alpha automation (kl) sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
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`) = 'area management sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
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`) = 'arifin & partners' 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`) = 'bakri runners club' 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`) = 'bear hill' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121111
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`) = 'canon/doremon' 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`) = 'carigali hess operating company 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`) = 'chin hin group berhad' 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`) = 'cogdev malaysia sdn bhd (911560-m)' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
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`) = 'conocophillips asia pacific sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
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`) = 'dexon electrical engineering sdn bhd' 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`) = 'dutch lady milk industries berhad' 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`) = 'everfine management sdn bhd' 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`) = 'fujikura federal cables s/b' 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`) = 'gct' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
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`) = 'geohan' 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`) = 'gs net ' 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`) = 'innity sdn bhd' 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`) = 'kelantan@n9' 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`) = 'kone asc' 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`) = 'kpmg' 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`) = 'malaysian technology development corporation' 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`) = 'maxi stone marketing sdn bhd' 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`) = 'mirage club' 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`) = 'paramount pes engineering sdn bhd' 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`) = 'pentago group of companies' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
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`) = 'persatuan alumni sekolah seri puteri malaysia' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
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`) = 'petroliam nasional berhad' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
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`) = 'petronas chemicals group berhad' 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`) = 'positive engineering' 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`) = 'psi runners' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
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`) = 'pwc' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
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`) = 'rabbit' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
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`) = 'renesas semiconductor kl 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`) = 'royal selangor international 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`) = 'running colony' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
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`) = 'secm sdn bhd' 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`) = 'sunway shared services sdn bhd' 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`) = 't y lin international sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121111
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`) = 'taman bukit jalil runner' 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`) = 'tdh running club' 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`) = 'technave.com' 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`) = 'themed attractions resorts & hotels sdn bhd' AND `Organisation`.`var11` = 'yes' AND `Organisation`.`status` IN ('submitted', 'accept', 'complete') AND `Organisation`.`event_id` = 121110
58SELECT 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
59SELECT 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
60SELECT 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