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

Golden Taklon Brushes

by Loew Cornell


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241112253
barcode_type UPC
col1 10/0
col1_sortorder 80
col2 shader
col2_sortorder 457
col3 7300
col3_sortorder 334
cost 2.1
deal_of_the_week NO
description 10/0, shader, 7300
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 44026
list_price 5.29
map NO
mfr_num 7300-10/0
net_weight 0.02
non_member_discount 30
non_member_price 3.7
prop65 NO
ship_rule_desc STD
shipping STD
sku 44026
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.38
ta_dealer_c_price 2.38
ta_price 3.7
text
array
1 44026
2 7300-10/0
3 10/0, shader, 7300
timestamp 2015-03-27T14:47:16.557Z
vip_member_price 3.17

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107129
barcode_type UPC
col1 3/0
col1_sortorder 83
col2 round
col2_sortorder 434
col3 7000
col3_sortorder 324
cost 1.98
deal_of_the_week NO
description 3/0, round, 7000
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 59153
list_price 4.99
map NO
mfr_num 7000-3/0
net_weight 0.04
non_member_discount 30
non_member_price 3.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 59153
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.25
ta_price 3.49
text
array
1 59153
2 7000-3/0
3 3/0, round, 7000
timestamp 2015-03-27T14:47:34.852Z
vip_member_price 2.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107037
barcode_type UPC
col1 0
col1_sortorder 85
col2 round
col2_sortorder 434
col3 7000
col3_sortorder 324
cost 2.01
deal_of_the_week NO
description 0, round, 7000
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 77215
list_price 5.09
map NO
mfr_num 7000-0
net_weight 0.04
non_member_discount 30
non_member_price 3.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 77215
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.29
ta_dealer_c_price 2.29
ta_price 3.56
text
array
1 77215
2 7000-0
3 0, round, 7000
timestamp 2015-03-27T14:48:07.044Z
vip_member_price 3.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107044
barcode_type UPC
col1 1
col1_sortorder 275
col2 round
col2_sortorder 434
col3 7000
col3_sortorder 324
cost 2.06
deal_of_the_week NO
description 1, round, 7000
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 68565
list_price 5.19
map NO
mfr_num 7000-1
net_weight 0.04
non_member_discount 30
non_member_price 3.63
prop65 NO
ship_rule_desc STD
shipping STD
sku 68565
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.34
ta_dealer_c_price 2.34
ta_price 3.63
text
array
1 68565
2 7000-1
3 1, round, 7000
timestamp 2015-03-27T14:47:51.579Z
vip_member_price 3.11

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107952
barcode_type UPC
col1 1
col1_sortorder 275
col2 liner
col2_sortorder 282
col3 7350
col3_sortorder 335
cost 2.06
deal_of_the_week NO
description 1, liner, 7350
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 70003
list_price 5.19
map NO
mfr_num 7350-1
net_weight 0.04
non_member_discount 30
non_member_price 3.63
prop65 NO
ship_rule_desc STD
shipping STD
sku 70003
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.34
ta_dealer_c_price 2.34
ta_price 3.63
text
array
1 70003
2 7350-1
3 1, liner, 7350
timestamp 2015-03-27T14:47:55.577Z
vip_member_price 3.11

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107280
barcode_type UPC
col1 1
col1_sortorder 275
col2 script liner
col2_sortorder 455
col3 7050
col3_sortorder 326
cost 2.06
deal_of_the_week NO
description 1, script liner, 7050
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 80514
list_price 5.19
map NO
mfr_num 7050-1
net_weight 0.04
non_member_discount 30
non_member_price 3.63
prop65 NO
ship_rule_desc STD
shipping STD
sku 80514
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.34
ta_dealer_c_price 2.34
ta_price 3.63
text
array
1 80514
2 7050-1
3 1, script liner, 7050
timestamp 2015-03-27T14:48:11.074Z
vip_member_price 3.11

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241108065
barcode_type UPC
col1 3/8 in.
col1_sortorder 358
col2 angular shader
col2_sortorder 81
col3 7400
col3_sortorder 336
cost 3.68
deal_of_the_week NO
description 3/8 in., angular shader, 7400
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 54891
list_price 9.29
map NO
mfr_num 7400-3/8
net_weight 0.02
non_member_discount 30
non_member_price 6.5
prop65 NO
ship_rule_desc STD
shipping STD
sku 54891
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.18
ta_dealer_c_price 4.18
ta_price 6.5
text
array
1 54891
2 7400-3/8
3 3/8 in., angular shader, 7400
timestamp 2015-03-27T14:47:29.384Z
vip_member_price 5.57

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241108027
barcode_type UPC
col1 1/2 in.
col1_sortorder 359
col2 angular shader
col2_sortorder 81
col3 7400
col3_sortorder 336
cost 4
deal_of_the_week NO
description 1/2 in., angular shader, 7400
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 69062
list_price 10.09
map NO
mfr_num 7400-1/2
net_weight 0.02
non_member_discount 30
non_member_price 7.06
prop65 NO
ship_rule_desc STD
shipping STD
sku 69062
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.54
ta_dealer_c_price 4.54
ta_price 7.06
text
array
1 69062
2 7400-1/2
3 1/2 in., angular shader, 7400
timestamp 2015-03-27T14:47:53.023Z
vip_member_price 6.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107433
barcode_type UPC
col1 3/4 in.
col1_sortorder 360
col2 wash/glaze
col2_sortorder 540
col3 7150
col3_sortorder 331
cost 8.67
deal_of_the_week NO
description 3/4 in., wash/glaze, 7150
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 71460
list_price 21.89
map NO
mfr_num 7150-3/4
net_weight 0.04
non_member_discount 30
non_member_price 15.32
prop65 NO
ship_rule_desc STD
shipping STD
sku 71460
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.85
ta_dealer_c_price 9.85
ta_price 15.32
text
array
1 71460
2 7150-3/4
3 3/4 in., wash/glaze, 7150
timestamp 2015-03-27T14:47:59.756Z
vip_member_price 13.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241108041
barcode_type UPC
col1 1/8 in.
col1_sortorder 506
col2 angular shader
col2_sortorder 81
col3 7400
col3_sortorder 336
cost 2.22
deal_of_the_week NO
description 1/8 in., angular shader, 7400
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 77227
list_price 5.59
map NO
mfr_num 7400-1/8
net_weight 0.02
non_member_discount 30
non_member_price 3.91
prop65 NO
ship_rule_desc STD
shipping STD
sku 77227
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.52
ta_dealer_c_price 2.52
ta_price 3.91
text
array
1 77227
2 7400-1/8
3 1/8 in., angular shader, 7400
timestamp 2015-03-27T14:48:07.058Z
vip_member_price 3.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241108034
barcode_type UPC
col1 1/4 in.
col1_sortorder 578
col2 angular shader
col2_sortorder 81
col3 7400
col3_sortorder 336
cost 3.09
deal_of_the_week NO
description 1/4 in., angular shader, 7400
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 29635
list_price 7.79
map NO
mfr_num 7400-1/4
net_weight 0.02
non_member_discount 30
non_member_price 5.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 29635
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.51
ta_dealer_c_price 3.51
ta_price 5.45
text
array
1 29635
2 7400-1/4
3 1/4 in., angular shader, 7400
timestamp 2015-03-27T14:46:53.555Z
vip_member_price 4.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241108652
barcode_type UPC
col1 1/4 in.
col1_sortorder 578
col2 dagger
col2_sortorder 162
col3 7800
col3_sortorder 344
cost 4.12
deal_of_the_week NO
description 1/4 in., dagger, 7800
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 42730
list_price 10.39
map NO
mfr_num 7800-1/4
net_weight 0.02
non_member_discount 30
non_member_price 7.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 42730
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.68
ta_dealer_c_price 4.68
ta_price 7.27
text
array
1 42730
2 7800-1/4
3 1/4 in., dagger, 7800
timestamp 2015-03-27T14:47:15.4Z
vip_member_price 6.23

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107853
barcode_type UPC
col1 10
col1_sortorder 692
col2 shader
col2_sortorder 457
col3 7300
col3_sortorder 334
cost 3.31
deal_of_the_week NO
description 10, shader, 7300
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 38890
list_price 8.34
map NO
mfr_num 7300-10
net_weight 0.02
non_member_discount 30
non_member_price 5.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 38890
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.75
ta_dealer_c_price 3.75
ta_price 5.84
text
array
1 38890
2 7300-10
3 10, shader, 7300
timestamp 2015-03-27T14:47:11.129Z
vip_member_price 5

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107198
barcode_type UPC
col1 10
col1_sortorder 692
col2 ultra round
col2_sortorder 534
col3 7020
col3_sortorder 325
cost 5.98
deal_of_the_week NO
description 10, ultra round, 7020
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 53200
list_price 15.09
map NO
mfr_num 7020-10
net_weight 0.03
non_member_discount 30
non_member_price 10.56
prop65 NO
ship_rule_desc STD
shipping STD
sku 53200
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.79
ta_dealer_c_price 6.79
ta_price 10.56
text
array
1 53200
2 7020-10
3 10, ultra round, 7020
timestamp 2015-03-27T14:47:28.345Z
vip_member_price 9.05

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107075
barcode_type UPC
col1 12
col1_sortorder 816
col2 round
col2_sortorder 434
col3 7000
col3_sortorder 324
cost 5.34
deal_of_the_week NO
description 12, round, 7000
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 13139
list_price 13.49
map NO
mfr_num 7000-12
net_weight 0.04
non_member_discount 30
non_member_price 9.44
prop65 NO
ship_rule_desc STD
shipping STD
sku 13139
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.07
ta_dealer_c_price 6.07
ta_price 9.44
text
array
1 13139
2 7000-12
3 12, round, 7000
timestamp 2015-03-27T14:46:28.486Z
vip_member_price 8.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107204
barcode_type UPC
col1 12
col1_sortorder 816
col2 ultra round
col2_sortorder 534
col3 7020
col3_sortorder 325
cost 6.89
deal_of_the_week NO
description 12, ultra round, 7020
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 51557
list_price 17.39
map NO
mfr_num 7020-12
net_weight 0.04
non_member_discount 30
non_member_price 12.17
prop65 NO
ship_rule_desc STD
shipping STD
sku 51557
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.83
ta_dealer_c_price 7.83
ta_price 12.17
text
array
1 51557
2 7020-12
3 12, ultra round, 7020
timestamp 2015-03-27T14:47:25.55Z
vip_member_price 10.43

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107860
barcode_type UPC
col1 12
col1_sortorder 816
col2 shader
col2_sortorder 457
col3 7300
col3_sortorder 334
cost 3.88
deal_of_the_week NO
description 12, shader, 7300
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 54214
list_price 9.79
map NO
mfr_num 7300-12
net_weight 0.02
non_member_discount 30
non_member_price 6.85
prop65 NO
ship_rule_desc STD
shipping STD
sku 54214
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.41
ta_dealer_c_price 4.41
ta_price 6.85
text
array
1 54214
2 7300-12
3 12, shader, 7300
timestamp 2015-03-27T14:47:28.983Z
vip_member_price 5.87

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107211
barcode_type UPC
col1 14
col1_sortorder 912
col2 ultra round
col2_sortorder 534
col3 7020
col3_sortorder 325
cost 7.53
deal_of_the_week NO
description 14, ultra round, 7020
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 40402
list_price 18.99
map NO
mfr_num 7020-14
net_weight 0.04
non_member_discount 30
non_member_price 13.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 40402
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.55
ta_dealer_c_price 8.55
ta_price 13.29
text
array
1 40402
2 7020-14
3 14, ultra round, 7020
timestamp 2015-03-27T14:47:12.594Z
vip_member_price 11.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107877
barcode_type UPC
col1 14
col1_sortorder 912
col2 shader
col2_sortorder 457
col3 7300
col3_sortorder 334
cost 4.87
deal_of_the_week NO
description 14, shader, 7300
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 69147
list_price 12.29
map NO
mfr_num 7300-14
net_weight 0.03
non_member_discount 30
non_member_price 8.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 69147
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.53
ta_dealer_c_price 5.53
ta_price 8.6
text
array
1 69147
2 7300-14
3 14, shader, 7300
timestamp 2015-03-27T14:47:53.403Z
vip_member_price 7.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241112260
barcode_type UPC
col1 18/0
col1_sortorder 1095
col2 liner
col2_sortorder 282
col3 7350
col3_sortorder 335
cost 2.1
deal_of_the_week NO
description 18/0, liner, 7350
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 16925
list_price 5.29
map NO
mfr_num 7350-18/0
net_weight 0.02
non_member_discount 30
non_member_price 3.7
prop65 NO
ship_rule_desc STD
shipping STD
sku 16925
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.38
ta_dealer_c_price 2.38
ta_price 3.7
text
array
1 16925
2 7350-18/0
3 18/0, liner, 7350
timestamp 2015-03-27T14:46:36.514Z
vip_member_price 3.17

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241112239
barcode_type UPC
col1 18/0
col1_sortorder 1095
col2 round
col2_sortorder 434
col3 7000
col3_sortorder 324
cost 2.1
deal_of_the_week NO
description 18/0, round, 7000
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 29551
list_price 5.29
map NO
mfr_num 7000-18/0
net_weight 0.02
non_member_discount 30
non_member_price 3.7
prop65 NO
ship_rule_desc STD
shipping STD
sku 29551
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.38
ta_dealer_c_price 2.38
ta_price 3.7
text
array
1 29551
2 7000-18/0
3 18/0, round, 7000
timestamp 2015-03-27T14:46:53.491Z
vip_member_price 3.17

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241108102
barcode_type UPC
col1 2
col1_sortorder 1114
col2 chisel blender
col2_sortorder 140
col3 7400
col3_sortorder 336
cost 2.22
deal_of_the_week NO
description 2, chisel blender, 7400
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 40224
list_price 5.59
map NO
mfr_num 7450-2
net_weight 0.02
non_member_discount 30
non_member_price 3.91
prop65 NO
ship_rule_desc STD
shipping STD
sku 40224
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.52
ta_dealer_c_price 2.52
ta_price 3.91
text
array
1 40224
2 7450-2
3 2, chisel blender, 7400
timestamp 2015-03-27T14:47:12.477Z
vip_member_price 3.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107228
barcode_type UPC
col1 2
col1_sortorder 1114
col2 ultra round
col2_sortorder 534
col3 7020
col3_sortorder 325
cost 3.33
deal_of_the_week NO
description 2, ultra round, 7020
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 54533
list_price 8.39
map NO
mfr_num 7020-2
net_weight 0.01
non_member_discount 30
non_member_price 5.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 54533
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.78
ta_dealer_c_price 3.78
ta_price 5.87
text
array
1 54533
2 7020-2
3 2, ultra round, 7020
timestamp 2015-03-27T14:47:29.155Z
vip_member_price 5.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107099
barcode_type UPC
col1 2
col1_sortorder 1114
col2 round
col2_sortorder 434
col3 7000
col3_sortorder 324
cost 2.14
deal_of_the_week NO
description 2, round, 7000
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 64453
list_price 5.39
map NO
mfr_num 7000-2
net_weight 0.04
non_member_discount 30
non_member_price 3.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 64453
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.43
ta_dealer_c_price 2.43
ta_price 3.77
text
array
1 64453
2 7000-2
3 2, round, 7000
timestamp 2015-03-27T14:47:44.923Z
vip_member_price 3.23

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107440
barcode_type UPC
col1 2
col1_sortorder 1114
col2 fan
col2_sortorder 198
col3 7200
col3_sortorder 332
cost 3.4
deal_of_the_week NO
description 2, fan, 7200
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 69169
list_price 8.59
map NO
mfr_num 7200-2
net_weight 0.02
non_member_discount 30
non_member_price 6.01
prop65 NO
ship_rule_desc STD
shipping STD
sku 69169
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.87
ta_dealer_c_price 3.87
ta_price 6.01
text
array
1 69169
2 7200-2
3 2, fan, 7200
timestamp 2015-03-27T14:47:53.458Z
vip_member_price 5.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107976
barcode_type UPC
col1 2
col1_sortorder 1114
col2 liner
col2_sortorder 282
col3 7350
col3_sortorder 335
cost 2.14
deal_of_the_week NO
description 2, liner, 7350
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 80517
list_price 5.39
map NO
mfr_num 7350-2
net_weight 0.04
non_member_discount 30
non_member_price 3.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 80517
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.43
ta_dealer_c_price 2.43
ta_price 3.77
text
array
1 80517
2 7350-2
3 2, liner, 7350
timestamp 2015-03-27T14:48:11.079Z
vip_member_price 3.23

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107891
barcode_type UPC
col1 2
col1_sortorder 1114
col2 shader
col2_sortorder 457
col3 7300
col3_sortorder 334
cost 2.22
deal_of_the_week NO
description 2, shader, 7300
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 84899
list_price 5.59
map NO
mfr_num 7300-2
net_weight 0.02
non_member_discount 30
non_member_price 3.91
prop65 NO
ship_rule_desc STD
shipping STD
sku 84899
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.52
ta_dealer_c_price 2.52
ta_price 3.91
text
array
1 84899
2 7300-2
3 2, shader, 7300
timestamp 2015-03-27T14:48:14.965Z
vip_member_price 3.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241071055
barcode_type UPC
col1 20
col1_sortorder 1248
col2 round
col2_sortorder 434
col3 7000
col3_sortorder 324
cost 1.98
deal_of_the_week NO
description 20, round, 7000
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 43467
list_price 4.99
map NO
mfr_num 7000-2/0
net_weight 0.04
non_member_discount 30
non_member_price 3.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 43467
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.25
ta_price 3.49
text
array
1 43467
2 7000-2/0
3 20, round, 7000
timestamp 2015-03-27T14:47:16.109Z
vip_member_price 2.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107112
barcode_type UPC
col1 3
col1_sortorder 1434
col2 round
col2_sortorder 434
col3 7000
col3_sortorder 324
cost 2.33
deal_of_the_week NO
description 3, round, 7000
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 83935
list_price 5.89
map NO
mfr_num 7000-3
net_weight 0.04
non_member_discount 30
non_member_price 4.12
prop65 NO
ship_rule_desc STD
shipping STD
sku 83935
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.65
ta_dealer_c_price 2.65
ta_price 4.12
text
array
1 83935
2 7000-3
3 3, round, 7000
timestamp 2015-03-27T14:48:14.304Z
vip_member_price 3.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107914
barcode_type UPC
col1 4
col1_sortorder 1724
col2 shader
col2_sortorder 457
col3 7300
col3_sortorder 334
cost 2.33
deal_of_the_week NO
description 4, shader, 7300
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 31784
list_price 5.89
map NO
mfr_num 7300-4
net_weight 0.02
non_member_discount 30
non_member_price 4.12
prop65 NO
ship_rule_desc STD
shipping STD
sku 31784
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.65
ta_dealer_c_price 2.65
ta_price 4.12
text
array
1 31784
2 7300-4
3 4, shader, 7300
timestamp 2015-03-27T14:46:57.463Z
vip_member_price 3.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107235
barcode_type UPC
col1 4
col1_sortorder 1724
col2 ultra round
col2_sortorder 534
col3 7020
col3_sortorder 325
cost 3.81
deal_of_the_week NO
description 4, ultra round, 7020
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 77402
list_price 9.59
map NO
mfr_num 7020-4
net_weight 0.01
non_member_discount 30
non_member_price 6.71
prop65 NO
ship_rule_desc STD
shipping STD
sku 77402
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.32
ta_dealer_c_price 4.32
ta_price 6.71
text
array
1 77402
2 7020-4
3 4, ultra round, 7020
timestamp 2015-03-27T14:48:07.17Z
vip_member_price 5.75

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e030cc3b6871e08fb08076c64625c2d1e2e1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~11-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=30111629&CFTOKEN=22972606&jsessionid=e030cc3b6871e08fb08076c64625c2d1e2e1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 00:57:08'}
sessionid e0304e3bff9044072333694a7d6954715929
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~loew-cornell~fp~11-16~c1~brushes~&gr=loew-cornell-golden-taklon-brushes.html
urltoken CFID=30111628&CFTOKEN=50467226&jsessionid=e0304e3bff9044072333694a7d6954715929
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 089241107136
barcode_type UPC
col1 4
col1_sortorder 1724
col2 round
col2_sortorder 434
col3 7000
col3_sortorder 324
cost 2.45
deal_of_the_week NO
description 4, round, 7000
group_id 669
group_uname loew-cornell-golden-taklon-brushes
id 87934
list_price 6.19
map NO
mfr_num 7000-4
net_weight 0.04
non_member_discount 30
non_member_price 4.33
prop65 NO
ship_rule_desc STD
shipping STD
sku 87934
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.79
ta_dealer_c_price 2.79
ta_price 4.33
text
array
1 87934
2 7000-4
3 4, round, 7000
timestamp 2015-03-27T14:48:20.718Z
vip_member_price 3.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
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] = '740' 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.163.105.38

URL: