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

Silverstone Series Hog Bristle Brushes

by Silver Brush


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179113509
barcode_type UPC
col1 0
col1_sortorder 85
col2 filbert
col2_sortorder 202
col3 1103
col3_sortorder 41
cost 2.94
deal_of_the_week NO
description 0, filbert, 1103
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 55801
list_price 9.65
map NO
mfr_num 1103-0
net_weight 0.01
non_member_discount 50
non_member_price 4.83
prop65 NO
ship_rule_desc STD
shipping STD
sku 55801
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.28
ta_dealer_c_price 3.28
ta_price 5.79
text
array
1 55801
2 1103-0
3 0, filbert, 1103
timestamp 2015-03-26T14:51:31.842Z
vip_member_price 3.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179110508
barcode_type UPC
col1 0
col1_sortorder 85
col2 round
col2_sortorder 434
col3 1100
col3_sortorder 38
cost 2.61
deal_of_the_week NO
description 0, round, 1100
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 70447
list_price 8.55
map NO
mfr_num 1100-0
net_weight 0.02
non_member_discount 50
non_member_price 4.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 70447
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.91
ta_dealer_c_price 2.91
ta_price 5.13
text
array
1 70447
2 1100-0
3 0, round, 1100
timestamp 2015-03-26T14:51:58.328Z
vip_member_price 3.42

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179112502
barcode_type UPC
col1 0
col1_sortorder 85
col2 bright
col2_sortorder 112
col3 1102
col3_sortorder 40
cost 2.61
deal_of_the_week NO
description 0, bright, 1102
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 71300
list_price 8.55
map NO
mfr_num 1102-0
net_weight 0.01
non_member_discount 50
non_member_price 4.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 71300
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.91
ta_dealer_c_price 2.91
ta_price 5.13
text
array
1 71300
2 1102-0
3 0, bright, 1102
timestamp 2015-03-26T14:51:59.652Z
vip_member_price 3.42

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179111505
barcode_type UPC
col1 0
col1_sortorder 85
col2 flat
col2_sortorder 209
col3 1101
col3_sortorder 39
cost 2.61
deal_of_the_week NO
description 0, flat, 1101
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 85631
list_price 8.55
map NO
mfr_num 1101-0
net_weight 0.02
non_member_discount 50
non_member_price 4.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 85631
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.91
ta_dealer_c_price 2.91
ta_price 5.13
text
array
1 85631
2 1101-0
3 0, flat, 1101
timestamp 2015-03-26T14:52:17.416Z
vip_member_price 3.42

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179111512
barcode_type UPC
col1 1
col1_sortorder 275
col2 flat
col2_sortorder 209
col3 1101
col3_sortorder 39
cost 2.82
deal_of_the_week NO
description 1, flat, 1101
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 11144
list_price 9.25
map NO
mfr_num 1101-1
net_weight 0.02
non_member_discount 50
non_member_price 4.63
prop65 NO
ship_rule_desc STD
shipping STD
sku 11144
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.15
ta_dealer_c_price 3.15
ta_price 5.55
text
array
1 11144
2 1101-1
3 1, flat, 1101
timestamp 2015-03-26T14:50:27.879Z
vip_member_price 3.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179112519
barcode_type UPC
col1 1
col1_sortorder 275
col2 bright
col2_sortorder 112
col3 1102
col3_sortorder 40
cost 2.82
deal_of_the_week NO
description 1, bright, 1102
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 24743
list_price 9.25
map NO
mfr_num 1102-1
net_weight 0.02
non_member_discount 50
non_member_price 4.63
prop65 NO
ship_rule_desc STD
shipping STD
sku 24743
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.15
ta_dealer_c_price 3.15
ta_price 5.55
text
array
1 24743
2 1102-1
3 1, bright, 1102
timestamp 2015-03-26T14:50:47.855Z
vip_member_price 3.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179114513
barcode_type UPC
col1 1
col1_sortorder 275
col2 fan
col2_sortorder 198
col3 1104
col3_sortorder 42
cost 3.25
deal_of_the_week NO
description 1, fan, 1104
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 40141
list_price 10.65
map NO
mfr_num 1104-1
net_weight 0.02
non_member_discount 50
non_member_price 5.33
prop65 NO
ship_rule_desc STD
shipping STD
sku 40141
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.62
ta_dealer_c_price 3.62
ta_price 6.39
text
array
1 40141
2 1104-1
3 1, fan, 1104
timestamp 2015-03-26T14:51:09.947Z
vip_member_price 4.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179110515
barcode_type UPC
col1 1
col1_sortorder 275
col2 round
col2_sortorder 434
col3 1100
col3_sortorder 38
cost 2.82
deal_of_the_week NO
description 1, round, 1100
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 76204
list_price 9.25
map NO
mfr_num 1100-1
net_weight 0.03
non_member_discount 50
non_member_price 4.63
prop65 NO
ship_rule_desc STD
shipping STD
sku 76204
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.15
ta_dealer_c_price 3.15
ta_price 5.55
text
array
1 76204
2 1100-1
3 1, round, 1100
timestamp 2015-03-26T14:52:06.868Z
vip_member_price 3.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179113516
barcode_type UPC
col1 1
col1_sortorder 275
col2 filbert
col2_sortorder 202
col3 1103
col3_sortorder 41
cost 2.99
deal_of_the_week NO
description 1, filbert, 1103
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 88504
list_price 9.8
map NO
mfr_num 1103-1
net_weight 0.02
non_member_discount 50
non_member_price 4.9
prop65 NO
ship_rule_desc STD
shipping STD
sku 88504
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.33
ta_dealer_c_price 3.33
ta_price 5.88
text
array
1 88504
2 1103-1
3 1, filbert, 1103
timestamp 2015-03-26T14:52:20.176Z
vip_member_price 3.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179110607
barcode_type UPC
col1 10
col1_sortorder 692
col2 round
col2_sortorder 434
col3 1100
col3_sortorder 38
cost 6.64
deal_of_the_week NO
description 10, round, 1100
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 23982
list_price 21.75
map NO
mfr_num 1100-10
net_weight 0.06
non_member_discount 50
non_member_price 10.88
prop65 NO
ship_rule_desc STD
shipping STD
sku 23982
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.4
ta_dealer_c_price 7.4
ta_price 13.05
text
array
1 23982
2 1100-10
3 10, round, 1100
timestamp 2015-03-26T14:50:46.595Z
vip_member_price 8.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179112601
barcode_type UPC
col1 10
col1_sortorder 692
col2 bright
col2_sortorder 112
col3 1102
col3_sortorder 40
cost 6.64
deal_of_the_week NO
description 10, bright, 1102
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 38022
list_price 21.75
map NO
mfr_num 1102-10
net_weight 0.08
non_member_discount 50
non_member_price 10.88
prop65 NO
ship_rule_desc STD
shipping STD
sku 38022
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.4
ta_dealer_c_price 7.4
ta_price 13.05
text
array
1 38022
2 1102-10
3 10, bright, 1102
timestamp 2015-03-26T14:51:07.807Z
vip_member_price 8.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179111604
barcode_type UPC
col1 10
col1_sortorder 692
col2 flat
col2_sortorder 209
col3 1101
col3_sortorder 39
cost 6.64
deal_of_the_week NO
description 10, flat, 1101
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 52949
list_price 21.75
map NO
mfr_num 1101-10
net_weight 0.08
non_member_discount 50
non_member_price 10.88
prop65 NO
ship_rule_desc STD
shipping STD
sku 52949
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.4
ta_dealer_c_price 7.4
ta_price 13.05
text
array
1 52949
2 1101-10
3 10, flat, 1101
timestamp 2015-03-26T14:51:28.182Z
vip_member_price 8.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179114605
barcode_type UPC
col1 10
col1_sortorder 692
col2 fan
col2_sortorder 198
col3 1104
col3_sortorder 42
cost 6.87
deal_of_the_week NO
description 10, fan, 1104
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 56293
list_price 22.5
map NO
mfr_num 1104-10
net_weight 0.07
non_member_discount 50
non_member_price 11.25
prop65 NO
ship_rule_desc STD
shipping STD
sku 56293
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.65
ta_dealer_c_price 7.65
ta_price 13.5
text
array
1 56293
2 1104-10
3 10, fan, 1104
timestamp 2015-03-26T14:51:32.67Z
vip_member_price 9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179113608
barcode_type UPC
col1 10
col1_sortorder 692
col2 filbert
col2_sortorder 202
col3 1103
col3_sortorder 41
cost 6.87
deal_of_the_week NO
description 10, filbert, 1103
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 67204
list_price 22.5
map NO
mfr_num 1103-10
net_weight 0.08
non_member_discount 50
non_member_price 11.25
prop65 NO
ship_rule_desc STD
shipping STD
sku 67204
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.65
ta_dealer_c_price 7.65
ta_price 13.5
text
array
1 67204
2 1103-10
3 10, filbert, 1103
timestamp 2015-03-26T14:51:51.528Z
vip_member_price 9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179110621
barcode_type UPC
col1 12
col1_sortorder 816
col2 round
col2_sortorder 434
col3 1100
col3_sortorder 38
cost 8.43
deal_of_the_week NO
description 12, round, 1100
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 41836
list_price 27.65
map NO
mfr_num 1100-12
net_weight 0.08
non_member_discount 50
non_member_price 13.83
prop65 NO
ship_rule_desc STD
shipping STD
sku 41836
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.4
ta_dealer_c_price 9.4
ta_price 16.59
text
array
1 41836
2 1100-12
3 12, round, 1100
timestamp 2015-03-26T14:51:11.352Z
vip_member_price 11.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179113622
barcode_type UPC
col1 12
col1_sortorder 816
col2 filbert
col2_sortorder 202
col3 1103
col3_sortorder 41
cost 8.66
deal_of_the_week NO
description 12, filbert, 1103
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 47197
list_price 28.4
map NO
mfr_num 1103-12
net_weight 0.08
non_member_discount 50
non_member_price 14.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 47197
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.66
ta_dealer_c_price 9.66
ta_price 17.04
text
array
1 47197
2 1103-12
3 12, filbert, 1103
timestamp 2015-03-26T14:51:18.958Z
vip_member_price 11.36

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179111628
barcode_type UPC
col1 12
col1_sortorder 816
col2 flat
col2_sortorder 209
col3 1101
col3_sortorder 39
cost 8.43
deal_of_the_week NO
description 12, flat, 1101
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 54329
list_price 27.65
map NO
mfr_num 1101-12
net_weight 0.08
non_member_discount 50
non_member_price 13.83
prop65 NO
ship_rule_desc STD
shipping STD
sku 54329
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.4
ta_dealer_c_price 9.4
ta_price 16.59
text
array
1 54329
2 1101-12
3 12, flat, 1101
timestamp 2015-03-26T14:51:29.865Z
vip_member_price 11.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179112625
barcode_type UPC
col1 12
col1_sortorder 816
col2 bright
col2_sortorder 112
col3 1102
col3_sortorder 40
cost 8.43
deal_of_the_week NO
description 12, bright, 1102
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 69020
list_price 27.65
map NO
mfr_num 1102-12
net_weight 0.08
non_member_discount 50
non_member_price 13.83
prop65 NO
ship_rule_desc STD
shipping STD
sku 69020
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.4
ta_dealer_c_price 9.4
ta_price 16.59
text
array
1 69020
2 1102-12
3 12, bright, 1102
timestamp 2015-03-26T14:51:54.892Z
vip_member_price 11.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179114629
barcode_type UPC
col1 12
col1_sortorder 816
col2 fan
col2_sortorder 198
col3 1104
col3_sortorder 42
cost 8.36
deal_of_the_week NO
description 12, fan, 1104
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 69272
list_price 27.4
map NO
mfr_num 1104-12
net_weight 0.07
non_member_discount 50
non_member_price 13.7
prop65 NO
ship_rule_desc STD
shipping STD
sku 69272
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.32
ta_dealer_c_price 9.32
ta_price 16.44
text
array
1 69272
2 1104-12
3 12, fan, 1104
timestamp 2015-03-26T14:51:55.622Z
vip_member_price 10.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179113646
barcode_type UPC
col1 14
col1_sortorder 912
col2 filbert
col2_sortorder 202
col3 1103
col3_sortorder 41
cost 14.15
deal_of_the_week NO
description 14, filbert, 1103
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 37968
list_price 46.4
map NO
mfr_num 1103-14
net_weight 0.08
non_member_discount 50
non_member_price 23.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 37968
sku_pix YES
supplier_id 1
ta_dealer_a_price 15.78
ta_dealer_c_price 15.78
ta_price 27.84
text
array
1 37968
2 1103-14
3 14, filbert, 1103
timestamp 2015-03-26T14:51:07.766Z
vip_member_price 18.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179113660
barcode_type UPC
col1 16
col1_sortorder 979
col2 filbert
col2_sortorder 202
col3 1103
col3_sortorder 41
cost 17.68
deal_of_the_week NO
description 16, filbert, 1103
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 56778
list_price 57.95
map NO
mfr_num 1103-16
net_weight 0.09
non_member_discount 50
non_member_price 28.98
prop65 NO
ship_rule_desc STD
shipping STD
sku 56778
sku_pix YES
supplier_id 1
ta_dealer_a_price 19.7
ta_dealer_c_price 19.7
ta_price 34.77
text
array
1 56778
2 1103-16
3 16, filbert, 1103
timestamp 2015-03-26T14:51:33.271Z
vip_member_price 23.18

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179113684
barcode_type UPC
col1 18
col1_sortorder 1043
col2 filbert
col2_sortorder 202
col3 1103
col3_sortorder 41
cost 21.9
deal_of_the_week NO
description 18, filbert, 1103
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 82257
list_price 71.8
map NO
mfr_num 1103-18
net_weight 0.09
non_member_discount 50
non_member_price 35.9
prop65 NO
ship_rule_desc STD
shipping STD
sku 82257
sku_pix YES
supplier_id 1
ta_dealer_a_price 24.41
ta_dealer_c_price 24.41
ta_price 43.08
text
array
1 82257
2 1103-18
3 18, filbert, 1103
timestamp 2015-03-26T14:52:14.979Z
vip_member_price 28.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179112526
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bright
col2_sortorder 112
col3 1102
col3_sortorder 40
cost 2.99
deal_of_the_week NO
description 2, bright, 1102
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 10344
list_price 9.78
map NO
mfr_num 1102-2
net_weight 0.02
non_member_discount 50
non_member_price 4.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 10344
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.33
ta_dealer_c_price 3.33
ta_price 5.87
text
array
1 10344
2 1102-2
3 2, bright, 1102
timestamp 2015-03-26T14:50:27.004Z
vip_member_price 3.91

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179111529
barcode_type UPC
col1 2
col1_sortorder 1114
col2 flat
col2_sortorder 209
col3 1101
col3_sortorder 39
cost 2.99
deal_of_the_week NO
description 2, flat, 1101
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 44007
list_price 9.8
map NO
mfr_num 1101-2
net_weight 0.02
non_member_discount 50
non_member_price 4.9
prop65 NO
ship_rule_desc STD
shipping STD
sku 44007
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.33
ta_dealer_c_price 3.33
ta_price 5.88
text
array
1 44007
2 1101-2
3 2, flat, 1101
timestamp 2015-03-26T14:51:13.67Z
vip_member_price 3.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179110522
barcode_type UPC
col1 2
col1_sortorder 1114
col2 round
col2_sortorder 434
col3 1100
col3_sortorder 38
cost 2.99
deal_of_the_week NO
description 2, round, 1100
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 46441
list_price 9.8
map NO
mfr_num 1100-2
net_weight 0.04
non_member_discount 50
non_member_price 4.9
prop65 NO
ship_rule_desc STD
shipping STD
sku 46441
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.33
ta_dealer_c_price 3.33
ta_price 5.88
text
array
1 46441
2 1100-2
3 2, round, 1100
timestamp 2015-03-26T14:51:17.545Z
vip_member_price 3.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179113523
barcode_type UPC
col1 2
col1_sortorder 1114
col2 filbert
col2_sortorder 202
col3 1103
col3_sortorder 41
cost 3.12
deal_of_the_week NO
description 2, filbert, 1103
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 55220
list_price 10.25
map NO
mfr_num 1103-2
net_weight 0.02
non_member_discount 50
non_member_price 5.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 55220
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.49
ta_dealer_c_price 3.49
ta_price 6.15
text
array
1 55220
2 1103-2
3 2, filbert, 1103
timestamp 2015-03-26T14:51:30.981Z
vip_member_price 4.1

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179114520
barcode_type UPC
col1 2
col1_sortorder 1114
col2 fan
col2_sortorder 198
col3 1104
col3_sortorder 42
cost 3.43
deal_of_the_week NO
description 2, fan, 1104
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 64420
list_price 11.25
map NO
mfr_num 1104-2
net_weight 0.03
non_member_discount 50
non_member_price 5.63
prop65 NO
ship_rule_desc STD
shipping STD
sku 64420
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.83
ta_dealer_c_price 3.83
ta_price 6.75
text
array
1 64420
2 1104-2
3 2, fan, 1104
timestamp 2015-03-26T14:51:46.891Z
vip_member_price 4.5

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179114704
barcode_type UPC
col1 20
col1_sortorder 1248
col2 fan
col2_sortorder 198
col3 1104
col3_sortorder 42
cost 10.97
deal_of_the_week NO
description 20, fan, 1104
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 83495
list_price 35.95
map NO
mfr_num 1104-20
net_weight 0.08
non_member_discount 50
non_member_price 17.98
prop65 NO
ship_rule_desc STD
shipping STD
sku 83495
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.22
ta_dealer_c_price 12.22
ta_price 21.57
text
array
1 83495
2 1104-20
3 20, fan, 1104
timestamp 2015-03-26T14:52:15.825Z
vip_member_price 14.38

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179113707
barcode_type UPC
col1 20
col1_sortorder 1248
col2 filbert
col2_sortorder 202
col3 1103
col3_sortorder 41
cost 27.44
deal_of_the_week NO
description 20, filbert, 1103
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 87935
list_price 89.95
map NO
mfr_num 1103-20
net_weight 0.09
non_member_discount 50
non_member_price 44.98
prop65 NO
ship_rule_desc STD
shipping STD
sku 87935
sku_pix YES
supplier_id 1
ta_dealer_a_price 30.58
ta_dealer_c_price 30.58
ta_price 53.97
text
array
1 87935
2 1103-20
3 20, filbert, 1103
timestamp 2015-03-26T14:52:19.628Z
vip_member_price 35.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179113530
barcode_type UPC
col1 3
col1_sortorder 1434
col2 filbert
col2_sortorder 202
col3 1103
col3_sortorder 41
cost 3.29
deal_of_the_week NO
description 3, filbert, 1103
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 45671
list_price 10.8
map NO
mfr_num 1103-3
net_weight 0.04
non_member_discount 50
non_member_price 5.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 45671
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.67
ta_dealer_c_price 3.67
ta_price 6.48
text
array
1 45671
2 1103-3
3 3, filbert, 1103
timestamp 2015-03-26T14:51:16.183Z
vip_member_price 4.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 60
barcode 765179111536
barcode_type UPC
col1 3
col1_sortorder 1434
col2 flat
col2_sortorder 209
col3 1101
col3_sortorder 39
cost 3.29
deal_of_the_week NO
description 3, flat, 1101
group_id 264
group_uname silver-brush-silverstone-series-hog-bristle-brushes
id 46425
list_price 10.8
map NO
mfr_num 1101-3
net_weight 0.04
non_member_discount 50
non_member_price 5.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 46425
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.67
ta_dealer_c_price 3.67
ta_price 6.48
text
array
1 46425
2 1101-3
3 3, flat, 1101
timestamp 2015-03-26T14:51:17.529Z
vip_member_price 4.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 22751
2 0E-12 22954
3 0E-12 27555
4 0E-12 32364
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] = '10737' 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.167.175.241

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e03072fb330bf3810cef2e4a301e66496671
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=puzzles-games&CatD=sort~1~fb~melissa-doug~fp~5-15~&gr=melissa-doug-wooden-chunky-puzzles.html
urltoken CFID=29236926&CFTOKEN=56151766&jsessionid=e03072fb330bf3810cef2e4a301e66496671
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 21:38:15'}
sessionid e030ec9835687a79f7d848203a37f367f624
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=sort~1~fp~10-9999.99~c1~brushes~&gr=silver-brush-silverstone-series-hog-bristle-brushes.html
urltoken CFID=29236925&CFTOKEN=29692964&jsessionid=e030ec9835687a79f7d848203a37f367f624
validationerror [empty string]


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

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

ItemIDList: 22751,22954,27555,32364
AvailQtyList: 0E-12,0E-12,0E-12,0E-12