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

Foam Board

by Bienfang


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 079946098013
barcode_type UPC
col1 white core
col2 1/2 in. x 40 in. x 60 in.
col2_sortorder 269
col3 each
col3_sortorder 344
color_swatch 255-255-255.jpg
cost 8.78
deal_of_the_week NO
description white core, 1/2 in. x 40 in. x 60 in., each
group_id 1154
group_uname bienfang-foam-board
id 34262
list_price 21.3
map NO
mfr_num 900-402
net_weight 2.72
non_member_discount 31
non_member_price 14.7
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 34262
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.65
ta_dealer_c_price 10.65
ta_price 14.91
text
array
1 34262
2 900-402
3 white core, 1/2 in. x 40 in. x 60 in., each
timestamp 2015-03-31T17:53:16.025Z
vip_member_price 12.57

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 50079946098025
barcode_type UPC-RANDOM
col1 white core
col2 1/2 in. x 48 in. x 96 in.
col2_sortorder 270
col3 each
col3_sortorder 344
color_swatch 255-255-255.jpg
cost 16.78
deal_of_the_week NO
description white core, 1/2 in. x 48 in. x 96 in., each
group_id 1154
group_uname bienfang-foam-board
id 42782
list_price 40.68
map NO
mfr_num 900-403
net_weight 5.27
non_member_discount 31
non_member_price 28.07
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 42782
sku_pix YES
supplier_id 1
ta_dealer_a_price 20.34
ta_dealer_c_price 20.34
ta_price 28.48
text
array
1 42782
2 900-403
3 white core, 1/2 in. x 48 in. x 96 in., each
timestamp 2015-03-31T17:53:26.671Z
vip_member_price 24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 50079946098001
barcode_type UPC-RANDOM
col1 white core
col2 1/2 in. x 30 in. x 40 in.
col2_sortorder 268
col3 each
col3_sortorder 344
color_swatch 255-255-255.jpg
cost 4.83
deal_of_the_week NO
description white core, 1/2 in. x 30 in. x 40 in., each
group_id 1154
group_uname bienfang-foam-board
id 68057
list_price 11.72
map NO
mfr_num 900-400
net_weight 1.34
non_member_discount 31
non_member_price 8.09
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 68057
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.86
ta_dealer_c_price 5.86
ta_price 8.2
text
array
1 68057
2 900-400
3 white core, 1/2 in. x 30 in. x 40 in., each
timestamp 2015-03-31T17:54:13.404Z
vip_member_price 6.91

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 50079946109509
barcode_type UPC-RANDOM
col1 black
col1_sortorder 402
col2 3/16 in. x 32 in. x 40 in.
col2_sortorder 235
col3 each
col3_sortorder 344
color_swatch 0-0-0.jpg
cost 6
deal_of_the_week NO
description black, 3/16 in. x 32 in. x 40 in., each
group_id 1154
group_uname bienfang-foam-board
id 24760
list_price 14.56
map NO
mfr_num 900-525
net_weight 1.01
non_member_discount 31
non_member_price 10.05
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 24760
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.28
ta_dealer_c_price 7.28
ta_price 10.19
text
array
1 24760
2 900-525
3 black, 3/16 in. x 32 in. x 40 in., each
timestamp 2015-03-31T17:53:00.493Z
vip_member_price 8.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


Problem with item sku 24760-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 46
col1 black
col1_sortorder 402
col2 3/16 in. x 32 in. x 40 in.
col2_sortorder 235
col3 pack of 10
col3_sortorder 408
color_swatch 0-0-0.jpg
cost 60
deal_of_the_week NO
description black, 3/16 in. x 32 in. x 40 in., pack of 10
group_id 1154
group_uname bienfang-foam-board
id 24760-PK
list_price 145.6
map NO
net_weight 16
non_member_discount 36
non_member_price 93.18
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 24760-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 24760-PK
2 black, 3/16 in. x 32 in. x 40 in., pack of 10
timestamp 2015-03-31T17:53:00.495Z
vip_member_price 78.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 50079946129934
barcode_type UPC-RANDOM
col1 black
col1_sortorder 402
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 each
col3_sortorder 344
color_swatch 0-0-0.jpg
cost 2.84
deal_of_the_week NO
description black, 3/16 in. x 20 in. x 30 in., each
group_id 1154
group_uname bienfang-foam-board
id 26216
list_price 6.89
map NO
mfr_num 950-055
net_weight 0.76
non_member_discount 31
non_member_price 4.75
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 26216
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.45
ta_dealer_c_price 3.45
ta_price 4.82
text
array
1 26216
2 950-055
3 black, 3/16 in. x 20 in. x 30 in., each
timestamp 2015-03-31T17:53:02.881Z
vip_member_price 4.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


Problem with item sku 26216-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 46
col1 black
col1_sortorder 402
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 pack of 10
col3_sortorder 408
color_swatch 0-0-0.jpg
cost 28.4
deal_of_the_week NO
description black, 3/16 in. x 20 in. x 30 in., pack of 10
group_id 1154
group_uname bienfang-foam-board
id 26216-PK
list_price 68.9
map NO
net_weight 8
non_member_discount 36
non_member_price 44.1
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 26216-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 26216-PK
2 black, 3/16 in. x 20 in. x 30 in., pack of 10
timestamp 2015-03-31T17:53:02.892Z
vip_member_price 37.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 50079946109486
barcode_type UPC-RANDOM
col1 blue
col1_sortorder 542
col2 3/16 in. x 32 in. x 40 in.
col2_sortorder 235
col3 each
col3_sortorder 344
color_swatch 0-0-210.jpg
cost 6
deal_of_the_week NO
description blue, 3/16 in. x 32 in. x 40 in., each
group_id 1154
group_uname bienfang-foam-board
id 23116
list_price 14.56
map NO
mfr_num 900-523
net_weight 1.11
non_member_discount 31
non_member_price 10.05
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 23116
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.28
ta_dealer_c_price 7.28
ta_price 10.19
text
array
1 23116
2 900-523
3 blue, 3/16 in. x 32 in. x 40 in., each
timestamp 2015-03-31T17:52:58.986Z
vip_member_price 8.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 079946129915
barcode_type UPC
col1 blue
col1_sortorder 542
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 each
col3_sortorder 344
color_swatch 0-0-210.jpg
cost 2.84
deal_of_the_week NO
description blue, 3/16 in. x 20 in. x 30 in., each
group_id 1154
group_uname bienfang-foam-board
id 57081
list_price 6.89
map NO
mfr_num 950-053
net_weight 0.76
non_member_discount 31
non_member_price 4.75
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 57081
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.45
ta_dealer_c_price 3.45
ta_price 4.82
text
array
1 57081
2 950-053
3 blue, 3/16 in. x 20 in. x 30 in., each
timestamp 2015-03-31T17:53:51.174Z
vip_member_price 4.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


Problem with item sku 57081-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 46
col1 blue
col1_sortorder 542
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 pack of 10
col3_sortorder 408
color_swatch 0-0-210.jpg
cost 28.4
deal_of_the_week NO
description blue, 3/16 in. x 20 in. x 30 in., pack of 10
group_id 1154
group_uname bienfang-foam-board
id 57081-PK
list_price 68.9
map NO
net_weight 8
non_member_discount 36
non_member_price 44.1
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 57081-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 57081-PK
2 blue, 3/16 in. x 20 in. x 30 in., pack of 10
timestamp 2015-03-31T17:53:51.176Z
vip_member_price 37.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 50079946130022
barcode_type UPC-RANDOM
col1 gold
col1_sortorder 2491
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 each
col3_sortorder 344
color_swatch 195-174-47.jpg
cost 2.84
deal_of_the_week NO
description gold, 3/16 in. x 20 in. x 30 in., each
group_id 1154
group_uname bienfang-foam-board
id 24923
list_price 6.89
map NO
mfr_num 950-887
net_weight 0.76
non_member_discount 31
non_member_price 4.75
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 24923
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.45
ta_dealer_c_price 3.45
ta_price 4.82
text
array
1 24923
2 950-887
3 gold, 3/16 in. x 20 in. x 30 in., each
timestamp 2015-03-31T17:53:00.615Z
vip_member_price 4.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


Problem with item sku 24923-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 46
col1 gold
col1_sortorder 2491
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 pack of 10
col3_sortorder 408
color_swatch 195-174-47.jpg
cost 28.4
deal_of_the_week NO
description gold, 3/16 in. x 20 in. x 30 in., pack of 10
group_id 1154
group_uname bienfang-foam-board
id 24923-PK
list_price 68.9
map NO
net_weight 8
non_member_discount 36
non_member_price 44.1
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 24923-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 24923-PK
2 gold, 3/16 in. x 20 in. x 30 in., pack of 10
timestamp 2015-03-31T17:53:00.617Z
vip_member_price 37.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 50079946133559
barcode_type UPC-RANDOM
col1 gray
col1_sortorder 2603
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 each
col3_sortorder 344
color_swatch 166-166-166.jpg
cost 2.84
deal_of_the_week NO
description gray, 3/16 in. x 20 in. x 30 in., each
group_id 1154
group_uname bienfang-foam-board
id 11593
list_price 6.89
map NO
mfr_num 950-056
net_weight 0.76
non_member_discount 31
non_member_price 4.75
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 11593
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.45
ta_dealer_c_price 3.45
ta_price 4.82
text
array
1 11593
2 950-056
3 gray, 3/16 in. x 20 in. x 30 in., each
timestamp 2015-03-31T17:52:37.67Z
vip_member_price 4.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


Problem with item sku 11593-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 46
col1 gray
col1_sortorder 2603
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 pack of 10
col3_sortorder 408
color_swatch 166-166-166.jpg
cost 28.4
deal_of_the_week NO
description gray, 3/16 in. x 20 in. x 30 in., pack of 10
group_id 1154
group_uname bienfang-foam-board
id 11593-PK
list_price 68.9
map NO
net_weight 8
non_member_discount 36
non_member_price 44.1
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 11593-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 11593-PK
2 gray, 3/16 in. x 20 in. x 30 in., pack of 10
timestamp 2015-03-31T17:52:37.673Z
vip_member_price 37.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
col1 gray
col1_sortorder 2603
col2 3/16 in. x 32 in. x 40 in.
col2_sortorder 235
col3 each
col3_sortorder 344
color_swatch 166-166-166.jpg
cost 6
deal_of_the_week NO
description gray, 3/16 in. x 32 in. x 40 in., each
group_id 1154
group_uname bienfang-foam-board
id 13789
list_price 14.56
map NO
mfr_num 900-526
net_weight 1.1
non_member_discount 31
non_member_price 10.05
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 13789
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.28
ta_dealer_c_price 7.28
ta_price 10.19
text
array
1 13789
2 900-526
3 gray, 3/16 in. x 32 in. x 40 in., each
timestamp 2015-03-31T17:52:41.177Z
vip_member_price 8.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


Problem with item sku 13789-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 46
col1 gray
col1_sortorder 2603
col2 3/16 in. x 32 in. x 40 in.
col2_sortorder 235
col3 pack of 10
col3_sortorder 408
color_swatch 166-166-166.jpg
cost 60
deal_of_the_week NO
description gray, 3/16 in. x 32 in. x 40 in., pack of 10
group_id 1154
group_uname bienfang-foam-board
id 13789-PK
list_price 145.6
map NO
net_weight 16
non_member_discount 36
non_member_price 93.18
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 13789-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 13789-PK
2 gray, 3/16 in. x 32 in. x 40 in., pack of 10
timestamp 2015-03-31T17:52:41.18Z
vip_member_price 78.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 50079946109493
barcode_type UPC-RANDOM
col1 green
col1_sortorder 2626
col2 3/16 in. x 32 in. x 40 in.
col2_sortorder 235
col3 each
col3_sortorder 344
color_swatch 51-153-69.jpg
cost 6
deal_of_the_week NO
description green, 3/16 in. x 32 in. x 40 in., each
group_id 1154
group_uname bienfang-foam-board
id 14904
list_price 14.56
map NO
mfr_num 900-524
net_weight 1.09
non_member_discount 31
non_member_price 10.05
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 14904
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.28
ta_dealer_c_price 7.28
ta_price 10.19
text
array
1 14904
2 900-524
3 green, 3/16 in. x 32 in. x 40 in., each
timestamp 2015-03-31T17:52:44.886Z
vip_member_price 8.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


Problem with item sku 14904-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 46
col1 green
col1_sortorder 2626
col2 3/16 in. x 32 in. x 40 in.
col2_sortorder 235
col3 pack of 10
col3_sortorder 408
color_swatch 51-153-69.jpg
cost 60
deal_of_the_week NO
description green, 3/16 in. x 32 in. x 40 in., pack of 10
group_id 1154
group_uname bienfang-foam-board
id 14904-PK
list_price 145.6
map NO
net_weight 16
non_member_discount 36
non_member_price 93.18
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 14904-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 14904-PK
2 green, 3/16 in. x 32 in. x 40 in., pack of 10
timestamp 2015-03-31T17:52:44.891Z
vip_member_price 78.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 079946129922
barcode_type UPC
col1 green
col1_sortorder 2626
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 each
col3_sortorder 344
color_swatch 51-153-69.jpg
cost 2.84
deal_of_the_week NO
description green, 3/16 in. x 20 in. x 30 in., each
group_id 1154
group_uname bienfang-foam-board
id 44000
list_price 6.89
map NO
mfr_num 950-054
net_weight 0.76
non_member_discount 31
non_member_price 4.75
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 44000
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.45
ta_dealer_c_price 3.45
ta_price 4.82
text
array
1 44000
2 950-054
3 green, 3/16 in. x 20 in. x 30 in., each
timestamp 2015-03-31T17:53:29.019Z
vip_member_price 4.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


Problem with item sku 44000-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 46
col1 green
col1_sortorder 2626
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 pack of 10
col3_sortorder 408
color_swatch 51-153-69.jpg
cost 28.4
deal_of_the_week NO
description green, 3/16 in. x 20 in. x 30 in., pack of 10
group_id 1154
group_uname bienfang-foam-board
id 44000-PK
list_price 68.9
map NO
net_weight 8
non_member_discount 36
non_member_price 44.1
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 44000-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 44000-PK
2 green, 3/16 in. x 20 in. x 30 in., pack of 10
timestamp 2015-03-31T17:53:29.03Z
vip_member_price 37.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 079946040180
barcode_type UPC
col1 greystone
col1_sortorder 2720
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 each
col3_sortorder 344
color_swatch 189-168-210.jpg
cost 3.03
deal_of_the_week NO
description greystone, 3/16 in. x 20 in. x 30 in., each
group_id 1154
group_uname bienfang-foam-board
id 57796
list_price 7.34
map NO
mfr_num 951-037
net_weight 0.58
non_member_discount 31
non_member_price 5.06
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 57796
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.67
ta_dealer_c_price 3.67
ta_price 5.14
text
array
1 57796
2 951-037
3 greystone, 3/16 in. x 20 in. x 30 in., each
timestamp 2015-03-31T17:53:51.632Z
vip_member_price 4.33

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


Problem with item sku 57796-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 46
col1 greystone
col1_sortorder 2720
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 pack of 10
col3_sortorder 408
color_swatch 189-168-210.jpg
cost 30.3
deal_of_the_week NO
description greystone, 3/16 in. x 20 in. x 30 in., pack of 10
group_id 1154
group_uname bienfang-foam-board
id 57796-PK
list_price 73.4
map NO
net_weight 8
non_member_discount 36
non_member_price 46.98
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 57796-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 57796-PK
2 greystone, 3/16 in. x 20 in. x 30 in., pack of 10
timestamp 2015-03-31T17:53:51.634Z
vip_member_price 39.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 50079946133542
barcode_type UPC-RANDOM
col1 orange
col1_sortorder 4222
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 each
col3_sortorder 344
color_swatch 210-90-0.jpg
cost 2.84
deal_of_the_week NO
description orange, 3/16 in. x 20 in. x 30 in., each
group_id 1154
group_uname bienfang-foam-board
id 74370
list_price 6.89
map NO
mfr_num 950-051 3/16
net_weight 0.58
non_member_discount 31
non_member_price 4.75
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 74370
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.45
ta_dealer_c_price 3.45
ta_price 4.82
text
array
1 74370
2 950-051 3/16
3 orange, 3/16 in. x 20 in. x 30 in., each
timestamp 2015-03-31T17:54:26.257Z
vip_member_price 4.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


Problem with item sku 74370-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 46
col1 orange
col1_sortorder 4222
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 pack of 10
col3_sortorder 408
color_swatch 210-90-0.jpg
cost 28.4
deal_of_the_week NO
description orange, 3/16 in. x 20 in. x 30 in., pack of 10
group_id 1154
group_uname bienfang-foam-board
id 74370-PK
list_price 68.9
map NO
net_weight 8
non_member_discount 36
non_member_price 44.1
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 74370-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 74370-PK
2 orange, 3/16 in. x 20 in. x 30 in., pack of 10
timestamp 2015-03-31T17:54:26.26Z
vip_member_price 37.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 079946129908
barcode_type UPC
col1 red
col1_sortorder 5088
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 each
col3_sortorder 344
color_swatch 195-47-47.jpg
cost 2.84
deal_of_the_week NO
description red, 3/16 in. x 20 in. x 30 in., each
group_id 1154
group_uname bienfang-foam-board
id 23487
list_price 6.89
map NO
mfr_num 950-052
net_weight 0.76
non_member_discount 31
non_member_price 4.75
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 23487
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.45
ta_dealer_c_price 3.45
ta_price 4.82
text
array
1 23487
2 950-052
3 red, 3/16 in. x 20 in. x 30 in., each
timestamp 2015-03-31T17:52:59.351Z
vip_member_price 4.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


Problem with item sku 23487-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 46
col1 red
col1_sortorder 5088
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 pack of 10
col3_sortorder 408
color_swatch 195-47-47.jpg
cost 28.4
deal_of_the_week NO
description red, 3/16 in. x 20 in. x 30 in., pack of 10
group_id 1154
group_uname bienfang-foam-board
id 23487-PK
list_price 68.9
map NO
net_weight 8
non_member_discount 36
non_member_price 44.1
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 23487-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 23487-PK
2 red, 3/16 in. x 20 in. x 30 in., pack of 10
timestamp 2015-03-31T17:52:59.353Z
vip_member_price 37.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 50079946109479
barcode_type UPC-RANDOM
col1 red
col1_sortorder 5088
col2 3/16 in. x 32 in. x 40 in.
col2_sortorder 235
col3 each
col3_sortorder 344
color_swatch 195-47-47.jpg
cost 6
deal_of_the_week NO
description red, 3/16 in. x 32 in. x 40 in., each
group_id 1154
group_uname bienfang-foam-board
id 45965
list_price 14.56
map NO
mfr_num 900-522
net_weight 1.1
non_member_discount 31
non_member_price 10.05
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 45965
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.28
ta_dealer_c_price 7.28
ta_price 10.19
text
array
1 45965
2 900-522
3 red, 3/16 in. x 32 in. x 40 in., each
timestamp 2015-03-31T17:53:31.382Z
vip_member_price 8.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


Problem with item sku 45965-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 46
col1 red
col1_sortorder 5088
col2 3/16 in. x 32 in. x 40 in.
col2_sortorder 235
col3 pack of 10
col3_sortorder 408
color_swatch 195-47-47.jpg
cost 60
deal_of_the_week NO
description red, 3/16 in. x 32 in. x 40 in., pack of 10
group_id 1154
group_uname bienfang-foam-board
id 45965-PK
list_price 145.6
map NO
net_weight 16
non_member_discount 36
non_member_price 93.18
prop65 NO
ship_rule_desc LTL
shipping LTL
sku 45965-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 45965-PK
2 red, 3/16 in. x 32 in. x 40 in., pack of 10
timestamp 2015-03-31T17:53:31.385Z
vip_member_price 78.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 079946040203
barcode_type UPC
col1 sandstone
col1_sortorder 5353
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 each
col3_sortorder 344
color_swatch 240-208-183.jpg
cost 3.03
deal_of_the_week NO
description sandstone, 3/16 in. x 20 in. x 30 in., each
group_id 1154
group_uname bienfang-foam-board
id 71362
list_price 7.34
map NO
mfr_num 951-038
net_weight 0.58
non_member_discount 31
non_member_price 5.06
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 71362
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.67
ta_dealer_c_price 3.67
ta_price 5.14
text
array
1 71362
2 951-038
3 sandstone, 3/16 in. x 20 in. x 30 in., each
timestamp 2015-03-31T17:54:21.075Z
vip_member_price 4.33

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


Problem with item sku 71362-PK. Item is found in Solr index but not found in vAvailQtyTbl.

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 46
col1 sandstone
col1_sortorder 5353
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 pack of 10
col3_sortorder 408
color_swatch 240-208-183.jpg
cost 30.3
deal_of_the_week NO
description sandstone, 3/16 in. x 20 in. x 30 in., pack of 10
group_id 1154
group_uname bienfang-foam-board
id 71362-PK
list_price 73.4
map NO
net_weight 8
non_member_discount 36
non_member_price 46.98
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 71362-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 71362-PK
2 sandstone, 3/16 in. x 20 in. x 30 in., pack of 10
timestamp 2015-03-31T17:54:21.078Z
vip_member_price 39.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 05:36:43'}
sessionid e03066ef5d4584daf0d0564168282e7a4655
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=display-boards&CatC=fp~5-48~&gr=bienfang-foam-board.html
urltoken CFID=30714821&CFTOKEN=77760723&jsessionid=e03066ef5d4584daf0d0564168282e7a4655
validationerror [empty string]


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

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

ItemIDList: 07997,14550,37088,43873,73971,74720,77759
AvailQtyList: 38.000000000000,12.000000000000,18.000000000000,42.000000000000,23.000000000000,11.000000000000,1.000000000000

struct
FLAGS 0
VIP_member_discount 41
barcode 50079946130015
barcode_type UPC-RANDOM
col1 silver
col1_sortorder 5572
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 each
col3_sortorder 344
color_swatch 210-210-210.jpg
cost 2.84
deal_of_the_week NO
description silver, 3/16 in. x 20 in. x 30 in., each
group_id 1154
group_uname bienfang-foam-board
id 71242
list_price 6.89
map NO
mfr_num 950-886
net_weight 0.76
non_member_discount 31
non_member_price 4.75
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 71242
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.45
ta_dealer_c_price 3.45
ta_price 4.82
text
array
1 71242
2 950-886
3 silver, 3/16 in. x 20 in. x 30 in., each
timestamp 2015-03-31T17:54:20.922Z
vip_member_price 4.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 38.000000000000 07997
2 12.000000000000 14550
3 18.000000000000 37088
4 42.000000000000 43873
5 23.000000000000 73971
6 11.000000000000 74720
7 1.000000000000 77759
CACHED false
EXECUTIONTIME 16
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] = '8855' 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.147.255.107