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

Basics Matt Acrylic Colors

by Liquitex


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933130
barcode_type UPC
col1 acra magenta
col1_sortorder 53
col2 [empty string]
col3 [empty string]
color_swatch 114-17-61.jpg
cost 2
deal_of_the_week NO
description acra magenta
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 68954
list_price 4.69
map NO
mfr_num 1075114
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 68954
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 68954
2 1075114
3 acra magenta
timestamp 2015-03-31T17:54:15.436Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933147
barcode_type UPC
col1 alizarin crimson
col1_sortorder 81
col2 [empty string]
col3 [empty string]
color_swatch 115-64-67.jpg
cost 2
deal_of_the_week NO
description alizarin crimson
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 32124
list_price 4.69
map NO
mfr_num 1075116
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 32124
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 32124
2 1075116
3 alizarin crimson
timestamp 2015-03-31T17:53:10.63Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933154
barcode_type UPC
col1 bright aqua green
col1_sortorder 688
col2 [empty string]
col3 [empty string]
color_swatch 0-176-154.jpg
cost 2
deal_of_the_week NO
description bright aqua green
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 12144
list_price 4.69
map NO
mfr_num 1075660
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 12144
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 12144
2 1075660
3 bright aqua green
timestamp 2015-03-31T17:52:38.555Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933161
barcode_type UPC
col1 burnt sienna
col1_sortorder 876
col2 [empty string]
col3 [empty string]
color_swatch 114-57-5.jpg
cost 2
deal_of_the_week NO
description burnt sienna
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 78915
list_price 4.69
map NO
mfr_num 1075127
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 78915
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 78915
2 1075127
3 burnt sienna
timestamp 2015-03-31T17:54:31.78Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933178
barcode_type UPC
col1 burnt umber
col1_sortorder 887
col2 [empty string]
col3 [empty string]
color_swatch 84-44-49.jpg
cost 2
deal_of_the_week NO
description burnt umber
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 14709
list_price 4.69
map NO
mfr_num 1075128
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 14709
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 14709
2 1075128
3 burnt umber
timestamp 2015-03-31T17:52:44.035Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933185
barcode_type UPC
col1 cadmium orange hue
col1_sortorder 948
col2 [empty string]
col3 [empty string]
color_swatch 248-153-27.jpg
cost 2
deal_of_the_week NO
description cadmium orange hue
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 37028
list_price 4.69
map NO
mfr_num 1075720
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 37028
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 37028
2 1075720
3 cadmium orange hue
timestamp 2015-03-31T17:53:20.08Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933192
barcode_type UPC
col1 cadmium red deep hue
col1_sortorder 962
col2 [empty string]
col3 [empty string]
color_swatch 144-0-38.jpg
cost 2
deal_of_the_week NO
description cadmium red deep hue
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 84745
list_price 4.69
map NO
mfr_num 1075311
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 84745
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 84745
2 1075311
3 cadmium red deep hue
timestamp 2015-03-31T17:54:38.448Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933208
barcode_type UPC
col1 cadmium red light hue
col1_sortorder 974
col2 [empty string]
col3 [empty string]
color_swatch 241-93-46.jpg
cost 2
deal_of_the_week NO
description cadmium red light hue
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 38399
list_price 4.69
map NO
mfr_num 1075510
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 38399
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 38399
2 1075510
3 cadmium red light hue
timestamp 2015-03-31T17:53:22.039Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933215
barcode_type UPC
col1 cadmium red medium hue
col1_sortorder 982
col2 [empty string]
col3 [empty string]
color_swatch 214-53-70.jpg
cost 2
deal_of_the_week NO
description cadmium red medium hue
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 34143
list_price 4.69
map NO
mfr_num 1075151
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 34143
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 34143
2 1075151
3 cadmium red medium hue
timestamp 2015-03-31T17:53:15.942Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933451
barcode_type UPC
col1 cadmium yellow deep hue
col1_sortorder 1004
col2 [empty string]
col3 [empty string]
color_swatch 253-179-21.jpg
cost 2
deal_of_the_week NO
description cadmium yellow deep hue
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 44685
list_price 4.69
map NO
mfr_num 1075163
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 44685
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 44685
2 1075163
3 cadmium yellow deep hue
timestamp 2015-03-31T17:53:30.122Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933222
barcode_type UPC
col1 cadmium yellow light hue
col1_sortorder 1015
col2 [empty string]
col3 [empty string]
color_swatch 255-237-0.jpg
cost 2
deal_of_the_week NO
description cadmium yellow light hue
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 57773
list_price 4.69
map NO
mfr_num 1075160
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 57773
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 57773
2 1075160
3 cadmium yellow light hue
timestamp 2015-03-31T17:53:51.614Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933239
barcode_type UPC
col1 cadmium yellow medium hue
col1_sortorder 1023
col2 [empty string]
col3 [empty string]
color_swatch 255-223-25.jpg
cost 2
deal_of_the_week NO
description cadmium yellow medium hue
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 50588
list_price 4.69
map NO
mfr_num 1075161
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 50588
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 50588
2 1075161
3 cadmium yellow medium hue
timestamp 2015-03-31T17:53:37.222Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933246
barcode_type UPC
col1 cerulean blue hue
col1_sortorder 1164
col2 [empty string]
col3 [empty string]
color_swatch 0-122-182.jpg
cost 2
deal_of_the_week NO
description cerulean blue hue
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 33446
list_price 4.69
map NO
mfr_num 1075470
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 33446
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 33446
2 1075470
3 cerulean blue hue
timestamp 2015-03-31T17:53:14.855Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933253
barcode_type UPC
col1 cobalt blue hue
col1_sortorder 1358
col2 [empty string]
col3 [empty string]
color_swatch 0-95-169.jpg
cost 2
deal_of_the_week NO
description cobalt blue hue
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 81920
list_price 4.69
map NO
mfr_num 1075170
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 81920
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 81920
2 1075170
3 cobalt blue hue
timestamp 2015-03-31T17:54:35.268Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933260
barcode_type UPC
col1 deep green permanent
col1_sortorder 1819
col2 [empty string]
col3 [empty string]
color_swatch 0-89-64.jpg
cost 2
deal_of_the_week NO
description deep green permanent
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 46682
list_price 4.69
map NO
mfr_num 1075350
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 46682
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 46682
2 1075350
3 deep green permanent
timestamp 2015-03-31T17:53:32.062Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933277
barcode_type UPC
col1 deep violet
col1_sortorder 1843
col2 [empty string]
col3 [empty string]
color_swatch 70-21-55.jpg
cost 2
deal_of_the_week NO
description deep violet
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 72171
list_price 4.69
map NO
mfr_num 1075115
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 72171
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 72171
2 1075115
3 deep violet
timestamp 2015-03-31T17:54:22.491Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933284
barcode_type UPC
col1 dioxazine purple
col1_sortorder 1910
col2 [empty string]
col3 [empty string]
color_swatch 22-30-104.jpg
cost 2
deal_of_the_week NO
description dioxazine purple
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 44211
list_price 4.69
map NO
mfr_num 1075186
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 44211
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 44211
2 1075186
3 dioxazine purple
timestamp 2015-03-31T17:53:29.466Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933291
barcode_type UPC
col1 gold
col1_sortorder 2491
col2 [empty string]
col3 [empty string]
color_swatch 193-151-8.jpg
cost 2
deal_of_the_week NO
description gold
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 66265
list_price 4.69
map NO
mfr_num 1075234
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 66265
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 66265
2 1075234
3 gold
timestamp 2015-03-31T17:54:10.447Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933499
barcode_type UPC
col1 hookers green hue permanent
col1_sortorder 2861
col2 [empty string]
col3 [empty string]
color_swatch 0-70-26.jpg
cost 2
deal_of_the_week NO
description hookers green hue permanent
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 76488
list_price 4.69
map NO
mfr_num 1075224
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 76488
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 76488
2 1075224
3 hookers green hue permanent
timestamp 2015-03-31T17:54:28.884Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933307
barcode_type UPC
col1 ivory black
col1_sortorder 3126
col2 [empty string]
col3 [empty string]
color_swatch 24-7-17.jpg
cost 2
deal_of_the_week NO
description ivory black
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 77365
list_price 4.69
map NO
mfr_num 1075244
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 77365
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 77365
2 1075244
3 ivory black
timestamp 2015-03-31T17:54:29.76Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933314
barcode_type UPC
col1 light green permanent
col1_sortorder 3363
col2 [empty string]
col3 [empty string]
color_swatch 0-157-87.jpg
cost 2
deal_of_the_week NO
description light green permanent
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 81378
list_price 4.69
map NO
mfr_num 1075312
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 81378
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 81378
2 1075312
3 light green permanent
timestamp 2015-03-31T17:54:34.577Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933321
barcode_type UPC
col1 mars black
col1_sortorder 3610
col2 [empty string]
col3 [empty string]
color_swatch 32-7-17.jpg
cost 2
deal_of_the_week NO
description mars black
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 12312
list_price 4.69
map NO
mfr_num 1075276
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 12312
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 12312
2 1075276
3 mars black
timestamp 2015-03-31T17:52:38.763Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933468
barcode_type UPC
col1 naphthol crimson
col1_sortorder 3901
col2 [empty string]
col3 [empty string]
color_swatch 190-46-55.jpg
cost 2
deal_of_the_week NO
description naphthol crimson
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 75951
list_price 4.69
map NO
mfr_num 1075292
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 75951
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 75951
2 1075292
3 naphthol crimson
timestamp 2015-03-31T17:54:28.137Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933338
barcode_type UPC
col1 neutral grey 5
col1_sortorder 4052
col2 [empty string]
col3 [empty string]
color_swatch 145-145-148.jpg
cost 2
deal_of_the_week NO
description neutral grey 5
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 15788
list_price 4.69
map NO
mfr_num 1075599
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 15788
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 15788
2 1075599
3 neutral grey 5
timestamp 2015-03-31T17:52:46.932Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933345
barcode_type UPC
col1 phthalo blue
col1_sortorder 4660
col2 [empty string]
col3 [empty string]
color_swatch 0-26-88.jpg
cost 2
deal_of_the_week NO
description phthalo blue
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 69730
list_price 4.69
map NO
mfr_num 1075316
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 69730
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 69730
2 1075316
3 phthalo blue
timestamp 2015-03-31T17:54:17.274Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933352
barcode_type UPC
col1 phthalo green
col1_sortorder 4679
col2 [empty string]
col3 [empty string]
color_swatch 0-71-57.jpg
cost 2
deal_of_the_week NO
description phthalo green
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 70400
list_price 4.69
map NO
mfr_num 1075317
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 70400
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 70400
2 1075317
3 phthalo green
timestamp 2015-03-31T17:54:18.388Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933444
barcode_type UPC
col1 primary blue
col1_sortorder 4863
col2 [empty string]
col3 [empty string]
color_swatch 0-83-148.jpg
cost 2
deal_of_the_week NO
description primary blue
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 59357
list_price 4.69
map NO
mfr_num 1075420
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 59357
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 59357
2 1075420
3 primary blue
timestamp 2015-03-31T17:53:53.308Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933437
barcode_type UPC
col1 primary red
col1_sortorder 4875
col2 [empty string]
col3 [empty string]
color_swatch 215-19-63.jpg
cost 2
deal_of_the_week NO
description primary red
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 24036
list_price 4.69
map NO
mfr_num 1075415
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 24036
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 24036
2 1075415
3 primary red
timestamp 2015-03-31T17:52:59.696Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933420
barcode_type UPC
col1 primary yellow
col1_sortorder 4878
col2 [empty string]
col3 [empty string]
color_swatch 248-229-0.jpg
cost 2
deal_of_the_week NO
description primary yellow
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 57858
list_price 4.69
map NO
mfr_num 1075410
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 57858
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 57858
2 1075410
3 primary yellow
timestamp 2015-03-31T17:53:51.67Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~winsor-newton~fp~7-9999.99~&gr=winsor-newton-series-7-kolinsky-sable-pointed-round-brushes.html
urltoken CFID=30667234&CFTOKEN=99076834&jsessionid=e03079fecb19f754df7af703a3df522a2e4b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e0303561652362d38745521b7f5f4275cb3e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html
urltoken CFID=30667235&CFTOKEN=78097016&jsessionid=e0303561652362d38745521b7f5f4275cb3e
validationerror [empty string]


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

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

ItemIDList: 18809,24754,25178,40380,42760,48027,57120,80416,81938,83362,86549
AvailQtyList: 14.000000000000,7.000000000000,60.000000000000,3.000000000000,54.000000000000,40.000000000000,63.000000000000,4.000000000000,28.000000000000,63.000000000000,10.000000000000

struct
FLAGS 0
VIP_member_discount 35
barcode 094376933369
barcode_type UPC
col1 raw sienna
col1_sortorder 5061
col2 [empty string]
col3 [empty string]
color_swatch 177-121-10.jpg
cost 2
deal_of_the_week NO
description raw sienna
group_id 7793
group_uname liquitex-basics-matt-acrylic-colors
id 50241
list_price 4.69
map NO
mfr_num 1075330
net_weight 0.2
non_member_discount 25
non_member_price 3.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 50241
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.28
text
array
1 50241
2 1075330
3 raw sienna
timestamp 2015-03-31T17:53:36.996Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 18809
2 7.000000000000 24754
3 60.000000000000 25178
4 3.000000000000 40380
5 54.000000000000 42760
6 40.000000000000 48027
7 63.000000000000 57120
8 4.000000000000 80416
9 28.000000000000 81938
10 63.000000000000 83362
11 10.000000000000 86549
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] = '1304' 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.80.69.152

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=liquitex-basics-matt-acrylic-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 01:19:55'}
sessionid e03079fecb19f754df7af703a3df522a2e4b
stformdata