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

Free-Style Detail Brushes

by Liquitex


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976113
barcode_type UPC
col1 10
col1_sortorder 692
col2 round
col2_sortorder 434
col3 [empty string]
cost 7.17
deal_of_the_week NO
description 10, round
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97504
list_price 25.29
map NO
mfr_num 1300110
net_weight 0.08
non_member_discount 51
non_member_price 12.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 97504
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.6
ta_dealer_c_price 7.59
ta_price 16.44
text
array
1 97504
2 1300110
3 10, round
timestamp 2015-03-31T17:54:53.502Z
vip_member_price 9.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976175
barcode_type UPC
col1 10
col1_sortorder 692
col2 bright
col2_sortorder 112
col3 [empty string]
cost 7.17
deal_of_the_week NO
description 10, bright
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97510
list_price 25.29
map NO
mfr_num 1300210
net_weight 0.08
non_member_discount 51
non_member_price 12.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 97510
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.6
ta_dealer_c_price 7.59
ta_price 16.44
text
array
1 97510
2 1300210
3 10, bright
timestamp 2015-03-31T17:54:53.523Z
vip_member_price 9.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976236
barcode_type UPC
col1 10
col1_sortorder 692
col2 flat
col2_sortorder 209
col3 [empty string]
cost 7.17
deal_of_the_week NO
description 10, flat
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97516
list_price 25.29
map NO
mfr_num 1300310
net_weight 0.08
non_member_discount 51
non_member_price 12.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 97516
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.6
ta_dealer_c_price 7.59
ta_price 16.44
text
array
1 97516
2 1300310
3 10, flat
timestamp 2015-03-31T17:54:53.543Z
vip_member_price 9.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976298
barcode_type UPC
col1 10
col1_sortorder 692
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 7.17
deal_of_the_week NO
description 10, filbert
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97522
list_price 25.29
map NO
mfr_num 1300410
net_weight 0.08
non_member_discount 51
non_member_price 12.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 97522
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.6
ta_dealer_c_price 7.59
ta_price 16.44
text
array
1 97522
2 1300410
3 10, filbert
timestamp 2015-03-31T17:54:53.566Z
vip_member_price 9.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976120
barcode_type UPC
col1 12
col1_sortorder 816
col2 round
col2_sortorder 434
col3 [empty string]
cost 7.17
deal_of_the_week NO
description 12, round
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97505
list_price 25.29
map NO
mfr_num 1300112
net_weight 0.09
non_member_discount 51
non_member_price 12.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 97505
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.6
ta_dealer_c_price 7.59
ta_price 16.44
text
array
1 97505
2 1300112
3 12, round
timestamp 2015-03-31T17:54:53.504Z
vip_member_price 9.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976182
barcode_type UPC
col1 12
col1_sortorder 816
col2 bright
col2_sortorder 112
col3 [empty string]
cost 7.17
deal_of_the_week NO
description 12, bright
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97511
list_price 25.29
map NO
mfr_num 1300212
net_weight 0.11
non_member_discount 51
non_member_price 12.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 97511
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.6
ta_dealer_c_price 7.59
ta_price 16.44
text
array
1 97511
2 1300212
3 12, bright
timestamp 2015-03-31T17:54:53.525Z
vip_member_price 9.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976243
barcode_type UPC
col1 12
col1_sortorder 816
col2 flat
col2_sortorder 209
col3 [empty string]
cost 7.17
deal_of_the_week NO
description 12, flat
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97517
list_price 25.29
map NO
mfr_num 1300312
net_weight 0.11
non_member_discount 51
non_member_price 12.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 97517
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.6
ta_dealer_c_price 7.59
ta_price 16.44
text
array
1 97517
2 1300312
3 12, flat
timestamp 2015-03-31T17:54:53.545Z
vip_member_price 9.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976304
barcode_type UPC
col1 12
col1_sortorder 816
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 7.17
deal_of_the_week NO
description 12, filbert
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97523
list_price 25.29
map NO
mfr_num 1300412
net_weight 0.11
non_member_discount 51
non_member_price 12.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 97523
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.6
ta_dealer_c_price 7.59
ta_price 16.44
text
array
1 97523
2 1300412
3 12, filbert
timestamp 2015-03-31T17:54:53.568Z
vip_member_price 9.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976076
barcode_type UPC
col1 2
col1_sortorder 1114
col2 round
col2_sortorder 434
col3 [empty string]
cost 3.75
deal_of_the_week NO
description 2, round
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97500
list_price 13.19
map NO
mfr_num 1300102
net_weight 0.02
non_member_discount 51
non_member_price 6.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 97500
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.48
ta_dealer_c_price 3.96
ta_price 8.57
text
array
1 97500
2 1300102
3 2, round
timestamp 2015-03-31T17:54:53.487Z
vip_member_price 5.14

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976137
barcode_type UPC
col1 2
col1_sortorder 1114
col2 bright
col2_sortorder 112
col3 [empty string]
cost 3.75
deal_of_the_week NO
description 2, bright
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97506
list_price 13.19
map NO
mfr_num 1300202
net_weight 0.02
non_member_discount 51
non_member_price 6.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 97506
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.48
ta_dealer_c_price 3.96
ta_price 8.57
text
array
1 97506
2 1300202
3 2, bright
timestamp 2015-03-31T17:54:53.508Z
vip_member_price 5.14

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976199
barcode_type UPC
col1 2
col1_sortorder 1114
col2 flat
col2_sortorder 209
col3 [empty string]
cost 3.75
deal_of_the_week NO
description 2, flat
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97512
list_price 13.19
map NO
mfr_num 1300302
net_weight 0.02
non_member_discount 51
non_member_price 6.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 97512
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.48
ta_dealer_c_price 3.96
ta_price 8.57
text
array
1 97512
2 1300302
3 2, flat
timestamp 2015-03-31T17:54:53.529Z
vip_member_price 5.14

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976250
barcode_type UPC
col1 2
col1_sortorder 1114
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 3.75
deal_of_the_week NO
description 2, filbert
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97518
list_price 13.19
map NO
mfr_num 1300402
net_weight 0.02
non_member_discount 51
non_member_price 6.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 97518
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.48
ta_dealer_c_price 3.96
ta_price 8.57
text
array
1 97518
2 1300402
3 2, filbert
timestamp 2015-03-31T17:54:53.549Z
vip_member_price 5.14

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976083
barcode_type UPC
col1 4
col1_sortorder 1724
col2 round
col2_sortorder 434
col3 [empty string]
cost 3.75
deal_of_the_week NO
description 4, round
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97501
list_price 13.19
map NO
mfr_num 1300104
net_weight 0.03
non_member_discount 51
non_member_price 6.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 97501
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.48
ta_dealer_c_price 3.96
ta_price 8.57
text
array
1 97501
2 1300104
3 4, round
timestamp 2015-03-31T17:54:53.491Z
vip_member_price 5.14

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976144
barcode_type UPC
col1 4
col1_sortorder 1724
col2 bright
col2_sortorder 112
col3 [empty string]
cost 3.75
deal_of_the_week NO
description 4, bright
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97507
list_price 13.19
map NO
mfr_num 1300204
net_weight 0.03
non_member_discount 51
non_member_price 6.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 97507
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.48
ta_dealer_c_price 3.96
ta_price 8.57
text
array
1 97507
2 1300204
3 4, bright
timestamp 2015-03-31T17:54:53.512Z
vip_member_price 5.14

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976205
barcode_type UPC
col1 4
col1_sortorder 1724
col2 flat
col2_sortorder 209
col3 [empty string]
cost 3.75
deal_of_the_week NO
description 4, flat
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97513
list_price 13.19
map NO
mfr_num 1300304
net_weight 0.03
non_member_discount 51
non_member_price 6.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 97513
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.48
ta_dealer_c_price 3.96
ta_price 8.57
text
array
1 97513
2 1300304
3 4, flat
timestamp 2015-03-31T17:54:53.534Z
vip_member_price 5.14

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976267
barcode_type UPC
col1 4
col1_sortorder 1724
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 3.75
deal_of_the_week NO
description 4, filbert
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97519
list_price 13.19
map NO
mfr_num 1300404
net_weight 0.03
non_member_discount 51
non_member_price 6.46
prop65 NO
ship_rule_desc STD
shipping STD
sku 97519
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.48
ta_dealer_c_price 3.96
ta_price 8.57
text
array
1 97519
2 1300404
3 4, filbert
timestamp 2015-03-31T17:54:53.555Z
vip_member_price 5.14

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976090
barcode_type UPC
col1 6
col1_sortorder 2077
col2 round
col2_sortorder 434
col3 [empty string]
cost 4.99
deal_of_the_week NO
description 6, round
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97502
list_price 17.59
map NO
mfr_num 1300106
net_weight 0.05
non_member_discount 51
non_member_price 8.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 97502
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.98
ta_dealer_c_price 5.28
ta_price 11.43
text
array
1 97502
2 1300106
3 6, round
timestamp 2015-03-31T17:54:53.497Z
vip_member_price 6.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976151
barcode_type UPC
col1 6
col1_sortorder 2077
col2 bright
col2_sortorder 112
col3 [empty string]
cost 4.99
deal_of_the_week NO
description 6, bright
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97508
list_price 17.59
map NO
mfr_num 1300206
net_weight 0.03
non_member_discount 51
non_member_price 8.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 97508
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.98
ta_dealer_c_price 5.28
ta_price 11.43
text
array
1 97508
2 1300206
3 6, bright
timestamp 2015-03-31T17:54:53.519Z
vip_member_price 6.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976212
barcode_type UPC
col1 6
col1_sortorder 2077
col2 flat
col2_sortorder 209
col3 [empty string]
cost 4.99
deal_of_the_week NO
description 6, flat
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97514
list_price 17.59
map NO
mfr_num 1300306
net_weight 0.04
non_member_discount 51
non_member_price 8.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 97514
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.98
ta_dealer_c_price 5.28
ta_price 11.43
text
array
1 97514
2 1300306
3 6, flat
timestamp 2015-03-31T17:54:53.539Z
vip_member_price 6.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976274
barcode_type UPC
col1 6
col1_sortorder 2077
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 4.99
deal_of_the_week NO
description 6, filbert
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97520
list_price 17.59
map NO
mfr_num 1300406
net_weight 0.04
non_member_discount 51
non_member_price 8.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 97520
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.98
ta_dealer_c_price 5.28
ta_price 11.43
text
array
1 97520
2 1300406
3 6, filbert
timestamp 2015-03-31T17:54:53.56Z
vip_member_price 6.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976106
barcode_type UPC
col1 8
col1_sortorder 2250
col2 round
col2_sortorder 434
col3 [empty string]
cost 4.99
deal_of_the_week NO
description 8, round
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97503
list_price 17.59
map NO
mfr_num 1300108
net_weight 0.06
non_member_discount 51
non_member_price 8.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 97503
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.98
ta_dealer_c_price 5.28
ta_price 11.43
text
array
1 97503
2 1300108
3 8, round
timestamp 2015-03-31T17:54:53.5Z
vip_member_price 6.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976168
barcode_type UPC
col1 8
col1_sortorder 2250
col2 bright
col2_sortorder 112
col3 [empty string]
cost 4.99
deal_of_the_week NO
description 8, bright
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97509
list_price 17.59
map NO
mfr_num 1300208
net_weight 0.05
non_member_discount 51
non_member_price 8.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 97509
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.98
ta_dealer_c_price 5.28
ta_price 11.43
text
array
1 97509
2 1300208
3 8, bright
timestamp 2015-03-31T17:54:53.521Z
vip_member_price 6.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976229
barcode_type UPC
col1 8
col1_sortorder 2250
col2 flat
col2_sortorder 209
col3 [empty string]
cost 4.99
deal_of_the_week NO
description 8, flat
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97515
list_price 17.59
map NO
mfr_num 1300308
net_weight 0.04
non_member_discount 51
non_member_price 8.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 97515
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.98
ta_dealer_c_price 5.28
ta_price 11.43
text
array
1 97515
2 1300308
3 8, flat
timestamp 2015-03-31T17:54:53.541Z
vip_member_price 6.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


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

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

ItemIDList: 26131,26131-PK,30211,32102,32102-PK,52729,52729-PK,56540,56540-PK,57583,57583-PK,71050,71050-PK
AvailQtyList: 401.000000000000,33.000000000000,653.000000000000,98.000000000000,8.000000000000,194.000000000000,16.000000000000,1767.000000000000,147.000000000000,1795.000000000000,149.000000000000,1304.000000000000,108.000000000000

struct
FLAGS 0
VIP_member_discount 61
barcode 094376976281
barcode_type UPC
col1 8
col1_sortorder 2250
col2 filbert
col2_sortorder 202
col3 [empty string]
cost 4.99
deal_of_the_week NO
description 8, filbert
group_id 10184
group_uname liquitex-free-style-detail-brushes
id 97521
list_price 17.59
map NO
mfr_num 1300408
net_weight 0.05
non_member_discount 51
non_member_price 8.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 97521
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.98
ta_dealer_c_price 5.28
ta_price 11.43
text
array
1 97521
2 1300408
3 8, filbert
timestamp 2015-03-31T17:54:53.564Z
vip_member_price 6.86

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 401.000000000000 26131
2 33.000000000000 26131-PK
3 653.000000000000 30211
4 98.000000000000 32102
5 8.000000000000 32102-PK
6 194.000000000000 52729
7 16.000000000000 52729-PK
8 1767.000000000000 56540
9 147.000000000000 56540-PK
10 1795.000000000000 57583
11 149.000000000000 57583-PK
12 1304.000000000000 71050
13 108.000000000000 71050-PK
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] = '1129' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.215.139

URL: www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0301e9e43175084f60c65262277552a7654
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=all-surface&gr=stabilo-all-pencil.html
urltoken CFID=30567660&CFTOKEN=90962319&jsessionid=e0301e9e43175084f60c65262277552a7654
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:37:38'}
sessionid e0307f214f01a6a2d15104a842834643d7a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=acrylic-brushes&gr=liquitex-free-style-detail-brushes.html
urltoken CFID=30567661&CFTOKEN=43975515&jsessionid=e0307f214f01a6a2d15104a842834643d7a6
validationerror [empty string]


These brushes are ideal for acrylics, but can also be used with water mixable oils. Free-Style Detail Brushes are made from blended synthetic, and stand up well to texture gels and mediums. They have ideal stiffness, snap, and shape retention for control.

Their long handles are contoured with a satin matte finish for comfort, and designed with a stainless steel rust proof ferrule. Each brush is conveniently printed with the size on the handle for easy identification. Available in Round, Bright, Flat, and Filbert shapes.

Share on Facebook Twitter Pinterest

Ask a question about Free-Style Detail Brushes Ask a question about this product

Free-Style Detail Brushes

by Liquitex









  Item# Image size
Ascending
shape Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
97504
Free-Style Detail Brushes 10 round
Zoom Image
10 round 1300110 $25.29 $12.39 51% Off $9.86 61% Off Email When In Stock
Add to Favorites
97510
Free-Style Detail Brushes 10 bright
Zoom Image
10 bright 1300210 $25.29 $12.39 51% Off $9.86 61% Off Email When In Stock
Add to Favorites
97516
Free-Style Detail Brushes 10 flat
Zoom Image
10 flat 1300310 $25.29 $12.39 51% Off $9.86 61% Off Email When In Stock
Add to Favorites
97522
Free-Style Detail Brushes 10 filbert
Zoom Image
10 filbert 1300410 $25.29 $12.39 51% Off $9.86 61% Off Email When In Stock
Add to Favorites
97505
Free-Style Detail Brushes 12 round
Zoom Image
12 round 1300112 $25.29 $12.39 51% Off $9.86 61% Off Email When In Stock
Add to Favorites
97511
Free-Style Detail Brushes 12 bright
Zoom Image
12 bright 1300212 $25.29 $12.39 51% Off $9.86 61% Off Email When In Stock
Add to Favorites
97517
Free-Style Detail Brushes 12 flat
Zoom Image
12 flat 1300312 $25.29 $12.39 51% Off $9.86 61% Off Email When In Stock
Add to Favorites
97523
Free-Style Detail Brushes 12 filbert
Zoom Image
12 filbert 1300412 $25.29 $12.39 51% Off $9.86 61% Off Email When In Stock
Add to Favorites
97500
Free-Style Detail Brushes 2 round
Zoom Image
2 round 1300102 $13.19 $6.46 51% Off $5.14 61% Off Email When In Stock
Add to Favorites
97506
Free-Style Detail Brushes 2 bright
Zoom Image
2 bright 1300202 $13.19 $6.46 51% Off $5.14 61% Off Email When In Stock
Add to Favorites
97512
Free-Style Detail Brushes 2 flat
Zoom Image
2 flat 1300302 $13.19 $6.46 51% Off $5.14 61% Off Email When In Stock
Add to Favorites
97518
Free-Style Detail Brushes 2 filbert
Zoom Image
2 filbert 1300402 $13.19 $6.46 51% Off $5.14 61% Off Email When In Stock
Add to Favorites
97501
Free-Style Detail Brushes 4 round
Zoom Image
4 round 1300104 $13.19 $6.46 51% Off $5.14 61% Off Email When In Stock
Add to Favorites
97507
Free-Style Detail Brushes 4 bright
Zoom Image
4 bright 1300204 $13.19 $6.46 51% Off $5.14 61% Off Email When In Stock
Add to Favorites
97513
Free-Style Detail Brushes 4 flat
Zoom Image
4 flat 1300304 $13.19 $6.46 51% Off $5.14 61% Off Email When In Stock
Add to Favorites
97519
Free-Style Detail Brushes 4 filbert
Zoom Image
4 filbert 1300404 $13.19 $6.46 51% Off $5.14 61% Off Email When In Stock
Add to Favorites
97502
Free-Style Detail Brushes 6 round
Zoom Image
6 round 1300106 $17.59 $8.62 51% Off $6.86 61% Off Email When In Stock
Add to Favorites
97508
Free-Style Detail Brushes 6 bright
Zoom Image
6 bright 1300206 $17.59 $8.62 51% Off $6.86 61% Off Email When In Stock
Add to Favorites
97514
Free-Style Detail Brushes 6 flat
Zoom Image
6 flat 1300306 $17.59 $8.62 51% Off $6.86 61% Off Email When In Stock
Add to Favorites
97520
Free-Style Detail Brushes 6 filbert
Zoom Image
6 filbert 1300406 $17.59 $8.62 51% Off $6.86 61% Off Email When In Stock
Add to Favorites
97503
Free-Style Detail Brushes 8 round
Zoom Image
8 round 1300108 $17.59 $8.62 51% Off $6.86 61% Off Email When In Stock
Add to Favorites
97509
Free-Style Detail Brushes 8 bright
Zoom Image
8 bright 1300208 $17.59 $8.62 51% Off $6.86 61% Off Email When In Stock
Add to Favorites
97515
Free-Style Detail Brushes 8 flat
Zoom Image
8 flat 1300308 $17.59 $8.62 51% Off $6.86 61% Off Email When In Stock
Add to Favorites
97521
Free-Style Detail Brushes 8 filbert
Zoom Image
8 filbert 1300408 $17.59 $8.62 51% Off $6.86 61% Off Email When In Stock

Click the to add item to your Favorites.



Please wait...
You May Also Like...

Alabama Primed Cotton Canvas Rolls

by Fredrix

Quality universal media canvas

Up to 50% Off

Red Label Stretched Cotton Canvas

by Fredrix

Medium texture pre-stretched canvas is an artist favorite

Up to 65% Off

From $2.99

How to get VIP Club Prices
Anyone can be a VIP Member with:
  • Additional savings on all products
  • Express order handling
  • Exclusive promotions
  • Priority customer service
Only $25/year

Learn More »

Ask a Question About Free-Style Detail Brushes

Your email will not be shared. We will only use your email address to respond to your question. When asking your question, please be as descriptive as possible, it will allow us to give you the most accurate answer possible.

Write a Product Review for Free-Style Detail Brushes

Add Your Review

Tell us what you think. We appreciate you taking the time to share your opinion with other artists and crafters. Please keep your review detailed and specific.

Product reviews are intended to be a resource for artists interested in product quality and use. MisterArt.com reserves the right not to post any product review or to remove any published product review at any time without notice. Published reviews must conform to MisterArt.com guidelines. Your review may be posted on this page within five to ten business days.

Tips on Writing Reviews
Rating Scale
  • (5-Star) Excellent
  • (4-Star) Good
  • (3-Star) Average
  • (2-Star) Fair
  • (1-Star) Poor
Do:
  • Give your perspective on how you used the product and why you liked or disliked it.
  • Keep your reviews short enough to hold the audience's attention.
  • Be honest and mindful of others when providing editorial commentary.
Don't:
  • Include phone numbers, addresses, URLs, or HTML tags.
  • Write profanity, obscenities, vulgarities, or spiteful comments.
  • Make defamatory comments.
Please wait...
Please wait...