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

White Sable Short Handle Brushes

by Robert Simmons


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372166260
barcode_type UPC
col1 3/0
col1_sortorder 83
col2 round
col2_sortorder 434
col3 785
col3_sortorder 346
cost 2.35
deal_of_the_week NO
description 3/0, round, 785
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 63178
list_price 6.9
map NO
mfr_num 220085097
net_weight 0.04
non_member_discount 52
non_member_price 3.33
prop65 NO
ship_rule_desc STD
shipping STD
sku 63178
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.55
ta_dealer_c_price 2.55
ta_price 4.14
text
array
1 63178
2 220085097
3 3/0, round, 785
timestamp 2015-03-31T17:54:05.372Z
vip_member_price 2.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372167267
barcode_type UPC
col1 2/0
col1_sortorder 84
col2 round
col2_sortorder 434
col3 785
col3_sortorder 346
cost 2.44
deal_of_the_week NO
description 2/0, round, 785
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 72562
list_price 7.15
map NO
mfr_num 220085098
net_weight 0.04
non_member_discount 52
non_member_price 3.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 72562
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.65
ta_dealer_c_price 2.65
ta_price 4.29
text
array
1 72562
2 220085098
3 2/0, round, 785
timestamp 2015-03-31T17:54:23.695Z
vip_member_price 2.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372168264
barcode_type UPC
col1 0
col1_sortorder 85
col2 round
col2_sortorder 434
col3 785
col3_sortorder 346
cost 2.51
deal_of_the_week NO
description 0, round, 785
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 37403
list_price 7.35
map NO
mfr_num 220085099
net_weight 0.04
non_member_discount 52
non_member_price 3.54
prop65 NO
ship_rule_desc STD
shipping STD
sku 37403
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.72
ta_dealer_c_price 2.72
ta_price 4.41
text
array
1 37403
2 220085099
3 0, round, 785
timestamp 2015-03-31T17:53:20.734Z
vip_member_price 2.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372169261
barcode_type UPC
col1 1
col1_sortorder 275
col2 round
col2_sortorder 434
col3 785
col3_sortorder 346
cost 2.72
deal_of_the_week NO
description 1, round, 785
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 17892
list_price 7.95
map NO
mfr_num 220085001
net_weight 0.02
non_member_discount 52
non_member_price 3.83
prop65 NO
ship_rule_desc STD
shipping STD
sku 17892
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.94
ta_dealer_c_price 2.94
ta_price 4.77
text
array
1 17892
2 220085001
3 1, round, 785
timestamp 2015-03-31T17:52:49.254Z
vip_member_price 3.22

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372068267
barcode_type UPC
col1 1
col1_sortorder 275
col2 liner
col2_sortorder 282
col3 750
col3_sortorder 339
cost 2.65
deal_of_the_week NO
description 1, liner, 750
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 73369
list_price 7.75
map NO
mfr_num 220050001
net_weight 0.02
non_member_discount 52
non_member_price 3.74
prop65 NO
ship_rule_desc STD
shipping STD
sku 73369
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.87
ta_dealer_c_price 2.87
ta_price 4.65
text
array
1 73369
2 220050001
3 1, liner, 750
timestamp 2015-03-31T17:54:24.686Z
vip_member_price 3.14

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372016268
barcode_type UPC
col1 1 1/2 in.
col1_sortorder 297
col2 one stroke
col2_sortorder 371
col3 721
col3_sortorder 333
cost 22.59
deal_of_the_week NO
description 1 1/2 in., one stroke, 721
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 28821
list_price 66.15
map NO
mfr_num 220221150
net_weight 0.04
non_member_discount 52
non_member_price 31.88
prop65 NO
ship_rule_desc STD
shipping STD
sku 28821
sku_pix YES
supplier_id 1
ta_dealer_a_price 24.48
ta_dealer_c_price 24.48
ta_price 39.69
text
array
1 28821
2 220221150
3 1 1/2 in., one stroke, 721
timestamp 2015-03-31T17:53:05.923Z
vip_member_price 26.78

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372013267
barcode_type UPC
col1 1/2 in.
col1_sortorder 359
col2 one stroke
col2_sortorder 371
col3 721
col3_sortorder 333
cost 4.9
deal_of_the_week NO
description 1/2 in., one stroke, 721
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 31238
list_price 14.35
map NO
mfr_num 220221050
net_weight 0.04
non_member_discount 52
non_member_price 6.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 31238
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.31
ta_dealer_c_price 5.31
ta_price 8.61
text
array
1 31238
2 220221050
3 1/2 in., one stroke, 721
timestamp 2015-03-31T17:53:09.685Z
vip_member_price 5.81

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372095263
barcode_type UPC
col1 1/2 in.
col1_sortorder 359
col2 wash
col2_sortorder 539
col3 755
col3_sortorder 342
cost 5.99
deal_of_the_week NO
description 1/2 in., wash, 755
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 66303
list_price 17.55
map NO
mfr_num 220055050
net_weight 0.04
non_member_discount 52
non_member_price 8.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 66303
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.49
ta_dealer_c_price 6.49
ta_price 10.53
text
array
1 66303
2 220055050
3 1/2 in., wash, 755
timestamp 2015-03-31T17:54:10.55Z
vip_member_price 7.11

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372083260
barcode_type UPC
col1 1/2 in.
col1_sortorder 359
col2 oval wash
col2_sortorder 384
col3 752
col3_sortorder 341
cost 5.81
deal_of_the_week NO
description 1/2 in., oval wash, 752
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 81485
list_price 17
map NO
mfr_num 220052050
net_weight 0.04
non_member_discount 52
non_member_price 8.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 81485
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.29
ta_dealer_c_price 6.29
ta_price 10.2
text
array
1 81485
2 220052050
3 1/2 in., oval wash, 752
timestamp 2015-03-31T17:54:34.905Z
vip_member_price 6.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372014264
barcode_type UPC
col1 3/4 in.
col1_sortorder 360
col2 one stroke
col2_sortorder 371
col3 721
col3_sortorder 333
cost 7.76
deal_of_the_week NO
description 3/4 in., one stroke, 721
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 13052
list_price 22.7
map NO
mfr_num 220221075
net_weight 0.04
non_member_discount 52
non_member_price 10.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 13052
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.4
ta_dealer_c_price 8.4
ta_price 13.62
text
array
1 13052
2 220221075
3 3/4 in., one stroke, 721
timestamp 2015-03-31T17:52:39.597Z
vip_member_price 9.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372096260
barcode_type UPC
col1 3/4 in.
col1_sortorder 360
col2 wash
col2_sortorder 539
col3 755
col3_sortorder 342
cost 8.06
deal_of_the_week NO
description 3/4 in., wash, 755
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 31894
list_price 23.6
map NO
mfr_num 220055075
net_weight 0.04
non_member_discount 52
non_member_price 11.38
prop65 NO
ship_rule_desc STD
shipping STD
sku 31894
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.73
ta_dealer_c_price 8.73
ta_price 14.16
text
array
1 31894
2 220055075
3 3/4 in., wash, 755
timestamp 2015-03-31T17:53:10.417Z
vip_member_price 9.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372084267
barcode_type UPC
col1 3/4 in.
col1_sortorder 360
col2 oval wash
col2_sortorder 384
col3 752
col3_sortorder 341
cost 10.52
deal_of_the_week NO
description 3/4 in., oval wash, 752
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 85707
list_price 30.8
map NO
mfr_num 220052075
net_weight 0.04
non_member_discount 52
non_member_price 14.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 85707
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.4
ta_dealer_c_price 11.4
ta_price 18.48
text
array
1 85707
2 220052075
3 3/4 in., oval wash, 752
timestamp 2015-03-31T17:54:39.114Z
vip_member_price 12.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372015261
barcode_type UPC
col1 1 in.
col1_sortorder 363
col2 one stroke
col2_sortorder 371
col3 721
col3_sortorder 333
cost 11.83
deal_of_the_week NO
description 1 in., one stroke, 721
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 51945
list_price 34.65
map NO
mfr_num 220221100
net_weight 0.04
non_member_discount 52
non_member_price 16.7
prop65 NO
ship_rule_desc STD
shipping STD
sku 51945
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.82
ta_dealer_c_price 12.82
ta_price 20.79
text
array
1 51945
2 220221100
3 1 in., one stroke, 721
timestamp 2015-03-31T17:53:38.768Z
vip_member_price 14.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372085264
barcode_type UPC
col1 1 in.
col1_sortorder 363
col2 oval wash
col2_sortorder 384
col3 752
col3_sortorder 341
cost 12.74
deal_of_the_week NO
description 1 in., oval wash, 752
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 80216
list_price 37.3
map NO
mfr_num 220052100
net_weight 0.12
non_member_discount 52
non_member_price 17.98
prop65 NO
ship_rule_desc STD
shipping STD
sku 80216
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.8
ta_dealer_c_price 13.8
ta_price 22.38
text
array
1 80216
2 220052100
3 1 in., oval wash, 752
timestamp 2015-03-31T17:54:33.322Z
vip_member_price 15.1

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372097267
barcode_type UPC
col1 1 in.
col1_sortorder 363
col2 wash
col2_sortorder 539
col3 755
col3_sortorder 342
cost 10.49
deal_of_the_week NO
description 1 in., wash, 755
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 81108
list_price 30.7
map NO
mfr_num 220055100
net_weight 0.04
non_member_discount 52
non_member_price 14.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 81108
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.36
ta_dealer_c_price 11.36
ta_price 18.42
text
array
1 81108
2 220055100
3 1 in., wash, 755
timestamp 2015-03-31T17:54:34.244Z
vip_member_price 12.43

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 57
barcode 038372011263
barcode_type UPC
col1 1/8 in.
col1_sortorder 506
col2 one stroke
col2_sortorder 371
col3 721
col3_sortorder 333
cost 2.75
deal_of_the_week NO
description 1/8 in., one stroke, 721
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 67556
list_price 8.05
map NO
mfr_num 220221012
net_weight 0.05
non_member_discount 52
non_member_price 3.88
prop65 NO
ship_rule_desc STD
shipping STD
sku 67556
sku_pix NO
supplier_id 1
ta_dealer_a_price 2.98
ta_dealer_c_price 2.98
ta_price 5.63
text
array
1 67556
2 220221012
3 1/8 in., one stroke, 721
timestamp 2015-03-31T17:54:12.661Z
vip_member_price 3.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372082263
barcode_type UPC
col1 1/4 in.
col1_sortorder 578
col2 oval wash
col2_sortorder 384
col3 752
col3_sortorder 341
cost 4.48
deal_of_the_week NO
description 1/4 in., oval wash, 752
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 29794
list_price 13.1
map NO
mfr_num 220052025
net_weight 0.04
non_member_discount 52
non_member_price 6.31
prop65 NO
ship_rule_desc STD
shipping STD
sku 29794
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.85
ta_dealer_c_price 4.85
ta_price 7.86
text
array
1 29794
2 220052025
3 1/4 in., oval wash, 752
timestamp 2015-03-31T17:53:07.247Z
vip_member_price 5.3

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372012260
barcode_type UPC
col1 1/4 in.
col1_sortorder 578
col2 one stroke
col2_sortorder 371
col3 721
col3_sortorder 333
cost 3.49
deal_of_the_week NO
description 1/4 in., one stroke, 721
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 60156
list_price 10.2
map NO
mfr_num 220221025
net_weight 0.04
non_member_discount 52
non_member_price 4.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 60156
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.77
ta_dealer_c_price 3.77
ta_price 6.12
text
array
1 60156
2 220221025
3 1/4 in., one stroke, 721
timestamp 2015-03-31T17:53:54.789Z
vip_member_price 4.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372144268
barcode_type UPC
col1 10
col1_sortorder 692
col2 bright
col2_sortorder 112
col3 762B
col3_sortorder 343
cost 4.31
deal_of_the_week NO
description 10, bright, 762B
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 25519
list_price 12.6
map NO
mfr_num 220062010
net_weight 0.02
non_member_discount 52
non_member_price 6.07
prop65 NO
ship_rule_desc STD
shipping STD
sku 25519
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.66
ta_dealer_c_price 4.66
ta_price 7.56
text
array
1 25519
2 220062010
3 10, bright, 762B
timestamp 2015-03-31T17:53:01.67Z
vip_member_price 5.1

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372176269
barcode_type UPC
col1 10
col1_sortorder 692
col2 round
col2_sortorder 434
col3 785
col3_sortorder 346
cost 6.53
deal_of_the_week NO
description 10, round, 785
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 85020
list_price 19.1
map NO
mfr_num 220085010
net_weight 0.04
non_member_discount 52
non_member_price 9.21
prop65 NO
ship_rule_desc STD
shipping STD
sku 85020
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.07
ta_dealer_c_price 7.07
ta_price 11.46
text
array
1 85020
2 220085010
3 10, round, 785
timestamp 2015-03-31T17:54:38.754Z
vip_member_price 7.73

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372177266
barcode_type UPC
col1 12
col1_sortorder 816
col2 round
col2_sortorder 434
col3 785
col3_sortorder 346
cost 7.21
deal_of_the_week NO
description 12, round, 785
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 34363
list_price 21.1
map NO
mfr_num 220085012
net_weight 0.04
non_member_discount 52
non_member_price 10.17
prop65 NO
ship_rule_desc STD
shipping STD
sku 34363
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.81
ta_dealer_c_price 7.81
ta_price 12.66
text
array
1 34363
2 220085012
3 12, round, 785
timestamp 2015-03-31T17:53:16.292Z
vip_member_price 8.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372145265
barcode_type UPC
col1 12
col1_sortorder 816
col2 bright
col2_sortorder 112
col3 762B
col3_sortorder 343
cost 5.09
deal_of_the_week NO
description 12, bright, 762B
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 80865
list_price 14.9
map NO
mfr_num 220062012
net_weight 0.02
non_member_discount 52
non_member_price 7.18
prop65 NO
ship_rule_desc STD
shipping STD
sku 80865
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.51
ta_dealer_c_price 5.51
ta_price 8.94
text
array
1 80865
2 220062012
3 12, bright, 762B
timestamp 2015-03-31T17:54:33.973Z
vip_member_price 6.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372178263
barcode_type UPC
col1 14
col1_sortorder 912
col2 round
col2_sortorder 434
col3 785
col3_sortorder 346
cost 7.76
deal_of_the_week NO
description 14, round, 785
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 77091
list_price 22.7
map NO
mfr_num 220085014
net_weight 0.04
non_member_discount 52
non_member_price 10.94
prop65 NO
ship_rule_desc STD
shipping STD
sku 77091
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.4
ta_dealer_c_price 8.4
ta_price 13.62
text
array
1 77091
2 220085014
3 14, round, 785
timestamp 2015-03-31T17:54:29.482Z
vip_member_price 9.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372140260
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bright
col2_sortorder 112
col3 762B
col3_sortorder 343
cost 2.65
deal_of_the_week NO
description 2, bright, 762B
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 39788
list_price 7.75
map NO
mfr_num 220062002
net_weight 0.02
non_member_discount 52
non_member_price 3.74
prop65 NO
ship_rule_desc STD
shipping STD
sku 39788
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.87
ta_dealer_c_price 2.87
ta_price 4.65
text
array
1 39788
2 220062002
3 2, bright, 762B
timestamp 2015-03-31T17:53:23.706Z
vip_member_price 3.14

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372053263
barcode_type UPC
col1 2
col1_sortorder 1114
col2 fan
col2_sortorder 198
col3 748
col3_sortorder 338
cost 4.14
deal_of_the_week NO
description 2, fan, 748
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 86665
list_price 12.1
map NO
mfr_num 220048002
net_weight 0.05
non_member_discount 52
non_member_price 5.83
prop65 NO
ship_rule_desc STD
shipping STD
sku 86665
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.48
ta_dealer_c_price 4.48
ta_price 7.26
text
array
1 86665
2 220048002
3 2, fan, 748
timestamp 2015-03-31T17:54:39.848Z
vip_member_price 4.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372170267
barcode_type UPC
col1 2
col1_sortorder 1114
col2 round
col2_sortorder 434
col3 785
col3_sortorder 346
cost 2.92
deal_of_the_week NO
description 2, round, 785
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 87190
list_price 8.55
map NO
mfr_num 220085002
net_weight 0.04
non_member_discount 52
non_member_price 4.12
prop65 NO
ship_rule_desc STD
shipping STD
sku 87190
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 87190
2 220085002
3 2, round, 785
timestamp 2015-03-31T17:54:40.525Z
vip_member_price 3.46

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372069264
barcode_type UPC
col1 2
col1_sortorder 1114
col2 liner
col2_sortorder 282
col3 750
col3_sortorder 339
cost 2.72
deal_of_the_week NO
description 2, liner, 750
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 88064
list_price 7.95
map NO
mfr_num 220050002
net_weight 0.02
non_member_discount 52
non_member_price 3.83
prop65 NO
ship_rule_desc STD
shipping STD
sku 88064
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.94
ta_dealer_c_price 2.94
ta_price 4.77
text
array
1 88064
2 220050002
3 2, liner, 750
timestamp 2015-03-31T17:54:41.479Z
vip_member_price 3.22

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372189269
barcode_type UPC
col1 26
col1_sortorder 1404
col2 round wash
col2_sortorder 442
col3 789
col3_sortorder 347
cost 14.04
deal_of_the_week NO
description 26, round wash, 789
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 24051
list_price 41.1
map NO
mfr_num 220089026
net_weight 0.12
non_member_discount 52
non_member_price 19.81
prop65 NO
ship_rule_desc STD
shipping STD
sku 24051
sku_pix YES
supplier_id 1
ta_dealer_a_price 15.21
ta_dealer_c_price 15.21
ta_price 24.66
text
array
1 24051
2 220089026
3 26, round wash, 789
timestamp 2015-03-31T17:52:59.729Z
vip_member_price 16.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 57
barcode 038372070260
barcode_type UPC
col1 3
col1_sortorder 1434
col2 liner
col2_sortorder 282
col3 750
col3_sortorder 339
cost 2.49
deal_of_the_week NO
description 3, liner, 750
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 45994
list_price 7.3
map NO
mfr_num 220050003
net_weight 0.02
non_member_discount 52
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 45994
sku_pix NO
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.7
ta_price 5.11
text
array
1 45994
2 220050003
3 3, liner, 750
timestamp 2015-03-31T17:53:31.431Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372171264
barcode_type UPC
col1 3
col1_sortorder 1434
col2 round
col2_sortorder 434
col3 785
col3_sortorder 346
cost 3.21
deal_of_the_week NO
description 3, round, 785
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 67183
list_price 9.4
map NO
mfr_num 220085003
net_weight 0.02
non_member_discount 52
non_member_price 4.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 67183
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.48
ta_dealer_c_price 3.48
ta_price 5.64
text
array
1 67183
2 220085003
3 3, round, 785
timestamp 2015-03-31T17:54:12.024Z
vip_member_price 3.81

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372190265
barcode_type UPC
col1 30
col1_sortorder 1603
col2 round wash
col2_sortorder 442
col3 789
col3_sortorder 347
cost 18.28
deal_of_the_week NO
description 30, round wash, 789
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 40423
list_price 53.5
map NO
mfr_num 220089030
net_weight 0.15
non_member_discount 52
non_member_price 25.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 40423
sku_pix YES
supplier_id 1
ta_dealer_a_price 19.8
ta_dealer_c_price 19.8
ta_price 32.1
text
array
1 40423
2 220089030
3 30, round wash, 789
timestamp 2015-03-31T17:53:24.094Z
vip_member_price 21.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030af73a290f505993418634c241b766161
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=tools&CatD=sort~1~fp~6-12~&gr=proedge-mini-screwdriver-with-phillips-and-regular-tips.html
urltoken CFID=30631160&CFTOKEN=77023429&jsessionid=e030af73a290f505993418634c241b766161
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 22:16:49'}
sessionid e030bc1170a6b91b3bc3114b261e404b92b4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html
urltoken CFID=30631159&CFTOKEN=43128847&jsessionid=e030bc1170a6b91b3bc3114b261e404b92b4
validationerror [empty string]


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

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

ItemIDList: 62889
AvailQtyList: 18.000000000000

struct
FLAGS 0
VIP_member_discount 60
barcode 038372191262
barcode_type UPC
col1 36
col1_sortorder 1677
col2 round wash
col2_sortorder 442
col3 789
col3_sortorder 347
cost 19.39
deal_of_the_week NO
description 36, round wash, 789
group_id 1124
group_uname robert-simmons-white-sable-short-handle-brushes
id 44492
list_price 56.75
map NO
mfr_num 220089036
net_weight 0.18
non_member_discount 52
non_member_price 27.35
prop65 NO
ship_rule_desc STD
shipping STD
sku 44492
sku_pix YES
supplier_id 1
ta_dealer_a_price 21
ta_dealer_c_price 21
ta_price 34.05
text
array
1 44492
2 220089036
3 36, round wash, 789
timestamp 2015-03-31T17:53:29.748Z
vip_member_price 22.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 18.000000000000 62889
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] = '6324' 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.87.83.162

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~robert-simmons~fp~2-6~&gr=robert-simmons-white-sable-short-handle-brushes.html

StartSessionVariables: