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

Block Printing Water Soluble Ink

by Speedball


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032034008
barcode_type UPC
col1 black
col1_sortorder 402
col2 1.3 oz.
col2_sortorder 533
col3 [empty string]
color_swatch 18-14-14.jpg
cost 2.2
deal_of_the_week NO
description black, 1.3 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 18457
list_price 4.44
map NO
mfr_num 3400
net_weight 0.12
non_member_discount 15
non_member_price 3.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 18457
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.4
ta_price 3.55
text
array
1 18457
2 3400
3 black, 1.3 oz.
timestamp 2015-03-31T17:52:50.346Z
vip_member_price 2.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032037009
barcode_type UPC
col1 black
col1_sortorder 402
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 18-14-14.jpg
cost 11.49
deal_of_the_week NO
description black, 16 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 66797
list_price 23.25
map NO
mfr_num 3700
net_weight 1.54
non_member_discount 15
non_member_price 19.76
prop65 NO
ship_rule_desc STD
shipping STD
sku 66797
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.56
ta_dealer_c_price 12.56
ta_price 18.6
text
array
1 66797
2 3700
3 black, 16 oz.
timestamp 2015-03-31T17:54:11.514Z
vip_member_price 12.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 651032035005
barcode_type UPC
col1 black
col1_sortorder 402
col2 2.5 oz.
col2_sortorder 1240
col3 [empty string]
color_swatch 18-14-14.jpg
cost 3.67
deal_of_the_week NO
description black, 2.5 oz.
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 78887
list_price 7.44
map NO
mfr_num 3500
net_weight 0.31
non_member_discount 15
non_member_price 6.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 78887
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.02
ta_dealer_c_price 4.02
ta_price 5.95
text
array
1 78887
2 3500
3 black, 2.5 oz.
timestamp 2015-03-31T17:54:31.748Z
vip_member_price 4.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032034022
barcode_type UPC
col1 blue
col1_sortorder 542
col2 1.3 oz.
col2_sortorder 533
col3 [empty string]
color_swatch 56-81-161.jpg
cost 2.2
deal_of_the_week NO
description blue, 1.3 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 12578
list_price 4.44
map NO
mfr_num 3402
net_weight 0.12
non_member_discount 15
non_member_price 3.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 12578
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.4
ta_price 3.55
text
array
1 12578
2 3402
3 blue, 1.3 oz.
timestamp 2015-03-31T17:52:38.949Z
vip_member_price 2.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 651032035029
barcode_type UPC
col1 blue
col1_sortorder 542
col2 2.5 oz.
col2_sortorder 1240
col3 [empty string]
color_swatch 56-81-161.jpg
cost 3.67
deal_of_the_week NO
description blue, 2.5 oz.
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 32276
list_price 7.44
map NO
mfr_num 3502
net_weight 0.31
non_member_discount 15
non_member_price 6.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 32276
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.02
ta_dealer_c_price 4.02
ta_price 5.95
text
array
1 32276
2 3502
3 blue, 2.5 oz.
timestamp 2015-03-31T17:53:11.025Z
vip_member_price 4.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032037023
barcode_type UPC
col1 blue
col1_sortorder 542
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 56-81-161.jpg
cost 11.49
deal_of_the_week NO
description blue, 16 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 62342
list_price 23.25
map NO
mfr_num 3702
net_weight 1.54
non_member_discount 15
non_member_price 19.76
prop65 NO
ship_rule_desc STD
shipping STD
sku 62342
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.56
ta_dealer_c_price 12.56
ta_price 18.6
text
array
1 62342
2 3702
3 blue, 16 oz.
timestamp 2015-03-31T17:54:03.26Z
vip_member_price 12.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 651032034060
barcode_type UPC
col1 brown
col1_sortorder 799
col2 1.3 oz.
col2_sortorder 533
col3 [empty string]
color_swatch 92-42-14.jpg
cost 2.2
deal_of_the_week NO
description brown, 1.3 oz.
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 22666
list_price 4.44
map NO
mfr_num 3406
net_weight 0.12
non_member_discount 15
non_member_price 3.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 22666
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.4
ta_price 3.55
text
array
1 22666
2 3406
3 brown, 1.3 oz.
timestamp 2015-03-31T17:52:58.195Z
vip_member_price 2.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 651032035067
barcode_type UPC
col1 brown
col1_sortorder 799
col2 2.5 oz.
col2_sortorder 1240
col3 [empty string]
color_swatch 92-42-14.jpg
cost 3.67
deal_of_the_week NO
description brown, 2.5 oz.
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 32254
list_price 7.44
map NO
mfr_num 3506
net_weight 0.31
non_member_discount 15
non_member_price 6.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 32254
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.02
ta_dealer_c_price 4.02
ta_price 5.95
text
array
1 32254
2 3506
3 brown, 2.5 oz.
timestamp 2015-03-31T17:53:11.008Z
vip_member_price 4.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032035166
barcode_type UPC
col1 copper
col1_sortorder 1529
col2 2.5 oz.
col2_sortorder 1240
col3 [empty string]
color_swatch 162-76-36.jpg
cost 3.67
deal_of_the_week NO
description copper, 2.5 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 18897
list_price 7.44
map NO
mfr_num 3516
net_weight 0.31
non_member_discount 15
non_member_price 6.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 18897
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.02
ta_dealer_c_price 4.02
ta_price 5.95
text
array
1 18897
2 3516
3 copper, 2.5 oz.
timestamp 2015-03-31T17:52:51.018Z
vip_member_price 4.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 651032034169
barcode_type UPC
col1 copper
col1_sortorder 1529
col2 1.3 oz.
col2_sortorder 533
col3 [empty string]
color_swatch 162-76-36.jpg
cost 2.2
deal_of_the_week NO
description copper, 1.3 oz.
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 22741
list_price 4.44
map NO
mfr_num 3416
net_weight 0.12
non_member_discount 15
non_member_price 3.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 22741
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.4
ta_price 3.55
text
array
1 22741
2 3416
3 copper, 1.3 oz.
timestamp 2015-03-31T17:52:58.272Z
vip_member_price 2.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 651032035128
barcode_type UPC
col1 dark yellow
col1_sortorder 1776
col2 2.5 oz.
col2_sortorder 1240
col3 [empty string]
color_swatch 251-198-26.jpg
cost 3.67
deal_of_the_week NO
description dark yellow, 2.5 oz.
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 30893
list_price 7.44
map NO
mfr_num 3512
net_weight 0.31
non_member_discount 15
non_member_price 6.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 30893
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.02
ta_dealer_c_price 4.02
ta_price 5.95
text
array
1 30893
2 3512
3 dark yellow, 2.5 oz.
timestamp 2015-03-31T17:53:09.135Z
vip_member_price 4.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032034121
barcode_type UPC
col1 dark yellow
col1_sortorder 1776
col2 1.3 oz.
col2_sortorder 533
col3 [empty string]
color_swatch 251-198-26.jpg
cost 2.2
deal_of_the_week NO
description dark yellow, 1.3 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 45208
list_price 4.44
map NO
mfr_num 3412
net_weight 0.12
non_member_discount 15
non_member_price 3.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 45208
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.4
ta_price 3.55
text
array
1 45208
2 3412
3 dark yellow, 1.3 oz.
timestamp 2015-03-31T17:53:30.606Z
vip_member_price 2.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032035258
barcode_type UPC
col1 fluorescent blue
col1_sortorder 2215
col2 2.5 oz.
col2_sortorder 1240
col3 [empty string]
color_swatch 45-157-216.jpg
cost 3.67
deal_of_the_week NO
description fluorescent blue, 2.5 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 07793
list_price 7.44
map NO
mfr_num 3525
net_weight 0.23
non_member_discount 15
non_member_price 6.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 07793
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.02
ta_dealer_c_price 4.02
ta_price 5.95
text
array
1 07793
2 3525
3 fluorescent blue, 2.5 oz.
timestamp 2015-03-31T17:52:29.872Z
vip_member_price 4.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032035210
barcode_type UPC
col1 fluorescent hot pink
col1_sortorder 2221
col2 2.5 oz.
col2_sortorder 1240
col3 [empty string]
color_swatch 232-64-150.jpg
cost 3.67
deal_of_the_week NO
description fluorescent hot pink, 2.5 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 07782
list_price 7.44
map NO
mfr_num 3521
net_weight 0.23
non_member_discount 15
non_member_price 6.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 07782
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.02
ta_dealer_c_price 4.02
ta_price 5.95
text
array
1 07782
2 3521
3 fluorescent hot pink, 2.5 oz.
timestamp 2015-03-31T17:52:29.853Z
vip_member_price 4.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032035203
barcode_type UPC
col1 fluorescent lime green
col1_sortorder 2224
col2 2.5 oz.
col2_sortorder 1240
col3 [empty string]
color_swatch 107-189-68.jpg
cost 3.67
deal_of_the_week NO
description fluorescent lime green, 2.5 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 07785
list_price 7.44
map NO
mfr_num 3520
net_weight 0.23
non_member_discount 15
non_member_price 6.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 07785
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.02
ta_dealer_c_price 4.02
ta_price 5.95
text
array
1 07785
2 3520
3 fluorescent lime green, 2.5 oz.
timestamp 2015-03-31T17:52:29.855Z
vip_member_price 4.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032035234
barcode_type UPC
col1 fluorescent magenta
col1_sortorder 2225
col2 2.5 oz.
col2_sortorder 1240
col3 [empty string]
color_swatch 237-39-65.jpg
cost 3.67
deal_of_the_week NO
description fluorescent magenta, 2.5 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 07789
list_price 7.44
map NO
mfr_num 3523
net_weight 0.23
non_member_discount 15
non_member_price 6.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 07789
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.02
ta_dealer_c_price 4.02
ta_price 5.95
text
array
1 07789
2 3523
3 fluorescent magenta, 2.5 oz.
timestamp 2015-03-31T17:52:29.861Z
vip_member_price 4.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032035227
barcode_type UPC
col1 fluorescent orange
col1_sortorder 2226
col2 2.5 oz.
col2_sortorder 1240
col3 [empty string]
color_swatch 243-117-32.jpg
cost 3.67
deal_of_the_week NO
description fluorescent orange, 2.5 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 07786
list_price 7.44
map NO
mfr_num 3522
net_weight 0.23
non_member_discount 15
non_member_price 6.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 07786
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.02
ta_dealer_c_price 4.02
ta_price 5.95
text
array
1 07786
2 3522
3 fluorescent orange, 2.5 oz.
timestamp 2015-03-31T17:52:29.857Z
vip_member_price 4.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032035241
barcode_type UPC
col1 fluorescent yellow
col1_sortorder 2238
col2 2.5 oz.
col2_sortorder 1240
col3 [empty string]
color_swatch 246-235-22.jpg
cost 3.67
deal_of_the_week NO
description fluorescent yellow, 2.5 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 07791
list_price 7.44
map NO
mfr_num 3524
net_weight 0.23
non_member_discount 15
non_member_price 6.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 07791
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.02
ta_dealer_c_price 4.02
ta_price 5.95
text
array
1 07791
2 3524
3 fluorescent yellow, 2.5 oz.
timestamp 2015-03-31T17:52:29.866Z
vip_member_price 4.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 651032037139
barcode_type UPC
col1 gold
col1_sortorder 2491
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 148-119-44.jpg
cost 11.49
deal_of_the_week NO
description gold, 16 oz.
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 29476
list_price 23.25
map NO
mfr_num 3713
net_weight 1.54
non_member_discount 15
non_member_price 19.76
prop65 NO
ship_rule_desc STD
shipping STD
sku 29476
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.56
ta_dealer_c_price 12.56
ta_price 18.6
text
array
1 29476
2 3713
3 gold, 16 oz.
timestamp 2015-03-31T17:53:06.815Z
vip_member_price 12.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 651032035135
barcode_type UPC
col1 gold
col1_sortorder 2491
col2 2.5 oz.
col2_sortorder 1240
col3 [empty string]
color_swatch 148-119-44.jpg
cost 3.67
deal_of_the_week NO
description gold, 2.5 oz.
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 33192
list_price 7.44
map NO
mfr_num 3513
net_weight 0.31
non_member_discount 15
non_member_price 6.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 33192
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.02
ta_dealer_c_price 4.02
ta_price 5.95
text
array
1 33192
2 3513
3 gold, 2.5 oz.
timestamp 2015-03-31T17:53:14.314Z
vip_member_price 4.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032034138
barcode_type UPC
col1 gold
col1_sortorder 2491
col2 1.3 oz.
col2_sortorder 533
col3 [empty string]
color_swatch 148-119-44.jpg
cost 2.2
deal_of_the_week NO
description gold, 1.3 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 68722
list_price 4.44
map NO
mfr_num 3413
net_weight 0.12
non_member_discount 15
non_member_price 3.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 68722
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.4
ta_price 3.55
text
array
1 68722
2 3413
3 gold, 1.3 oz.
timestamp 2015-03-31T17:54:15.088Z
vip_member_price 2.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032034046
barcode_type UPC
col1 green
col1_sortorder 2626
col2 1.3 oz.
col2_sortorder 533
col3 [empty string]
color_swatch 41-116-80.jpg
cost 2.2
deal_of_the_week NO
description green, 1.3 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 36527
list_price 4.44
map NO
mfr_num 3404
net_weight 0.12
non_member_discount 15
non_member_price 3.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 36527
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.4
ta_price 3.55
text
array
1 36527
2 3404
3 green, 1.3 oz.
timestamp 2015-03-31T17:53:19.339Z
vip_member_price 2.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032035043
barcode_type UPC
col1 green
col1_sortorder 2626
col2 2.5 oz.
col2_sortorder 1240
col3 [empty string]
color_swatch 41-116-80.jpg
cost 3.67
deal_of_the_week NO
description green, 2.5 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 41574
list_price 7.44
map NO
mfr_num 3504
net_weight 0.31
non_member_discount 15
non_member_price 6.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 41574
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.02
ta_dealer_c_price 4.02
ta_price 5.95
text
array
1 41574
2 3504
3 green, 2.5 oz.
timestamp 2015-03-31T17:53:25.231Z
vip_member_price 4.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032037047
barcode_type UPC
col1 green
col1_sortorder 2626
col2 16 oz.
col2_sortorder 1008
col3 [empty string]
color_swatch 41-116-80.jpg
cost 11.49
deal_of_the_week NO
description green, 16 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 43339
list_price 23.25
map NO
mfr_num 3704
net_weight 1.54
non_member_discount 15
non_member_price 19.76
prop65 NO
ship_rule_desc STD
shipping STD
sku 43339
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.56
ta_dealer_c_price 12.56
ta_price 18.6
text
array
1 43339
2 3704
3 green, 16 oz.
timestamp 2015-03-31T17:53:28.023Z
vip_member_price 12.79

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 651032035111
barcode_type UPC
col1 light red
col1_sortorder 3402
col2 2.5 oz.
col2_sortorder 1240
col3 [empty string]
color_swatch 234-42-39.jpg
cost 3.67
deal_of_the_week NO
description light red, 2.5 oz.
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 78463
list_price 7.44
map NO
mfr_num 3511
net_weight 0.31
non_member_discount 15
non_member_price 6.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 78463
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.02
ta_dealer_c_price 4.02
ta_price 5.95
text
array
1 78463
2 3511
3 light red, 2.5 oz.
timestamp 2015-03-31T17:54:31.269Z
vip_member_price 4.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 651032034114
barcode_type UPC
col1 light red
col1_sortorder 3402
col2 1.3 oz.
col2_sortorder 533
col3 [empty string]
color_swatch 234-42-39.jpg
cost 2.2
deal_of_the_week NO
description light red, 1.3 oz.
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 86846
list_price 4.44
map NO
mfr_num 3411
net_weight 0.12
non_member_discount 15
non_member_price 3.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 86846
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.4
ta_price 3.55
text
array
1 86846
2 3411
3 light red, 1.3 oz.
timestamp 2015-03-31T17:54:40.172Z
vip_member_price 2.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032034107
barcode_type UPC
col1 magenta
col1_sortorder 3535
col2 1.3 oz.
col2_sortorder 533
col3 [empty string]
color_swatch 234-53-147.jpg
cost 2.2
deal_of_the_week NO
description magenta, 1.3 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 22965
list_price 4.44
map NO
mfr_num 3410
net_weight 0.12
non_member_discount 15
non_member_price 3.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 22965
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.4
ta_price 3.55
text
array
1 22965
2 3410
3 magenta, 1.3 oz.
timestamp 2015-03-31T17:52:58.702Z
vip_member_price 2.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032035104
barcode_type UPC
col1 magenta
col1_sortorder 3535
col2 2.5 oz.
col2_sortorder 1240
col3 [empty string]
color_swatch 234-53-147.jpg
cost 3.67
deal_of_the_week NO
description magenta, 2.5 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 23350
list_price 7.44
map NO
mfr_num 3510
net_weight 0.31
non_member_discount 15
non_member_price 6.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 23350
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.02
ta_dealer_c_price 4.02
ta_price 5.95
text
array
1 23350
2 3510
3 magenta, 2.5 oz.
timestamp 2015-03-31T17:52:59.181Z
vip_member_price 4.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
VIP_member_discount 45
barcode 651032035074
barcode_type UPC
col1 orange
col1_sortorder 4222
col2 2.5 oz.
col2_sortorder 1240
col3 [empty string]
color_swatch 236-98-36.jpg
cost 3.67
deal_of_the_week NO
description orange, 2.5 oz.
flags
array
1 1
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 13429
list_price 7.44
map NO
mfr_num 3507
net_weight 0.31
non_member_discount 15
non_member_price 6.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 13429
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.02
ta_dealer_c_price 4.02
ta_price 5.95
text
array
1 13429
2 3507
3 orange, 2.5 oz.
timestamp 2015-03-31T17:52:40.147Z
vip_member_price 4.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 651032034077
barcode_type UPC
col1 orange
col1_sortorder 4222
col2 1.3 oz.
col2_sortorder 533
col3 [empty string]
color_swatch 236-98-36.jpg
cost 2.2
deal_of_the_week NO
description orange, 1.3 oz.
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 36898
list_price 4.44
map NO
mfr_num 3407
net_weight 0.12
non_member_discount 15
non_member_price 3.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 36898
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.4
ta_price 3.55
text
array
1 36898
2 3407
3 orange, 1.3 oz.
timestamp 2015-03-31T17:53:19.771Z
vip_member_price 2.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 651032034152
barcode_type UPC
col1 pewter
col1_sortorder 4653
col2 1.3 oz.
col2_sortorder 533
col3 [empty string]
color_swatch 98-98-98.jpg
cost 2.2
deal_of_the_week NO
description pewter, 1.3 oz.
group_id 145
group_uname speedball-block-printing-water-soluble-ink
id 26215
list_price 4.44
map NO
mfr_num 3415
net_weight 0.12
non_member_discount 15
non_member_price 3.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 26215
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.4
ta_price 3.55
text
array
1 26215
2 3415
3 pewter, 1.3 oz.
timestamp 2015-03-31T17:53:02.87Z
vip_member_price 2.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 23559
2 5.000000000000 77337
3 7.000000000000 88392
CACHED false
EXECUTIONTIME 3
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] = '1038' 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.166.104.226

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e030868502ba739a9b7f3e5d3d2f7d106f1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~duncan~c1~brushes~&gr=duncan-round-opaque-brush.html
urltoken CFID=30648766&CFTOKEN=38260032&jsessionid=e030868502ba739a9b7f3e5d3d2f7d106f1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 23:48:28'}
sessionid e0301a1353435a97cb8e6f2bf416d3235453
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-bargain-bin&paramOpts=fb~speedball~&gr=speedball-block-printing-water-soluble-ink.html
urltoken CFID=30648765&CFTOKEN=92304732&jsessionid=e0301a1353435a97cb8e6f2bf416d3235453
validationerror [empty string]


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

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

ItemIDList: 23559,77337,88392
AvailQtyList: 11.000000000000,5.000000000000,7.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 651032035159
barcode_type UPC
col1 pewter
col1_sortorder 4653
col2 2.5 oz.
col2_sortorder 1240
col3 [empty string]
color_swatch 98-98-98.jpg
cost 3.67
deal_of_the_week NO
description pewter, 2.