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

Pearl Ex Powdered Pigments

by Jacquard


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772164906
barcode_type UPC
col1 varnish
col2 2.25 oz.
col2_sortorder 1229
col3 [empty string]
cost 2.05
deal_of_the_week NO
description varnish, 2.25 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 97491
list_price 4.49
map NO
mfr_num JPX1649
net_weight 0.2
non_member_discount 30
non_member_price 3.14
prop65 NO
ship_rule_desc STD
shipping STD
sku 97491
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.42
ta_dealer_c_price 2.25
ta_price 3.37
text
array
1 97491
2 JPX1649
3 varnish, 2.25 oz.
timestamp 2015-04-01T21:27:42.334Z
vip_member_price 2.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772166009
barcode_type UPC
col1 antique bronze
col1_sortorder 142
col2 0.75 oz.
col2_sortorder 145
col3 [empty string]
color_swatch 164-115-77.jpg
cost 2.75
deal_of_the_week NO
description antique bronze, 0.75 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 77239
list_price 5.99
map NO
mfr_num JPX1660
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 77239
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 77239
2 JPX1660
3 antique bronze, 0.75 oz.
timestamp 2015-04-01T21:27:16.142Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772166108
barcode_type UPC
col1 antique copper
col1_sortorder 147
col2 0.75 oz.
col2_sortorder 145
col3 [empty string]
color_swatch 195-163-47.jpg
cost 2.75
deal_of_the_week NO
description antique copper, 0.75 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 39626
list_price 5.99
map NO
mfr_num JPX1661
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 39626
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 39626
2 JPX1661
3 antique copper, 0.75 oz.
timestamp 2015-04-01T21:26:13.597Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772165903
barcode_type UPC
col1 antique gold
col1_sortorder 148
col2 0.75 oz.
col2_sortorder 145
col3 [empty string]
color_swatch 195-174-138.jpg
cost 2.75
deal_of_the_week NO
description antique gold, 0.75 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 18367
list_price 5.99
map NO
mfr_num JPX1659
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 18367
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 18367
2 JPX1659
3 antique gold, 0.75 oz.
timestamp 2015-04-01T21:25:39.929Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772166207
barcode_type UPC
col1 antique silver
col1_sortorder 158
col2 0.75 oz.
col2_sortorder 145
col3 [empty string]
color_swatch 135-135-135.jpg
cost 2.75
deal_of_the_week NO
description antique silver, 0.75 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 51798
list_price 5.99
map NO
mfr_num JPX1662
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 51798
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 51798
2 JPX1662
3 antique silver, 0.75 oz.
timestamp 2015-04-01T21:26:26.613Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
VIP_member_discount 40
barcode 743772029151
barcode_type UPC
col1 apple green
col1_sortorder 175
col2 0.50 oz.
col2_sortorder 130
col3 [empty string]
color_swatch 127-193-122.jpg
cost 2.75
deal_of_the_week NO
description apple green, 0.50 oz.
flags
array
1 2
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 11730
list_price 5.99
map NO
mfr_num JPX1635
net_weight 0.06
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 11730
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 11730
2 JPX1635
3 apple green, 0.50 oz.
timestamp 2015-04-01T21:25:28.897Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772165804
barcode_type UPC
col1 Aztec gold
col1_sortorder 281
col2 0.75 oz.
col2_sortorder 145
col3 [empty string]
color_swatch 240-225-138.jpg
cost 2.75
deal_of_the_week NO
description Aztec gold, 0.75 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 51070
list_price 5.99
map NO
mfr_num JPX1658
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 51070
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 51070
2 JPX1658
3 Aztec gold, 0.75 oz.
timestamp 2015-04-01T21:26:26.225Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772168904
barcode_type UPC
col1 blue russet
col1_sortorder 599
col2 0.50 oz.
col2_sortorder 130
col3 [empty string]
color_swatch 185-77-210.jpg
cost 2.75
deal_of_the_week NO
description blue russet, 0.50 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 44758
list_price 5.99
map NO
mfr_num JPX1689
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 44758
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 44758
2 JPX1689
3 blue russet, 0.50 oz.
timestamp 2015-04-01T21:26:18.794Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772168300
barcode_type UPC
col1 bright yellow
col1_sortorder 747
col2 0.50 oz.
col2_sortorder 130
col3 [empty string]
color_swatch 255-239-0.jpg
cost 2.75
deal_of_the_week NO
description bright yellow, 0.50 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 56378
list_price 5.99
map NO
mfr_num JPX1683
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 56378
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 56378
2 JPX1683
3 bright yellow, 0.50 oz.
timestamp 2015-04-01T21:26:33.995Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772165606
barcode_type UPC
col1 brilliant gold
col1_sortorder 755
col2 0.75 oz.
col2_sortorder 145
col3 [empty string]
color_swatch 240-232-183.jpg
cost 2.75
deal_of_the_week NO
description brilliant gold, 0.75 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 52196
list_price 5.99
map NO
mfr_num JPX1656
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 52196
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 52196
2 JPX1656
3 brilliant gold, 0.75 oz.
timestamp 2015-04-01T21:26:27.133Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772164005
barcode_type UPC
col1 carbon black
col1_sortorder 1099
col2 0.75 oz.
col2_sortorder 145
col3 [empty string]
color_swatch 0-0-0.jpg
cost 2.75
deal_of_the_week NO
description carbon black, 0.75 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 14135
list_price 5.99
map NO
mfr_num JPX1640
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 14135
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 14135
2 JPX1640
3 carbon black, 0.75 oz.
timestamp 2015-04-01T21:25:34.765Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
VIP_member_discount 40
barcode 743772029106
barcode_type UPC
col1 citrine
col1_sortorder 1294
col2 0.50 oz.
col2_sortorder 130
col3 [empty string]
color_swatch 244-215-123.jpg
cost 2.75
deal_of_the_week NO
description citrine, 0.50 oz.
flags
array
1 2
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 11680
list_price 5.99
map NO
mfr_num JPX1630
net_weight 0.06
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 11680
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 11680
2 JPX1630
3 citrine, 0.50 oz.
timestamp 2015-04-01T21:25:28.761Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
VIP_member_discount 40
barcode 743772029175
barcode_type UPC
col1 dark brown
col1_sortorder 1683
col2 0.50 oz.
col2_sortorder 130
col3 [empty string]
color_swatch 123-83-58.jpg
cost 2.75
deal_of_the_week NO
description dark brown, 0.50 oz.
flags
array
1 2
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 11755
list_price 5.99
map NO
mfr_num JPX1637
net_weight 0.06
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 11755
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 11755
2 JPX1637
3 dark brown, 0.50 oz.
timestamp 2015-04-01T21:25:28.915Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772168003
barcode_type UPC
col1 duo red-blue
col1_sortorder 1975
col2 0.50 oz.
col2_sortorder 130
col3 [empty string]
color_swatch 185-77-210.jpg
cost 2.75
deal_of_the_week NO
description duo red-blue, 0.50 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 56719
list_price 5.99
map NO
mfr_num JPX1680
net_weight 0.05
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 56719
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 56719
2 JPX1680
3 duo red-blue, 0.50 oz.
timestamp 2015-04-01T21:26:34.225Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
VIP_member_discount 40
barcode 743772029168
barcode_type UPC
col1 emerald
col1_sortorder 2031
col2 0.50 oz.
col2_sortorder 130
col3 [empty string]
color_swatch 62-177-144.jpg
cost 2.75
deal_of_the_week NO
description emerald, 0.50 oz.
flags
array
1 2
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 11754
list_price 5.99
map NO
mfr_num JPX1636
net_weight 0.06
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 11754
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 11754
2 JPX1636
3 emerald, 0.50 oz.
timestamp 2015-04-01T21:25:28.912Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772168409
barcode_type UPC
col1 flamingo pink
col1_sortorder 2175
col2 0.50 oz.
col2_sortorder 130
col3 [empty string]
color_swatch 240-138-199.jpg
cost 2.75
deal_of_the_week NO
description flamingo pink, 0.50 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 44477
list_price 5.99
map NO
mfr_num JPX1684
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 44477
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 44477
2 JPX1684
3 flamingo pink, 0.50 oz.
timestamp 2015-04-01T21:26:18.331Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772164500
barcode_type UPC
col1 grey lavender
col1_sortorder 2709
col2 0.75 oz.
col2_sortorder 145
col3 [empty string]
color_swatch 184-138-195.jpg
cost 2.75
deal_of_the_week NO
description grey lavender, 0.75 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 59182
list_price 5.99
map NO
mfr_num JPX1645
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 59182
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 59182
2 JPX1645
3 grey lavender, 0.75 oz.
timestamp 2015-04-01T21:26:38.417Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772167105
barcode_type UPC
col1 interference blue
col1_sortorder 2974
col2 0.50 oz.
col2_sortorder 130
col3 [empty string]
color_swatch 138-138-240.jpg
cost 2.75
deal_of_the_week NO
description interference blue, 0.50 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 23233
list_price 5.99
map NO
mfr_num JPX1671
net_weight 0.05
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 23233
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 23233
2 JPX1671
3 interference blue, 0.50 oz.
timestamp 2015-04-01T21:25:45.334Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772167402
barcode_type UPC
col1 interference gold
col1_sortorder 2977
col2 0.50 oz.
col2_sortorder 130
col3 [empty string]
color_swatch 195-174-47.jpg
cost 2.75
deal_of_the_week NO
description interference gold, 0.50 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 75314
list_price 5.99
map NO
mfr_num JPX1674
net_weight 0.05
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 75314
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 75314
2 JPX1674
3 interference gold, 0.50 oz.
timestamp 2015-04-01T21:27:14.169Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772167204
barcode_type UPC
col1 interference green
col1_sortorder 2979
col2 0.50 oz.
col2_sortorder 130
col3 [empty string]
color_swatch 138-195-177.jpg
cost 2.75
deal_of_the_week NO
description interference green, 0.50 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 59483
list_price 5.99
map NO
mfr_num JPX1672
net_weight 0.05
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 59483
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 59483
2 JPX1672
3 interference green, 0.50 oz.
timestamp 2015-04-01T21:26:39.631Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772167006
barcode_type UPC
col1 interference red
col1_sortorder 2990
col2 0.50 oz.
col2_sortorder 130
col3 [empty string]
color_swatch 179-138-195.jpg
cost 2.75
deal_of_the_week NO
description interference red, 0.50 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 26809
list_price 5.99
map NO
mfr_num JPX1670
net_weight 0.05
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 26809
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 26809
2 JPX1670
3 interference red, 0.50 oz.
timestamp 2015-04-01T21:25:50.066Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772167303
barcode_type UPC
col1 interference violet
col1_sortorder 2993
col2 0.50 oz.
col2_sortorder 130
col3 [empty string]
color_swatch 166-92-195.jpg
cost 2.75
deal_of_the_week NO
description interference violet, 0.50 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 60982
list_price 5.99
map NO
mfr_num JPX1673
net_weight 0.05
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 60982
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 60982
2 JPX1673
3 interference violet, 0.50 oz.
timestamp 2015-04-01T21:26:44.331Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772165200
barcode_type UPC
col1 macropearl
col1_sortorder 3522
col2 0.75 oz.
col2_sortorder 145
col3 [empty string]
color_swatch 255-249-213.jpg
cost 2.75
deal_of_the_week NO
description macropearl, 0.75 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 39224
list_price 5.99
map NO
mfr_num JPX1652
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 39224
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 39224
2 JPX1652
3 macropearl, 0.75 oz.
timestamp 2015-04-01T21:26:13.397Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
VIP_member_discount 40
barcode 743772029120
barcode_type UPC
col1 magenta
col1_sortorder 3535
col2 0.50 oz.
col2_sortorder 130
col3 [empty string]
color_swatch 225-92-121.jpg
cost 2.75
deal_of_the_week NO
description magenta, 0.50 oz.
flags
array
1 2
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 11692
list_price 5.99
map NO
mfr_num JPX1632
net_weight 0.06
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 11692
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 11692
2 JPX1632
3 magenta, 0.50 oz.
timestamp 2015-04-01T21:25:28.794Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772165002
barcode_type UPC
col1 micropearl
col1_sortorder 3755
col2 0.75 oz.
col2_sortorder 145
col3 [empty string]
color_swatch 255-252-213.jpg
cost 2.75
deal_of_the_week NO
description micropearl, 0.75 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 66051
list_price 5.99
map NO
mfr_num JPX1650
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 66051
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 66051
2 JPX1650
3 micropearl, 0.75 oz.
timestamp 2015-04-01T21:26:50.598Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772164609
barcode_type UPC
col1 mink
col1_sortorder 3786
col2 0.75 oz.
col2_sortorder 145
col3 [empty string]
color_swatch 165-165-165.jpg
cost 2.75
deal_of_the_week NO
description mink, 0.75 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 80210
list_price 5.99
map NO
mfr_num JPX1646
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 80210
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 80210
2 JPX1646
3 mink, 0.75 oz.
timestamp 2015-04-01T21:27:19.771Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772168805
barcode_type UPC
col1 misty lavender
col1_sortorder 3808
col2 0.50 oz.
col2_sortorder 130
col3 [empty string]
color_swatch 81-47-195.jpg
cost 2.75
deal_of_the_week NO
description misty lavender, 0.50 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 32084
list_price 5.99
map NO
mfr_num JPX1688
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 32084
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 32084
2 JPX1688
3 misty lavender, 0.50 oz.
timestamp 2015-04-01T21:25:58.713Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772165101
barcode_type UPC
col1 pearl white
col1_sortorder 4488
col2 0.75 oz.
col2_sortorder 145
col3 [empty string]
color_swatch 255-255-213.jpg
cost 2.75
deal_of_the_week NO
description pearl white, 0.75 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 68470
list_price 5.99
map NO
mfr_num JPX1651
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 68470
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 68470
2 JPX1651
3 pearl white, 0.75 oz.
timestamp 2015-04-01T21:26:55.374Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772164302
barcode_type UPC
col1 pink gold
col1_sortorder 4741
col2 0.75 oz.
col2_sortorder 145
col3 [empty string]
color_swatch 240-194-183.jpg
cost 2.75
deal_of_the_week NO
description pink gold, 0.75 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 41307
list_price 5.99
map NO
mfr_num JPX1643
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 41307
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 41307
2 JPX1643
3 pink gold, 0.75 oz.
timestamp 2015-04-01T21:26:14.779Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772164104
barcode_type UPC
col1 pumpkin orange
col1_sortorder 4921
col2 0.75 oz.
col2_sortorder 145
col3 [empty string]
color_swatch 195-95-47.jpg
cost 2.75
deal_of_the_week NO
description pumpkin orange, 0.75 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 36732
list_price 5.99
map NO
mfr_num JPX1641
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 36732
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 36732
2 JPX1641
3 pumpkin orange, 0.75 oz.
timestamp 2015-04-01T21:26:10.846Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772165309
barcode_type UPC
col1 red russet
col1_sortorder 5146
col2 0.75 oz.
col2_sortorder 145
col3 [empty string]
color_swatch 164-0-90.jpg
cost 2.75
deal_of_the_week NO
description red russet, 0.75 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 85315
list_price 5.99
map NO
mfr_num JPX1653
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 85315
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 85315
2 JPX1653
3 red russet, 0.75 oz.
timestamp 2015-04-01T21:27:24.453Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e0305c54d01342a3f8e43e4b446511416615
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html
urltoken CFID=30879729&CFTOKEN=70134881&jsessionid=e0305c54d01342a3f8e43e4b446511416615
validationerror [empty string]


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

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

ItemIDList: 39948
AvailQtyList: 9.000000000000

struct
FLAGS 0
VIP_member_discount 40
barcode 743772164401
barcode_type UPC
col1 reflex violet
col1_sortorder 5176
col2 0.75 oz.
col2_sortorder 145
col3 [empty string]
color_swatch 114-0-164.jpg
cost 2.75
deal_of_the_week NO
description reflex violet, 0.75 oz.
group_id 776
group_uname jacquard-pearl-ex-powdered-pigments
id 38193
list_price 5.99
map NO
mfr_num JPX1644
net_weight 0.08
non_member_discount 30
non_member_price 4.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 38193
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.23
ta_dealer_c_price 3
ta_price 4.49
text
array
1 38193
2 JPX1644
3 reflex violet, 0.75 oz.
timestamp 2015-04-01T21:26:12.306Z
vip_member_price 3.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 9.000000000000 39948
CACHED false
EXECUTIONTIME 4
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5656' 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.161.234.150

URL: www.misterart.com:/index.cfm:module=crafts&catB=stamps-embossing&CatC=fb~jacquard~&gr=jacquard-pearl-ex-powdered-pigments.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 19:27:06'}
sessionid e030ad6555b81009348e5f3310473a572c1b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=activity-books&CatC=fb~dover~fp~0-11~&gr=dover-color-your-own-zoo-animals-stickers.html
urltoken CFID=30879730&CFTOKEN=56790089&jsessionid=e030ad6555b81009348e5f3310473a572c1b
validationerror [empty string]


EndSessionVariables: