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

Mi-Teintes Tinted Paper

by Canson


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955735503
barcode_type EAN
col1 anise
col1_sortorder 128
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 210-197-122.jpg
cost 1.13
deal_of_the_week NO
description anise, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 24638
list_price 2.85
map NO
mfr_num 100511273
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 24638
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 24638
2 100511273
3 anise, 19 in. x 25 in.
timestamp 2015-03-27T14:46:45.951Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955733851
barcode_type EAN
col1 azure
col1_sortorder 283
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 183-197-240.jpg
cost 1.13
deal_of_the_week NO
description azure, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 65780
list_price 2.85
map NO
mfr_num 100511218
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 65780
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 65780
2 100511218
3 azure, 19 in. x 25 in.
timestamp 2015-03-27T14:47:47.805Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
col1 bisque
col1_sortorder 397
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 149-102-47.jpg
cost 1.13
deal_of_the_week NO
description bisque, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 42278
list_price 2.85
map NO
mfr_num 100511256
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 42278
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 42278
2 100511256
3 bisque, 19 in. x 25 in.
timestamp 2015-03-27T14:47:14.794Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736791
barcode_type EAN
col1 bisque
col1_sortorder 397
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 149-102-47.jpg
cost 0.31
deal_of_the_week NO
description bisque, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 66338
list_price 0.8
map NO
mfr_num 100511316
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 66338
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 66338
2 100511316
3 bisque, 8.5 in. x 11 in.
timestamp 2015-03-27T14:47:48.82Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736401
barcode_type EAN
col1 black
col1_sortorder 402
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 0-0-0.jpg
cost 0.31
deal_of_the_week NO
description black, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 27955
list_price 0.8
map NO
mfr_num 100511303
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 27955
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 27955
2 100511303
3 black, 8.5 in. x 11 in.
timestamp 2015-03-27T14:46:51.387Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734605
barcode_type EAN
col1 black
col1_sortorder 402
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.13
deal_of_the_week NO
description black, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 42922
list_price 2.85
map NO
mfr_num 100511243
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 42922
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 42922
2 100511243
3 black, 19 in. x 25 in.
timestamp 2015-03-27T14:47:15.595Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955735299
barcode_type EAN
col1 Bordeaux
col1_sortorder 662
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 240-157-138.jpg
cost 1.13
deal_of_the_week NO
description Bordeaux, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 87244
list_price 2.85
map NO
mfr_num 100511266
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 87244
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 87244
2 100511266
3 Bordeaux, 19 in. x 25 in.
timestamp 2015-03-27T14:48:19.242Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734513
barcode_type EAN
col1 buff
col1_sortorder 843
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 240-202-183.jpg
cost 1.13
deal_of_the_week NO
description buff, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 69760
list_price 2.85
map NO
mfr_num 100511240
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 69760
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 69760
2 100511240
3 buff, 19 in. x 25 in.
timestamp 2015-03-27T14:47:54.874Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955735022
barcode_type EAN
col1 burgundy
col1_sortorder 849
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 119-0-96.jpg
cost 1.13
deal_of_the_week NO
description burgundy, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 17517
list_price 2.85
map NO
mfr_num 100511257
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 17517
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 17517
2 100511257
3 burgundy, 19 in. x 25 in.
timestamp 2015-03-27T14:46:37.382Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736821
barcode_type EAN
col1 burgundy
col1_sortorder 849
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 119-0-96.jpg
cost 0.31
deal_of_the_week NO
description burgundy, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 25548
list_price 0.8
map NO
mfr_num 100511317
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 25548
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 25548
2 100511317
3 burgundy, 8.5 in. x 11 in.
timestamp 2015-03-27T14:46:47.263Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736975
barcode_type EAN
col1 cadmium yellow deep
col1_sortorder 1001
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 240-229-92.jpg
cost 0.31
deal_of_the_week NO
description cadmium yellow deep, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 21891
list_price 0.8
map NO
mfr_num 100511322
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 21891
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 21891
2 100511322
3 cadmium yellow deep, 8.5 in. x 11 in.
timestamp 2015-03-27T14:46:42.688Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955735176
barcode_type EAN
col1 cadmium yellow deep
col1_sortorder 1001
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 240-229-92.jpg
cost 1.13
deal_of_the_week NO
description cadmium yellow deep, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 41077
list_price 2.85
map NO
mfr_num 100511262
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 41077
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 41077
2 100511262
3 cadmium yellow deep, 19 in. x 25 in.
timestamp 2015-03-27T14:47:13.183Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736340
barcode_type EAN
col1 canary
col1_sortorder 1057
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 241-255-122.jpg
cost 0.31
deal_of_the_week NO
description canary, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 33063
list_price 0.8
map NO
mfr_num 100511301
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 33063
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 33063
2 100511301
3 canary, 8.5 in. x 11 in.
timestamp 2015-03-27T14:47:00.968Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
col1 canary
col1_sortorder 1057
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 241-255-122.jpg
cost 1.13
deal_of_the_week NO
description canary, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 57933
list_price 2.85
map NO
mfr_num 100511241
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 57933
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 57933
2 100511241
3 canary, 19 in. x 25 in.
timestamp 2015-03-27T14:47:33.215Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734780
barcode_type EAN
col1 champagne
col1_sortorder 1175
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 240-219-183.jpg
cost 1.13
deal_of_the_week NO
description champagne, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 88069
list_price 2.85
map NO
mfr_num 100511249
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 88069
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 88069
2 100511249
3 champagne, 19 in. x 25 in.
timestamp 2015-03-27T14:48:21.048Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736371
barcode_type EAN
col1 cream
col1_sortorder 1593
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 240-240-183.jpg
cost 0.31
deal_of_the_week NO
description cream, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 14851
list_price 0.8
map NO
mfr_num 100511302
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 14851
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 14851
2 100511302
3 cream, 8.5 in. x 11 in.
timestamp 2015-03-27T14:46:32.459Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
col1 cream
col1_sortorder 1593
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 240-240-183.jpg
cost 1.13
deal_of_the_week NO
description cream, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 42224
list_price 2.85
map NO
mfr_num 100511242
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 42224
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 42224
2 100511242
3 cream, 19 in. x 25 in.
timestamp 2015-03-27T14:47:14.72Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734360
barcode_type EAN
col1 dark gray
col1_sortorder 1706
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 105-105-105.jpg
cost 1.13
deal_of_the_week NO
description dark gray, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 16715
list_price 2.85
map NO
mfr_num 100511235
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 16715
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 16715
2 100511235
3 dark gray, 19 in. x 25 in.
timestamp 2015-03-27T14:46:36.25Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736166
barcode_type EAN
col1 dark gray
col1_sortorder 1706
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 105-105-105.jpg
cost 0.31
deal_of_the_week NO
description dark gray, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 32225
list_price 0.8
map NO
mfr_num 100511295
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 32225
sku_pix NO
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 32225
2 100511295
3 dark gray, 8.5 in. x 11 in.
timestamp 2015-03-27T14:46:58.165Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955733882
barcode_type EAN
col1 dawn pink
col1_sortorder 1780
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 240-214-183.jpg
cost 1.13
deal_of_the_week NO
description dawn pink, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 16800
list_price 2.85
map NO
mfr_num 100511219
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 16800
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 16800
2 100511219
3 dawn pink, 19 in. x 25 in.
timestamp 2015-03-27T14:46:36.371Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734001
barcode_type EAN
col1 egg shell
col1_sortorder 2004
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 251-255-213.jpg
cost 1.13
deal_of_the_week NO
description egg shell, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 16709
list_price 2.85
map NO
mfr_num 100511223
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 16709
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 16709
2 100511223
3 egg shell, 19 in. x 25 in.
timestamp 2015-03-27T14:46:36.222Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734667
barcode_type EAN
col1 felt gray
col1_sortorder 2108
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 120-120-120.jpg
cost 1.13
deal_of_the_week NO
description felt gray, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 87142
list_price 2.85
map NO
mfr_num 100511245
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 87142
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 87142
2 100511245
3 felt gray, 19 in. x 25 in.
timestamp 2015-03-27T14:48:19.152Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736463
barcode_type EAN
col1 felt grey
col1_sortorder 2110
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 120-120-120.jpg
cost 0.31
deal_of_the_week NO
description felt grey, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 41970
list_price 0.8
map NO
mfr_num 100511305
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 41970
sku_pix NO
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 41970
2 100511305
3 felt grey, 8.5 in. x 11 in.
timestamp 2015-03-27T14:47:14.476Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955735862
barcode_type EAN
col1 flannel grey
col1_sortorder 2172
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 150-150-150.jpg
cost 0.31
deal_of_the_week NO
description flannel grey, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 48467
list_price 0.8
map NO
mfr_num 100511285
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 48467
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 48467
2 100511285
3 flannel grey, 8.5 in. x 11 in.
timestamp 2015-03-27T14:47:22.931Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734063
barcode_type EAN
col1 flannel grey
col1_sortorder 2172
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 150-150-150.jpg
cost 1.13
deal_of_the_week NO
description flannel grey, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 71382
list_price 2.85
map NO
mfr_num 100511225
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 71382
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 71382
2 100511225
3 flannel grey, 19 in. x 25 in.
timestamp 2015-03-27T14:47:59.572Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955736616
barcode_type EAN
col1 green
col1_sortorder 2621
col2 8.5 in. x 11 in.
col2_sortorder 2336
col3 [empty string]
color_swatch 122-210-122.jpg
cost 0.31
deal_of_the_week NO
description green, 8.5 in. x 11 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 66340
list_price 0.8
map NO
mfr_num 100511310
net_weight 0.02
non_member_discount 34
non_member_price 0.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 66340
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.36
ta_dealer_c_price 0.36
ta_price 0.6
text
array
1 66340
2 100511310
3 green, 8.5 in. x 11 in.
timestamp 2015-03-27T14:47:48.827Z
vip_member_price 0.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734810
barcode_type EAN
col1 green
col1_sortorder 2621
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 122-210-122.jpg
cost 1.13
deal_of_the_week NO
description green, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 74678
list_price 2.85
map NO
mfr_num 100511250
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 74678
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 74678
2 100511250
3 green, 19 in. x 25 in.
timestamp 2015-03-27T14:48:04.936Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734483
barcode_type EAN
col1 hemp
col1_sortorder 2788
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 240-208-183.jpg
cost 1.13
deal_of_the_week NO
description hemp, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 77447
list_price 2.85
map NO
mfr_num 100511239
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 77447
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 77447
2 100511239
3 hemp, 19 in. x 25 in.
timestamp 2015-03-27T14:48:07.213Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734391
barcode_type EAN
col1 honeysuckle
col1_sortorder 2836
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 240-208-183.jpg
cost 1.13
deal_of_the_week NO
description honeysuckle, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 12711
list_price 2.85
map NO
mfr_num 100511236
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 12711
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 12711
2 100511236
3 honeysuckle, 19 in. x 25 in.
timestamp 2015-03-27T14:46:27.826Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955735350
barcode_type EAN
col1 icy blue
col1_sortorder 2902
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 180-180-180.jpg
cost 1.13
deal_of_the_week NO
description icy blue, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 34550
list_price 2.85
map NO
mfr_num 100511268
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 34550
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 34550
2 100511268
3 icy blue, 19 in. x 25 in.
timestamp 2015-03-27T14:47:04.932Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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

ItemIDList: 33059,47013,51974,66050,87662
AvailQtyList: 51.000000000000,44.000000000000,50.000000000000,29.000000000000,349.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 3148955734186
barcode_type EAN
col1 indigo blue
col1_sortorder 2948
col2 19 in. x 25 in.
col2_sortorder 1107
col3 [empty string]
color_swatch 47-47-149.jpg
cost 1.13
deal_of_the_week NO
description indigo blue, 19 in. x 25 in.
group_id 347
group_uname canson-mi-teintes-tinted-paper
id 45888
list_price 2.85
map NO
mfr_num 100511229
net_weight 0.1
non_member_discount 34
non_member_price 1.87
prop65 NO
ship_rule_desc STD
shipping STD
sku 45888
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.28
ta_dealer_c_price 1.28
ta_price 2.14
text
array
1 45888
2 100511229
3 indigo blue, 19 in. x 25 in.
timestamp 2015-03-27T14:47:19.211Z
vip_member_price 1.6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 51.000000000000 33059
2 44.000000000000 47013
3 50.000000000000 51974
4 29.000000000000 66050
5 349.000000000000 87662
CACHED false
EXECUTIONTIME 1
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] = '200' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.167.135.247

URL: www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e030717a6ef0e27c15982f50693853496020
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=gold-leaf&CatC=c3~tools~&gr=plaid-liquid-leaf.html
urltoken CFID=30041456&CFTOKEN=46151850&jsessionid=e030717a6ef0e27c15982f50693853496020
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 19:01:11'}
sessionid e0304409b10a5be5f5ae7d4b50264f787954
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=scrapbooking&catB=paper-cardstock&CatC=fp~0-1~&gr=canson-mi-teintes-tinted-paper.html
urltoken CFID=30041455&CFTOKEN=73461212&jsessionid=e0304409b10a5be5f5ae7d4b50264f787954
validationerror [empty string]


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

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