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

Metal Frame Kit

by Nielsen Bainbridge


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828640854
barcode_type UPC
col1 black
col1_sortorder 402
col2 8 in.
col2_sortorder 2283
col3 [empty string]
color_swatch 0-0-0.jpg
cost 4.62
deal_of_the_week NO
description black, 8 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 12290
list_price 15.17
map NO
mfr_num F108-21
net_weight 0.22
non_member_discount 46
non_member_price 8.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 12290
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.07
ta_dealer_c_price 5.31
ta_price 7.59
text
array
1 12290
2 F108-21
3 black, 8 in.
timestamp 2015-03-30T16:19:17.623Z
vip_member_price 6.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828715231
barcode_type UPC
col1 black
col1_sortorder 402
col2 24 in.
col2_sortorder 1331
col3 [empty string]
color_swatch 0-0-0.jpg
cost 7.42
deal_of_the_week NO
description black, 24 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 16212
list_price 24.31
map NO
mfr_num F124-21
net_weight 0.62
non_member_discount 46
non_member_price 13.13
prop65 NO
ship_rule_desc STD
shipping STD
sku 16212
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.72
ta_dealer_c_price 8.51
ta_price 12.16
text
array
1 16212
2 F124-21
3 black, 24 in.
timestamp 2015-03-30T16:19:32.271Z
vip_member_price 10.7

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828731644
barcode_type UPC
col1 black
col1_sortorder 402
col2 22 in.
col2_sortorder 1296
col3 [empty string]
color_swatch 0-0-0.jpg
cost 7.08
deal_of_the_week NO
description black, 22 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 17837
list_price 23.21
map NO
mfr_num F122-21
net_weight 0.58
non_member_discount 46
non_member_price 12.53
prop65 NO
ship_rule_desc STD
shipping STD
sku 17837
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.28
ta_dealer_c_price 8.12
ta_price 11.61
text
array
1 17837
2 F122-21
3 black, 22 in.
timestamp 2015-03-30T16:19:34.782Z
vip_member_price 10.21

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828628739
barcode_type UPC
col1 black
col1_sortorder 402
col2 20 in.
col2_sortorder 1253
col3 [empty string]
color_swatch 0-0-0.jpg
cost 6.81
deal_of_the_week NO
description black, 20 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 18910
list_price 22.31
map NO
mfr_num F120-21
net_weight 0.54
non_member_discount 46
non_member_price 12.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 18910
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.92
ta_dealer_c_price 7.81
ta_price 11.16
text
array
1 18910
2 F120-21
3 black, 20 in.
timestamp 2015-03-30T16:19:37.418Z
vip_member_price 9.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828726077
barcode_type UPC
col1 black
col1_sortorder 402
col2 31 in.
col2_sortorder 1636
col3 [empty string]
color_swatch 0-0-0.jpg
cost 8.7
deal_of_the_week NO
description black, 31 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 24860
list_price 28.51
map NO
mfr_num F131-21
net_weight 0.76
non_member_discount 46
non_member_price 15.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 24860
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.4
ta_dealer_c_price 9.98
ta_price 14.26
text
array
1 24860
2 F131-21
3 black, 31 in.
timestamp 2015-03-30T16:19:47.262Z
vip_member_price 12.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828508239
barcode_type UPC
col1 black
col1_sortorder 402
col2 10 in.
col2_sortorder 711
col3 [empty string]
color_swatch 0-0-0.jpg
cost 5.03
deal_of_the_week NO
description black, 10 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 24997
list_price 16.49
map NO
mfr_num F110-21
net_weight 0.28
non_member_discount 46
non_member_price 8.9
prop65 NO
ship_rule_desc STD
shipping STD
sku 24997
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.6
ta_dealer_c_price 5.77
ta_price 8.25
text
array
1 24997
2 F110-21
3 black, 10 in.
timestamp 2015-03-30T16:19:47.433Z
vip_member_price 7.26

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828717389
barcode_type UPC
col1 black
col1_sortorder 402
col2 13 in.
col2_sortorder 900
col3 [empty string]
color_swatch 0-0-0.jpg
cost 5.48
deal_of_the_week NO
description black, 13 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 28431
list_price 17.96
map NO
mfr_num F113-21
net_weight 0.36
non_member_discount 46
non_member_price 9.7
prop65 NO
ship_rule_desc STD
shipping STD
sku 28431
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.18
ta_dealer_c_price 6.29
ta_price 8.98
text
array
1 28431
2 F113-21
3 black, 13 in.
timestamp 2015-03-30T16:19:53.524Z
vip_member_price 7.9

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828615739
barcode_type UPC
col1 black
col1_sortorder 402
col2 15 in.
col2_sortorder 952
col3 [empty string]
color_swatch 0-0-0.jpg
cost 5.88
deal_of_the_week NO
description black, 15 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 28843
list_price 19.27
map NO
mfr_num F115-21
net_weight 0.41
non_member_discount 46
non_member_price 10.41
prop65 NO
ship_rule_desc STD
shipping STD
sku 28843
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.71
ta_dealer_c_price 6.74
ta_price 9.64
text
array
1 28843
2 F115-21
3 black, 15 in.
timestamp 2015-03-30T16:19:54.212Z
vip_member_price 8.48

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828735314
barcode_type UPC
col1 black
col1_sortorder 402
col2 33 in.
col2_sortorder 1666
col3 [empty string]
color_swatch 0-0-0.jpg
cost 9.03
deal_of_the_week NO
description black, 33 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 29076
list_price 29.61
map NO
mfr_num F133-21
net_weight 0.82
non_member_discount 46
non_member_price 15.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 29076
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.84
ta_dealer_c_price 10.36
ta_price 14.81
text
array
1 29076
2 F133-21
3 black, 33 in.
timestamp 2015-03-30T16:19:55.027Z
vip_member_price 13.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828715743
barcode_type UPC
col1 black
col1_sortorder 402
col2 11 in.
col2_sortorder 778
col3 [empty string]
color_swatch 0-0-0.jpg
cost 5.14
deal_of_the_week NO
description black, 11 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 30130
list_price 16.85
map NO
mfr_num F111-21
net_weight 0.3
non_member_discount 46
non_member_price 9.1
prop65 NO
ship_rule_desc STD
shipping STD
sku 30130
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.74
ta_dealer_c_price 5.9
ta_price 8.43
text
array
1 30130
2 F111-21
3 black, 11 in.
timestamp 2015-03-30T16:19:57.123Z
vip_member_price 7.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828528534
barcode_type UPC
col1 black
col1_sortorder 402
col2 34 in.
col2_sortorder 1671
col3 [empty string]
color_swatch 0-0-0.jpg
cost 9.06
deal_of_the_week NO
description black, 34 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 30200
list_price 29.72
map NO
mfr_num F134-21
net_weight 0.84
non_member_discount 46
non_member_price 16.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 30200
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.89
ta_dealer_c_price 10.4
ta_price 14.86
text
array
1 30200
2 F134-21
3 black, 34 in.
timestamp 2015-03-30T16:19:57.485Z
vip_member_price 13.08

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828735178
barcode_type UPC
col1 black
col1_sortorder 402
col2 38 in.
col2_sortorder 1717
col3 [empty string]
color_swatch 0-0-0.jpg
cost 9.92
deal_of_the_week NO
description black, 38 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 32268
list_price 32.5
map NO
mfr_num F138-21
net_weight 0.9
non_member_discount 46
non_member_price 17.55
prop65 NO
ship_rule_desc STD
shipping STD
sku 32268
sku_pix YES
supplier_id 1
ta_dealer_a_price 13
ta_dealer_c_price 11.38
ta_price 16.25
text
array
1 32268
2 F138-21
3 black, 38 in.
timestamp 2015-03-30T16:20:02.36Z
vip_member_price 14.3

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828710694
barcode_type UPC
col1 black
col1_sortorder 402
col2 25 in.
col2_sortorder 1382
col3 [empty string]
color_swatch 0-0-0.jpg
cost 7.59
deal_of_the_week NO
description black, 25 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 37518
list_price 24.89
map NO
mfr_num F125-21
net_weight 0.64
non_member_discount 46
non_member_price 13.44
prop65 NO
ship_rule_desc STD
shipping STD
sku 37518
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.96
ta_dealer_c_price 8.71
ta_price 12.45
text
array
1 37518
2 F125-21
3 black, 25 in.
timestamp 2015-03-30T16:20:19.208Z
vip_member_price 10.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828725391
barcode_type UPC
col1 black
col1_sortorder 402
col2 40 in.
col2_sortorder 1833
col3 [empty string]
color_swatch 0-0-0.jpg
cost 10.38
deal_of_the_week NO
description black, 40 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 40483
list_price 34.02
map NO
mfr_num F140-21
net_weight 0.92
non_member_discount 46
non_member_price 18.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 40483
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.61
ta_dealer_c_price 11.91
ta_price 17.01
text
array
1 40483
2 F140-21
3 black, 40 in.
timestamp 2015-03-30T16:20:24.262Z
vip_member_price 14.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828612530
barcode_type UPC
col1 black
col1_sortorder 402
col2 17 in.
col2_sortorder 1027
col3 [empty string]
color_swatch 0-0-0.jpg
cost 6.26
deal_of_the_week NO
description black, 17 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 42833
list_price 20.53
map NO
mfr_num F117-21
net_weight 0.46
non_member_discount 46
non_member_price 11.09
prop65 NO
ship_rule_desc STD
shipping STD
sku 42833
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.21
ta_dealer_c_price 7.19
ta_price 10.27
text
array
1 42833
2 F117-21
3 black, 17 in.
timestamp 2015-03-30T16:20:27.337Z
vip_member_price 9.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828717594
barcode_type UPC
col1 black
col1_sortorder 402
col2 27 in.
col2_sortorder 1415
col3 [empty string]
color_swatch 0-0-0.jpg
cost 7.99
deal_of_the_week NO
description black, 27 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 44282
list_price 26.2
map NO
mfr_num F127-21
net_weight 0.68
non_member_discount 46
non_member_price 14.15
prop65 NO
ship_rule_desc STD
shipping STD
sku 44282
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.48
ta_dealer_c_price 9.17
ta_price 13.1
text
array
1 44282
2 F127-21
3 black, 27 in.
timestamp 2015-03-30T16:20:29.094Z
vip_member_price 11.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828708486
barcode_type UPC
col1 black
col1_sortorder 402
col2 32 in.
col2_sortorder 1647
col3 [empty string]
color_swatch 0-0-0.jpg
cost 8.89
deal_of_the_week NO
description black, 32 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 44825
list_price 29.14
map NO
mfr_num F132-21
net_weight 0.78
non_member_discount 46
non_member_price 15.74
prop65 NO
ship_rule_desc STD
shipping STD
sku 44825
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.66
ta_dealer_c_price 10.2
ta_price 14.57
text
array
1 44825
2 F132-21
3 black, 32 in.
timestamp 2015-03-30T16:20:29.738Z
vip_member_price 12.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828706543
barcode_type UPC
col1 black
col1_sortorder 402
col2 12 in.
col2_sortorder 832
col3 [empty string]
color_swatch 0-0-0.jpg
cost 5.33
deal_of_the_week NO
description black, 12 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 45179
list_price 17.48
map NO
mfr_num F112-21
net_weight 0.33
non_member_discount 46
non_member_price 9.44
prop65 NO
ship_rule_desc STD
shipping STD
sku 45179
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.99
ta_dealer_c_price 6.12
ta_price 8.74
text
array
1 45179
2 F112-21
3 black, 12 in.
timestamp 2015-03-30T16:20:30.408Z
vip_member_price 7.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828730531
barcode_type UPC
col1 black
col1_sortorder 402
col2 8 1/2 in.
col2_sortorder 2252
col3 [empty string]
color_swatch 0-0-0.jpg
cost 4.47
deal_of_the_week NO
description black, 8 1/2 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 48505
list_price 14.65
map NO
mfr_num F1085-21
net_weight 0.23
non_member_discount 46
non_member_price 7.91
prop65 NO
ship_rule_desc STD
shipping STD
sku 48505
sku_pix NO
supplier_id 1
ta_dealer_a_price 5.86
ta_dealer_c_price 5.13
ta_price 7.33
text
array
1 48505
2 F1085-21
3 black, 8 1/2 in.
timestamp 2015-03-30T16:20:35.218Z
vip_member_price 6.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828702439
barcode_type UPC
col1 black
col1_sortorder 402
col2 26 in.
col2_sortorder 1407
col3 [empty string]
color_swatch 0-0-0.jpg
cost 7.7
deal_of_the_week NO
description black, 26 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 48545
list_price 25.25
map NO
mfr_num F126-21
net_weight 0.66
non_member_discount 46
non_member_price 13.64
prop65 NO
ship_rule_desc STD
shipping STD
sku 48545
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.1
ta_dealer_c_price 8.84
ta_price 12.63
text
array
1 48545
2 F126-21
3 black, 26 in.
timestamp 2015-03-30T16:20:35.227Z
vip_member_price 11.11

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828727586
barcode_type UPC
col1 black
col1_sortorder 402
col2 7 in.
col2_sortorder 2191
col3 [empty string]
color_swatch 0-0-0.jpg
cost 4.25
deal_of_the_week NO
description black, 7 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 48685
list_price 13.9
map NO
mfr_num F107-21
net_weight 0.2
non_member_discount 46
non_member_price 7.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 48685
sku_pix NO
supplier_id 1
ta_dealer_a_price 5.56
ta_dealer_c_price 4.87
ta_price 6.95
text
array
1 48685
2 F107-21
3 black, 7 in.
timestamp 2015-03-30T16:20:35.377Z
vip_member_price 6.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828359282
barcode_type UPC
col1 black
col1_sortorder 402
col2 23 in.
col2_sortorder 1314
col3 [empty string]
color_swatch 0-0-0.jpg
cost 7.22
deal_of_the_week NO
description black, 23 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 50589
list_price 23.68
map NO
mfr_num F123-21
net_weight 0.6
non_member_discount 46
non_member_price 12.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 50589
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.47
ta_dealer_c_price 8.29
ta_price 11.84
text
array
1 50589
2 F123-21
3 black, 23 in.
timestamp 2015-03-30T16:20:39.014Z
vip_member_price 10.42

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828340853
barcode_type UPC
col1 black
col1_sortorder 402
col2 39 in.
col2_sortorder 1722
col3 [empty string]
color_swatch 0-0-0.jpg
cost 10.13
deal_of_the_week NO
description black, 39 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 51409
list_price 33.18
map NO
mfr_num F139-21
net_weight 0.92
non_member_discount 46
non_member_price 17.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 51409
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.27
ta_dealer_c_price 11.61
ta_price 16.59
text
array
1 51409
2 F139-21
3 black, 39 in.
timestamp 2015-03-30T16:20:39.491Z
vip_member_price 14.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828717983
barcode_type UPC
col1 black
col1_sortorder 402
col2 36 in.
col2_sortorder 1679
col3 [empty string]
color_swatch 0-0-0.jpg
cost 9.58
deal_of_the_week NO
description black, 36 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 52052
list_price 31.4
map NO
mfr_num F136-21
net_weight 0.88
non_member_discount 46
non_member_price 16.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 52052
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.56
ta_dealer_c_price 10.99
ta_price 15.7
text
array
1 52052
2 F136-21
3 black, 36 in.
timestamp 2015-03-30T16:20:41.027Z
vip_member_price 13.82

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828708790
barcode_type UPC
col1 black
col1_sortorder 402
col2 29 in.
col2_sortorder 1426
col3 [empty string]
color_swatch 0-0-0.jpg
cost 8.28
deal_of_the_week NO
description black, 29 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 53864
list_price 27.14
map NO
mfr_num F129-21
net_weight 0.72
non_member_discount 46
non_member_price 14.66
prop65 NO
ship_rule_desc STD
shipping STD
sku 53864
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.86
ta_dealer_c_price 9.5
ta_price 13.57
text
array
1 53864
2 F129-21
3 black, 29 in.
timestamp 2015-03-30T16:20:46.209Z
vip_member_price 11.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828602623
barcode_type UPC
col1 black
col1_sortorder 402
col2 9 in.
col2_sortorder 2368
col3 [empty string]
color_swatch 0-0-0.jpg
cost 4.81
deal_of_the_week NO
description black, 9 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 55943
list_price 15.75
map NO
mfr_num F109-21
net_weight 0.25
non_member_discount 46
non_member_price 8.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 55943
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.3
ta_dealer_c_price 5.51
ta_price 7.88
text
array
1 55943
2 F109-21
3 black, 9 in.
timestamp 2015-03-30T16:20:47.541Z
vip_member_price 6.93

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828713626
barcode_type UPC
col1 black
col1_sortorder 402
col2 30 in.
col2_sortorder 1607
col3 [empty string]
color_swatch 0-0-0.jpg
cost 8.5
deal_of_the_week NO
description black, 30 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 56937
list_price 27.88
map NO
mfr_num F130-21
net_weight 0.74
non_member_discount 46
non_member_price 15.06
prop65 NO
ship_rule_desc STD
shipping STD
sku 56937
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.15
ta_dealer_c_price 9.76
ta_price 13.94
text
array
1 56937
2 F130-21
3 black, 30 in.
timestamp 2015-03-30T16:20:49.329Z
vip_member_price 12.27

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828636314
barcode_type UPC
col1 black
col1_sortorder 402
col2 16 in.
col2_sortorder 983
col3 [empty string]
color_swatch 0-0-0.jpg
cost 5.98
deal_of_the_week NO
description black, 16 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 57628
list_price 19.58
map NO
mfr_num F116-21
net_weight 0.44
non_member_discount 46
non_member_price 10.57
prop65 NO
ship_rule_desc STD
shipping STD
sku 57628
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.83
ta_dealer_c_price 6.85
ta_price 9.79
text
array
1 57628
2 F116-21
3 black, 16 in.
timestamp 2015-03-30T16:20:49.885Z
vip_member_price 8.62

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828708288
barcode_type UPC
col1 black
col1_sortorder 402
col2 28 in.
col2_sortorder 1421
col3 [empty string]
color_swatch 0-0-0.jpg
cost 8.14
deal_of_the_week NO
description black, 28 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 58185
list_price 26.67
map NO
mfr_num F128-21
net_weight 0.7
non_member_discount 46
non_member_price 14.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 58185
sku_pix YES
supplier_id 1
ta_dealer_a_price 10.67
ta_dealer_c_price 9.33
ta_price 13.34
text
array
1 58185
2 F128-21
3 black, 28 in.
timestamp 2015-03-30T16:20:50.448Z
vip_member_price 11.73

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828701579
barcode_type UPC
col1 black
col1_sortorder 402
col2 6 in.
col2_sortorder 2107
col3 [empty string]
color_swatch 0-0-0.jpg
cost 4
deal_of_the_week NO
description black, 6 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 60948
list_price 13.1
map NO
mfr_num F106-21
net_weight 0.17
non_member_discount 46
non_member_price 7.07
prop65 NO
ship_rule_desc STD
shipping STD
sku 60948
sku_pix NO
supplier_id 1
ta_dealer_a_price 5.24
ta_dealer_c_price 4.59
ta_price 6.55
text
array
1 60948
2 F106-21
3 black, 6 in.
timestamp 2015-03-30T16:20:57.354Z
vip_member_price 5.76

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828730463
barcode_type UPC
col1 black
col1_sortorder 402
col2 19 in.
col2_sortorder 1103
col3 [empty string]
color_swatch 0-0-0.jpg
cost 6.64
deal_of_the_week NO
description black, 19 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 67273
list_price 21.74
map NO
mfr_num F119-21
net_weight 0.52
non_member_discount 46
non_member_price 11.74
prop65 NO
ship_rule_desc STD
shipping STD
sku 67273
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.7
ta_dealer_c_price 7.61
ta_price 10.87
text
array
1 67273
2 F119-21
3 black, 19 in.
timestamp 2015-03-30T16:21:13.504Z
vip_member_price 9.57

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' 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.157.94

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 04:55:25'}
sessionid e030631b60724545b3184058607065162f5d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-gift-ideas&gr=nielsen-bainbridge-metal-frame-kit.html
urltoken CFID=30438756&CFTOKEN=82162207&jsessionid=e030631b60724545b3184058607065162f5d
validationerror [empty string]


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

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

ItemIDList: 25793,41232,79623
AvailQtyList: 0E-12,0E-12,9.000000000000

struct
FLAGS 0
VIP_member_discount 56
barcode 087828708219
barcode_type UPC
col1 black
col1_sortorder 402
col2 5 in.
col2_sortorder 1947
col3 [empty string]
color_swatch 0-0-0.jpg
cost 3.83
deal_of_the_week NO
description black, 5 in.
group_id 935
group_uname nielsen-bainbridge-metal-frame-kit
id 70725
list_price 12.55
map NO
mfr_num F105-21
net_weight 0.14
non_member_discount 46
non_member_price 6.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 70725
sku_pix NO
supplier_id 1
ta_dealer_a_price 5.02
ta_dealer_c_price 4.39
ta_price 6.28
text
array
1 70725
2 F105-21
3 black, 5 in.
timestamp 2015-03-30T16:21:26.506Z
vip_member_price 5.52

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 25793
2 0E-12 41232
3 9.000000000000 79623
CACHED false
EXECUTIONTIME 10
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] = '5446' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: