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

Berkshire Mat Board

by Crescent


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924176258
barcode_type UPC
col1 autumn
col1_sortorder 259
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 165-107-54.jpg
cost 2.33
deal_of_the_week NO
description autumn, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 36152
list_price 5.46
map NO
mfr_num B557
net_weight 1.29
non_member_discount 30
non_member_price 3.82
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 36152
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.73
ta_dealer_c_price 2.73
ta_price 4.1
text
array
1 36152
2 B557
3 autumn, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:20:16.19Z
vip_member_price 3.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
savedquery watercolor paper 40"x29x
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~watercolor%20paper%2040%22x29x~
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924175794
barcode_type UPC
col1 beige
col1_sortorder 365
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 245-222-200.jpg
cost 2.06
deal_of_the_week NO
description beige, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 56139
list_price 4.83
map NO
mfr_num B511
net_weight 1.1
non_member_discount 30
non_member_price 3.38
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 56139
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.42
ta_dealer_c_price 2.42
ta_price 3.62
text
array
1 56139
2 B511
3 beige, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:20:47.907Z
vip_member_price 2.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
savedquery watercolor paper 40"x29x
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~watercolor%20paper%2040%22x29x~
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924176104
barcode_type UPC
col1 blue
col1_sortorder 542
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 13-123-164.jpg
cost 2.33
deal_of_the_week NO
description blue, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 11542
list_price 5.46
map NO
mfr_num B542
net_weight 1.23
non_member_discount 30
non_member_price 3.82
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 11542
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.73
ta_dealer_c_price 2.73
ta_price 4.1
text
array
1 11542
2 B542
3 blue, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:19:15.787Z
vip_member_price 3.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
savedquery watercolor paper 40"x29x
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~watercolor%20paper%2040%22x29x~
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924163975
barcode_type UPC
col1 buttercup
col1_sortorder 901
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 251-242-92.jpg
cost 2.06
deal_of_the_week NO
description buttercup, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 31975
list_price 4.83
map NO
mfr_num B110
net_weight 1.33
non_member_discount 30
non_member_price 3.38
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 31975
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.42
ta_dealer_c_price 2.42
ta_price 3.62
text
array
1 31975
2 B110
3 buttercup, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:20:01.965Z
vip_member_price 2.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
savedquery watercolor paper 40"x29x
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~watercolor%20paper%2040%22x29x~
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924176180
barcode_type UPC
col1 cardinal
col1_sortorder 1101
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 208-37-61.jpg
cost 2.33
deal_of_the_week NO
description cardinal, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 53916
list_price 5.46
map NO
mfr_num B550
net_weight 1.25
non_member_discount 30
non_member_price 3.82
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 53916
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.73
ta_dealer_c_price 2.73
ta_price 4.1
text
array
1 53916
2 B550
3 cardinal, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:20:46.224Z
vip_member_price 3.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
savedquery watercolor paper 40"x29x
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~watercolor%20paper%2040%22x29x~
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924165214
barcode_type UPC
col1 carnelian
col1_sortorder 1123
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 218-110-73.jpg
cost 2.33
deal_of_the_week NO
description carnelian, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 28971
list_price 5.46
map NO
mfr_num B700
net_weight 1.3
non_member_discount 30
non_member_price 3.82
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 28971
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.73
ta_dealer_c_price 2.73
ta_price 4.1
text
array
1 28971
2 B700
3 carnelian, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:19:54.604Z
vip_member_price 3.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
savedquery watercolor paper 40"x29x
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~watercolor%20paper%2040%22x29x~
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924175947
barcode_type UPC
col1 celtic
col1_sortorder 1148
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 68-118-98.jpg
cost 2.33
deal_of_the_week NO
description celtic, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 70880
list_price 5.46
map NO
mfr_num B526
net_weight 1.28
non_member_discount 30
non_member_price 3.82
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 70880
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.73
ta_dealer_c_price 2.73
ta_price 4.1
text
array
1 70880
2 B526
3 celtic, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:21:26.993Z
vip_member_price 3.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
savedquery watercolor paper 40"x29x
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~watercolor%20paper%2040%22x29x~
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924164132
barcode_type UPC
col1 chestnut
col1_sortorder 1206
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 126-106-87.jpg
cost 2.06
deal_of_the_week NO
description chestnut, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 31877
list_price 4.83
map NO
mfr_num B139
net_weight 1.25
non_member_discount 30
non_member_price 3.38
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 31877
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.42
ta_dealer_c_price 2.42
ta_price 3.62
text
array
1 31877
2 B139
3 chestnut, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:20:01.677Z
vip_member_price 2.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
savedquery watercolor paper 40"x29x
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~watercolor%20paper%2040%22x29x~
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924176364
barcode_type UPC
col1 cinder
col1_sortorder 1292
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 87-90-84.jpg
cost 2.06
deal_of_the_week NO
description cinder, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 11990
list_price 4.83
map NO
mfr_num B569
net_weight 0.81
non_member_discount 30
non_member_price 3.38
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 11990
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.42
ta_dealer_c_price 2.42
ta_price 3.62
text
array
1 11990
2 B569
3 cinder, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:19:17.082Z
vip_member_price 2.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
savedquery watercolor paper 40"x29x
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~watercolor%20paper%2040%22x29x~
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924175701
barcode_type UPC
col1 cloud
col1_sortorder 1338
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 254-249-240.jpg
cost 2.06
deal_of_the_week NO
description cloud, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 18689
list_price 4.83
map NO
mfr_num B502
net_weight 0.91
non_member_discount 30
non_member_price 3.38
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 18689
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.42
ta_dealer_c_price 2.42
ta_price 3.62
text
array
1 18689
2 B502
3 cloud, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:19:36.927Z
vip_member_price 2.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924176128
barcode_type UPC
col1 cobalt
col1_sortorder 1351
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 56-91-121.jpg
cost 2.06
deal_of_the_week NO
description cobalt, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 14804
list_price 4.83
map NO
mfr_num B544
net_weight 1
non_member_discount 30
non_member_price 3.38
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 14804
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.42
ta_dealer_c_price 2.42
ta_price 3.62
text
array
1 14804
2 B544
3 cobalt, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:19:27.93Z
vip_member_price 2.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924164897
barcode_type UPC
col1 crisp
col1_sortorder 1618
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 254-255-255.jpg
cost 1.85
deal_of_the_week NO
description crisp, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 78773
list_price 4.34
map NO
mfr_num B461
net_weight 1.26
non_member_discount 30
non_member_price 3.04
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 78773
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.17
ta_dealer_c_price 2.17
ta_price 3.26
text
array
1 78773
2 B461
3 crisp, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:21:44.577Z
vip_member_price 2.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924176302
barcode_type UPC
col1 dark brown
col1_sortorder 1683
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 81-71-66.jpg
cost 2.33
deal_of_the_week NO
description dark brown, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 34589
list_price 5.46
map NO
mfr_num B562
net_weight 1.26
non_member_discount 30
non_member_price 3.82
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 34589
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.73
ta_dealer_c_price 2.73
ta_price 4.1
text
array
1 34589
2 B562
3 dark brown, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:20:11.096Z
vip_member_price 3.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924163463
barcode_type UPC
col1 dark olive
col1_sortorder 1732
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 81-85-73.jpg
cost 2.06
deal_of_the_week NO
description dark olive, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 87612
list_price 4.83
map NO
mfr_num B453
net_weight 1.27
non_member_discount 30
non_member_price 3.38
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 87612
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.42
ta_dealer_c_price 2.42
ta_price 3.62
text
array
1 87612
2 B453
3 dark olive, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:21:59.054Z
vip_member_price 2.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924164873
barcode_type UPC
col1 deep red
col1_sortorder 1829
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 164-33-52.jpg
cost 2.06
deal_of_the_week NO
description deep red, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 44155
list_price 4.83
map NO
mfr_num B459
net_weight 1.31
non_member_discount 30
non_member_price 3.38
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 44155
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.42
ta_dealer_c_price 2.42
ta_price 3.62
text
array
1 44155
2 B459
3 deep red, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:20:28.953Z
vip_member_price 2.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924163395
barcode_type UPC
col1 dill
col1_sortorder 1906
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 89-107-67.jpg
cost 2.06
deal_of_the_week NO
description dill, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 77476
list_price 4.83
map NO
mfr_num B358
net_weight 1.33
non_member_discount 30
non_member_price 3.38
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 77476
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.42
ta_dealer_c_price 2.42
ta_price 3.62
text
array
1 77476
2 B358
3 dill, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:21:42.507Z
vip_member_price 2.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924175985
barcode_type UPC
col1 everglade green
col1_sortorder 2085
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 24-115-110.jpg
cost 2.33
deal_of_the_week NO
description everglade green, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 51984
list_price 5.46
map NO
mfr_num B530
net_weight 1.28
non_member_discount 30
non_member_price 3.82
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 51984
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.73
ta_dealer_c_price 2.73
ta_price 4.1
text
array
1 51984
2 B530
3 everglade green, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:20:40.965Z
vip_member_price 3.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924176340
barcode_type UPC
col1 felt
col1_sortorder 2111
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 160-159-143.jpg
cost 2.33
deal_of_the_week NO
description felt, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 29859
list_price 5.46
map NO
mfr_num B566
net_weight 1.27
non_member_discount 30
non_member_price 3.82
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 29859
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.73
ta_dealer_c_price 2.73
ta_price 4.1
text
array
1 29859
2 B566
3 felt, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:19:56.426Z
vip_member_price 3.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924176272
barcode_type UPC
col1 fig
col1_sortorder 2132
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 123-109-86.jpg
cost 2.06
deal_of_the_week NO
description fig, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 40255
list_price 4.83
map NO
mfr_num B559
net_weight 1.31
non_member_discount 30
non_member_price 3.38
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 40255
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.42
ta_dealer_c_price 2.42
ta_price 3.62
text
array
1 40255
2 B559
3 fig, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:20:23.94Z
vip_member_price 2.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924164040
barcode_type UPC
col1 forest shadow
col1_sortorder 2253
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 59-91-77.jpg
cost 2.33
deal_of_the_week NO
description forest shadow, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 53239
list_price 5.46
map NO
mfr_num B127
net_weight 1.31
non_member_discount 30
non_member_price 3.82
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 53239
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.73
ta_dealer_c_price 2.73
ta_price 4.1
text
array
1 53239
2 B127
3 forest shadow, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:20:45.807Z
vip_member_price 3.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924176029
barcode_type UPC
col1 fountain blue
col1_sortorder 2267
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 175-200-213.jpg
cost 2.06
deal_of_the_week NO
description fountain blue, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 63433
list_price 4.83
map NO
mfr_num B534
net_weight 1.34
non_member_discount 30
non_member_price 3.38
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 63433
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.42
ta_dealer_c_price 2.42
ta_price 3.62
text
array
1 63433
2 B534
3 fountain blue, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:21:04.36Z
vip_member_price 2.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924176425
barcode_type UPC
col1 gold foil
col1_sortorder 2492
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 210-187-124.jpg
cost 3.59
deal_of_the_week NO
description gold foil, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 86844
list_price 8.4
map NO
mfr_num B575
net_weight 0.45
non_member_discount 30
non_member_price 5.88
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 86844
sku_pix NO
supplier_id 1
ta_dealer_a_price 4.2
ta_dealer_c_price 4.2
ta_price 6.3
text
array
1 86844
2 B575
3 gold foil, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:21:57.894Z
vip_member_price 5.04

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924164330
barcode_type UPC
col1 granite
col1_sortorder 2573
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 96-98-94.jpg
cost 1.85
deal_of_the_week NO
description granite, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 77282
list_price 4.34
map NO
mfr_num B161
net_weight 1.33
non_member_discount 30
non_member_price 3.04
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 77282
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.17
ta_dealer_c_price 2.17
ta_price 3.26
text
array
1 77282
2 B161
3 granite, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:21:42.27Z
vip_member_price 2.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924176036
barcode_type UPC
col1 gray
col1_sortorder 2603
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 188-192-187.jpg
cost 2.33
deal_of_the_week NO
description gray, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 59911
list_price 5.46
map NO
mfr_num B535
net_weight 1.21
non_member_discount 30
non_member_price 3.82
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 59911
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.73
ta_dealer_c_price 2.73
ta_price 4.1
text
array
1 59911
2 B535
3 gray, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:20:54.321Z
vip_member_price 3.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924164323
barcode_type UPC
col1 harbor
col1_sortorder 2755
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 141-150-156.jpg
cost 2.33
deal_of_the_week NO
description harbor, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 78816
list_price 5.46
map NO
mfr_num B160
net_weight 1.19
non_member_discount 30
non_member_price 3.82
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 78816
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.73
ta_dealer_c_price 2.73
ta_price 4.1
text
array
1 78816
2 B160
3 harbor, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:21:44.619Z
vip_member_price 3.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924164668
barcode_type UPC
col1 hay
col1_sortorder 2774
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 241-237-213.jpg
cost 2.33
deal_of_the_week NO
description hay, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 21304
list_price 5.46
map NO
mfr_num B350
net_weight 1.3
non_member_discount 30
non_member_price 3.82
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 21304
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.73
ta_dealer_c_price 2.73
ta_price 4.1
text
array
1 21304
2 B350
3 hay, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:19:41.534Z
vip_member_price 3.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924175923
barcode_type UPC
col1 hunter green
col1_sortorder 2887
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 66-100-78.jpg
cost 1.85
deal_of_the_week NO
description hunter green, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 32395
list_price 4.34
map NO
mfr_num B524
net_weight 1.27
non_member_discount 30
non_member_price 3.04
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 32395
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.17
ta_dealer_c_price 2.17
ta_price 3.26
text
array
1 32395
2 B524
3 hunter green, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:20:02.697Z
vip_member_price 2.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924176142
barcode_type UPC
col1 ink
col1_sortorder 2962
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 56-66-96.jpg
cost 2.06
deal_of_the_week NO
description ink, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 49213
list_price 4.83
map NO
mfr_num B546
net_weight 1.31
non_member_discount 30
non_member_price 3.38
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 49213
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.42
ta_dealer_c_price 2.42
ta_price 3.62
text
array
1 49213
2 B546
3 ink, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:20:36.503Z
vip_member_price 2.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924175961
barcode_type UPC
col1 jade
col1_sortorder 3139
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 129-174-141.jpg
cost 2.33
deal_of_the_week NO
description jade, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 56310
list_price 5.46
map NO
mfr_num B528
net_weight 1.3
non_member_discount 30
non_member_price 3.82
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 56310
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.73
ta_dealer_c_price 2.73
ta_price 4.1
text
array
1 56310
2 B528
3 jade, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:20:48.271Z
vip_member_price 3.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924163234
barcode_type UPC
col1 maroon
col1_sortorder 3607
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 112-59-67.jpg
cost 1.85
deal_of_the_week NO
description maroon, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 80252
list_price 4.34
map NO
mfr_num B038
net_weight 1.25
non_member_discount 30
non_member_price 3.04
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 80252
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.17
ta_dealer_c_price 2.17
ta_price 3.26
text
array
1 80252
2 B038
3 maroon, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:21:46.109Z
vip_member_price 2.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924175930
barcode_type UPC
col1 olive
col1_sortorder 4168
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 81-115-80.jpg
cost 2.33
deal_of_the_week NO
description olive, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 80598
list_price 5.46
map NO
mfr_num B525
net_weight 1.28
non_member_discount 30
non_member_price 3.82
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 80598
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.73
ta_dealer_c_price 2.73
ta_price 4.1
text
array
1 80598
2 B525
3 olive, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:21:46.432Z
vip_member_price 3.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' 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.227.215.140

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:26'}
sessionid e030a8c64edbfa290a8b2aa2a136a3165677
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=general&catB=error.html
urltoken CFID=30274300&CFTOKEN=91348513&jsessionid=e030a8c64edbfa290a8b2aa2a136a3165677
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 15:25:24'}
sessionid e030b42b3e39517f27887d31792e60395931
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~crescent~&gr=crescent-berkshire-mat-board.html
urltoken CFID=30277200&CFTOKEN=28599022&jsessionid=e030b42b3e39517f27887d31792e60395931
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 093924175909
barcode_type UPC
col1 palm
col1_sortorder 4340
col2 32 in. x 40 in.
col2_sortorder 1649
col3 cream core
col3_sortorder 1774
color_swatch 133-149-109.jpg
cost 2.33
deal_of_the_week NO
description palm, 32 in. x 40 in., cream core
group_id 10056
group_uname crescent-berkshire-mat-board
id 33479
list_price 5.46
map NO
mfr_num B522
net_weight 1.38
non_member_discount 30
non_member_price 3.82
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 33479
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.73
ta_dealer_c_price 2.73
ta_price 4.1
text
array
1 33479
2 B522
3 palm, 32 in. x 40 in., cream core
timestamp 2015-03-30T16:20:08.507Z
vip_member_price 3.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
CACHED false
EXECUTIONTIME 74
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] = '2571' AND els_vipmemberprice is not null AND els_columnvalue1 !='