OfficeCo

1 (546)
12 (195)
100 (112)
50 (79)
24 (37)
6 (34)
10 (30)
25 (29)
96 (25)
1 Each (23)
500g (14)
8 (11)
36 (10)
500 (10)
40 (9)
4 (8)
50g (8)
480 (6)
1 Dozen (5)
1/4lb (5)
1lb (5)
1000 (4)
30 (4)
300 (4)
48 (4)
60 (4)
1400 (3)
16 (3)
1/2lb (2)
11 (2)
1500 (2)
20 (2)
200 / Pack (2)
24 / Box (2)
250 (2)
2lb (2)
3000 (2)
454g (2)
500 / Box (2)
5000 (2)
960 (2)
1 / Each (1)
100 sheets (1)
12 / Box (1)
12 / Pack (1)
130 (1)
14 (1)
144 (1)
150 (1)
1500 / Box (1)
1Kg (1)
2 / Pack (1)
2.5lb (1)
200 (1)
2000 (1)
24 / Pack (1)
28 (1)
288 (1)
3 (1)
30 / Carton (1)
30 / Pack (1)
30g (1)
310g (1)
32 (1)
35 (1)
4 / Pack (1)
44 (1)
450 (1)
5 (1)
6 / Set (1)
600 (1)
64 (1)
738 (1)
8000 (1)
900 (1)

1 (77)
3.3 (70)
0.25 (58)
0.2 (42)
1.1 (40)
2.9 (39)
0.01 (37)
0.06 (37)
0.5 (36)
0.1 (31)
3.5 (31)
0.02 (30)
0.19 (25)
0.15 (24)
1.2 (23)
1.3 (21)
1.4 (19)
0.3 (18)
1.5 (18)
2.3 (18)
4 (18)
0.22 (17)
0.85 (15)
44.1 (15)
0.04 (14)
0.11 (14)
0.45 (14)
0.05 (13)
6.6 (13)
9.4 (13)
0.55 (11)
0.6 (11)
1.8 (11)
9.5 (11)
0.17 (10)
16.1 (10)
5 (10)
5.1 (10)
0.35 (9)
2.42 (9)
23 (9)
0.13 (8)
0.24 (8)
0.4 (8)
0.8 (8)
0.9 (8)
2.2 (8)
0.09 (7)
0.12 (7)
0.16 (7)
0.65 (7)
0.18 (6)
0.32 (6)
0.7 (6)
0.75 (6)
0.03 (5)
0.07 (5)
0.08 (5)
0.27 (5)
0.31 (5)
3.1 (5)
4.2 (4)
0.21 (3)
0.26 (3)
0.29 (3)
0.34 (3)
0.74 (3)
0.78 (3)
0.82 (3)
2.4 (3)
5.4 (3)
8 (3)
0.28 (2)
0.36 (2)
0.38 (2)
0.41 (2)
0.43 (2)
0.44 (2)
0.51 (2)
0.53 (2)
0.68 (2)
0.77 (2)
0.95 (2)
1.15 (2)
1.23 (2)
1.65 (2)
1.7 (2)
1.85 (2)
1.9 (2)
2.17 (2)
2.6 (2)
3.2 (2)
3.6 (2)
6.1 (2)
7.7 (2)
0.23 (1)
0.37 (1)
0.39 (1)
0.42 (1)
0.46 (1)
0.47 (1)
0.52 (1)
0.58 (1)
0.62 (1)
0.63 (1)
0.81 (1)
0.83 (1)
0.86 (1)
0.96 (1)
1.03 (1)
1.05 (1)
1.14 (1)
1.26 (1)
1.28 (1)
1.35 (1)
1.51 (1)
1.54 (1)
1.55 (1)
1.6 (1)
10.22 (1)
10.7 (1)
11.6 (1)
12.1 (1)
13.2 (1)
14.2 (1)
18.6 (1)
19.3 (1)
2 (1)
2.05 (1)
2.1 (1)
2.25 (1)
2.5 (1)
2.71 (1)
2.95 (1)
21.3 (1)
24 (1)
24.2 (1)
24.4 (1)
26.5 (1)
28.3 (1)
28.4 (1)
28.9 (1)
3.7 (1)
30.5 (1)
35.7 (1)
37.5 (1)
38.5 (1)
4.9 (1)
41.9 (1)
5.11 (1)
5.5 (1)
5.73 (1)
51 (1)
6.2 (1)
6.5 (1)
6.7 (1)
7.2 (1)
7.6 (1)
7.9 (1)
8.5 (1)
8.9 (1)
9.24 (1)

No (35)
Yes (9)

100 (8)
72 (5)
144 (2)
30 (2)
40 (2)
80 (2)
160 (1)
20 (1)
200 (1)
32 (1)
48 (1)
60 (1)
70 (1)

50 (9)
72 (6)
10000 (1)
12 (1)
131 (1)
16 (1)
230 (1)
26 (1)
31 (1)
33 (1)
34 (1)
3504 (1)
36 (1)

50% (4)
100% (2)
7% (1)

Yes (4)
No (2)

Blue (3)
Red (3)

0% (3)
100% (1)
50% (1)

A796 (1)
D1 (1)
M (1)

#10 (1)
#9 (1)

192 (1)
200 (1)

Application Log
Timestamp	Level	Category	Message
14:10:10.538387	trace	system.CModule	Loading "log" application component in /home/rose/dev/index.php (12)
14:10:10.538697	trace	system.CModule	Loading "db" application component in /home/rose/dev/index.php (12)
14:10:10.539088	trace	system.db.CDbConnection	Opening DB connection in /home/rose/dev/index.php (12)
14:10:10.539403	trace	system.CModule	Loading "request" application component in /home/rose/dev/index.php (12)
14:10:10.542378	trace	system.db.ar.CActiveRecord	Portal.findByAttributes() in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
14:10:10.543795	trace	system.CModule	Loading "cache" application component in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
14:10:10.545098	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `portals` in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
14:10:10.546207	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `portals` in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
14:10:10.546792	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `portals` `t` WHERE `t`.`domain`=:yp0 LIMIT 1 in /home/rose/dev/protected/components/BeginRequest.php (15) in /home/rose/dev/index.php (12)
14:10:10.546925	trace	system.CModule	Loading "user" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
14:10:10.547538	trace	system.CModule	Loading "session" application component in /home/rose/dev/protected/components/BeginRequest.php (18) in /home/rose/dev/index.php (12)
14:10:10.640824	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
14:10:10.640867	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `users` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
14:10:10.641731	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `users` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
14:10:10.643661	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `accounts` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
14:10:10.644299	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `accounts` in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
14:10:10.644490	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/components/BeginRequest.php (48) in /home/rose/dev/index.php (12)
14:10:10.644825	trace	system.db.ar.CActiveRecord	HiddenProduct.findAll() in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
14:10:10.644845	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `hidden_products` in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
14:10:10.645397	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `hidden_products` in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
14:10:10.645518	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `hidden_products` `t` WHERE (customer_id = 3259 OR group_id=5) AND category_id <> 0 in /home/rose/dev/protected/components/BeginRequest.php (63) in /home/rose/dev/index.php (12)
14:10:10.645750	trace	system.db.ar.CActiveRecord	CustomCategory.findAll() in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
14:10:10.645766	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `cust_categories` in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
14:10:10.646279	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `cust_categories` in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
14:10:10.646373	trace	system.db.CDbCommand	Querying SQL: SELECT * FROM `cust_categories` `t` WHERE group_id=5 in /home/rose/dev/protected/components/BeginRequest.php (74) in /home/rose/dev/index.php (12)
14:10:10.646485	trace	system.CModule	Loading "urlManager" application component in /home/rose/dev/index.php (12)
14:10:10.649368	trace	system.web.filters.CFilterChain	Running filter ProductController.filteraccessControl() in /home/rose/dev/index.php (12)
14:10:10.649662	trace	system.db.ar.CActiveRecord	User.findByPk() in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
14:10:10.649749	trace	system.db.CDbCommand	Querying SQL: SELECT `t`.`userid` AS `t0_c0`, `t`.`username` AS `t0_c1`, `t`.`password` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`email` AS `t0_c4`, `t`.`access` AS `t0_c5`, `t`.`advanceware_id` AS `t0_c6`, `t`.`default_billing` AS `t0_c7`, `t`.`default_shipping` AS `t0_c8`, `t`.`po_required` AS `t0_c9`, `t`.`approval_threshold` AS `t0_c10`, `t`.`token` AS `t0_c11`, `t`.`gl_required` AS `t0_c12`, `t`.`lock_addresses` AS `t0_c13`, `account`.`id` AS `t1_c0`, `account`.`name` AS `t1_c1`, `account`.`account_no` AS `t1_c2`, `account`.`group_id` AS `t1_c3`, `account`.`tender_prefix` AS `t1_c4`, `account`.`taxable` AS `t1_c5`, `account`.`downloaded` AS `t1_c6`, `account`.`tax_id` AS `t1_c7`, `account`.`rep_id` AS `t1_c8`, `account`.`discount` AS `t1_c9`, `account`.`price_list` AS `t1_c10`, `account`.`markup` AS `t1_c11` FROM `users` `t` LEFT OUTER JOIN `accounts` `account` ON (`t`.`advanceware_id`=`account`.`id`) WHERE (`t`.`userid`=1826) in /home/rose/dev/protected/controllers/ProductController.php (293) in /home/rose/dev/index.php (12)
14:10:10.650099	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
14:10:10.650125	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `price_exceptions` in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
14:10:10.650649	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `price_exceptions` in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
14:10:10.650772	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM `price_exceptions` `t` WHERE customer_id=3259 in /home/rose/dev/protected/controllers/ProductController.php (319) in /home/rose/dev/index.php (12)
14:10:10.650902	trace	system.db.ar.CActiveRecord	PriceException.count() in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
14:10:10.650921	trace	system.db.CDbCommand	Querying SQL: SELECT COUNT(*) FROM `price_exceptions` `t` WHERE customer_id=0 in /home/rose/dev/protected/controllers/ProductController.php (322) in /home/rose/dev/index.php (12)
14:10:10.677201	trace	system.db.ar.CActiveRecord	Product.findBySql() in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
14:10:10.677228	trace	system.db.CDbCommand	Querying SQL: SELECT DISTINCT products.*, IFNULL(IF(x.sku='',products.sku,x.sku),products.sku)AS sku, IFNULL(MIN(x.price),products.price) AS price, MAX(x.customer_id) AS exceptcustomer, sp.price AS saleprice, IFNULL(favourites.quantity,-1) AS weight FROM products LEFT JOIN price_exceptions x ON products.id=x.product_id AND (x.customer_id=3259 OR x.customer_id=0) LEFT JOIN favourites ON (products.id=favourites.product_id AND favourites.customer_id=1826) LEFT JOIN sale_prices sp ON products.id=sp.product_id AND NOW() BETWEEN startdate AND enddate AND sp.customer_id=0 WHERE products.id=4453 GROUP BY IFNULL(x.product_id,products.id) in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
14:10:10.677918	trace	system.db.CDbCommand	Querying SQL: SHOW FULL COLUMNS FROM `products` in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)
14:10:10.678694	trace	system.db.CDbCommand	Querying SQL: SHOW CREATE TABLE `products` in /home/rose/dev/protected/controllers/ProductController.php (478) in /home/rose/dev/index.php (12)

21-172

21-174

21-175

21-176

21-177

21-179

21-180

21-181

21-182

21-183

21-190

21-192

21-193

21-194

21-195

21-196

21-215

21-216

21-218

21-219

Are you sure