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

Painting Knives

by Liquitex


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974270
barcode_type UPC
col1 large
col1_sortorder 2496
col2 18
col2_sortorder 67
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 18
group_id 9410
group_uname liquitex-painting-knives
id 10167
list_price 13.19
map NO
mfr_num 109918
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 10167
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 10167
2 109918
3 large, 18
timestamp 2015-03-27T14:46:24.185Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974201
barcode_type UPC
col1 large
col1_sortorder 2496
col2 11
col2_sortorder 59
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 11
group_id 9410
group_uname liquitex-painting-knives
id 10751
list_price 13.19
map NO
mfr_num 109911
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 10751
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 10751
2 109911
3 large, 11
timestamp 2015-03-27T14:46:24.773Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974218
barcode_type UPC
col1 large
col1_sortorder 2496
col2 12
col2_sortorder 60
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 12
group_id 9410
group_uname liquitex-painting-knives
id 10971
list_price 13.19
map NO
mfr_num 109912
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 10971
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 10971
2 109912
3 large, 12
timestamp 2015-03-27T14:46:24.983Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974119
barcode_type UPC
col1 large
col1_sortorder 2496
col2 2
col2_sortorder 30
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 2
group_id 9410
group_uname liquitex-painting-knives
id 12117
list_price 13.19
map NO
mfr_num 109902
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 12117
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 12117
2 109902
3 large, 2
timestamp 2015-03-27T14:46:27.092Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974140
barcode_type UPC
col1 large
col1_sortorder 2496
col2 5
col2_sortorder 43
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 5
group_id 9410
group_uname liquitex-painting-knives
id 12191
list_price 13.19
map NO
mfr_num 109905
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 12191
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 12191
2 109905
3 large, 5
timestamp 2015-03-27T14:46:27.251Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974249
barcode_type UPC
col1 large
col1_sortorder 2496
col2 15
col2_sortorder 63
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 15
group_id 9410
group_uname liquitex-painting-knives
id 13218
list_price 13.19
map NO
mfr_num 109915
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 13218
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 13218
2 109915
3 large, 15
timestamp 2015-03-27T14:46:28.544Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974164
barcode_type UPC
col1 large
col1_sortorder 2496
col2 7
col2_sortorder 49
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 7
group_id 9410
group_uname liquitex-painting-knives
id 13657
list_price 13.19
map NO
mfr_num 109907
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 13657
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 13657
2 109907
3 large, 7
timestamp 2015-03-27T14:46:29.16Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974126
barcode_type UPC
col1 large
col1_sortorder 2496
col2 3
col2_sortorder 32
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 3
group_id 9410
group_uname liquitex-painting-knives
id 14898
list_price 13.19
map NO
mfr_num 109903
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 14898
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 14898
2 109903
3 large, 3
timestamp 2015-03-27T14:46:32.814Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974232
barcode_type UPC
col1 large
col1_sortorder 2496
col2 14
col2_sortorder 62
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 14
group_id 9410
group_uname liquitex-painting-knives
id 15251
list_price 13.19
map NO
mfr_num 109914
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 15251
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 15251
2 109914
3 large, 14
timestamp 2015-03-27T14:46:33.958Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974263
barcode_type UPC
col1 large
col1_sortorder 2496
col2 17
col2_sortorder 66
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 17
group_id 9410
group_uname liquitex-painting-knives
id 17559
list_price 13.19
map NO
mfr_num 109917
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 17559
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 17559
2 109917
3 large, 17
timestamp 2015-03-27T14:46:37.444Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974171
barcode_type UPC
col1 large
col1_sortorder 2496
col2 8
col2_sortorder 51
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 8
group_id 9410
group_uname liquitex-painting-knives
id 18598
list_price 13.19
map NO
mfr_num 109908
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 18598
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 18598
2 109908
3 large, 8
timestamp 2015-03-27T14:46:38.847Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974102
barcode_type UPC
col1 large
col1_sortorder 2496
col2 1
col2_sortorder 18
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 1
group_id 9410
group_uname liquitex-painting-knives
id 19491
list_price 13.19
map NO
mfr_num 109901
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 19491
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 19491
2 109901
3 large, 1
timestamp 2015-03-27T14:46:39.643Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974225
barcode_type UPC
col1 large
col1_sortorder 2496
col2 13
col2_sortorder 61
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 13
group_id 9410
group_uname liquitex-painting-knives
id 20485
list_price 13.19
map NO
mfr_num 109913
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 20485
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 20485
2 109913
3 large, 13
timestamp 2015-03-27T14:46:40.623Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974157
barcode_type UPC
col1 large
col1_sortorder 2496
col2 6
col2_sortorder 46
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 6
group_id 9410
group_uname liquitex-painting-knives
id 22071
list_price 13.19
map NO
mfr_num 109906
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 22071
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 22071
2 109906
3 large, 6
timestamp 2015-03-27T14:46:42.977Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974133
barcode_type UPC
col1 large
col1_sortorder 2496
col2 4
col2_sortorder 38
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 4
group_id 9410
group_uname liquitex-painting-knives
id 22433
list_price 13.19
map NO
mfr_num 109904
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 22433
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 22433
2 109904
3 large, 4
timestamp 2015-03-27T14:46:43.403Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974188
barcode_type UPC
col1 large
col1_sortorder 2496
col2 9
col2_sortorder 55
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 9
group_id 9410
group_uname liquitex-painting-knives
id 31059
list_price 13.19
map NO
mfr_num 109909
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 31059
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 31059
2 109909
3 large, 9
timestamp 2015-03-27T14:46:56.1Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974195
barcode_type UPC
col1 large
col1_sortorder 2496
col2 10
col2_sortorder 56
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 10
group_id 9410
group_uname liquitex-painting-knives
id 31899
list_price 13.19
map NO
mfr_num 109910
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 31899
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 31899
2 109910
3 large, 10
timestamp 2015-03-27T14:46:57.637Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974256
barcode_type UPC
col1 large
col1_sortorder 2496
col2 16
col2_sortorder 64
col3 [empty string]
cost 5.64
deal_of_the_week NO
description large, 16
group_id 9410
group_uname liquitex-painting-knives
id 32585
list_price 13.19
map NO
mfr_num 109916
net_weight 0.14
non_member_discount 36
non_member_price 8.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 32585
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 6.2
ta_price 9.23
text
array
1 32585
2 109916
3 large, 16
timestamp 2015-03-27T14:46:58.575Z
vip_member_price 7.19

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974362
barcode_type UPC
col1 small
col1_sortorder 2593
col2 9
col2_sortorder 55
col3 [empty string]
cost 1.98
deal_of_the_week NO
description small, 9
group_id 9410
group_uname liquitex-painting-knives
id 11247
list_price 4.64
map NO
mfr_num 119909
net_weight 0.04
non_member_discount 36
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 11247
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.32
ta_dealer_c_price 2.18
ta_price 3.25
text
array
1 11247
2 119909
3 small, 9
timestamp 2015-03-27T14:46:25.346Z
vip_member_price 2.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974386
barcode_type UPC
col1 small
col1_sortorder 2593
col2 11
col2_sortorder 59
col3 [empty string]
cost 1.98
deal_of_the_week NO
description small, 11
group_id 9410
group_uname liquitex-painting-knives
id 13686
list_price 4.64
map NO
mfr_num 119911
net_weight 0.04
non_member_discount 36
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 13686
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.32
ta_dealer_c_price 2.18
ta_price 3.25
text
array
1 13686
2 119911
3 small, 11
timestamp 2015-03-27T14:46:29.219Z
vip_member_price 2.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974393
barcode_type UPC
col1 small
col1_sortorder 2593
col2 12
col2_sortorder 60
col3 [empty string]
cost 1.98
deal_of_the_week NO
description small, 12
group_id 9410
group_uname liquitex-painting-knives
id 15447
list_price 4.64
map NO
mfr_num 119912
net_weight 0.04
non_member_discount 36
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 15447
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.32
ta_dealer_c_price 2.18
ta_price 3.25
text
array
1 15447
2 119912
3 small, 12
timestamp 2015-03-27T14:46:34.371Z
vip_member_price 2.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974447
barcode_type UPC
col1 small
col1_sortorder 2593
col2 17
col2_sortorder 66
col3 [empty string]
cost 1.98
deal_of_the_week NO
description small, 17
group_id 9410
group_uname liquitex-painting-knives
id 19953
list_price 4.64
map NO
mfr_num 119917
net_weight 0.04
non_member_discount 36
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 19953
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.32
ta_dealer_c_price 2.18
ta_price 3.25
text
array
1 19953
2 119917
3 small, 17
timestamp 2015-03-27T14:46:40.004Z
vip_member_price 2.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974423
barcode_type UPC
col1 small
col1_sortorder 2593
col2 15
col2_sortorder 63
col3 [empty string]
cost 1.98
deal_of_the_week NO
description small, 15
group_id 9410
group_uname liquitex-painting-knives
id 21201
list_price 4.64
map NO
mfr_num 119915
net_weight 0.04
non_member_discount 36
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 21201
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.32
ta_dealer_c_price 2.18
ta_price 3.25
text
array
1 21201
2 119915
3 small, 15
timestamp 2015-03-27T14:46:41.669Z
vip_member_price 2.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974430
barcode_type UPC
col1 small
col1_sortorder 2593
col2 16
col2_sortorder 64
col3 [empty string]
cost 1.98
deal_of_the_week NO
description small, 16
group_id 9410
group_uname liquitex-painting-knives
id 23784
list_price 4.64
map NO
mfr_num 119916
net_weight 0.04
non_member_discount 36
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 23784
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.32
ta_dealer_c_price 2.18
ta_price 3.25
text
array
1 23784
2 119916
3 small, 16
timestamp 2015-03-27T14:46:45.04Z
vip_member_price 2.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974454
barcode_type UPC
col1 small
col1_sortorder 2593
col2 18
col2_sortorder 67
col3 [empty string]
cost 1.98
deal_of_the_week NO
description small, 18
group_id 9410
group_uname liquitex-painting-knives
id 26637
list_price 4.64
map NO
mfr_num 119918
net_weight 0.04
non_member_discount 36
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 26637
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.32
ta_dealer_c_price 2.18
ta_price 3.25
text
array
1 26637
2 119918
3 small, 18
timestamp 2015-03-27T14:46:49.553Z
vip_member_price 2.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974287
barcode_type UPC
col1 small
col1_sortorder 2593
col2 1
col2_sortorder 18
col3 [empty string]
cost 1.98
deal_of_the_week NO
description small, 1
group_id 9410
group_uname liquitex-painting-knives
id 27357
list_price 4.64
map NO
mfr_num 119901
net_weight 0.04
non_member_discount 36
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 27357
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.32
ta_dealer_c_price 2.18
ta_price 3.25
text
array
1 27357
2 119901
3 small, 1
timestamp 2015-03-27T14:46:50.536Z
vip_member_price 2.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974416
barcode_type UPC
col1 small
col1_sortorder 2593
col2 14
col2_sortorder 62
col3 [empty string]
cost 1.98
deal_of_the_week NO
description small, 14
group_id 9410
group_uname liquitex-painting-knives
id 27420
list_price 4.64
map NO
mfr_num 119914
net_weight 0.04
non_member_discount 36
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 27420
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.32
ta_dealer_c_price 2.18
ta_price 3.25
text
array
1 27420
2 119914
3 small, 14
timestamp 2015-03-27T14:46:50.619Z
vip_member_price 2.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974294
barcode_type UPC
col1 small
col1_sortorder 2593
col2 2
col2_sortorder 30
col3 [empty string]
cost 1.98
deal_of_the_week NO
description small, 2
group_id 9410
group_uname liquitex-painting-knives
id 27903
list_price 4.64
map NO
mfr_num 119902
net_weight 0.04
non_member_discount 36
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 27903
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.32
ta_dealer_c_price 2.18
ta_price 3.25
text
array
1 27903
2 119902
3 small, 2
timestamp 2015-03-27T14:46:51.14Z
vip_member_price 2.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974300
barcode_type UPC
col1 small
col1_sortorder 2593
col2 3
col2_sortorder 32
col3 [empty string]
cost 1.98
deal_of_the_week NO
description small, 3
group_id 9410
group_uname liquitex-painting-knives
id 28776
list_price 4.64
map NO
mfr_num 119903
net_weight 0.04
non_member_discount 36
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 28776
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.32
ta_dealer_c_price 2.18
ta_price 3.25
text
array
1 28776
2 119903
3 small, 3
timestamp 2015-03-27T14:46:52.475Z
vip_member_price 2.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974317
barcode_type UPC
col1 small
col1_sortorder 2593
col2 4
col2_sortorder 38
col3 [empty string]
cost 1.98
deal_of_the_week NO
description small, 4
group_id 9410
group_uname liquitex-painting-knives
id 29127
list_price 4.64
map NO
mfr_num 119904
net_weight 0.04
non_member_discount 36
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 29127
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.32
ta_dealer_c_price 2.18
ta_price 3.25
text
array
1 29127
2 119904
3 small, 4
timestamp 2015-03-27T14:46:53.024Z
vip_member_price 2.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974409
barcode_type UPC
col1 small
col1_sortorder 2593
col2 13
col2_sortorder 61
col3 [empty string]
cost 1.98
deal_of_the_week NO
description small, 13
group_id 9410
group_uname liquitex-painting-knives
id 29451
list_price 4.64
map NO
mfr_num 119913
net_weight 0.04
non_member_discount 36
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 29451
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.32
ta_dealer_c_price 2.18
ta_price 3.25
text
array
1 29451
2 119913
3 small, 13
timestamp 2015-03-27T14:46:53.369Z
vip_member_price 2.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e03082fdd2f80be0f5a07076911601f10651
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html
urltoken CFID=30047074&CFTOKEN=34943067&jsessionid=e03082fdd2f80be0f5a07076911601f10651
validationerror [empty string]


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

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

ItemIDList: 23778,29042
AvailQtyList: 3.000000000000,14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376974331
barcode_type UPC
col1 small
col1_sortorder 2593
col2 6
col2_sortorder 46
col3 [empty string]
cost 1.98
deal_of_the_week NO
description small, 6
group_id 9410
group_uname liquitex-painting-knives
id 30345
list_price 4.64
map NO
mfr_num 119906
net_weight 0.04
non_member_discount 36
non_member_price 2.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 30345
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.32
ta_dealer_c_price 2.18
ta_price 3.25
text
array
1 30345
2 119906
3 small, 6
timestamp 2015-03-27T14:46:54.857Z
vip_member_price 2.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 3.000000000000 23778
2 14.000000000000 29042
CACHED false
EXECUTIONTIME 1
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] = '828' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 50.16.112.199

URL: www.misterart.com:/index.cfm:module=tools&catB=sort~1~fb~liquitex~fp~5-9~&gr=liquitex-painting-knives.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:25:52'}
sessionid e030de6b7ab771adc67461534701a6712171
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=drawing-illustration&catB=pencils&CatC=drawing-sketching-pencils&gr=derwent-sketching-pencil-collections.html
urltoken CFID=30047075&CFTOKEN=68316285&jsessionid=e030de6b7ab771adc67461534701a6712171
validationerror [empty string]


EndSessionVariables: