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

Archival Ink

by Ranger


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030577
barcode_type UPC
col1 aquamarine
col1_sortorder 191
col2 2 1/2 in. x 3 3/4 in.
col2_sortorder 1125
col3 pad
col3_sortorder 548
color_swatch 48-204-216.jpg
cost 2.56
deal_of_the_week NO
description aquamarine, 2 1/2 in. x 3 3/4 in., pad
group_id 895
group_uname ranger-archival-ink
id 69770
list_price 6
map NO
mfr_num AIP30577
net_weight 0.11
non_member_discount 29
non_member_price 4.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 69770
sku_pix YES
supplier_id 1
ta_dealer_a_price 3
ta_dealer_c_price 3
ta_price 4.5
text
array
1 69770
2 AIP30577
3 aquamarine, 2 1/2 in. x 3 3/4 in., pad
timestamp 2015-03-27T14:47:54.891Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030867
barcode_type UPC
col1 aquamarine
col1_sortorder 191
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 239
color_swatch 48-204-216.jpg
cost 1.49
deal_of_the_week NO
description aquamarine, 1/2 oz., bottle
group_id 895
group_uname ranger-archival-ink
id 69844
list_price 3.49
map NO
mfr_num ARR30867
net_weight 0.05
non_member_discount 29
non_member_price 2.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 69844
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.62
text
array
1 69844
2 ARR30867
3 aquamarine, 1/2 oz., bottle
timestamp 2015-03-27T14:47:55.078Z
vip_member_price 2.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030584
barcode_type UPC
col1 blue violet
col1_sortorder 612
col2 2 1/2 in. x 3 3/4 in.
col2_sortorder 1125
col3 pad
col3_sortorder 548
color_swatch 166-162-199.jpg
cost 2.56
deal_of_the_week NO
description blue violet, 2 1/2 in. x 3 3/4 in., pad
group_id 895
group_uname ranger-archival-ink
id 69791
list_price 6
map NO
mfr_num AIP30584
net_weight 0.11
non_member_discount 29
non_member_price 4.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 69791
sku_pix YES
supplier_id 1
ta_dealer_a_price 3
ta_dealer_c_price 3
ta_price 4.5
text
array
1 69791
2 AIP30584
3 blue violet, 2 1/2 in. x 3 3/4 in., pad
timestamp 2015-03-27T14:47:54.948Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030874
barcode_type UPC
col1 blue violet
col1_sortorder 612
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 239
color_swatch 166-162-199.jpg
cost 1.49
deal_of_the_week NO
description blue violet, 1/2 oz., bottle
group_id 895
group_uname ranger-archival-ink
id 69845
list_price 3.49
map NO
mfr_num ARR30874
net_weight 0.05
non_member_discount 29
non_member_price 2.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 69845
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.62
text
array
1 69845
2 ARR30874
3 blue violet, 1/2 oz., bottle
timestamp 2015-03-27T14:47:55.08Z
vip_member_price 2.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030591
barcode_type UPC
col1 chrome yellow
col1_sortorder 1254
col2 2 1/2 in. x 3 3/4 in.
col2_sortorder 1125
col3 pad
col3_sortorder 548
color_swatch 250-217-101.jpg
cost 2.56
deal_of_the_week NO
description chrome yellow, 2 1/2 in. x 3 3/4 in., pad
group_id 895
group_uname ranger-archival-ink
id 69792
list_price 6
map NO
mfr_num AIP30591
net_weight 0.11
non_member_discount 29
non_member_price 4.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 69792
sku_pix YES
supplier_id 1
ta_dealer_a_price 3
ta_dealer_c_price 3
ta_price 4.5
text
array
1 69792
2 AIP30591
3 chrome yellow, 2 1/2 in. x 3 3/4 in., pad
timestamp 2015-03-27T14:47:54.95Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541031390
barcode_type UPC
col1 chrome yellow
col1_sortorder 1254
col2 5 in. x 6 1/2 in.
col2_sortorder 1957
col3 pad
col3_sortorder 548
color_swatch 250-217-101.jpg
cost 5.12
deal_of_the_week NO
description chrome yellow, 5 in. x 6 1/2 in., pad
group_id 895
group_uname ranger-archival-ink
id 69834
list_price 12
map NO
mfr_num A3P31390
net_weight 0.36
non_member_discount 29
non_member_price 8.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 69834
sku_pix YES
supplier_id 1
ta_dealer_a_price 6
ta_dealer_c_price 6
ta_price 9
text
array
1 69834
2 A3P31390
3 chrome yellow, 5 in. x 6 1/2 in., pad
timestamp 2015-03-27T14:47:55.058Z
vip_member_price 7.31

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030881
barcode_type UPC
col1 chrome yellow
col1_sortorder 1254
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 239
color_swatch 250-217-101.jpg
cost 1.49
deal_of_the_week NO
description chrome yellow, 1/2 oz., bottle
group_id 895
group_uname ranger-archival-ink
id 69848
list_price 3.49
map NO
mfr_num ARR30881
net_weight 0.05
non_member_discount 29
non_member_price 2.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 69848
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.62
text
array
1 69848
2 ARR30881
3 chrome yellow, 1/2 oz., bottle
timestamp 2015-03-27T14:47:55.084Z
vip_member_price 2.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541031444
barcode_type UPC
col1 cobalt
col1_sortorder 1350
col2 2 1/2 in. x 3 3/4 in.
col2_sortorder 1125
col3 pad
col3_sortorder 548
color_swatch 1-44-95.jpg
cost 2.56
deal_of_the_week NO
description cobalt, 2 1/2 in. x 3 3/4 in., pad
group_id 895
group_uname ranger-archival-ink
id 61807
list_price 6
map NO
mfr_num AIP31444
net_weight 0.12
non_member_discount 29
non_member_price 4.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 61807
sku_pix YES
supplier_id 1
ta_dealer_a_price 3
ta_dealer_c_price 3
ta_price 4.5
text
array
1 61807
2 AIP31444
3 cobalt, 2 1/2 in. x 3 3/4 in., pad
timestamp 2015-03-27T14:47:41.213Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030768
barcode_type UPC
col1 cobalt
col1_sortorder 1350
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 239
color_swatch 1-44-95.jpg
cost 1.49
deal_of_the_week NO
description cobalt, 1/2 oz., bottle
group_id 895
group_uname ranger-archival-ink
id 69849
list_price 3.49
map NO
mfr_num ARR30768
net_weight 0.06
non_member_discount 29
non_member_price 2.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 69849
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.62
text
array
1 69849
2 ARR30768
3 cobalt, 1/2 oz., bottle
timestamp 2015-03-27T14:47:55.087Z
vip_member_price 2.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541031451
barcode_type UPC
col1 coffee
col1_sortorder 1418
col2 2 1/2 in. x 3 3/4 in.
col2_sortorder 1125
col3 pad
col3_sortorder 548
color_swatch 108-74-29.jpg
cost 2.56
deal_of_the_week NO
description coffee, 2 1/2 in. x 3 3/4 in., pad
group_id 895
group_uname ranger-archival-ink
id 61812
list_price 6
map NO
mfr_num AIP31451
net_weight 0.11
non_member_discount 29
non_member_price 4.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 61812
sku_pix YES
supplier_id 1
ta_dealer_a_price 3
ta_dealer_c_price 3
ta_price 4.5
text
array
1 61812
2 AIP31451
3 coffee, 2 1/2 in. x 3 3/4 in., pad
timestamp 2015-03-27T14:47:41.217Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030775
barcode_type UPC
col1 coffee
col1_sortorder 1418
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 239
color_swatch 108-74-29.jpg
cost 1.49
deal_of_the_week NO
description coffee, 1/2 oz., bottle
group_id 895
group_uname ranger-archival-ink
id 69851
list_price 3.49
map NO
mfr_num ARR30775
net_weight 0.05
non_member_discount 29
non_member_price 2.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 69851
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.62
text
array
1 69851
2 ARR30775
3 coffee, 1/2 oz., bottle
timestamp 2015-03-27T14:47:55.276Z
vip_member_price 2.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030430
barcode_type UPC
col1 deep purple
col1_sortorder 1825
col2 2 1/2 in. x 3 3/4 in.
col2_sortorder 1125
col3 pad
col3_sortorder 548
color_swatch 121-119-194.jpg
cost 2.56
deal_of_the_week NO
description deep purple, 2 1/2 in. x 3 3/4 in., pad
group_id 895
group_uname ranger-archival-ink
id 69793
list_price 6
map NO
mfr_num AIP30430
net_weight 0.11
non_member_discount 29
non_member_price 4.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 69793
sku_pix YES
supplier_id 1
ta_dealer_a_price 3
ta_dealer_c_price 3
ta_price 4.5
text
array
1 69793
2 AIP30430
3 deep purple, 2 1/2 in. x 3 3/4 in., pad
timestamp 2015-03-27T14:47:54.952Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030478
barcode_type UPC
col1 deep purple
col1_sortorder 1825
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 239
color_swatch 121-119-194.jpg
cost 1.49
deal_of_the_week NO
description deep purple, 1/2 oz., bottle
group_id 895
group_uname ranger-archival-ink
id 69852
list_price 3.49
map NO
mfr_num ARR30478
net_weight 0.04
non_member_discount 29
non_member_price 2.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 69852
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.62
text
array
1 69852
2 ARR30478
3 deep purple, 1/2 oz., bottle
timestamp 2015-03-27T14:47:55.278Z
vip_member_price 2.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030447
barcode_type UPC
col1 emerald green
col1_sortorder 2033
col2 2 1/2 in. x 3 3/4 in.
col2_sortorder 1125
col3 pad
col3_sortorder 548
color_swatch 1-154-74.jpg
cost 2.56
deal_of_the_week NO
description emerald green, 2 1/2 in. x 3 3/4 in., pad
group_id 895
group_uname ranger-archival-ink
id 69794
list_price 6
map NO
mfr_num AIP30447
net_weight 0.11
non_member_discount 29
non_member_price 4.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 69794
sku_pix YES
supplier_id 1
ta_dealer_a_price 3
ta_dealer_c_price 3
ta_price 4.5
text
array
1 69794
2 AIP30447
3 emerald green, 2 1/2 in. x 3 3/4 in., pad
timestamp 2015-03-27T14:47:54.954Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030515
barcode_type UPC
col1 emerald green
col1_sortorder 2033
col2 5 in. x 6 1/2 in.
col2_sortorder 1957
col3 pad
col3_sortorder 548
color_swatch 1-154-74.jpg
cost 5.12
deal_of_the_week NO
description emerald green, 5 in. x 6 1/2 in., pad
group_id 895
group_uname ranger-archival-ink
id 69835
list_price 12
map NO
mfr_num A3P30515
net_weight 0.36
non_member_discount 29
non_member_price 8.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 69835
sku_pix YES
supplier_id 1
ta_dealer_a_price 6
ta_dealer_c_price 6
ta_price 9
text
array
1 69835
2 A3P30515
3 emerald green, 5 in. x 6 1/2 in., pad
timestamp 2015-03-27T14:47:55.061Z
vip_member_price 7.31

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030485
barcode_type UPC
col1 emerald green
col1_sortorder 2033
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 239
color_swatch 1-154-74.jpg
cost 1.49
deal_of_the_week NO
description emerald green, 1/2 oz., bottle
group_id 895
group_uname ranger-archival-ink
id 69855
list_price 3.49
map NO
mfr_num ARR30485
net_weight 0.06
non_member_discount 29
non_member_price 2.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 69855
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.62
text
array
1 69855
2 ARR30485
3 emerald green, 1/2 oz., bottle
timestamp 2015-03-27T14:47:55.284Z
vip_member_price 2.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030607
barcode_type UPC
col1 French ultramarine
col1_sortorder 2326
col2 2 1/2 in. x 3 3/4 in.
col2_sortorder 1125
col3 pad
col3_sortorder 548
color_swatch 152-197-236.jpg
cost 2.56
deal_of_the_week NO
description French ultramarine, 2 1/2 in. x 3 3/4 in., pad
group_id 895
group_uname ranger-archival-ink
id 69795
list_price 6
map NO
mfr_num AIP30607
net_weight 0.11
non_member_discount 29
non_member_price 4.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 69795
sku_pix YES
supplier_id 1
ta_dealer_a_price 3
ta_dealer_c_price 3
ta_price 4.5
text
array
1 69795
2 AIP30607
3 French ultramarine, 2 1/2 in. x 3 3/4 in., pad
timestamp 2015-03-27T14:47:54.96Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030898
barcode_type UPC
col1 French ultramarine
col1_sortorder 2326
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 239
color_swatch 152-197-236.jpg
cost 1.49
deal_of_the_week NO
description French ultramarine, 1/2 oz., bottle
group_id 895
group_uname ranger-archival-ink
id 69854
list_price 3.49
map NO
mfr_num ARR30898
net_weight 0.05
non_member_discount 29
non_member_price 2.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 69854
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.62
text
array
1 69854
2 ARR30898
3 French ultramarine, 1/2 oz., bottle
timestamp 2015-03-27T14:47:55.283Z
vip_member_price 2.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541006701
barcode_type UPC
col1 jet black
col1_sortorder 3155
col2 5 in. x 6 1/2 in.
col2_sortorder 1957
col3 pad
col3_sortorder 548
color_swatch 43-39-36.jpg
cost 5.12
deal_of_the_week NO
description jet black, 5 in. x 6 1/2 in., pad
group_id 895
group_uname ranger-archival-ink
id 60661
list_price 12
map NO
mfr_num A3P06701
net_weight 0.42
non_member_discount 29
non_member_price 8.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 60661
sku_pix YES
supplier_id 1
ta_dealer_a_price 6
ta_dealer_c_price 6
ta_price 9
text
array
1 60661
2 A3P06701
3 jet black, 5 in. x 6 1/2 in., pad
timestamp 2015-03-27T14:47:38.741Z
vip_member_price 7.31

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541031468
barcode_type UPC
col1 jet black
col1_sortorder 3155
col2 2 1/2 in. x 3 3/4 in.
col2_sortorder 1125
col3 pad
col3_sortorder 548
color_swatch 43-39-36.jpg
cost 2.56
deal_of_the_week NO
description jet black, 2 1/2 in. x 3 3/4 in., pad
group_id 895
group_uname ranger-archival-ink
id 67141
list_price 6
map NO
mfr_num AIP31468
net_weight 0.12
non_member_discount 29
non_member_price 4.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 67141
sku_pix YES
supplier_id 1
ta_dealer_a_price 3
ta_dealer_c_price 3
ta_price 4.5
text
array
1 67141
2 AIP31468
3 jet black, 2 1/2 in. x 3 3/4 in., pad
timestamp 2015-03-27T14:47:49.856Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030799
barcode_type UPC
col1 jet black
col1_sortorder 3155
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 239
color_swatch 43-39-36.jpg
cost 1.49
deal_of_the_week NO
description jet black, 1/2 oz., bottle
group_id 895
group_uname ranger-archival-ink
id 69853
list_price 3.49
map NO
mfr_num ARR30799
net_weight 0.05
non_member_discount 29
non_member_price 2.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 69853
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.62
text
array
1 69853
2 ARR30799
3 jet black, 1/2 oz., bottle
timestamp 2015-03-27T14:47:55.28Z
vip_member_price 2.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030805
barcode_type UPC
col1 library green
col1_sortorder 3296
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 239
color_swatch 1-86-67.jpg
cost 1.49
deal_of_the_week NO
description library green, 1/2 oz., bottle
group_id 895
group_uname ranger-archival-ink
id 69857
list_price 3.49
map NO
mfr_num ARR30805
net_weight 0.06
non_member_discount 29
non_member_price 2.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 69857
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.62
text
array
1 69857
2 ARR30805
3 library green, 1/2 oz., bottle
timestamp 2015-03-27T14:47:55.286Z
vip_member_price 2.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541031475
barcode_type UPC
col1 library green
col1_sortorder 3296
col2 2 1/2 in. x 3 3/4 in.
col2_sortorder 1125
col3 pad
col3_sortorder 548
color_swatch 1-86-67.jpg
cost 2.56
deal_of_the_week NO
description library green, 2 1/2 in. x 3 3/4 in., pad
group_id 895
group_uname ranger-archival-ink
id 74211
list_price 6
map NO
mfr_num AIP31475
net_weight 0.12
non_member_discount 29
non_member_price 4.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 74211
sku_pix YES
supplier_id 1
ta_dealer_a_price 3
ta_dealer_c_price 3
ta_price 4.5
text
array
1 74211
2 AIP31475
3 library green, 2 1/2 in. x 3 3/4 in., pad
timestamp 2015-03-27T14:48:04.558Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030614
barcode_type UPC
col1 magenta hue
col1_sortorder 3533
col2 2 1/2 in. x 3 3/4 in.
col2_sortorder 1125
col3 pad
col3_sortorder 548
color_swatch 218-136-184.jpg
cost 2.56
deal_of_the_week NO
description magenta hue, 2 1/2 in. x 3 3/4 in., pad
group_id 895
group_uname ranger-archival-ink
id 69796
list_price 6
map NO
mfr_num AIP30614
net_weight 0.12
non_member_discount 29
non_member_price 4.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 69796
sku_pix YES
supplier_id 1
ta_dealer_a_price 3
ta_dealer_c_price 3
ta_price 4.5
text
array
1 69796
2 AIP30614
3 magenta hue, 2 1/2 in. x 3 3/4 in., pad
timestamp 2015-03-27T14:47:54.964Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030904
barcode_type UPC
col1 magenta hue
col1_sortorder 3533
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 239
color_swatch 218-136-184.jpg
cost 1.49
deal_of_the_week NO
description magenta hue, 1/2 oz., bottle
group_id 895
group_uname ranger-archival-ink
id 69858
list_price 3.49
map NO
mfr_num ARR30904
net_weight 0.05
non_member_discount 29
non_member_price 2.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 69858
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.62
text
array
1 69858
2 ARR30904
3 magenta hue, 1/2 oz., bottle
timestamp 2015-03-27T14:47:55.288Z
vip_member_price 2.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030454
barcode_type UPC
col1 manganese blue
col1_sortorder 3566
col2 2 1/2 in. x 3 3/4 in.
col2_sortorder 1125
col3 pad
col3_sortorder 548
color_swatch 1-120-202.jpg
cost 2.56
deal_of_the_week NO
description manganese blue, 2 1/2 in. x 3 3/4 in., pad
group_id 895
group_uname ranger-archival-ink
id 69799
list_price 6
map NO
mfr_num AIP30454
net_weight 0.12
non_member_discount 29
non_member_price 4.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 69799
sku_pix YES
supplier_id 1
ta_dealer_a_price 3
ta_dealer_c_price 3
ta_price 4.5
text
array
1 69799
2 AIP30454
3 manganese blue, 2 1/2 in. x 3 3/4 in., pad
timestamp 2015-03-27T14:47:54.969Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030539
barcode_type UPC
col1 manganese blue
col1_sortorder 3566
col2 5 in. x 6 1/2 in.
col2_sortorder 1957
col3 pad
col3_sortorder 548
color_swatch 1-120-202.jpg
cost 5.12
deal_of_the_week NO
description manganese blue, 5 in. x 6 1/2 in., pad
group_id 895
group_uname ranger-archival-ink
id 69837
list_price 12
map NO
mfr_num A3P30539
net_weight 0.36
non_member_discount 29
non_member_price 8.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 69837
sku_pix YES
supplier_id 1
ta_dealer_a_price 6
ta_dealer_c_price 6
ta_price 9
text
array
1 69837
2 A3P30539
3 manganese blue, 5 in. x 6 1/2 in., pad
timestamp 2015-03-27T14:47:55.066Z
vip_member_price 7.31

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030492
barcode_type UPC
col1 manganese blue
col1_sortorder 3566
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 239
color_swatch 1-120-202.jpg
cost 1.49
deal_of_the_week NO
description manganese blue, 1/2 oz., bottle
group_id 895
group_uname ranger-archival-ink
id 69861
list_price 3.49
map NO
mfr_num ARR30492
net_weight 0.05
non_member_discount 29
non_member_price 2.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 69861
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.62
text
array
1 69861
2 ARR30492
3 manganese blue, 1/2 oz., bottle
timestamp 2015-03-27T14:47:55.294Z
vip_member_price 2.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541031239
barcode_type UPC
col1 monarch orange
col1_sortorder 3818
col2 2 1/2 in. x 3 3/4 in.
col2_sortorder 1125
col3 pad
col3_sortorder 548
color_swatch 227-73-19.jpg
cost 2.56
deal_of_the_week NO
description monarch orange, 2 1/2 in. x 3 3/4 in., pad
group_id 895
group_uname ranger-archival-ink
id 69804
list_price 6
map NO
mfr_num AIP31239
net_weight 0.11
non_member_discount 29
non_member_price 4.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 69804
sku_pix YES
supplier_id 1
ta_dealer_a_price 3
ta_dealer_c_price 3
ta_price 4.5
text
array
1 69804
2 AIP31239
3 monarch orange, 2 1/2 in. x 3 3/4 in., pad
timestamp 2015-03-27T14:47:54.979Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541031406
barcode_type UPC
col1 monarch orange
col1_sortorder 3818
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 239
color_swatch 227-73-19.jpg
cost 1.49
deal_of_the_week NO
description monarch orange, 1/2 oz., bottle
group_id 895
group_uname ranger-archival-ink
id 69862
list_price 3.49
map NO
mfr_num ARR31406
net_weight 0.05
non_member_discount 29
non_member_price 2.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 69862
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.62
text
array
1 69862
2 ARR31406
3 monarch orange, 1/2 oz., bottle
timestamp 2015-03-27T14:47:55.296Z
vip_member_price 2.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541031482
barcode_type UPC
col1 olive
col1_sortorder 4161
col2 2 1/2 in. x 3 3/4 in.
col2_sortorder 1125
col3 pad
col3_sortorder 548
color_swatch 65-118-48.jpg
cost 2.56
deal_of_the_week NO
description olive, 2 1/2 in. x 3 3/4 in., pad
group_id 895
group_uname ranger-archival-ink
id 39043
list_price 6
map NO
mfr_num AIP31482
net_weight 0.12
non_member_discount 29
non_member_price 4.27
prop65 NO
ship_rule_desc STD
shipping STD
sku 39043
sku_pix YES
supplier_id 1
ta_dealer_a_price 3
ta_dealer_c_price 3
ta_price 4.5
text
array
1 39043
2 AIP31482
3 olive, 2 1/2 in. x 3 3/4 in., pad
timestamp 2015-03-27T14:47:11.273Z
vip_member_price 3.66

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0302cb4d718b68f299f5ad3c65c61164525
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html
urltoken CFID=29594806&CFTOKEN=67966979&jsessionid=e0302cb4d718b68f299f5ad3c65c61164525
validationerror [empty string]


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

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

ItemIDList: 01272
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 39
barcode 789541030829
barcode_type UPC
col1 olive
col1_sortorder 4161
col2 1/2 oz.
col2_sortorder 319
col3 bottle
col3_sortorder 239
color_swatch 65-118-48.jpg
cost 1.49
deal_of_the_week NO
description olive, 1/2 oz., bottle
group_id 895
group_uname ranger-archival-ink
id 69864
list_price 3.49
map NO
mfr_num ARR30829
net_weight 0.06
non_member_discount 29
non_member_price 2.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 69864
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.75
ta_dealer_c_price 1.75
ta_price 2.62
text
array
1 69864
2 ARR30829
3 olive, 1/2 oz., bottle
timestamp 2015-03-27T14:47:55.303Z
vip_member_price 2.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 01272
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] = '9996' 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.167.176.58

URL: www.misterart.com:/index.cfm:module=crafts&catB=fp~4-5~&gr=ranger-archival-ink.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 05:18:26'}
sessionid e0305109dd7c1b3339ec7212461fc1578474
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=craft-hobby&CatC=jewelry-making-beading&CatD=fp~3-22~&gr=design-originals-parachute-cord-craft.html
urltoken CFID=29594805&CFTOKEN=73883147&jsessionid=e0305109dd7c1b3339ec7212461fc1578474
validationerror [empty string]


EndSessionVariables: