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

Balsa Sheets

by Midwest


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157064014
barcode_type UPC
col1 1/32 in.
col1_sortorder 72
col2 4 in. x 36 in.
col2_sortorder 85
col3 [empty string]
cost 1.23
deal_of_the_week NO
description 1/32 in., 4 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 64918
list_price 2.49
map NO
mfr_num 6401
net_weight 0.05
non_member_discount 18
non_member_price 2.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 64918
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.34
ta_dealer_c_price 1.34
ta_price 2.12
text
array
1 64918
2 6401
3 1/32 in., 4 in. x 36 in.
timestamp 2015-03-27T14:47:46.142Z
vip_member_price 1.75

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157063017
barcode_type UPC
col1 1/32 in.
col1_sortorder 72
col2 3 in. x 36 in.
col2_sortorder 81
col3 [empty string]
cost 0.88
deal_of_the_week NO
description 1/32 in., 3 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 64931
list_price 1.79
map NO
mfr_num 6301
net_weight 0.02
non_member_discount 18
non_member_price 1.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 64931
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.97
ta_dealer_c_price 0.97
ta_price 1.52
text
array
1 64931
2 6301
3 1/32 in., 3 in. x 36 in.
timestamp 2015-03-27T14:47:46.164Z
vip_member_price 1.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157062010
barcode_type UPC
col1 1/32 in.
col1_sortorder 72
col2 2 in. x 36 in.
col2_sortorder 77
col3 [empty string]
cost 0.88
deal_of_the_week NO
description 1/32 in., 2 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 65414
list_price 1.79
map NO
mfr_num 6201
net_weight 0.02
non_member_discount 18
non_member_price 1.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 65414
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.97
ta_dealer_c_price 0.97
ta_price 1.52
text
array
1 65414
2 6201
3 1/32 in., 2 in. x 36 in.
timestamp 2015-03-27T14:47:46.972Z
vip_member_price 1.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 091157064069
barcode_type UPC
col1 1/4 in.
col1_sortorder 77
col2 4 in. x 36 in.
col2_sortorder 85
col3 [empty string]
cost 2.37
deal_of_the_week NO
description 1/4 in., 4 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 32888
list_price 4.79
map NO
mfr_num 6406
net_weight 0.18
non_member_discount 16
non_member_price 4.04
prop65 NO
ship_rule_desc STD
shipping STD
sku 32888
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.59
ta_dealer_c_price 2.59
ta_price 4.07
text
array
1 32888
2 6406
3 1/4 in., 4 in. x 36 in.
timestamp 2015-03-27T14:46:59.825Z
vip_member_price 3.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 32
barcode 091157061068
barcode_type UPC
col1 1/4 in.
col1_sortorder 77
col2 1 in. x 36 in.
col2_sortorder 64
col3 [empty string]
cost 1.38
deal_of_the_week NO
description 1/4 in., 1 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 40271
list_price 2.79
map NO
mfr_num 6106
net_weight 0.1
non_member_discount 23
non_member_price 2.14
prop65 NO
ship_rule_desc STD
shipping STD
sku 40271
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.51
ta_dealer_c_price 1.51
ta_price 2.37
text
array
1 40271
2 6106
3 1/4 in., 1 in. x 36 in.
timestamp 2015-03-27T14:47:12.509Z
vip_member_price 1.89

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 24
barcode 091157063062
barcode_type UPC
col1 1/4 in.
col1_sortorder 77
col2 3 in. x 36 in.
col2_sortorder 81
col3 [empty string]
cost 1.72
deal_of_the_week NO
description 1/4 in., 3 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 53530
list_price 3.49
map NO
mfr_num 6306
net_weight 0.15
non_member_discount 14
non_member_price 3
prop65 NO
ship_rule_desc STD
shipping STD
sku 53530
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.88
ta_dealer_c_price 1.88
ta_price 2.97
text
array
1 53530
2 6306
3 1/4 in., 3 in. x 36 in.
timestamp 2015-03-27T14:47:28.535Z
vip_member_price 2.64

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 29
barcode 091157062065
barcode_type UPC
col1 1/4 in.
col1_sortorder 77
col2 2 in. x 36 in.
col2_sortorder 77
col3 [empty string]
cost 1.57
deal_of_the_week NO
description 1/4 in., 2 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 65421
list_price 3.19
map NO
mfr_num 6206
net_weight 0.1
non_member_discount 20
non_member_price 2.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 65421
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.72
ta_dealer_c_price 1.72
ta_price 2.71
text
array
1 65421
2 6206
3 1/4 in., 2 in. x 36 in.
timestamp 2015-03-27T14:47:46.981Z
vip_member_price 2.27

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 34
barcode 091157061099
barcode_type UPC
col1 1/2 in.
col1_sortorder 80
col2 1 in. x 36 in.
col2_sortorder 64
col3 [empty string]
cost 1.87
deal_of_the_week NO
description 1/2 in., 1 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 41472
list_price 3.79
map NO
mfr_num 6109
net_weight 0.1
non_member_discount 26
non_member_price 2.82
prop65 NO
ship_rule_desc STD
shipping STD
sku 41472
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.05
ta_dealer_c_price 2.05
ta_price 3.22
text
array
1 41472
2 6109
3 1/2 in., 1 in. x 36 in.
timestamp 2015-03-27T14:47:13.691Z
vip_member_price 2.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 34
barcode 091157062096
barcode_type UPC
col1 1/2 in.
col1_sortorder 80
col2 2 in. x 36 in.
col2_sortorder 77
col3 [empty string]
cost 2.71
deal_of_the_week NO
description 1/2 in., 2 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 87976
list_price 5.49
map NO
mfr_num 6209
net_weight 0.18
non_member_discount 25
non_member_price 4.12
prop65 NO
ship_rule_desc STD
shipping STD
sku 87976
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.96
ta_dealer_c_price 2.96
ta_price 4.67
text
array
1 87976
2 6209
3 1/2 in., 2 in. x 36 in.
timestamp 2015-03-27T14:48:20.961Z
vip_member_price 3.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 32
barcode 091157061020
barcode_type UPC
col1 1/16 in.
col1_sortorder 83
col2 1 in. x 36 in.
col2_sortorder 64
col3 [empty string]
cost 0.69
deal_of_the_week NO
description 1/16 in., 1 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 12655
list_price 1.39
map NO
mfr_num 6102
net_weight 0.08
non_member_discount 23
non_member_price 1.07
prop65 NO
ship_rule_desc STD
shipping STD
sku 12655
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.75
ta_dealer_c_price 0.75
ta_price 1.18
text
array
1 12655
2 6102
3 1/16 in., 1 in. x 36 in.
timestamp 2015-03-27T14:46:27.753Z
vip_member_price 0.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 29
barcode 091157063024
barcode_type UPC
col1 1/16 in.
col1_sortorder 83
col2 3 in. x 36 in.
col2_sortorder 81
col3 [empty string]
cost 0.83
deal_of_the_week NO
description 1/16 in., 3 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 26842
list_price 1.69
map NO
mfr_num 6302
net_weight 0.12
non_member_discount 20
non_member_price 1.35
prop65 NO
ship_rule_desc STD
shipping STD
sku 26842
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.91
ta_dealer_c_price 0.91
ta_price 1.44
text
array
1 26842
2 6302
3 1/16 in., 3 in. x 36 in.
timestamp 2015-03-27T14:46:49.823Z
vip_member_price 1.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 29
barcode 091157066025
barcode_type UPC
col1 1/16 in.
col1_sortorder 83
col2 6 in. x 36 in.
col2_sortorder 93
col3 [empty string]
cost 1.98
deal_of_the_week NO
description 1/16 in., 6 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 31535
list_price 3.99
map NO
mfr_num 6602
net_weight 0.18
non_member_discount 20
non_member_price 3.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 31535
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.15
ta_dealer_c_price 2.15
ta_price 3.39
text
array
1 31535
2 6602
3 1/16 in., 6 in. x 36 in.
timestamp 2015-03-27T14:46:57.075Z
vip_member_price 2.83

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 29
barcode 091157062027
barcode_type UPC
col1 1/16 in.
col1_sortorder 83
col2 2 in. x 36 in.
col2_sortorder 77
col3 [empty string]
cost 0.83
deal_of_the_week NO
description 1/16 in., 2 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 33577
list_price 1.69
map NO
mfr_num 6202
net_weight 0.1
non_member_discount 20
non_member_price 1.35
prop65 NO
ship_rule_desc STD
shipping STD
sku 33577
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.91
ta_dealer_c_price 0.91
ta_price 1.44
text
array
1 33577
2 6202
3 1/16 in., 2 in. x 36 in.
timestamp 2015-03-27T14:47:03.791Z
vip_member_price 1.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157064021
barcode_type UPC
col1 1/16 in.
col1_sortorder 83
col2 4 in. x 36 in.
col2_sortorder 85
col3 [empty string]
cost 1.23
deal_of_the_week NO
description 1/16 in., 4 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 34896
list_price 2.49
map NO
mfr_num 6402
net_weight 0.14
non_member_discount 18
non_member_price 2.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 34896
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.34
ta_dealer_c_price 1.34
ta_price 2.12
text
array
1 34896
2 6402
3 1/16 in., 4 in. x 36 in.
timestamp 2015-03-27T14:47:05.42Z
vip_member_price 1.75

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 091157064038
barcode_type UPC
col1 3/32 in.
col1_sortorder 84
col2 4 in. x 36 in.
col2_sortorder 85
col3 [empty string]
cost 1.43
deal_of_the_week NO
description 3/32 in., 4 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 26470
list_price 2.89
map NO
mfr_num 6403
net_weight 0.14
non_member_discount 15
non_member_price 2.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 26470
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.56
ta_dealer_c_price 1.56
ta_price 2.46
text
array
1 26470
2 6403
3 3/32 in., 4 in. x 36 in.
timestamp 2015-03-27T14:46:49.282Z
vip_member_price 2.17

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 34
barcode 091157062034
barcode_type UPC
col1 3/32 in.
col1_sortorder 84
col2 2 in. x 36 in.
col2_sortorder 77
col3 [empty string]
cost 0.95
deal_of_the_week NO
description 3/32 in., 2 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 49359
list_price 1.89
map NO
mfr_num 6203
net_weight 0.1
non_member_discount 26
non_member_price 1.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 49359
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.02
ta_dealer_c_price 1.02
ta_price 1.61
text
array
1 49359
2 6203
3 3/32 in., 2 in. x 36 in.
timestamp 2015-03-27T14:47:23.781Z
vip_member_price 1.24

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 24
barcode 091157066032
barcode_type UPC
col1 3/32 in.
col1_sortorder 84
col2 6 in. x 36 in.
col2_sortorder 93
col3 [empty string]
cost 2.22
deal_of_the_week NO
description 3/32 in., 6 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 54921
list_price 4.49
map NO
mfr_num 6603
net_weight 0.18
non_member_discount 14
non_member_price 3.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 54921
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.42
ta_dealer_c_price 2.42
ta_price 3.82
text
array
1 54921
2 6603
3 3/32 in., 6 in. x 36 in.
timestamp 2015-03-27T14:47:29.521Z
vip_member_price 3.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 26
barcode 091157061037
barcode_type UPC
col1 3/32 in.
col1_sortorder 84
col2 1 in. x 36 in.
col2_sortorder 64
col3 [empty string]
cost 0.68
deal_of_the_week NO
description 3/32 in., 1 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 68867
list_price 1.39
map NO
mfr_num 6103
net_weight 0.08
non_member_discount 16
non_member_price 1.17
prop65 NO
ship_rule_desc STD
shipping STD
sku 68867
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.75
ta_dealer_c_price 0.75
ta_price 1.18
text
array
1 68867
2 6103
3 3/32 in., 1 in. x 36 in.
timestamp 2015-03-27T14:47:52.307Z
vip_member_price 1.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 28
barcode 091157063031
barcode_type UPC
col1 3/32 in.
col1_sortorder 84
col2 3 in. x 36 in.
col2_sortorder 81
col3 [empty string]
cost 1.04
deal_of_the_week NO
description 3/32 in., 3 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 71301
list_price 2.09
map NO
mfr_num 6303
net_weight 0.12
non_member_discount 18
non_member_price 1.71
prop65 NO
ship_rule_desc STD
shipping STD
sku 71301
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.13
ta_dealer_c_price 1.13
ta_price 1.78
text
array
1 71301
2 6303
3 3/32 in., 3 in. x 36 in.
timestamp 2015-03-27T14:47:59.494Z
vip_member_price 1.51

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 31
barcode 091157062041
barcode_type UPC
col1 1/8 in.
col1_sortorder 85
col2 2 in. x 36 in.
col2_sortorder 77
col3 [empty string]
cost 0.99
deal_of_the_week NO
description 1/8 in., 2 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 16328
list_price 1.99
map NO
mfr_num 6204
net_weight 0.1
non_member_discount 22
non_member_price 1.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 16328
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.07
ta_dealer_c_price 1.07
ta_price 1.69
text
array
1 16328
2 6204
3 1/8 in., 2 in. x 36 in.
timestamp 2015-03-27T14:46:35.74Z
vip_member_price 1.38

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 24
barcode 091157063048
barcode_type UPC
col1 1/8 in.
col1_sortorder 85
col2 3 in. x 36 in.
col2_sortorder 81
col3 [empty string]
cost 1.13
deal_of_the_week NO
description 1/8 in., 3 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 38729
list_price 2.29
map NO
mfr_num 6304
net_weight 0.12
non_member_discount 14
non_member_price 1.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 38729
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.24
ta_dealer_c_price 1.24
ta_price 1.95
text
array
1 38729
2 6304
3 1/8 in., 3 in. x 36 in.
timestamp 2015-03-27T14:47:10.823Z
vip_member_price 1.73

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 29
barcode 091157064045
barcode_type UPC
col1 1/8 in.
col1_sortorder 85
col2 4 in. x 36 in.
col2_sortorder 85
col3 [empty string]
cost 1.57
deal_of_the_week NO
description 1/8 in., 4 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 48649
list_price 3.19
map NO
mfr_num 6404
net_weight 0.14
non_member_discount 20
non_member_price 2.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 48649
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.72
ta_dealer_c_price 1.72
ta_price 2.71
text
array
1 48649
2 6404
3 1/8 in., 4 in. x 36 in.
timestamp 2015-03-27T14:47:23.068Z
vip_member_price 2.27

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 091157066049
barcode_type UPC
col1 1/8 in.
col1_sortorder 85
col2 6 in. x 36 in.
col2_sortorder 93
col3 [empty string]
cost 2.76
deal_of_the_week NO
description 1/8 in., 6 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 70504
list_price 5.59
map NO
mfr_num 6604
net_weight 0.18
non_member_discount 15
non_member_price 4.73
prop65 NO
ship_rule_desc STD
shipping STD
sku 70504
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.02
ta_dealer_c_price 3.02
ta_price 4.75
text
array
1 70504
2 6604
3 1/8 in., 6 in. x 36 in.
timestamp 2015-03-27T14:47:56.624Z
vip_member_price 4.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 30
barcode 091157061044
barcode_type UPC
col1 1/8 in.
col1_sortorder 85
col2 1 in. x 36 in.
col2_sortorder 64
col3 [empty string]
cost 0.78
deal_of_the_week NO
description 1/8 in., 1 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 88326
list_price 1.59
map NO
mfr_num 6104
net_weight 0.08
non_member_discount 21
non_member_price 1.26
prop65 NO
ship_rule_desc STD
shipping STD
sku 88326
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.86
ta_dealer_c_price 0.86
ta_price 1.35
text
array
1 88326
2 6104
3 1/8 in., 1 in. x 36 in.
timestamp 2015-03-27T14:48:21.722Z
vip_member_price 1.11

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 37
barcode 091157061051
barcode_type UPC
col1 3/16 in.
col1_sortorder 86
col2 1 in. x 36 in.
col2_sortorder 64
col3 [empty string]
cost 1.17
deal_of_the_week NO
description 3/16 in., 1 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 20206
list_price 2.39
map NO
mfr_num 6105
net_weight 0.08
non_member_discount 28
non_member_price 1.71
prop65 NO
ship_rule_desc STD
shipping STD
sku 20206
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.29
ta_dealer_c_price 1.29
ta_price 2.03
text
array
1 20206
2 6105
3 3/16 in., 1 in. x 36 in.
timestamp 2015-03-27T14:46:40.217Z
vip_member_price 1.51

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 34
barcode 091157062058
barcode_type UPC
col1 3/16 in.
col1_sortorder 86
col2 2 in. x 36 in.
col2_sortorder 77
col3 [empty string]
cost 1.28
deal_of_the_week NO
description 3/16 in., 2 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 23105
list_price 2.59
map NO
mfr_num 6205
net_weight 0.1
non_member_discount 25
non_member_price 1.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 23105
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.2
text
array
1 23105
2 6205
3 3/16 in., 2 in. x 36 in.
timestamp 2015-03-27T14:46:44.152Z
vip_member_price 1.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 24
barcode 091157066056
barcode_type UPC
col1 3/16 in.
col1_sortorder 86
col2 6 in. x 36 in.
col2_sortorder 93
col3 [empty string]
cost 2.96
deal_of_the_week NO
description 3/16 in., 6 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 44961
list_price 5.99
map NO
mfr_num 6605
net_weight 0.18
non_member_discount 15
non_member_price 5.12
prop65 NO
ship_rule_desc STD
shipping STD
sku 44961
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3.23
ta_price 5.09
text
array
1 44961
2 6605
3 3/16 in., 6 in. x 36 in.
timestamp 2015-03-27T14:47:17.889Z
vip_member_price 4.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 29
barcode 091157064052
barcode_type UPC
col1 3/16 in.
col1_sortorder 86
col2 4 in. x 36 in.
col2_sortorder 85
col3 [empty string]
cost 1.98
deal_of_the_week NO
description 3/16 in., 4 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 70884
list_price 3.99
map NO
mfr_num 6405
net_weight 0.14
non_member_discount 20
non_member_price 3.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 70884
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.15
ta_dealer_c_price 2.15
ta_price 3.39
text
array
1 70884
2 6405
3 3/16 in., 4 in. x 36 in.
timestamp 2015-03-27T14:47:58.043Z
vip_member_price 2.83

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 29
barcode 091157063055
barcode_type UPC
col1 3/16 in.
col1_sortorder 86
col2 3 in. x 36 in.
col2_sortorder 81
col3 [empty string]
cost 1.48
deal_of_the_week NO
description 3/16 in., 3 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 75682
list_price 2.99
map NO
mfr_num 6305
net_weight 0.12
non_member_discount 20
non_member_price 2.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 75682
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.61
ta_dealer_c_price 1.61
ta_price 2.54
text
array
1 75682
2 6305
3 3/16 in., 3 in. x 36 in.
timestamp 2015-03-27T14:48:05.666Z
vip_member_price 2.11

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 091157063086
barcode_type UPC
col1 3/8 in.
col1_sortorder 87
col2 3 in. x 36 in.
col2_sortorder 81
col3 [empty string]
cost 2.56
deal_of_the_week NO
description 3/8 in., 3 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 19236
list_price 5.19
map NO
mfr_num 6308
net_weight 0.18
non_member_discount 15
non_member_price 4.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 19236
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.8
ta_dealer_c_price 2.8
ta_price 4.41
text
array
1 19236
2 6308
3 3/8 in., 3 in. x 36 in.
timestamp 2015-03-27T14:46:39.448Z
vip_member_price 3.88

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 29
barcode 091157061082
barcode_type UPC
col1 3/8 in.
col1_sortorder 87
col2 1 in. x 36 in.
col2_sortorder 64
col3 [empty string]
cost 1.57
deal_of_the_week NO
description 3/8 in., 1 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 29328
list_price 3.19
map NO
mfr_num 6108
net_weight 0.1
non_member_discount 20
non_member_price 2.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 29328
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.72
ta_dealer_c_price 1.72
ta_price 2.71
text
array
1 29328
2 6108
3 3/8 in., 1 in. x 36 in.
timestamp 2015-03-27T14:46:53.227Z
vip_member_price 2.27

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' 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.92.233.9

URL: www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e030aab8bd4893ff196f74705a451b464127
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=transporting&catB=packing-shipping-material&CatC=fb~southwestern-packaging~&gr=southwestern-packaging-jiffylite-cushioned-mailers.html
urltoken CFID=29690320&CFTOKEN=37952812&jsessionid=e030aab8bd4893ff196f74705a451b464127
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 13:13:04'}
sessionid e03093ca95f3c8c886f82514d477776c6b3c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~&gr=midwest-balsa-sheets.html
urltoken CFID=29690319&CFTOKEN=78889078&jsessionid=e03093ca95f3c8c886f82514d477776c6b3c
validationerror [empty string]


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

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

ItemIDList: 37012,45327,54696
AvailQtyList: 0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 091157064083
barcode_type UPC
col1 3/8 in.
col1_sortorder 87
col2 4 in. x 36 in.
col2_sortorder 85
col3 [empty string]
cost 3.26
deal_of_the_week NO
description 3/8 in., 4 in. x 36 in.
group_id 1449
group_uname midwest-balsa-sheets
id 80911
list_price 6.59
map NO
mfr_num 6408
net_weight 0.18
non_member_discount 15
non_member_price 5.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 80911
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.56
ta_dealer_c_price 3.56
ta_price 5.6
text
array
1 80911
2 6408
3 3/8 in., 4 in. x 36 in.
timestamp 2015-03-27T14:48:11.633Z
vip_member_price 4.96

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 37012
2 0E-12 45327
3 0E-12 54696
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1135' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: