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

Ultrafine Transparent Glitter

by Art Institute Glitter


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048252017
barcode_type UPC
col1 abyss
col1_sortorder 45
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 122-122-210.jpg
cost 3.04
deal_of_the_week NO
description abyss, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 55838
list_price 4.98
map NO
mfr_num 201
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 55838
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 55838
2 201
3 abyss, 1/2 oz., jar
timestamp 2015-03-31T17:53:49.06Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048250983
barcode_type UPC
col1 amethyst
col1_sortorder 115
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 149-47-135.jpg
cost 3.04
deal_of_the_week NO
description amethyst, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 75895
list_price 4.98
map NO
mfr_num 98
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 75895
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 75895
2 98
3 amethyst, 1/2 oz., jar
timestamp 2015-03-31T17:54:28.094Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048250860
barcode_type UPC
col1 angel dust
col1_sortorder 126
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 255-255-255.jpg
cost 3.04
deal_of_the_week NO
description angel dust, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 16350
list_price 4.98
map NO
mfr_num 86
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 16350
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 16350
2 86
3 angel dust, 1/2 oz., jar
timestamp 2015-03-31T17:52:47.535Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048251652
barcode_type UPC
col1 autumn
col1_sortorder 259
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 149-92-47.jpg
cost 3.04
deal_of_the_week NO
description autumn, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 44378
list_price 4.98
map NO
mfr_num 165
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 44378
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 44378
2 165
3 autumn, 1/2 oz., jar
timestamp 2015-03-31T17:53:29.648Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048251492
barcode_type UPC
col1 azure
col1_sortorder 283
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 185-77-210.jpg
cost 3.04
deal_of_the_week NO
description azure, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 11133
list_price 4.98
map NO
mfr_num 149
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 11133
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 11133
2 149
3 azure, 1/2 oz., jar
timestamp 2015-03-31T17:52:36.753Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048251010
barcode_type UPC
col1 baby's breath
col1_sortorder 297
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 243-213-255.jpg
cost 3.04
deal_of_the_week NO
description baby's breath, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 13772
list_price 4.98
map NO
mfr_num 101
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 13772
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 13772
2 101
3 baby's breath, 1/2 oz., jar
timestamp 2015-03-31T17:52:41.137Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048250921
barcode_type UPC
col1 bananan
col1_sortorder 316
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 240-213-47.jpg
cost 3.04
deal_of_the_week NO
description bananan, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 59154
list_price 4.98
map NO
mfr_num 92
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 59154
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 59154
2 92
3 bananan, 1/2 oz., jar
timestamp 2015-03-31T17:53:52.97Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048252055
barcode_type UPC
col1 berry pie
col1_sortorder 378
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 164-0-129.jpg
cost 3.04
deal_of_the_week NO
description berry pie, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 74757
list_price 4.98
map NO
mfr_num 205
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 74757
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 74757
2 205
3 berry pie, 1/2 oz., jar
timestamp 2015-03-31T17:54:26.711Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048251683
barcode_type UPC
col1 black light
col1_sortorder 450
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 70-47-149.jpg
cost 3.04
deal_of_the_week NO
description black light, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 59439
list_price 4.98
map NO
mfr_num 168
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 59439
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 59439
2 168
3 black light, 1/2 oz., jar
timestamp 2015-03-31T17:53:53.444Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048251454
barcode_type UPC
col1 blue boy
col1_sortorder 558
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 77-120-255.jpg
cost 3.04
deal_of_the_week NO
description blue boy, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 66635
list_price 4.98
map NO
mfr_num 145
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 66635
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 66635
2 145
3 blue boy, 1/2 oz., jar
timestamp 2015-03-31T17:54:11.226Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048251201
barcode_type UPC
col1 blue rain
col1_sortorder 593
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 223-213-255.jpg
cost 3.04
deal_of_the_week NO
description blue rain, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 62896
list_price 4.98
map NO
mfr_num 120
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 62896
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 62896
2 120
3 blue rain, 1/2 oz., jar
timestamp 2015-03-31T17:54:04.57Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048250969
barcode_type UPC
col1 blue water
col1_sortorder 617
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 122-172-255.jpg
cost 3.04
deal_of_the_week NO
description blue water, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 86580
list_price 4.98
map NO
mfr_num 96
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 86580
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 86580
2 96
3 blue water, 1/2 oz., jar
timestamp 2015-03-31T17:54:39.783Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048252123
barcode_type UPC
col1 blue whale
col1_sortorder 618
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 77-120-255.jpg
cost 3.04
deal_of_the_week NO
description blue whale, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 37679
list_price 4.98
map NO
mfr_num 212
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 37679
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 37679
2 212
3 blue whale, 1/2 oz., jar
timestamp 2015-03-31T17:53:20.872Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048251461
barcode_type UPC
col1 bonnie blue
col1_sortorder 659
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 122-122-255.jpg
cost 3.04
deal_of_the_week NO
description bonnie blue, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 58480
list_price 4.98
map NO
mfr_num 146
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 58480
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 58480
2 146
3 bonnie blue, 1/2 oz., jar
timestamp 2015-03-31T17:53:52.28Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048251515
barcode_type UPC
col1 butterfly
col1_sortorder 903
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 149-92-47.jpg
cost 3.04
deal_of_the_week NO
description butterfly, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 67753
list_price 4.98
map NO
mfr_num 151
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 67753
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 67753
2 151
3 butterfly, 1/2 oz., jar
timestamp 2015-03-31T17:54:13.011Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048251720
barcode_type UPC
col1 calypso
col1_sortorder 1047
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 47-47-195.jpg
cost 3.04
deal_of_the_week NO
description calypso, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 24586
list_price 4.98
map NO
mfr_num 172
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 24586
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 24586
2 172
3 calypso, 1/2 oz., jar
timestamp 2015-03-31T17:53:00.307Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048251645
barcode_type UPC
col1 chrysalis
col1_sortorder 1277
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 166-210-0.jpg
cost 3.04
deal_of_the_week NO
description chrysalis, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 35261
list_price 4.98
map NO
mfr_num 164
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 35261
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 35261
2 164
3 chrysalis, 1/2 oz., jar
timestamp 2015-03-31T17:53:17.432Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048251423
barcode_type UPC
col1 coral reef
col1_sortorder 1551
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 210-0-72.jpg
cost 3.04
deal_of_the_week NO
description coral reef, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 16142
list_price 4.98
map NO
mfr_num 142
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 16142
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 16142
2 142
3 coral reef, 1/2 oz., jar
timestamp 2015-03-31T17:52:47.337Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048250853
barcode_type UPC
col1 crystal
col1_sortorder 1627
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 255-255-255.jpg
cost 3.04
deal_of_the_week NO
description crystal, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 72938
list_price 4.98
map NO
mfr_num 85
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 72938
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 72938
2 85
3 crystal, 1/2 oz., jar
timestamp 2015-03-31T17:54:24.152Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048252031
barcode_type UPC
col1 eggplant
col1_sortorder 2011
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 140-0-164.jpg
cost 3.04
deal_of_the_week NO
description eggplant, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 36144
list_price 4.98
map NO
mfr_num 203
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 36144
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 36144
2 203
3 eggplant, 1/2 oz., jar
timestamp 2015-03-31T17:53:18.849Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048252086
barcode_type UPC
col1 fauna
col1_sortorder 2107
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 240-232-183.jpg
cost 3.04
deal_of_the_week NO
description fauna, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 25443
list_price 4.98
map NO
mfr_num 208
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 25443
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 25443
2 208
3 fauna, 1/2 oz., jar
timestamp 2015-03-31T17:53:01.438Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048251973
barcode_type UPC
col1 flax
col1_sortorder 2192
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 240-202-138.jpg
cost 3.04
deal_of_the_week NO
description flax, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 14112
list_price 4.98
map NO
mfr_num 197
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 14112
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 14112
2 197
3 flax, 1/2 oz., jar
timestamp 2015-03-31T17:52:42.417Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048252000
barcode_type UPC
col1 fog
col1_sortorder 2240
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 167-138-195.jpg
cost 3.04
deal_of_the_week NO
description fog, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 79604
list_price 4.98
map NO
mfr_num 200
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 79604
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 79604
2 200
3 fog, 1/2 oz., jar
timestamp 2015-03-31T17:54:32.65Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048251058
barcode_type UPC
col1 forget me not
col1_sortorder 2258
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 168-200-255.jpg
cost 3.04
deal_of_the_week NO
description forget me not, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 27317
list_price 4.98
map NO
mfr_num 105
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 27317
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 27317
2 105
3 forget me not, 1/2 oz., jar
timestamp 2015-03-31T17:53:04.616Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048252109
barcode_type UPC
col1 fossil
col1_sortorder 2261
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 240-240-240.jpg
cost 3.04
deal_of_the_week NO
description fossil, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 36831
list_price 4.98
map NO
mfr_num 210
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 36831
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 36831
2 210
3 fossil, 1/2 oz., jar
timestamp 2015-03-31T17:53:19.736Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048252161
barcode_type UPC
col1 gazelle
col1_sortorder 2389
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 225-225-225.jpg
cost 3.04
deal_of_the_week NO
description gazelle, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 73164
list_price 4.98
map NO
mfr_num 216
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 73164
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 73164
2 216
3 gazelle, 1/2 oz., jar
timestamp 2015-03-31T17:54:24.314Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048251713
barcode_type UPC
col1 gelina
col1_sortorder 2392
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 99-47-149.jpg
cost 3.04
deal_of_the_week NO
description gelina, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 38953
list_price 4.98
map NO
mfr_num 171
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 38953
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 38953
2 171
3 gelina, 1/2 oz., jar
timestamp 2015-03-31T17:53:23.215Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048252116
barcode_type UPC
col1 glacier
col1_sortorder 2421
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 188-168-255.jpg
cost 3.04
deal_of_the_week NO
description glacier, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 30733
list_price 4.98
map NO
mfr_num 211
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 30733
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 30733
2 211
3 glacier, 1/2 oz., jar
timestamp 2015-03-31T17:53:09.024Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048251980
barcode_type UPC
col1 green briar
col1_sortorder 2633
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 63-119-0.jpg
cost 3.04
deal_of_the_week NO
description green briar, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 40942
list_price 4.98
map NO
mfr_num 198
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 40942
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 40942
2 198
3 green briar, 1/2 oz., jar
timestamp 2015-03-31T17:53:24.353Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048250877
barcode_type UPC
col1 hot kiss
col1_sortorder 2875
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 255-0-130.jpg
cost 3.04
deal_of_the_week NO
description hot kiss, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 82802
list_price 4.98
map NO
mfr_num 87
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 82802
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 82802
2 87
3 hot kiss, 1/2 oz., jar
timestamp 2015-03-31T17:54:36.686Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048251034
barcode_type UPC
col1 jonquil
col1_sortorder 3166
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 240-240-240.jpg
cost 3.04
deal_of_the_week NO
description jonquil, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 49224
list_price 4.98
map NO
mfr_num 103
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 49224
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 49224
2 103
3 jonquil, 1/2 oz., jar
timestamp 2015-03-31T17:53:35.812Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
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] = '3391' 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.159.215.49

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e030883a4f2e4b4da7d6191e37a471052461
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=writing-printer-paper&CatC=fp~4-6~&gr=strathmore-translucent-vellum.html
urltoken CFID=30786560&CFTOKEN=74950975&jsessionid=e030883a4f2e4b4da7d6191e37a471052461
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 12:01:43'}
sessionid e0306f06ea9eb3da3b16564f14fd5f186c6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~4-5~&gr=art-institute-glitter-ultrafine-transparent-glitter.html
urltoken CFID=30786559&CFTOKEN=14253327&jsessionid=e0306f06ea9eb3da3b16564f14fd5f186c6c
validationerror [empty string]


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

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

ItemIDList: 58789,90782
AvailQtyList: 6.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 762048250990
barcode_type UPC
col1 juicy fruit
col1_sortorder 3171
col2 1/2 oz.
col2_sortorder 319
col3 jar
col3_sortorder 350
color_swatch 255-111-77.jpg
cost 3.04
deal_of_the_week NO
description juicy fruit, 1/2 oz., jar
group_id 8184
group_uname art-institute-glitter-ultrafine-transparent-glitter
id 31562
list_price 4.98
map NO
mfr_num 99
net_weight 0.56
non_member_discount 10
non_member_price 4.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 31562
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.74
ta_dealer_c_price 3.74
ta_price 4.98
text
array
1 31562
2 99
3 juicy fruit, 1/2 oz., jar
timestamp 2015-03-31T17:53:09.99Z
vip_member_price 3.98

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 58789
2 18.000000000000 90782
CACHED false
EXECUTIONTIME 9
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[