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

Pitt Artist Pens

by Faber-Castell


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401670995
barcode_type EAN
col1 black
col1_sortorder 402
col2 extra superfine
col2_sortorder 35
col3 199
col3_sortorder 330
color_swatch 0-0-0.jpg
cost 1.62
deal_of_the_week NO
description black, extra superfine, 199
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 13760
list_price 3.5
map NO
mfr_num 167099
net_weight 0.02
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 13760
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 13760
2 167099
3 black, extra superfine, 199
timestamp 2015-04-01T21:25:33.817Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401673996
barcode_type EAN
col1 black
col1_sortorder 402
col2 medium
col2_sortorder 44
col3 199
col3_sortorder 330
color_swatch 0-0-0.jpg
cost 1.62
deal_of_the_week NO
description black, medium, 199
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 15936
list_price 3.5
map NO
mfr_num 167399
net_weight 0.03
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 15936
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 15936
2 167399
3 black, medium, 199
timestamp 2015-04-01T21:25:37.897Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401674993
barcode_type EAN
col1 black
col1_sortorder 402
col2 brush
col2_sortorder 52
col3 199
col3_sortorder 330
color_swatch 0-0-0.jpg
cost 1.62
deal_of_the_week NO
description black, brush, 199
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 27388
list_price 3.5
map NO
mfr_num 167499
net_weight 0.03
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 27388
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 27388
2 167499
3 black, brush, 199
timestamp 2015-04-01T21:25:50.647Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401671992
barcode_type EAN
col1 black
col1_sortorder 402
col2 superfine
col2_sortorder 30
col3 199
col3_sortorder 330
color_swatch 0-0-0.jpg
cost 1.62
deal_of_the_week NO
description black, superfine, 199
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 44152
list_price 3.5
map NO
mfr_num 167199
net_weight 0.03
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 44152
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 44152
2 167199
3 black, superfine, 199
timestamp 2015-04-01T21:26:17.825Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401672999
barcode_type EAN
col1 black
col1_sortorder 402
col2 fine
col2_sortorder 36
col3 199
col3_sortorder 330
color_swatch 0-0-0.jpg
cost 1.62
deal_of_the_week NO
description black, fine, 199
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 73620
list_price 3.5
map NO
mfr_num 167299
net_weight 0.03
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 73620
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 73620
2 167299
3 black, fine, 199
timestamp 2015-04-01T21:27:11.505Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 092633800119
barcode_type UPC
col1 black
col1_sortorder 402
col2 superfine
col2_sortorder 30
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.74
deal_of_the_week NO
description black, superfine
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 98404
list_price 3.75
map NO
mfr_num 800010
net_weight 0
non_member_discount 34
non_member_price 2.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 98404
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.88
ta_dealer_c_price 1.88
ta_price 2.85
text
array
1 98404
2 800010
3 black, superfine
timestamp 2015-04-01T21:27:44.112Z
vip_member_price 2.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 092633800126
barcode_type UPC
col1 black
col1_sortorder 402
col2 fine
col2_sortorder 36
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.74
deal_of_the_week NO
description black, fine
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 98405
list_price 3.75
map NO
mfr_num 800011
net_weight 0
non_member_discount 34
non_member_price 2.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 98405
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.88
ta_dealer_c_price 1.88
ta_price 2.85
text
array
1 98405
2 800011
3 black, fine
timestamp 2015-04-01T21:27:44.295Z
vip_member_price 2.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 092633800133
barcode_type UPC
col1 black
col1_sortorder 402
col2 brush
col2_sortorder 52
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.74
deal_of_the_week NO
description black, brush
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 98406
list_price 3.75
map NO
mfr_num 800012
net_weight 0
non_member_discount 34
non_member_price 2.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 98406
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.88
ta_dealer_c_price 1.88
ta_price 2.85
text
array
1 98406
2 800012
3 black, brush
timestamp 2015-04-01T21:27:44.324Z
vip_member_price 2.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 092633800140
barcode_type UPC
col1 black
col1_sortorder 402
col2 medium
col2_sortorder 44
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.74
deal_of_the_week NO
description black, medium
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 98407
list_price 3.75
map NO
mfr_num 800013
net_weight 0
non_member_discount 34
non_member_price 2.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 98407
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.88
ta_dealer_c_price 1.88
ta_price 2.85
text
array
1 98407
2 800013
3 black, medium
timestamp 2015-04-01T21:27:44.326Z
vip_member_price 2.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 43
barcode 092633804124
barcode_type UPC
col1 black
col1_sortorder 402
col2 extra superfine
col2_sortorder 35
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.74
deal_of_the_week NO
description black, extra superfine
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 98408
list_price 3.75
map NO
mfr_num 800066
net_weight 0
non_member_discount 34
non_member_price 2.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 98408
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.88
ta_dealer_c_price 1.88
ta_price 2.85
text
array
1 98408
2 800066
3 black, extra superfine
timestamp 2015-04-01T21:27:44.33Z
vip_member_price 2.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401674078
barcode_type EAN
col1 cadmium yellow
col1_sortorder 997
col2 brush
col2_sortorder 52
col3 107
col3_sortorder 239
color_swatch 255-241-106.jpg
cost 1.62
deal_of_the_week NO
description cadmium yellow, brush, 107
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 38172
list_price 3.5
map NO
mfr_num 167407
net_weight 0.03
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 38172
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 38172
2 167407
3 cadmium yellow, brush, 107
timestamp 2015-04-01T21:26:12.295Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401674696
barcode_type EAN
col1 caput mortuum
col1_sortorder 1090
col2 brush
col2_sortorder 52
col3 169
col3_sortorder 300
color_swatch 186-146-149.jpg
cost 1.62
deal_of_the_week NO
description caput mortuum, brush, 169
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 19744
list_price 3.5
map NO
mfr_num 167469
net_weight 0.03
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 19744
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 19744
2 167469
3 caput mortuum, brush, 169
timestamp 2015-04-01T21:25:41.227Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401673781
barcode_type EAN
col1 chrome oxide green
col1_sortorder 1251
col2 brush
col2_sortorder 52
col3 278
col3_sortorder 449
color_swatch 94-106-57.jpg
cost 1.62
deal_of_the_week NO
description chrome oxide green, brush, 278
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 13973
list_price 3.5
map NO
mfr_num 167378
net_weight 0.02
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 13973
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 13973
2 167378
3 chrome oxide green, brush, 278
timestamp 2015-04-01T21:25:34.351Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401674764
barcode_type EAN
col1 chromium green opaque
col1_sortorder 1261
col2 brush
col2_sortorder 52
col3 174
col3_sortorder 305
color_swatch 154-157-101.jpg
cost 1.62
deal_of_the_week NO
description chromium green opaque, brush, 174
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 57691
list_price 3.5
map NO
mfr_num 167476
net_weight 0.03
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 57691
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 57691
2 167476
3 chromium green opaque, brush, 174
timestamp 2015-04-01T21:26:35.935Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401674894
barcode_type EAN
col1 cinnamon
col1_sortorder 1288
col2 brush
col2_sortorder 52
col3 189
col3_sortorder 320
color_swatch 234-210-173.jpg
cost 1.62
deal_of_the_week NO
description cinnamon, brush, 189
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 52808
list_price 3.5
map NO
mfr_num 167489
net_weight 0.03
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 52808
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 52808
2 167489
3 cinnamon, brush, 189
timestamp 2015-04-01T21:26:29.221Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401674436
barcode_type EAN
col1 cobalt blue
col1_sortorder 1353
col2 brush
col2_sortorder 52
col3 143
col3_sortorder 275
color_swatch 70-143-187.jpg
cost 1.62
deal_of_the_week NO
description cobalt blue, brush, 143
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 13985
list_price 3.5
map NO
mfr_num 167443
net_weight 0.02
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 13985
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 13985
2 167443
3 cobalt blue, brush, 143
timestamp 2015-04-01T21:25:34.369Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401037095
barcode_type ISBN13
col1 cobalt green
col1_sortorder 1372
col2 brush
col2_sortorder 52
col3 156
col3_sortorder 288
color_swatch 2-177-187.jpg
cost 1.62
deal_of_the_week NO
description cobalt green, brush, 156
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 55525
list_price 3.5
map NO
mfr_num 167456
net_weight 0.02
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 55525
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 55525
2 167456
3 cobalt green, brush, 156
timestamp 2015-04-01T21:26:32.908Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401036562
barcode_type ISBN13
col1 cobalt turquoise
col1_sortorder 1389
col2 brush
col2_sortorder 52
col3 153
col3_sortorder 285
color_swatch 0-169-162.jpg
cost 1.62
deal_of_the_week NO
description cobalt turquoise, brush, 153
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 55523
list_price 3.5
map NO
mfr_num 167453
net_weight 0.02
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 55523
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 55523
2 167453
3 cobalt turquoise, brush, 153
timestamp 2015-04-01T21:26:32.903Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401674306
barcode_type EAN
col1 cold grey I
col1_sortorder 1447
col2 brush
col2_sortorder 52
col3 230
col3_sortorder 383
color_swatch 214-222-226.jpg
cost 1.62
deal_of_the_week NO
description cold grey I, brush, 230
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 13974
list_price 3.5
map NO
mfr_num 167430
net_weight 0.02
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 13974
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 13974
2 167430
3 cold grey I, brush, 230
timestamp 2015-04-01T21:25:34.353Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401674320
barcode_type EAN
col1 cold grey III
col1_sortorder 1449
col2 brush
col2_sortorder 52
col3 232
col3_sortorder 391
color_swatch 202-202-208.jpg
cost 1.62
deal_of_the_week NO
description cold grey III, brush, 232
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 14234
list_price 3.5
map NO
mfr_num 167432
net_weight 0.03
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 14234
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 14234
2 167432
3 cold grey III, brush, 232
timestamp 2015-04-01T21:25:34.923Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401674337
barcode_type EAN
col1 cold grey IV
col1_sortorder 1450
col2 brush
col2_sortorder 52
col3 233
col3_sortorder 392
color_swatch 159-162-165.jpg
cost 1.62
deal_of_the_week NO
description cold grey IV, brush, 233
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 47711
list_price 3.5
map NO
mfr_num 167433
net_weight 0.03
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 47711
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 47711
2 167433
3 cold grey IV, brush, 233
timestamp 2015-04-01T21:26:22.575Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401674351
barcode_type EAN
col1 cold grey VI
col1_sortorder 1452
col2 brush
col2_sortorder 52
col3 235
col3_sortorder 400
color_swatch 83-97-101.jpg
cost 1.62
deal_of_the_week NO
description cold grey VI, brush, 235
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 60751
list_price 3.5
map NO
mfr_num 167435
net_weight 0.03
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 60751
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 60751
2 167435
3 cold grey VI, brush, 235
timestamp 2015-04-01T21:26:43.606Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401035435
barcode_type ISBN13
col1 crimson
col1_sortorder 1609
col2 brush
col2_sortorder 52
col3 134
col3_sortorder 266
color_swatch 185-85-166.jpg
cost 1.62
deal_of_the_week NO
description crimson, brush, 134
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 55517
list_price 3.5
map NO
mfr_num 167434
net_weight 0.02
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 55517
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 55517
2 167434
3 crimson, brush, 134
timestamp 2015-04-01T21:26:32.884Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401674092
barcode_type EAN
col1 dark chrome yellow
col1_sortorder 1693
col2 brush
col2_sortorder 52
col3 109
col3_sortorder 241
color_swatch 255-220-111.jpg
cost 1.62
deal_of_the_week NO
description dark chrome yellow, brush, 109
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 55115
list_price 3.5
map NO
mfr_num 167409
net_weight 0.03
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 55115
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 55115
2 167409
3 dark chrome yellow, brush, 109
timestamp 2015-04-01T21:26:32.254Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401674573
barcode_type EAN
col1 dark indigo
col1_sortorder 1705
col2 brush
col2_sortorder 52
col3 157
col3_sortorder 289
color_swatch 7-87-110.jpg
cost 1.62
deal_of_the_week NO
description dark indigo, brush, 157
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 13965
list_price 3.5
map NO
mfr_num 167457
net_weight 0.02
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 13965
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 13965
2 167457
3 dark indigo, brush, 157
timestamp 2015-04-01T21:25:34.341Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401033639
barcode_type ISBN13
col1 dark phthalo green
col1_sortorder 1740
col2 brush
col2_sortorder 52
col3 264
col3_sortorder 434
color_swatch 0-166-139.jpg
cost 1.62
deal_of_the_week NO
description dark phthalo green, brush, 264
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 55532
list_price 3.5
map NO
mfr_num 167478
net_weight 0.02
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 55532
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 55532
2 167478
3 dark phthalo green, brush, 264
timestamp 2015-04-01T21:26:32.927Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401671756
barcode_type EAN
col1 dark sepia
col1_sortorder 1752
col2 superfine
col2_sortorder 30
col3 175
col3_sortorder 306
color_swatch 117-83-66.jpg
cost 1.62
deal_of_the_week NO
description dark sepia, superfine, 175
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 19751
list_price 3.5
map NO
mfr_num 167175
net_weight 0.03
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 19751
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 19751
2 167175
3 dark sepia, superfine, 175
timestamp 2015-04-01T21:25:41.234Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401672753
barcode_type EAN
col1 dark sepia
col1_sortorder 1752
col2 fine
col2_sortorder 36
col3 175
col3_sortorder 306
color_swatch 117-83-66.jpg
cost 1.62
deal_of_the_week NO
description dark sepia, fine, 175
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 22911
list_price 3.5
map NO
mfr_num 167275
net_weight 0.03
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 22911
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 22911
2 167275
3 dark sepia, fine, 175
timestamp 2015-04-01T21:25:44.808Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401673750
barcode_type EAN
col1 dark sepia
col1_sortorder 1752
col2 medium
col2_sortorder 44
col3 175
col3_sortorder 306
color_swatch 117-83-66.jpg
cost 1.62
deal_of_the_week NO
description dark sepia, medium, 175
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 30503
list_price 3.5
map NO
mfr_num 167375
net_weight 0.03
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 30503
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 30503
2 167375
3 dark sepia, medium, 175
timestamp 2015-04-01T21:25:55.809Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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

ItemIDList: 12142,20690,32813,39340,41804,42511,59883,79179,81097
AvailQtyList: 12.000000000000,35.000000000000,101.000000000000,21.000000000000,22.000000000000,9.000000000000,14.000000000000,50.000000000000,40.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 4005401674757
barcode_type EAN
col1 dark sepia
col1_sortorder 1752
col2 brush
col2_sortorder 52
col3 175
col3_sortorder 306
color_swatch 117-83-66.jpg
cost 1.62
deal_of_the_week NO
description dark sepia, brush, 175
group_id 8105
group_uname faber-castell-pitt-artist-pens
id 86926
list_price 3.5
map NO
mfr_num 167475
net_weight 0.03
non_member_discount 43
non_member_price 2
prop65 NO
ship_rule_desc STD
shipping STD
sku 86926
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.66
text
array
1 86926
2 167475
3 dark sepia, brush, 175
timestamp 2015-04-01T21:27:26.238Z
vip_member_price 1.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 12.000000000000 12142
2 35.000000000000 20690
3 101.000000000000 32813
4 21.000000000000 39340
5 22.000000000000 41804
6 9.000000000000 42511
7 14.000000000000 59883
8 50.000000000000 79179
9 40.000000000000 81097
CACHED false
EXECUTIONTIME 21
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] = '23' 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.205.189.1

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:10'}
sessionid e03057692f540c0695003757233c52262d1c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=fp~9-9999.99~&gr=ludwig-precision-aluminum-t-square.html
urltoken CFID=30962157&CFTOKEN=69094547&jsessionid=e03057692f540c0695003757233c52262d1c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-02 03:06:09'}
sessionid e030da0fc6066101ef605f33603c93949465
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=sort~1~fb~faber-castell~c1~drawing-illustration~c2~pens~&gr=faber-castell-pitt-artist-pens.html
urltoken CFID=30962156&CFTOKEN=82464639&jsessionid=e030da0fc6066101ef605f33603c93949465
validationerror [empty string]


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

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