#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: 60004
AvailQtyList: 4.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-30T16:20:10.556Z
vip_member_price 12.57

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:20:27.291Z
vip_member_price 24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:21:15.688Z
vip_member_price 6.91

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:19:46.916Z
vip_member_price 8.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:19:46.923Z
vip_member_price 78.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:19:49.869Z
vip_member_price 4.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:19:49.889Z
vip_member_price 37.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:19:44.631Z
vip_member_price 8.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:20:49.505Z
vip_member_price 4.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:20:49.511Z
vip_member_price 37.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:19:47.307Z
vip_member_price 4.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:19:47.312Z
vip_member_price 37.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:19:15.905Z
vip_member_price 4.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:19:15.908Z
vip_member_price 37.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:19:22.471Z
vip_member_price 8.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:19:22.473Z
vip_member_price 78.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:19:28.471Z
vip_member_price 8.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:19:28.482Z
vip_member_price 78.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:20:28.805Z
vip_member_price 4.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:20:28.807Z
vip_member_price 37.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:20:49.997Z
vip_member_price 4.33

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:20:49.999Z
vip_member_price 39.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:21:38.828Z
vip_member_price 4.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:21:38.831Z
vip_member_price 37.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:19:45.238Z
vip_member_price 4.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:19:45.241Z
vip_member_price 37.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:20:31.199Z
vip_member_price 8.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:20:31.201Z
vip_member_price 78.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:21:29.502Z
vip_member_price 4.33

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:21:29.506Z
vip_member_price 39.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
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: 60004
AvailQtyList: 4.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-30T16:21:28.972Z
vip_member_price 4.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


Problem with item sku 71242-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: 60004
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 46
col1 silver
col1_sortorder 5572
col2 3/16 in. x 20 in. x 30 in.
col2_sortorder 232
col3 pack of 10
col3_sortorder 408
color_swatch 210-210-210.jpg
cost 28.4
deal_of_the_week NO
description silver, 3/16 in. x 20 in. x 30 in., pack of 10
group_id 1154
group_uname bienfang-foam-board
id 71242-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 71242-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 71242-PK
2 silver, 3/16 in. x 20 in. x 30 in., pack of 10
timestamp 2015-03-30T16:21:28.988Z
vip_member_price 37.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 60004
CACHED false
EXECUTIONTIME 18
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] = '10564' 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.122.88

URL: www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 01:44:35'}
sessionid e030be8ba72c88b9b51f72507b3e4745236a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=framing-display&CatC=fb~bienfang~fp~24-9999.99~&gr=bienfang-foam-board.html
urltoken CFID=30401728&CFTOKEN=83292928&jsessionid=e030be8ba72c88b9b51f72507b3e4745236a
validationerror [empty string]


EndSessionVariables: