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

Large Essentials Handmade Stickers

by Sandylion


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901254499
barcode_type UPC
col1 Angels
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description Angels
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 70577
list_price 2.22
map NO
mfr_num PESL223
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 70577
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 70577
2 PESL223
3 Angels
timestamp 2015-04-01T21:27:02.306Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901264986
barcode_type UPC
col1 wine and cheese
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description wine and cheese
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 75190
list_price 2.22
map NO
mfr_num PESL242
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 75190
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 75190
2 PESL242
3 wine and cheese
timestamp 2015-04-01T21:27:13.714Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901235207
barcode_type UPC
col1 tooth fairy
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description tooth fairy
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 75191
list_price 2.22
map NO
mfr_num PESL168
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 75191
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 75191
2 PESL168
3 tooth fairy
timestamp 2015-04-01T21:27:13.716Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901264818
barcode_type UPC
col1 first haircut
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description first haircut
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 75193
list_price 2.22
map NO
mfr_num PESL225
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 75193
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 75193
2 PESL225
3 first haircut
timestamp 2015-04-01T21:27:13.721Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901234309
barcode_type UPC
col1 small pets
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description small pets
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 75194
list_price 2.22
map NO
mfr_num PESL128
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 75194
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 75194
2 PESL128
3 small pets
timestamp 2015-04-01T21:27:13.725Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901264979
barcode_type UPC
col1 tweet tweet
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description tweet tweet
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 75195
list_price 2.22
map NO
mfr_num PESL241
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 75195
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 75195
2 PESL241
3 tweet tweet
timestamp 2015-04-01T21:27:13.73Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901220982
barcode_type UPC
col1 the bride
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description the bride
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 86601
list_price 2.22
map NO
mfr_num PESL120
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 86601
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 86601
2 PESL120
3 the bride
timestamp 2015-04-01T21:27:25.926Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901234873
barcode_type UPC
col1 wedding cake
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description wedding cake
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 86604
list_price 2.22
map NO
mfr_num PESL134
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 86604
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 86604
2 PESL134
3 wedding cake
timestamp 2015-04-01T21:27:25.933Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901244148
barcode_type UPC
col1 bridal shower
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description bridal shower
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 86606
list_price 2.22
map NO
mfr_num PESL196
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 86606
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 86606
2 PESL196
3 bridal shower
timestamp 2015-04-01T21:27:25.936Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901140167
barcode_type UPC
col1 cat
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description cat
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94912
list_price 2.22
map NO
mfr_num PSCBHMLE129
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94912
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94912
2 PSCBHMLE129
3 cat
timestamp 2015-04-01T21:27:36.043Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901140174
barcode_type UPC
col1 dog
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description dog
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94913
list_price 2.22
map NO
mfr_num PSCBHMLE130
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94913
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94913
2 PSCBHMLE130
3 dog
timestamp 2015-04-01T21:27:36.064Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901234316
barcode_type UPC
col1 motorcycle
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description motorcycle
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94916
list_price 2.22
map NO
mfr_num PESL129
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94916
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94916
2 PESL129
3 motorcycle
timestamp 2015-04-01T21:27:36.144Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901217883
barcode_type UPC
col1 ocean fish
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description ocean fish
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94917
list_price 2.22
map NO
mfr_num PESL123
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94917
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94917
2 PESL123
3 ocean fish
timestamp 2015-04-01T21:27:36.16Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901150753
barcode_type UPC
col1 baby girl booties
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description baby girl booties
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94925
list_price 2.22
map NO
mfr_num PSCBHMCLE36
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94925
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94925
2 PSCBHMCLE36
3 baby girl booties
timestamp 2015-04-01T21:27:36.241Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901235009
barcode_type UPC
col1 Father's Day
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description Father's Day
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94928
list_price 2.22
map NO
mfr_num PESL148
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94928
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94928
2 PESL148
3 Father's Day
timestamp 2015-04-01T21:27:36.26Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901235115
barcode_type UPC
col1 military
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description military
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94929
list_price 2.22
map NO
mfr_num PESL159
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94929
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94929
2 PESL159
3 military
timestamp 2015-04-01T21:27:36.295Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901135262
barcode_type UPC
col1 daisy with wire
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description daisy with wire
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94931
list_price 2.22
map NO
mfr_num PSCBHMLE43
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94931
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94931
2 PSCBHMLE43
3 daisy with wire
timestamp 2015-04-01T21:27:36.326Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901135637
barcode_type UPC
col1 purple and pink flowers
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description purple and pink flowers
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94932
list_price 2.22
map NO
mfr_num PSCBHMLE80
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94932
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94932
2 PSCBHMLE80
3 purple and pink flowers
timestamp 2015-04-01T21:27:36.356Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901175077
barcode_type UPC
col1 fun flowers
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description fun flowers
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94933
list_price 2.22
map NO
mfr_num PSCBHMLE191
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94933
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94933
2 PSCBHMLE191
3 fun flowers
timestamp 2015-04-01T21:27:36.386Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901223938
barcode_type UPC
col1 hibiscus flowers
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description hibiscus flowers
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94934
list_price 2.22
map NO
mfr_num PESL94
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94934
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94934
2 PESL94
3 hibiscus flowers
timestamp 2015-04-01T21:27:36.404Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901222504
barcode_type UPC
col1 cream and sugar flowers
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description cream and sugar flowers
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94935
list_price 2.22
map NO
mfr_num PESL118
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94935
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94935
2 PESL118
3 cream and sugar flowers
timestamp 2015-04-01T21:27:36.419Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901223976
barcode_type UPC
col1 black sketch flowers
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description black sketch flowers
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94936
list_price 2.22
map NO
mfr_num PESL98
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94936
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94936
2 PESL98
3 black sketch flowers
timestamp 2015-04-01T21:27:36.434Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901223631
barcode_type UPC
col1 BBQ food
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description BBQ food
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94939
list_price 2.22
map NO
mfr_num PESL140
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94939
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94939
2 PESL140
3 BBQ food
timestamp 2015-04-01T21:27:36.473Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901234347
barcode_type UPC
col1 coffee shop
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description coffee shop
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94940
list_price 2.22
map NO
mfr_num PESL132
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94940
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94940
2 PESL132
3 coffee shop
timestamp 2015-04-01T21:27:36.478Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901193637
barcode_type UPC
col1 silver stars
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description silver stars
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94942
list_price 2.22
map NO
mfr_num PESL16
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94942
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94942
2 PESL16
3 silver stars
timestamp 2015-04-01T21:27:36.485Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901155574
barcode_type UPC
col1 piano
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description piano
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94945
list_price 2.22
map NO
mfr_num PSCBHMLE159
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94945
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94945
2 PSCBHMLE159
3 piano
timestamp 2015-04-01T21:27:36.491Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901193576
barcode_type UPC
col1 formal boy
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description formal boy
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94948
list_price 2.22
map NO
mfr_num PESL10
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94948
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94948
2 PESL10
3 formal boy
timestamp 2015-04-01T21:27:36.495Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901219924
barcode_type UPC
col1 trike, wagon, and ball
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description trike, wagon, and ball
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94955
list_price 2.22
map NO
mfr_num PESL84
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94955
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94955
2 PESL84
3 trike, wagon, and ball
timestamp 2015-04-01T21:27:36.501Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901134937
barcode_type UPC
col1 feminine birthday
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description feminine birthday
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94958
list_price 2.22
map NO
mfr_num PSCBHMLE10
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94958
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94958
2 PSCBHMLE10
3 feminine birthday
timestamp 2015-04-01T21:27:36.506Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901135002
barcode_type UPC
col1 park
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description park
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94959
list_price 2.22
map NO
mfr_num PSCBHMLE17
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94959
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94959
2 PSCBHMLE17
3 park
timestamp 2015-04-01T21:27:36.508Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901235436
barcode_type UPC
col1 pin the tail on the donkey
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description pin the tail on the donkey
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94960
list_price 2.22
map NO
mfr_num PESL185
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94960
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94960
2 PESL185
3 pin the tail on the donkey
timestamp 2015-04-01T21:27:36.513Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12

struct
FLAGS 0
VIP_member_discount 25
barcode 067901234293
barcode_type UPC
col1 horseback riding
col2 [empty string]
col3 [empty string]
cost 1.22
deal_of_the_week NO
description horseback riding
group_id 11130
group_uname sandylion-large-essentials-handmade-stickers
id 94965
list_price 2.22
map NO
mfr_num PESL127
net_weight 0.01
non_member_discount 15
non_member_price 1.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 94965
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.44
ta_dealer_c_price 1.44
ta_price 1.5
text
array
1 94965
2 PESL127
3 horseback riding
timestamp 2015-04-01T21:27:36.527Z
vip_member_price 1.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 0E-12 33030
CACHED false
EXECUTIONTIME 4
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] = '4590' 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.190.170

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030cdbb8b567321151711102a58125c6fa4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=drafting&CatC=t-squares&CatD=sort~1~fp~6-16~&gr=helix-plastic-t-square.html
urltoken CFID=30898708&CFTOKEN=56616756&jsessionid=e030cdbb8b567321151711102a58125c6fa4
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 20:59:14'}
sessionid e030e0134dd9028febed2721f78113693a58
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-new-arrivals&gr=sandylion-large-essentials-handmade-stickers.html
urltoken CFID=30898707&CFTOKEN=81595202&jsessionid=e030e0134dd9028febed2721f78113693a58
validationerror [empty string]


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

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

ItemIDList: 33030
AvailQtyList: 0E-12