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

Artists' Deep Edge Canvas

by Winsor & Newton


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376956009
barcode_type UPC
col1 10 in. x 10 in.
col1_sortorder 719
col2 each
col2_sortorder 340
col3 [empty string]
cost 4.2
deal_of_the_week NO
description 10 in. x 10 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 46576
list_price 20.49
map NO
mfr_num 6015098
net_weight 1.13
non_member_discount 45
non_member_price 11.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 46576
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.12
ta_dealer_c_price 4.61
ta_price 8.2
text
array
1 46576
2 6015098
3 10 in. x 10 in., each
timestamp 2015-03-27T14:47:20.693Z
vip_member_price 9.22

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
VIP_member_discount 67
col1 10 in. x 10 in.
col1_sortorder 719
col2 carton of 6
col2_sortorder 328
col3 [empty string]
cost 25.2
deal_of_the_week NO
description 10 in. x 10 in., carton of 6
flags
array
1 1
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 46576-PK
list_price 122.94
map NO
net_weight 6.8
non_member_discount 57
non_member_price 52.86
prop65 NO
ship_rule_desc STD
shipping STD
sku 46576-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 46576-PK
2 10 in. x 10 in., carton of 6
timestamp 2015-03-27T14:47:20.696Z
vip_member_price 40.57

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376986198
barcode_type UPC
col1 10 in. x 30 in.
col1_sortorder 729
col2 each
col2_sortorder 340
col3 [empty string]
cost 7.27
deal_of_the_week NO
description 10 in. x 30 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 73728
list_price 35.49
map NO
mfr_num 6015342
net_weight 2.7
non_member_discount 45
non_member_price 19.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 73728
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.87
ta_dealer_c_price 7.99
ta_price 14.2
text
array
1 73728
2 6015342
3 10 in. x 30 in., each
timestamp 2015-03-27T14:48:03.868Z
vip_member_price 15.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376956016
barcode_type UPC
col1 11 in. x 14 in.
col1_sortorder 781
col2 each
col2_sortorder 340
col3 [empty string]
cost 5.01
deal_of_the_week NO
description 11 in. x 14 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 51818
list_price 24.49
map NO
mfr_num 6015111
net_weight 1.2
non_member_discount 45
non_member_price 13.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 51818
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.12
ta_dealer_c_price 5.51
ta_price 9.8
text
array
1 51818
2 6015111
3 11 in. x 14 in., each
timestamp 2015-03-27T14:47:25.939Z
vip_member_price 11.02

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
VIP_member_discount 67
col1 11 in. x 14 in.
col1_sortorder 781
col2 carton of 6
col2_sortorder 328
col3 [empty string]
cost 30.06
deal_of_the_week NO
description 11 in. x 14 in., carton of 6
flags
array
1 1
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 51818-PK
list_price 146.94
map NO
net_weight 7.25
non_member_discount 57
non_member_price 63.18
prop65 NO
ship_rule_desc STD
shipping STD
sku 51818-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 51818-PK
2 11 in. x 14 in., carton of 6
timestamp 2015-03-27T14:47:25.941Z
vip_member_price 48.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376956023
barcode_type UPC
col1 12 in. x 12 in.
col1_sortorder 838
col2 each
col2_sortorder 340
col3 [empty string]
cost 5.43
deal_of_the_week NO
description 12 in. x 12 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 38309
list_price 26.49
map NO
mfr_num 6015115
net_weight 1.36
non_member_discount 45
non_member_price 14.57
prop65 NO
ship_rule_desc STD
shipping STD
sku 38309
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.62
ta_dealer_c_price 5.96
ta_price 10.6
text
array
1 38309
2 6015115
3 12 in. x 12 in., each
timestamp 2015-03-27T14:47:10.583Z
vip_member_price 11.92

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
VIP_member_discount 67
col1 12 in. x 12 in.
col1_sortorder 838
col2 carton of 6
col2_sortorder 328
col3 [empty string]
cost 32.58
deal_of_the_week NO
description 12 in. x 12 in., carton of 6
flags
array
1 1
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 38309-PK
list_price 158.94
map NO
net_weight 8.2
non_member_discount 57
non_member_price 68.34
prop65 NO
ship_rule_desc STD
shipping STD
sku 38309-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 38309-PK
2 12 in. x 12 in., carton of 6
timestamp 2015-03-27T14:47:10.586Z
vip_member_price 52.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376956030
barcode_type UPC
col1 12 in. x 16 in.
col1_sortorder 843
col2 each
col2_sortorder 340
col3 [empty string]
cost 6.04
deal_of_the_week NO
description 12 in. x 16 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 69779
list_price 29.49
map NO
mfr_num 6015114
net_weight 1.64
non_member_discount 45
non_member_price 16.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 69779
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.37
ta_dealer_c_price 6.64
ta_price 11.8
text
array
1 69779
2 6015114
3 12 in. x 16 in., each
timestamp 2015-03-27T14:47:54.912Z
vip_member_price 13.27

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
VIP_member_discount 67
col1 12 in. x 16 in.
col1_sortorder 843
col2 carton of 6
col2_sortorder 328
col3 [empty string]
cost 36.24
deal_of_the_week NO
description 12 in. x 16 in., carton of 6
flags
array
1 1
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 69779-PK
list_price 176.94
map NO
net_weight 9.88
non_member_discount 57
non_member_price 76.08
prop65 NO
ship_rule_desc STD
shipping STD
sku 69779-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 69779-PK
2 12 in. x 16 in., carton of 6
timestamp 2015-03-27T14:47:54.915Z
vip_member_price 58.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376956047
barcode_type UPC
col1 12 in. x 24 in.
col1_sortorder 854
col2 each
col2_sortorder 340
col3 [empty string]
cost 6.25
deal_of_the_week NO
description 12 in. x 24 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 11189
list_price 30.49
map NO
mfr_num 6015126
net_weight 1.69
non_member_discount 45
non_member_price 16.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 11189
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.62
ta_dealer_c_price 6.86
ta_price 12.2
text
array
1 11189
2 6015126
3 12 in. x 24 in., each
timestamp 2015-03-27T14:46:25.239Z
vip_member_price 13.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
VIP_member_discount 67
col1 12 in. x 24 in.
col1_sortorder 854
col2 carton of 6
col2_sortorder 328
col3 [empty string]
cost 37.5
deal_of_the_week NO
description 12 in. x 24 in., carton of 6
flags
array
1 1
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 11189-PK
list_price 182.94
map NO
net_weight 10.14
non_member_discount 57
non_member_price 78.66
prop65 NO
ship_rule_desc STD
shipping STD
sku 11189-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 11189-PK
2 12 in. x 24 in., carton of 6
timestamp 2015-03-27T14:46:25.241Z
vip_member_price 60.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376986204
barcode_type UPC
col1 12 in. x 36 in.
col1_sortorder 860
col2 each
col2_sortorder 340
col3 [empty string]
cost 10.86
deal_of_the_week NO
description 12 in. x 36 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 73729
list_price 52.99
map NO
mfr_num 6015343
net_weight 3.45
non_member_discount 45
non_member_price 29.14
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 73729
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.25
ta_dealer_c_price 11.92
ta_price 21.2
text
array
1 73729
2 6015343
3 12 in. x 36 in., each
timestamp 2015-03-27T14:48:03.872Z
vip_member_price 23.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376986211
barcode_type UPC
col1 12 in. x 48 in.
col1_sortorder 861
col2 each
col2_sortorder 340
col3 [empty string]
cost 12.3
deal_of_the_week NO
description 12 in. x 48 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 73730
list_price 59.99
map NO
mfr_num 6015183
net_weight 4.35
non_member_discount 45
non_member_price 32.99
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 73730
sku_pix YES
supplier_id 1
ta_dealer_a_price 15
ta_dealer_c_price 13.5
ta_price 24
text
array
1 73730
2 6015183
3 12 in. x 48 in., each
timestamp 2015-03-27T14:48:03.874Z
vip_member_price 27

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376956054
barcode_type UPC
col1 14 in. x 18 in.
col1_sortorder 926
col2 each
col2_sortorder 340
col3 [empty string]
cost 6.87
deal_of_the_week NO
description 14 in. x 18 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 38082
list_price 33.49
map NO
mfr_num 6015116
net_weight 1.75
non_member_discount 45
non_member_price 18.42
prop65 NO
ship_rule_desc STD
shipping STD
sku 38082
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.37
ta_dealer_c_price 7.54
ta_price 13.4
text
array
1 38082
2 6015116
3 14 in. x 18 in., each
timestamp 2015-03-27T14:47:10.267Z
vip_member_price 15.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
VIP_member_discount 67
col1 14 in. x 18 in.
col1_sortorder 926
col2 carton of 6
col2_sortorder 328
col3 [empty string]
cost 41.22
deal_of_the_week NO
description 14 in. x 18 in., carton of 6
flags
array
1 1
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 38082-PK
list_price 200.94
map NO
net_weight 10.5
non_member_discount 57
non_member_price 86.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 38082-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 38082-PK
2 14 in. x 18 in., carton of 6
timestamp 2015-03-27T14:47:10.282Z
vip_member_price 66.31

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376972351
barcode_type UPC
col1 16 in. x 16 in.
col1_sortorder 987
col2 each
col2_sortorder 340
col3 [empty string]
cost 6.87
deal_of_the_week NO
description 16 in. x 16 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 30974
list_price 33.49
map NO
mfr_num 6015190
net_weight 1.8
non_member_discount 45
non_member_price 18.42
prop65 NO
ship_rule_desc STD
shipping STD
sku 30974
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.37
ta_dealer_c_price 7.54
ta_price 13.4
text
array
1 30974
2 6015190
3 16 in. x 16 in., each
timestamp 2015-03-27T14:46:55.99Z
vip_member_price 15.07

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
VIP_member_discount 67
col1 16 in. x 16 in.
col1_sortorder 987
col2 carton of 6
col2_sortorder 328
col3 [empty string]
cost 41.22
deal_of_the_week NO
description 16 in. x 16 in., carton of 6
flags
array
1 1
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 30974-PK
list_price 200.94
map NO
net_weight 10.8
non_member_discount 57
non_member_price 86.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 30974-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 30974-PK
2 16 in. x 16 in., carton of 6
timestamp 2015-03-27T14:46:55.993Z
vip_member_price 66.31

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376956061
barcode_type UPC
col1 16 in. x 20 in.
col1_sortorder 991
col2 each
col2_sortorder 340
col3 [empty string]
cost 7.27
deal_of_the_week NO
description 16 in. x 20 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 84722
list_price 35.49
map NO
mfr_num 6015129
net_weight 1.87
non_member_discount 45
non_member_price 19.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 84722
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.87
ta_dealer_c_price 7.99
ta_price 14.2
text
array
1 84722
2 6015129
3 16 in. x 20 in., each
timestamp 2015-03-27T14:48:14.884Z
vip_member_price 15.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
VIP_member_discount 67
col1 16 in. x 20 in.
col1_sortorder 991
col2 carton of 6
col2_sortorder 328
col3 [empty string]
cost 43.62
deal_of_the_week NO
description 16 in. x 20 in., carton of 6
flags
array
1 1
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 84722-PK
list_price 212.94
map NO
net_weight 11.25
non_member_discount 57
non_member_price 91.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 84722-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 84722-PK
2 16 in. x 20 in., carton of 6
timestamp 2015-03-27T14:48:14.886Z
vip_member_price 70.27

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376956078
barcode_type UPC
col1 18 in. x 24 in.
col1_sortorder 1067
col2 each
col2_sortorder 340
col3 [empty string]
cost 9.11
deal_of_the_week NO
description 18 in. x 24 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 77922
list_price 44.49
map NO
mfr_num 6015128
net_weight 2.5
non_member_discount 45
non_member_price 24.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 77922
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.12
ta_dealer_c_price 10.01
ta_price 17.8
text
array
1 77922
2 6015128
3 18 in. x 24 in., each
timestamp 2015-03-27T14:48:07.616Z
vip_member_price 20.02

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
VIP_member_discount 67
col1 18 in. x 24 in.
col1_sortorder 1067
col2 carton of 6
col2_sortorder 328
col3 [empty string]
cost 54.66
deal_of_the_week NO
description 18 in. x 24 in., carton of 6
flags
array
1 1
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 77922-PK
list_price 266.94
map NO
net_weight 15
non_member_discount 57
non_member_price 114.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 77922-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 77922-PK
2 18 in. x 24 in., carton of 6
timestamp 2015-03-27T14:48:07.618Z
vip_member_price 88.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376986242
barcode_type UPC
col1 18 in. x 36 in.
col1_sortorder 1078
col2 each
col2_sortorder 340
col3 [empty string]
cost 13.32
deal_of_the_week NO
description 18 in. x 36 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 73731
list_price 64.99
map NO
mfr_num 6015345
net_weight 4.2
non_member_discount 45
non_member_price 35.74
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 73731
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.25
ta_dealer_c_price 14.62
ta_price 26
text
array
1 73731
2 6015345
3 18 in. x 36 in., each
timestamp 2015-03-27T14:48:03.88Z
vip_member_price 29.25

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376956085
barcode_type UPC
col1 20 in. x 20 in.
col1_sortorder 1255
col2 each
col2_sortorder 340
col3 [empty string]
cost 9.11
deal_of_the_week NO
description 20 in. x 20 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 55766
list_price 44.49
map NO
mfr_num 6015123
net_weight 2.7
non_member_discount 45
non_member_price 24.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 55766
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.12
ta_dealer_c_price 10.01
ta_price 17.8
text
array
1 55766
2 6015123
3 20 in. x 20 in., each
timestamp 2015-03-27T14:47:30.529Z
vip_member_price 20.02

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
VIP_member_discount 67
col1 20 in. x 20 in.
col1_sortorder 1255
col2 carton of 6
col2_sortorder 328
col3 [empty string]
cost 54.66
deal_of_the_week NO
description 20 in. x 20 in., carton of 6
flags
array
1 1
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 55766-PK
list_price 266.94
map NO
net_weight 16.6
non_member_discount 57
non_member_price 114.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 55766-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 55766-PK
2 20 in. x 20 in., carton of 6
timestamp 2015-03-27T14:47:30.531Z
vip_member_price 88.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376956092
barcode_type UPC
col1 24 in. x 24 in.
col1_sortorder 1344
col2 each
col2_sortorder 340
col3 [empty string]
cost 11.48
deal_of_the_week NO
description 24 in. x 24 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 41466
list_price 55.99
map NO
mfr_num 6015127
net_weight 3.5
non_member_discount 45
non_member_price 30.79
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 41466
sku_pix YES
supplier_id 1
ta_dealer_a_price 14
ta_dealer_c_price 12.6
ta_price 22.4
text
array
1 41466
2 6015127
3 24 in. x 24 in., each
timestamp 2015-03-27T14:47:13.683Z
vip_member_price 25.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
VIP_member_discount 67
col1 24 in. x 24 in.
col1_sortorder 1344
col2 carton of 6
col2_sortorder 328
col3 [empty string]
cost 68.88
deal_of_the_week NO
description 24 in. x 24 in., carton of 6
flags
array
1 1
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 41466-PK
list_price 335.94
map NO
net_weight 18.45
non_member_discount 57
non_member_price 144.45
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 41466-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 41466-PK
2 24 in. x 24 in., carton of 6
timestamp 2015-03-27T14:47:13.687Z
vip_member_price 110.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376956108
barcode_type UPC
col1 24 in. x 30 in.
col1_sortorder 1349
col2 each
col2_sortorder 340
col3 [empty string]
cost 13.53
deal_of_the_week NO
description 24 in. x 30 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 81332
list_price 65.99
map NO
mfr_num 6015136
net_weight 3.45
non_member_discount 45
non_member_price 36.29
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 81332
sku_pix YES
supplier_id 1
ta_dealer_a_price 16.5
ta_dealer_c_price 14.85
ta_price 26.4
text
array
1 81332
2 6015136
3 24 in. x 30 in., each
timestamp 2015-03-27T14:48:12.296Z
vip_member_price 29.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
VIP_member_discount 67
col1 24 in. x 30 in.
col1_sortorder 1349
col2 carton of 6
col2_sortorder 328
col3 [empty string]
cost 81.18
deal_of_the_week NO
description 24 in. x 30 in., carton of 6
flags
array
1 1
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 81332-PK
list_price 395.94
map NO
net_weight 20.65
non_member_discount 57
non_member_price 170.25
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 81332-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 81332-PK
2 24 in. x 30 in., carton of 6
timestamp 2015-03-27T14:48:12.297Z
vip_member_price 130.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376956115
barcode_type UPC
col1 24 in. x 36 in.
col1_sortorder 1352
col2 each
col2_sortorder 340
col3 [empty string]
cost 15.88
deal_of_the_week NO
description 24 in. x 36 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 16369
list_price 77.49
map NO
mfr_num 6015138
net_weight 4.35
non_member_discount 45
non_member_price 42.62
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 16369
sku_pix YES
supplier_id 1
ta_dealer_a_price 19.37
ta_dealer_c_price 17.44
ta_price 34.87
text
array
1 16369
2 6015138
3 24 in. x 36 in., each
timestamp 2015-03-27T14:46:35.78Z
vip_member_price 34.87

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
VIP_member_discount 67
col1 24 in. x 36 in.
col1_sortorder 1352
col2 carton of 6
col2_sortorder 328
col3 [empty string]
cost 95.28
deal_of_the_week NO
description 24 in. x 36 in., carton of 6
flags
array
1 1
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 16369-PK
list_price 464.94
map NO
net_weight 26.2
non_member_discount 57
non_member_price 199.92
prop65 NO
ship_rule_desc OS1
shipping OS1
sku 16369-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 16369-PK
2 24 in. x 36 in., carton of 6
timestamp 2015-03-27T14:46:35.784Z
vip_member_price 153.43

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
FLAGS 0
VIP_member_discount 55
barcode 094376956122
barcode_type UPC
col1 24 in. x 48 in.
col1_sortorder 1366
col2 each
col2_sortorder 340
col3 [empty string]
cost 19.68
deal_of_the_week NO
description 24 in. x 48 in., each
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 21628
list_price 95.99
map NO
mfr_num 6015145
net_weight 4.5
non_member_discount 45
non_member_price 52.79
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 21628
sku_pix NO
supplier_id 1
ta_dealer_a_price 24
ta_dealer_c_price 21.6
ta_price 43.2
text
array
1 21628
2 6015145
3 24 in. x 48 in., each
timestamp 2015-03-27T14:46:42.25Z
vip_member_price 43.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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

ItemIDList: 36303
AvailQtyList: 43.000000000000

struct
VIP_member_discount 67
col1 24 in. x 48 in.
col1_sortorder 1366
col2 carton of 6
col2_sortorder 328
col3 [empty string]
cost 118.08
deal_of_the_week NO
description 24 in. x 48 in., carton of 6
flags
array
1 1
group_id 3822
group_uname winsor-newton-artists-deep-edge-canvas
id 21628-PK
list_price 575.94
map NO
net_weight 28.4
non_member_discount 57
non_member_price 247.65
prop65 NO
ship_rule_desc OS2
shipping OS2
sku 21628-PK
sku_pix NO
supplier_id 1
ta_dealer_a_price 0
ta_dealer_c_price 0
ta_price 0
text
array
1 21628-PK
2 24 in. x 48 in., carton of 6
timestamp 2015-03-27T14:46:42.255Z
vip_member_price 190.06

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 43.000000000000 36303
CACHED false
EXECUTIONTIME 16
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '8270' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.98.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:57'}
sessionid e030ea3b4d568b6ae47e2166664b234d475d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=drawing&CatC=fb~drimark~fp~3-5~&gr=drimark-tattoo-marks.html
urltoken CFID=29434233&CFTOKEN=91913574&jsessionid=e030ea3b4d568b6ae47e2166664b234d475d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 16:27:56'}
sessionid e030299fe5087e338eb3797f4e3e6bb32918
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-best-sellers&paramOpts=fb~winsor-newton~c1~canvas~&gr=winsor-newton-artists-deep-edge-canvas.html
urltoken CFID=29434232&CFTOKEN=42298260&jsessionid=e030299fe5087e338eb3797f4e3e6bb32918
validationerror [empty string]


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

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