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

Artisan Water Mixable Oil Colours

by Winsor & Newton


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376896183
barcode_type UPC
col1 burnt sienna
col1_sortorder 875
col2 37 ml
col2_sortorder 1711
col3 74
col3_sortorder 216
color_swatch 109-52-49.jpg
cost 3.62
deal_of_the_week NO
description burnt sienna, 37 ml, 74
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 38061
list_price 8.49
map YES
mfr_num 1514074
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 38061
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 38061
2 1514074
3 burnt sienna, 37 ml, 74
timestamp 2015-03-27T14:47:10.2Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376896190
barcode_type UPC
col1 burnt umber
col1_sortorder 886
col2 37 ml
col2_sortorder 1711
col3 76
col3_sortorder 218
color_swatch 52-40-39.jpg
cost 3.62
deal_of_the_week NO
description burnt umber, 37 ml, 76
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 60264
list_price 8.49
map YES
mfr_num 1514076
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 60264
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 60264
2 1514076
3 burnt umber, 37 ml, 76
timestamp 2015-03-27T14:47:37.915Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376895926
barcode_type UPC
col1 cadmium orange hue
col1_sortorder 947
col2 37 ml
col2_sortorder 1711
col3 90
color_swatch 250-211-16.jpg
cost 3.62
deal_of_the_week NO
description cadmium orange hue, 37 ml, 90
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 81833
list_price 8.49
map YES
mfr_num 1514090
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 81833
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 81833
2 1514090
3 cadmium orange hue, 37 ml, 90
timestamp 2015-03-27T14:48:12.617Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376895964
barcode_type UPC
col1 cadmium red dark
col1_sortorder 956
col2 37 ml
col2_sortorder 1711
col3 104
col3_sortorder 236
color_swatch 226-64-65.jpg
cost 7.69
deal_of_the_week NO
description cadmium red dark, 37 ml, 104
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 41608
list_price 17.99
map YES
mfr_num 1514104
net_weight 0.12
non_member_discount 40
non_member_price 10.79
prop65 YES
ship_rule_desc STD
shipping STD
sku 41608
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 8.46
ta_price 11.69
text
array
1 41608
2 1514104
3 cadmium red dark, 37 ml, 104
timestamp 2015-03-27T14:47:13.781Z
vip_member_price 9.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376895971
barcode_type UPC
col1 cadmium red deep hue
col1_sortorder 961
col2 37 ml
col2_sortorder 1711
col3 98
col3_sortorder 228
color_swatch 189-45-58.jpg
cost 3.62
deal_of_the_week NO
description cadmium red deep hue, 37 ml, 98
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 40887
list_price 8.49
map YES
mfr_num 1514098
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 40887
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 40887
2 1514098
3 cadmium red deep hue, 37 ml, 98
timestamp 2015-03-27T14:47:13.037Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376895957
barcode_type UPC
col1 cadmium red hue
col1_sortorder 968
col2 37 ml
col2_sortorder 1711
col3 95
col3_sortorder 226
color_swatch 235-100-67.jpg
cost 3.62
deal_of_the_week NO
description cadmium red hue, 37 ml, 95
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 63181
list_price 8.49
map YES
mfr_num 1514095
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 63181
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 63181
2 1514095
3 cadmium red hue, 37 ml, 95
timestamp 2015-03-27T14:47:43.217Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376895933
barcode_type UPC
col1 cadmium red light
col1_sortorder 969
col2 37 ml
col2_sortorder 1711
col3 100
col3_sortorder 230
color_swatch 217-34-58.jpg
cost 7.69
deal_of_the_week NO
description cadmium red light, 37 ml, 100
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 29915
list_price 17.99
map YES
mfr_num 1514100
net_weight 0.12
non_member_discount 40
non_member_price 10.79
prop65 YES
ship_rule_desc STD
shipping STD
sku 29915
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 8.46
ta_price 11.69
text
array
1 29915
2 1514100
3 cadmium red light, 37 ml, 100
timestamp 2015-03-27T14:46:54.018Z
vip_member_price 9.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376895940
barcode_type UPC
col1 cadmium red medium
col1_sortorder 977
col2 37 ml
col2_sortorder 1711
col3 99
col3_sortorder 229
color_swatch 200-30-48.jpg
cost 7.69
deal_of_the_week NO
description cadmium red medium, 37 ml, 99
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 19671
list_price 17.99
map YES
mfr_num 1514099
net_weight 0.12
non_member_discount 40
non_member_price 10.79
prop65 YES
ship_rule_desc STD
shipping STD
sku 19671
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 8.46
ta_price 11.69
text
array
1 19671
2 1514099
3 cadmium red medium, 37 ml, 99
timestamp 2015-03-27T14:46:39.776Z
vip_member_price 9.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376895919
barcode_type UPC
col1 cadmium yellow deep hue
col1_sortorder 1003
col2 37 ml
col2_sortorder 1711
col3 115
col3_sortorder 247
color_swatch 242-151-46.jpg
cost 3.62
deal_of_the_week NO
description cadmium yellow deep hue, 37 ml, 115
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 15752
list_price 8.49
map YES
mfr_num 1514115
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 15752
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 15752
2 1514115
3 cadmium yellow deep hue, 37 ml, 115
timestamp 2015-03-27T14:46:34.854Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376895902
barcode_type UPC
col1 cadmium yellow hue
col1_sortorder 1008
col2 37 ml
col2_sortorder 1711
col3 109
col3_sortorder 241
color_swatch 249-190-30.jpg
cost 3.62
deal_of_the_week NO
description cadmium yellow hue, 37 ml, 109
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 24096
list_price 8.49
map YES
mfr_num 1514109
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 24096
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 24096
2 1514109
3 cadmium yellow hue, 37 ml, 109
timestamp 2015-03-27T14:46:45.375Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376895872
barcode_type UPC
col1 cadmium yellow light
col1_sortorder 1010
col2 37 ml
col2_sortorder 1711
col3 113
col3_sortorder 245
color_swatch 242-151-47.jpg
cost 7.69
deal_of_the_week NO
description cadmium yellow light, 37 ml, 113
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 57116
list_price 17.99
map YES
mfr_num 1514113
net_weight 0.12
non_member_discount 40
non_member_price 10.79
prop65 YES
ship_rule_desc STD
shipping STD
sku 57116
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 8.46
ta_price 11.69
text
array
1 57116
2 1514113
3 cadmium yellow light, 37 ml, 113
timestamp 2015-03-27T14:47:32.202Z
vip_member_price 9.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376895896
barcode_type UPC
col1 cadmium yellow medium
col1_sortorder 1019
col2 37 ml
col2_sortorder 1711
col3 116
col3_sortorder 248
color_swatch 248-190-28.jpg
cost 7.69
deal_of_the_week NO
description cadmium yellow medium, 37 ml, 116
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 27146
list_price 17.99
map YES
mfr_num 1514116
net_weight 0.12
non_member_discount 40
non_member_price 10.79
prop65 YES
ship_rule_desc STD
shipping STD
sku 27146
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 8.46
ta_price 11.69
text
array
1 27146
2 1514116
3 cadmium yellow medium, 37 ml, 116
timestamp 2015-03-27T14:46:50.321Z
vip_member_price 9.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376895889
barcode_type UPC
col1 cadmium yellow pale hue
col1_sortorder 1029
col2 37 ml
col2_sortorder 1711
col3 119
col3_sortorder 251
color_swatch 250-211-12.jpg
cost 3.62
deal_of_the_week NO
description cadmium yellow pale hue, 37 ml, 119
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 72993
list_price 8.49
map YES
mfr_num 1514119
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 72993
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 72993
2 1514119
3 cadmium yellow pale hue, 37 ml, 119
timestamp 2015-03-27T14:48:03.171Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376896022
barcode_type UPC
col1 cerulean blue
col1_sortorder 1154
col2 37 ml
col2_sortorder 1711
col3 137
col3_sortorder 269
color_swatch 6-131-146.jpg
cost 7.69
deal_of_the_week NO
description cerulean blue, 37 ml, 137
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 39952
list_price 17.99
map YES
mfr_num 1514137
net_weight 0.12
non_member_discount 40
non_member_price 10.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 39952
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 8.46
ta_price 11.69
text
array
1 39952
2 1514137
3 cerulean blue, 37 ml, 137
timestamp 2015-03-27T14:47:12.314Z
vip_member_price 9.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 884955008324
barcode_type UPC
col1 cerulean blue hue
col1_sortorder 1163
col2 37 ml
col2_sortorder 1711
col3 138
col3_sortorder 270
color_swatch 23-169-208.jpg
cost 3.62
deal_of_the_week NO
description cerulean blue hue, 37 ml, 138
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 77467
list_price 8.49
map YES
mfr_num 1514138
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 77467
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 77467
2 1514138
3 cerulean blue hue, 37 ml, 138
timestamp 2015-03-27T14:48:07.221Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376896046
barcode_type UPC
col1 cobalt blue
col1_sortorder 1352
col2 37 ml
col2_sortorder 1711
col3 178
col3_sortorder 309
color_swatch 13-111-178.jpg
cost 7.69
deal_of_the_week NO
description cobalt blue, 37 ml, 178
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 50367
list_price 17.99
map YES
mfr_num 1514178
net_weight 0.12
non_member_discount 40
non_member_price 10.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 50367
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 8.46
ta_price 11.69
text
array
1 50367
2 1514178
3 cobalt blue, 37 ml, 178
timestamp 2015-03-27T14:47:24.845Z
vip_member_price 9.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376896053
barcode_type UPC
col1 cobalt blue hue
col1_sortorder 1357
col2 37 ml
col2_sortorder 1711
col3 138
col3_sortorder 270
color_swatch 26-79-162.jpg
cost 3.62
deal_of_the_week NO
description cobalt blue hue, 37 ml, 138
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 89943
list_price 8.49
map YES
mfr_num 1514179
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 89943
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 89943
2 1514179
3 cobalt blue hue, 37 ml, 138
timestamp 2015-03-27T14:48:24.724Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376896015
barcode_type UPC
col1 dioxazine purple
col1_sortorder 1907
col2 37 ml
col2_sortorder 1711
col3 229
col3_sortorder 382
color_swatch 85-52-138.jpg
cost 3.62
deal_of_the_week NO
description dioxazine purple, 37 ml, 229
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 68519
list_price 8.49
map YES
mfr_num 1514229
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 68519
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 68519
2 1514229
3 dioxazine purple, 37 ml, 229
timestamp 2015-03-27T14:47:51.562Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376896060
barcode_type UPC
col1 French ultramarine
col1_sortorder 2326
col2 37 ml
col2_sortorder 1711
col3 263
col3_sortorder 433
color_swatch 6-76-153.jpg
cost 3.62
deal_of_the_week NO
description French ultramarine, 37 ml, 263
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 52863
list_price 8.49
map YES
mfr_num 1514263
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 52863
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 52863
2 1514263
3 French ultramarine, 37 ml, 263
timestamp 2015-03-27T14:47:28.149Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376896176
barcode_type UPC
col1 Indian red
col1_sortorder 2934
col2 37 ml
col2_sortorder 1711
col3 317
col3_sortorder 485
color_swatch 134-56-56.jpg
cost 3.62
deal_of_the_week NO
description Indian red, 37 ml, 317
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 50873
list_price 8.49
map YES
mfr_num 1514317
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 50873
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 50873
2 1514317
3 Indian red, 37 ml, 317
timestamp 2015-03-27T14:47:25.149Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376896220
barcode_type UPC
col1 ivory black
col1_sortorder 3120
col2 37 ml
col2_sortorder 1711
col3 331
col3_sortorder 504
color_swatch 4-5-5.jpg
cost 3.62
deal_of_the_week NO
description ivory black, 37 ml, 331
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 10336
list_price 8.49
map YES
mfr_num 1514331
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 10336
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 10336
2 1514331
3 ivory black, 37 ml, 331
timestamp 2015-03-27T14:46:24.357Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376896237
barcode_type UPC
col1 lamp black
col1_sortorder 3230
col2 37 ml
col2_sortorder 1711
col3 337
col3_sortorder 514
color_swatch 10-14-15.jpg
cost 3.62
deal_of_the_week NO
description lamp black, 37 ml, 337
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 73904
list_price 8.49
map YES
mfr_num 1514337
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 73904
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 73904
2 1514337
3 lamp black, 37 ml, 337
timestamp 2015-03-27T14:48:03.987Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376895865
barcode_type UPC
col1 lemon yellow
col1_sortorder 3277
col2 37 ml
col2_sortorder 1711
col3 346
col3_sortorder 536
color_swatch 251-238-7.jpg
cost 3.62
deal_of_the_week NO
description lemon yellow, 37 ml, 346
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 44813
list_price 8.49
map YES
mfr_num 1514346
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 44813
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 44813
2 1514346
3 lemon yellow, 37 ml, 346
timestamp 2015-03-27T14:47:17.529Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376896008
barcode_type UPC
col1 magenta
col1_sortorder 3529
col2 37 ml
col2_sortorder 1711
col3 380
col3_sortorder 575
color_swatch 215-30-143.jpg
cost 3.62
deal_of_the_week NO
description magenta, 37 ml, 380
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 58175
list_price 8.49
map YES
mfr_num 1514380
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 58175
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 58175
2 1514380
3 magenta, 37 ml, 380
timestamp 2015-03-27T14:47:33.371Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376896145
barcode_type UPC
col1 Naples yellow hue
col1_sortorder 3906
col2 37 ml
col2_sortorder 1711
col3 422
col3_sortorder 625
color_swatch 248-194-111.jpg
cost 3.62
deal_of_the_week NO
description Naples yellow hue, 37 ml, 422
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 29510
list_price 8.49
map YES
mfr_num 1514422
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 29510
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 29510
2 1514422
3 Naples yellow hue, 37 ml, 422
timestamp 2015-03-27T14:46:53.45Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376896138
barcode_type UPC
col1 olive green
col1_sortorder 4164
col2 37 ml
col2_sortorder 1711
col3 447
col3_sortorder 646
color_swatch 75-71-45.jpg
cost 3.62
deal_of_the_week NO
description olive green, 37 ml, 447
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 72128
list_price 8.49
map YES
mfr_num 1514447
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 72128
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 72128
2 1514447
3 olive green, 37 ml, 447
timestamp 2015-03-27T14:48:01.189Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376896213
barcode_type UPC
col1 payne's gray
col1_sortorder 4418
col2 37 ml
col2_sortorder 1711
col3 465
col3_sortorder 659
color_swatch 42-56-59.jpg
cost 3.62
deal_of_the_week NO
description payne's gray, 37 ml, 465
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 23705
list_price 8.49
map YES
mfr_num 1514465
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 23705
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 23705
2 1514465
3 payne's gray, 37 ml, 465
timestamp 2015-03-27T14:46:44.973Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376895995
barcode_type UPC
col1 permanent alizarin crimson
col1_sortorder 4539
col2 37 ml
col2_sortorder 1711
col3 468
col3_sortorder 661
color_swatch 206-30-62.jpg
cost 3.62
deal_of_the_week NO
description permanent alizarin crimson, 37 ml, 468
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 41526
list_price 8.49
map YES
mfr_num 1514468
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 41526
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 41526
2 1514468
3 permanent alizarin crimson, 37 ml, 468
timestamp 2015-03-27T14:47:13.727Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376895988
barcode_type UPC
col1 permanent rose
col1_sortorder 4595
col2 37 ml
col2_sortorder 1711
col3 502
col3_sortorder 678
color_swatch 228-24-95.jpg
cost 3.62
deal_of_the_week NO
description permanent rose, 37 ml, 502
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 21943
list_price 8.49
map YES
mfr_num 1514502
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 21943
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 21943
2 1514502
3 permanent rose, 37 ml, 502
timestamp 2015-03-27T14:46:42.747Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376896121
barcode_type UPC
col1 permanent sap green
col1_sortorder 4596
col2 37 ml
col2_sortorder 1711
col3 503
col3_sortorder 679
color_swatch 78-122-65.jpg
cost 7.69
deal_of_the_week NO
description permanent sap green, 37 ml, 503
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 80364
list_price 17.99
map YES
mfr_num 1514503
net_weight 0.12
non_member_discount 40
non_member_price 10.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 80364
sku_pix YES
supplier_id 1
ta_dealer_a_price 9
ta_dealer_c_price 8.46
ta_price 11.69
text
array
1 80364
2 1514503
3 permanent sap green, 37 ml, 503
timestamp 2015-03-27T14:48:10.537Z
vip_member_price 9.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376896077
barcode_type UPC
col1 phthalo blue (red shade)
col1_sortorder 4655
col2 37 ml
col2_sortorder 1711
col3 514
col3_sortorder 703
color_swatch 28-56-85.jpg
cost 3.62
deal_of_the_week NO
description phthalo blue (red shade), 37 ml, 514
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 28559
list_price 8.49
map YES
mfr_num 1514514
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 28559
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 28559
2 1514514
3 phthalo blue (red shade), 37 ml, 514
timestamp 2015-03-27T14:46:52.208Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030a9a99d68382fb6bf1f62383f67745e14
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=books-media&CatC=sort~1~&gr=dover-perspective-made-easy.html
urltoken CFID=30074331&CFTOKEN=77626401&jsessionid=e030a9a99d68382fb6bf1f62383f67745e14
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 21:36:53'}
sessionid e030162c591f67e574303f761d3a11221f41
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html
urltoken CFID=30074332&CFTOKEN=20076130&jsessionid=e030162c591f67e574303f761d3a11221f41
validationerror [empty string]


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

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

ItemIDList: 72732
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376896114
barcode_type UPC
col1 phthalo green (blue shade)
col1_sortorder 4672
col2 37 ml
col2_sortorder 1711
col3 522
col3_sortorder 712
color_swatch 6-136-75.jpg
cost 3.62
deal_of_the_week NO
description phthalo green (blue shade), 37 ml, 522
group_id 813
group_uname winsor-newton-artisan-water-mixable-oil-colours
id 72759
list_price 8.49
map YES
mfr_num 1514522
net_weight 0.12
non_member_discount 40
non_member_price 5.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 72759
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.25
ta_dealer_c_price 3.99
ta_price 5.52
text
array
1 72759
2 1514522
3 phthalo green (blue shade), 37 ml, 522
timestamp 2015-03-27T14:48:02.844Z
vip_member_price 4.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 72732
CACHED false
EXECUTIONTIME 2
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] = '3054' 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.145.130.116

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=fp~6-17~&gr=winsor-newton-artisan-water-mixable-oil-colours.html

StartSessionVariables: