#1 Place for Craft Supplies, Art Supplies, Artist Materials and Kids Crafts

Signet Brushes

by Robert Simmons


Problem with item sku 11162. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372280270
barcode_type UPC
col1 2/0
col1_sortorder 84
col2 round
col2_sortorder 434
col3 40R
col3_sortorder 172
cost 2.89
deal_of_the_week NO
description 2/0, round, 40R
group_id 972
group_uname robert-simmons-signet-brushes
id 11162
list_price 8.45
map NO
mfr_num 222145098
net_weight 0.06
non_member_discount 40
non_member_price 5.07
prop65 NO
ship_rule_desc STD
shipping STD
sku 11162
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.13
ta_dealer_c_price 3.13
ta_price 5.07
text
array
1 11162
2 222145098
3 2/0, round, 40R
timestamp 2015-03-27T14:46:25.215Z
vip_member_price 3.38

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 64867. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372281277
barcode_type UPC
col1 0
col1_sortorder 85
col2 round
col2_sortorder 434
col3 40R
col3_sortorder 172
cost 2.92
deal_of_the_week NO
description 0, round, 40R
group_id 972
group_uname robert-simmons-signet-brushes
id 64867
list_price 8.55
map NO
mfr_num 222145099
net_weight 0.08
non_member_discount 40
non_member_price 5.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 64867
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.16
ta_dealer_c_price 3.16
ta_price 5.13
text
array
1 64867
2 222145099
3 0, round, 40R
timestamp 2015-03-27T14:47:46.103Z
vip_member_price 3.42

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 27438. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372265277
barcode_type UPC
col1 1
col1_sortorder 275
col2 flat
col2_sortorder 209
col3 40F
col3_sortorder 171
cost 3
deal_of_the_week NO
description 1, flat, 40F
group_id 972
group_uname robert-simmons-signet-brushes
id 27438
list_price 8.8
map NO
mfr_num 222144001
net_weight 0.04
non_member_discount 40
non_member_price 5.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 27438
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.26
ta_dealer_c_price 3.26
ta_price 5.28
text
array
1 27438
2 222144001
3 1, flat, 40F
timestamp 2015-03-27T14:46:50.625Z
vip_member_price 3.52

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 52735. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372282274
barcode_type UPC
col1 1
col1_sortorder 275
col2 round
col2_sortorder 434
col3 40R
col3_sortorder 172
cost 3
deal_of_the_week NO
description 1, round, 40R
group_id 972
group_uname robert-simmons-signet-brushes
id 52735
list_price 8.8
map NO
mfr_num 222145001
net_weight 0.08
non_member_discount 40
non_member_price 5.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 52735
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.26
ta_dealer_c_price 3.26
ta_price 5.28
text
array
1 52735
2 222145001
3 1, round, 40R
timestamp 2015-03-27T14:47:28.079Z
vip_member_price 3.52

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 61176. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372250273
barcode_type UPC
col1 1
col1_sortorder 275
col2 bright
col2_sortorder 112
col3 40B
col3_sortorder 170
cost 3
deal_of_the_week NO
description 1, bright, 40B
group_id 972
group_uname robert-simmons-signet-brushes
id 61176
list_price 8.8
map NO
mfr_num 222141001
net_weight 0.08
non_member_discount 40
non_member_price 5.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 61176
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.26
ta_dealer_c_price 3.26
ta_price 5.28
text
array
1 61176
2 222141001
3 1, bright, 40B
timestamp 2015-03-27T14:47:40.149Z
vip_member_price 3.52

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 63776. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372297278
barcode_type UPC
col1 1
col1_sortorder 275
col2 filbert
col2_sortorder 202
col3 42
col3_sortorder 195
cost 3
deal_of_the_week NO
description 1, filbert, 42
group_id 972
group_uname robert-simmons-signet-brushes
id 63776
list_price 8.8
map NO
mfr_num 222142001
net_weight 0.08
non_member_discount 40
non_member_price 5.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 63776
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.26
ta_dealer_c_price 3.26
ta_price 5.28
text
array
1 63776
2 222142001
3 1, filbert, 42
timestamp 2015-03-27T14:47:43.975Z
vip_member_price 3.52

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 39359. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372259276
barcode_type UPC
col1 10
col1_sortorder 692
col2 bright
col2_sortorder 112
col3 40B
col3_sortorder 170
cost 8.32
deal_of_the_week NO
description 10, bright, 40B
group_id 972
group_uname robert-simmons-signet-brushes
id 39359
list_price 24.35
map NO
mfr_num 222141010
net_weight 0.1
non_member_discount 40
non_member_price 14.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 39359
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.01
ta_dealer_c_price 9.01
ta_price 14.61
text
array
1 39359
2 222141010
3 10, bright, 40B
timestamp 2015-03-27T14:47:11.648Z
vip_member_price 9.74

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 46010. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372274279
barcode_type UPC
col1 10
col1_sortorder 692
col2 flat
col2_sortorder 209
col3 40F
col3_sortorder 171
cost 8.32
deal_of_the_week NO
description 10, flat, 40F
group_id 972
group_uname robert-simmons-signet-brushes
id 46010
list_price 24.36
map NO
mfr_num 222144010
net_weight 0.1
non_member_discount 40
non_member_price 14.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 46010
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.01
ta_dealer_c_price 9.01
ta_price 14.62
text
array
1 46010
2 222144010
3 10, flat, 40F
timestamp 2015-03-27T14:47:19.349Z
vip_member_price 9.74

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 83634. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372291276
barcode_type UPC
col1 10
col1_sortorder 692
col2 round
col2_sortorder 434
col3 40R
col3_sortorder 172
cost 8.32
deal_of_the_week NO
description 10, round, 40R
group_id 972
group_uname robert-simmons-signet-brushes
id 83634
list_price 24.35
map NO
mfr_num 222145010
net_weight 0.1
non_member_discount 40
non_member_price 14.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 83634
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.01
ta_dealer_c_price 9.01
ta_price 14.61
text
array
1 83634
2 222145010
3 10, round, 40R
timestamp 2015-03-27T14:48:13.873Z
vip_member_price 9.74

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 84054. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372306277
barcode_type UPC
col1 10
col1_sortorder 692
col2 filbert
col2_sortorder 202
col3 42
col3_sortorder 195
cost 8.32
deal_of_the_week NO
description 10, filbert, 42
group_id 972
group_uname robert-simmons-signet-brushes
id 84054
list_price 24.35
map NO
mfr_num 222142010
net_weight 0.1
non_member_discount 40
non_member_price 14.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 84054
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.01
ta_dealer_c_price 9.01
ta_price 14.61
text
array
1 84054
2 222142010
3 10, filbert, 42
timestamp 2015-03-27T14:48:14.36Z
vip_member_price 9.74

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 89638. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372268100
barcode_type UPC
col1 10
col1_sortorder 692
col2 fan
col2_sortorder 198
col3 408
col3_sortorder 175
cost 7.64
deal_of_the_week NO
description 10, fan, 408
group_id 972
group_uname robert-simmons-signet-brushes
id 89638
list_price 22.35
map NO
mfr_num 222146010
net_weight 0.08
non_member_discount 40
non_member_price 13.41
prop65 NO
ship_rule_desc STD
shipping STD
sku 89638
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.27
ta_dealer_c_price 8.27
ta_price 13.41
text
array
1 89638
2 222146010
3 10, fan, 408
timestamp 2015-03-27T14:48:24.474Z
vip_member_price 8.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 14838. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372260272
barcode_type UPC
col1 11
col1_sortorder 770
col2 bright
col2_sortorder 112
col3 40B
col3_sortorder 170
cost 9.26
deal_of_the_week NO
description 11, bright, 40B
group_id 972
group_uname robert-simmons-signet-brushes
id 14838
list_price 27.1
map NO
mfr_num 222141011
net_weight 0.1
non_member_discount 40
non_member_price 16.26
prop65 NO
ship_rule_desc STD
shipping STD
sku 14838
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.03
ta_dealer_c_price 10.03
ta_price 16.26
text
array
1 14838
2 222141011
3 11, bright, 40B
timestamp 2015-03-27T14:46:32.435Z
vip_member_price 10.84

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 35762. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372275276
barcode_type UPC
col1 11
col1_sortorder 770
col2 flat
col2_sortorder 209
col3 40F
col3_sortorder 171
cost 9.26
deal_of_the_week NO
description 11, flat, 40F
group_id 972
group_uname robert-simmons-signet-brushes
id 35762
list_price 27.1
map NO
mfr_num 222144011
net_weight 0.1
non_member_discount 40
non_member_price 16.26
prop65 NO
ship_rule_desc STD
shipping STD
sku 35762
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.03
ta_dealer_c_price 10.03
ta_price 16.26
text
array
1 35762
2 222144011
3 11, flat, 40F
timestamp 2015-03-27T14:47:06.683Z
vip_member_price 10.84

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 79691. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372307274
barcode_type UPC
col1 11
col1_sortorder 770
col2 filbert
col2_sortorder 202
col3 42
col3_sortorder 195
cost 9.26
deal_of_the_week NO
description 11, filbert, 42
group_id 972
group_uname robert-simmons-signet-brushes
id 79691
list_price 27.1
map NO
mfr_num 222142011
net_weight 0.12
non_member_discount 40
non_member_price 16.26
prop65 NO
ship_rule_desc STD
shipping STD
sku 79691
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.03
ta_dealer_c_price 10.03
ta_price 16.26
text
array
1 79691
2 222142011
3 11, filbert, 42
timestamp 2015-03-27T14:48:09.4Z
vip_member_price 10.84

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 43216. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372261279
barcode_type UPC
col1 12
col1_sortorder 816
col2 bright
col2_sortorder 112
col3 40B
col3_sortorder 170
cost 9.43
deal_of_the_week NO
description 12, bright, 40B
group_id 972
group_uname robert-simmons-signet-brushes
id 43216
list_price 27.6
map NO
mfr_num 222141012
net_weight 0.12
non_member_discount 40
non_member_price 16.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 43216
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.21
ta_dealer_c_price 10.21
ta_price 16.56
text
array
1 43216
2 222141012
3 12, bright, 40B
timestamp 2015-03-27T14:47:15.871Z
vip_member_price 11.04

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 60973. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372268124
barcode_type UPC
col1 12
col1_sortorder 816
col2 fan
col2_sortorder 198
col3 408
col3_sortorder 175
cost 10.81
deal_of_the_week NO
description 12, fan, 408
group_id 972
group_uname robert-simmons-signet-brushes
id 60973
list_price 31.65
map NO
mfr_num 222146012
net_weight 0.09
non_member_discount 40
non_member_price 18.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 60973
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.71
ta_dealer_c_price 11.71
ta_price 18.99
text
array
1 60973
2 222146012
3 12, fan, 408
timestamp 2015-03-27T14:47:39.562Z
vip_member_price 12.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 62607. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372308271
barcode_type UPC
col1 12
col1_sortorder 816
col2 filbert
col2_sortorder 202
col3 42
col3_sortorder 195
cost 9.43
deal_of_the_week NO
description 12, filbert, 42
group_id 972
group_uname robert-simmons-signet-brushes
id 62607
list_price 27.6
map NO
mfr_num 222142012
net_weight 0.12
non_member_discount 40
non_member_price 16.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 62607
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.21
ta_dealer_c_price 10.21
ta_price 16.56
text
array
1 62607
2 222142012
3 12, filbert, 42
timestamp 2015-03-27T14:47:42.276Z
vip_member_price 11.04

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 84366. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372293270
barcode_type UPC
col1 12
col1_sortorder 816
col2 round
col2_sortorder 434
col3 40R
col3_sortorder 172
cost 9.43
deal_of_the_week NO
description 12, round, 40R
group_id 972
group_uname robert-simmons-signet-brushes
id 84366
list_price 27.6
map NO
mfr_num 222145012
net_weight 0.12
non_member_discount 40
non_member_price 16.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 84366
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.21
ta_dealer_c_price 10.21
ta_price 16.56
text
array
1 84366
2 222145012
3 12, round, 40R
timestamp 2015-03-27T14:48:14.628Z
vip_member_price 11.04

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 87854. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372276273
barcode_type UPC
col1 12
col1_sortorder 816
col2 flat
col2_sortorder 209
col3 40F
col3_sortorder 171
cost 9.43
deal_of_the_week NO
description 12, flat, 40F
group_id 972
group_uname robert-simmons-signet-brushes
id 87854
list_price 27.6
map NO
mfr_num 222144012
net_weight 0.12
non_member_discount 40
non_member_price 16.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 87854
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.21
ta_dealer_c_price 10.21
ta_price 16.56
text
array
1 87854
2 222144012
3 12, flat, 40F
timestamp 2015-03-27T14:48:20.48Z
vip_member_price 11.04

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 10932. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372081334
barcode_type UPC
col1 14
col1_sortorder 912
col2 broad
col2_sortorder 122
col3 40
col3_sortorder 169
cost 13.31
deal_of_the_week NO
description 14, broad, 40
group_id 972
group_uname robert-simmons-signet-brushes
id 10932
list_price 38.95
map NO
mfr_num 222140014
net_weight 0.1
non_member_discount 40
non_member_price 23.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 10932
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.41
ta_dealer_c_price 14.41
ta_price 23.37
text
array
1 10932
2 222140014
3 14, broad, 40
timestamp 2015-03-27T14:46:24.949Z
vip_member_price 15.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 31837. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372082331
barcode_type UPC
col1 16
col1_sortorder 979
col2 broad
col2_sortorder 122
col3 40
col3_sortorder 169
cost 17.89
deal_of_the_week NO
description 16, broad, 40
group_id 972
group_uname robert-simmons-signet-brushes
id 31837
list_price 52.35
map NO
mfr_num 222140016
net_weight 0.15
non_member_discount 40
non_member_price 31.41
prop65 NO
ship_rule_desc STD
shipping STD
sku 31837
sku_pix YES
supplier_id 1
ta_dealer_a_price 19.37
ta_dealer_c_price 19.37
ta_price 31.41
text
array
1 31837
2 222140016
3 16, broad, 40
timestamp 2015-03-27T14:46:57.533Z
vip_member_price 20.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 43428. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372083338
barcode_type UPC
col1 18
col1_sortorder 1043
col2 broad
col2_sortorder 122
col3 40
col3_sortorder 169
cost 22.46
deal_of_the_week NO
description 18, broad, 40
group_id 972
group_uname robert-simmons-signet-brushes
id 43428
list_price 65.75
map NO
mfr_num 222140018
net_weight 0.17
non_member_discount 40
non_member_price 39.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 43428
sku_pix YES
supplier_id 1
ta_dealer_a_price 24.33
ta_dealer_c_price 24.33
ta_price 39.44
text
array
1 43428
2 222140018
3 18, broad, 40
timestamp 2015-03-27T14:47:16.067Z
vip_member_price 26.3

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 19574. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372266274
barcode_type UPC
col1 2
col1_sortorder 1114
col2 flat
col2_sortorder 209
col3 40F
col3_sortorder 171
cost 3.04
deal_of_the_week NO
description 2, flat, 40F
group_id 972
group_uname robert-simmons-signet-brushes
id 19574
list_price 8.9
map NO
mfr_num 222144002
net_weight 0.05
non_member_discount 40
non_member_price 5.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 19574
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.29
ta_dealer_c_price 3.29
ta_price 5.34
text
array
1 19574
2 222144002
3 2, flat, 40F
timestamp 2015-03-27T14:46:39.708Z
vip_member_price 3.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 21848. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372298275
barcode_type UPC
col1 2
col1_sortorder 1114
col2 filbert
col2_sortorder 202
col3 42
col3_sortorder 195
cost 3.04
deal_of_the_week NO
description 2, filbert, 42
group_id 972
group_uname robert-simmons-signet-brushes
id 21848
list_price 8.9
map NO
mfr_num 222142002
net_weight 0.04
non_member_discount 40
non_member_price 5.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 21848
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.29
ta_dealer_c_price 3.29
ta_price 5.34
text
array
1 21848
2 222142002
3 2, filbert, 42
timestamp 2015-03-27T14:46:42.653Z
vip_member_price 3.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 56737. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372283271
barcode_type UPC
col1 2
col1_sortorder 1114
col2 round
col2_sortorder 434
col3 40R
col3_sortorder 172
cost 3.04
deal_of_the_week NO
description 2, round, 40R
group_id 972
group_uname robert-simmons-signet-brushes
id 56737
list_price 8.9
map NO
mfr_num 222145002
net_weight 0.08
non_member_discount 40
non_member_price 5.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 56737
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.29
ta_dealer_c_price 3.29
ta_price 5.34
text
array
1 56737
2 222145002
3 2, round, 40R
timestamp 2015-03-27T14:47:31.841Z
vip_member_price 3.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 74848. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372251270
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bright
col2_sortorder 112
col3 40B
col3_sortorder 170
cost 3.04
deal_of_the_week NO
description 2, bright, 40B
group_id 972
group_uname robert-simmons-signet-brushes
id 74848
list_price 8.9
map NO
mfr_num 222141002
net_weight 0.08
non_member_discount 40
non_member_price 5.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 74848
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.29
ta_dealer_c_price 3.29
ta_price 5.34
text
array
1 74848
2 222141002
3 2, bright, 40B
timestamp 2015-03-27T14:48:05.025Z
vip_member_price 3.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 83760. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372318270
barcode_type UPC
col1 2
col1_sortorder 1114
col2 egbert
col2_sortorder 191
col3 43
col3_sortorder 196
cost 3.04
deal_of_the_week NO
description 2, egbert, 43
group_id 972
group_uname robert-simmons-signet-brushes
id 83760
list_price 8.9
map NO
mfr_num 222143002
net_weight 0.04
non_member_discount 40
non_member_price 5.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 83760
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.29
ta_dealer_c_price 3.29
ta_price 5.34
text
array
1 83760
2 222143002
3 2, egbert, 43
timestamp 2015-03-27T14:48:14.194Z
vip_member_price 3.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 88057. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372268025
barcode_type UPC
col1 2
col1_sortorder 1114
col2 fan
col2_sortorder 198
col3 408
col3_sortorder 175
cost 4.15
deal_of_the_week NO
description 2, fan, 408
group_id 972
group_uname robert-simmons-signet-brushes
id 88057
list_price 12.15
map NO
mfr_num 222146002
net_weight 0.04
non_member_discount 40
non_member_price 7.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 88057
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.5
ta_dealer_c_price 4.5
ta_price 8.51
text
array
1 88057
2 222146002
3 2, fan, 408
timestamp 2015-03-27T14:48:21.017Z
vip_member_price 4.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 12568. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 16794,27120,27210,28249,37830,39972,55278,62457,62562,79458,84400,84724,86644,87081,89953
AvailQtyList: 35.000000000000,11.000000000000,6.000000000000,126.000000000000,15.000000000000,54.000000000000,24.000000000000,34.000000000000,99.000000000000,2.000000000000,34.000000000000,13.000000000000,47.000000000000,18.000000000000,23.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372084335
barcode_type UPC
col1 20
col1_sortorder 1248
col2 broad
col2_sortorder 122
col3 40
col3_sortorder 169
cost 26.95
deal_of_the_week NO
description 20, broad, 40
group_id 972
group_uname robert-simmons-signet-brushes
id 12568
list_price 78.9
map NO
mfr_num 222140020
net_weight 0.2
non_member_discount 40
non_member_price 47.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 12568
sku_pix YES
supplier_id 1
ta_dealer_a_price 29.19
ta_dealer_c_price 29.19
ta_price 47.34
text
array
1 12568
2 222140020
3 20, broad, 40
timestamp 2015-03-27T14:46:27.672Z
vip_member_price 31.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 35.000000000000 16794
2 11.000000000000 27120
3 6.000000000000 27210
4 126.000000000000 28249
5 15.000000000000 37830
6 54.000000000000 39972
7 24.000000000000 55278
8 34.000000000000 62457
9 99.000000000000 62562
10 2.000000000000 79458
11 34.000000000000 84400
12 13.000000000000 84724
13 47.000000000000 86644
14 18.000000000000 87081
15 23.000000000000 89953
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8847' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e03093d202cc619124cd4a615a70196a5514
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=fb~midwest~fp~7-15~&gr=midwest-craft-plywood-sheets.html
urltoken CFID=29777529&CFTOKEN=75098398&jsessionid=e03093d202cc619124cd4a615a70196a5514
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:26:07'}
sessionid e030b9dfaf1ef116f0512f1921683c33282b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=oil-brushes&CatC=fb~robert-simmons~&gr=robert-simmons-signet-brushes.html
urltoken CFID=29777528&CFTOKEN=50060358&jsessionid=e030b9dfaf1ef116f0512f1921683c33282b
validationerror [empty string]


Problem with item sku 84975. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a972 972&wt=json&indent=on&fl=*&rows=1000&fq=group_id:972&sort=col1_sortorder asc&qt=dismax&hl=on