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

ChromaTemp Artists' Tempera Paint

by Chroma Inc.


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020001
barcode_type UPC
col1 black
col1_sortorder 402
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-0-0.jpg
cost 0.7
deal_of_the_week NO
description black, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 13299
list_price 2.32
map NO
mfr_num 2000
net_weight 0.16
non_member_discount 40
non_member_price 1.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 13299
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.81
ta_dealer_c_price 0.81
ta_price 1.21
text
array
1 13299
2 2000
3 black, 2 oz.
timestamp 2015-03-26T14:50:30.763Z
vip_member_price 1.16

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024009
barcode_type UPC
col1 black
col1_sortorder 402
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 0-0-0.jpg
cost 2.07
deal_of_the_week NO
description black, 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 16246
list_price 5.66
map NO
mfr_num 2400
net_weight 1.2
non_member_discount 40
non_member_price 3.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 16246
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.26
ta_dealer_c_price 2.26
ta_price 3.4
text
array
1 16246
2 2400
3 black, 16.9 oz.
timestamp 2015-03-26T14:50:36.498Z
vip_member_price 2.83

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022005
barcode_type UPC
col1 black
col1_sortorder 402
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.27
deal_of_the_week NO
description black, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 17534
list_price 4
map NO
mfr_num 2200
net_weight 0.74
non_member_discount 40
non_member_price 2.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 17534
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.08
text
array
1 17534
2 2200
3 black, 8 oz.
timestamp 2015-03-26T14:50:38.513Z
vip_member_price 2

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200026003
barcode_type UPC
col1 black
col1_sortorder 402
col2 32 oz.
col2_sortorder 1660
col3 [empty string]
color_swatch 0-0-0.jpg
cost 3.44
deal_of_the_week NO
description black, 32 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 37271
list_price 10.49
map NO
mfr_num 2600
net_weight 2.32
non_member_discount 40
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 37271
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.78
ta_dealer_c_price 3.78
ta_price 5.66
text
array
1 37271
2 2600
3 black, 32 oz.
timestamp 2015-03-26T14:51:07.301Z
vip_member_price 5.25

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200029004
barcode_type UPC
col1 black
col1_sortorder 402
col2 gallon
col2_sortorder 2486
col3 [empty string]
color_swatch 0-0-0.jpg
cost 10.92
deal_of_the_week NO
description black, gallon
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 70064
list_price 32.79
map NO
mfr_num 2900
net_weight 9.1
non_member_discount 40
non_member_price 19.67
prop65 NO
ship_rule_desc STD
shipping STD
sku 70064
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.13
ta_dealer_c_price 12.13
ta_price 18.03
text
array
1 70064
2 2900
3 black, gallon
timestamp 2015-03-26T14:51:57.637Z
vip_member_price 16.4

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024016
barcode_type UPC
col1 blue
col1_sortorder 542
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 0-0-164.jpg
cost 2.07
deal_of_the_week NO
description blue, 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 14115
list_price 5.66
map NO
mfr_num 2401
net_weight 1.2
non_member_discount 40
non_member_price 3.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 14115
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.26
ta_dealer_c_price 2.26
ta_price 3.4
text
array
1 14115
2 2401
3 blue, 16.9 oz.
timestamp 2015-03-26T14:50:32.581Z
vip_member_price 2.83

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020018
barcode_type UPC
col1 blue
col1_sortorder 542
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-0-164.jpg
cost 0.7
deal_of_the_week NO
description blue, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 24683
list_price 2.32
map NO
mfr_num 2001
net_weight 0.16
non_member_discount 40
non_member_price 1.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 24683
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.81
ta_dealer_c_price 0.81
ta_price 1.21
text
array
1 24683
2 2001
3 blue, 2 oz.
timestamp 2015-03-26T14:50:47.745Z
vip_member_price 1.16

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022012
barcode_type UPC
col1 blue
col1_sortorder 542
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 0-0-164.jpg
cost 1.27
deal_of_the_week NO
description blue, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 42156
list_price 4
map NO
mfr_num 2201
net_weight 0.74
non_member_discount 40
non_member_price 2.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 42156
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.08
text
array
1 42156
2 2201
3 blue, 8 oz.
timestamp 2015-03-26T14:51:11.822Z
vip_member_price 2

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024023
barcode_type UPC
col1 brown
col1_sortorder 798
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 119-60-0.jpg
cost 2.07
deal_of_the_week NO
description brown, 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 55946
list_price 5.66
map NO
mfr_num 2402
net_weight 1.2
non_member_discount 40
non_member_price 3.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 55946
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.26
ta_dealer_c_price 2.26
ta_price 3.4
text
array
1 55946
2 2402
3 brown, 16.9 oz.
timestamp 2015-03-26T14:51:32.171Z
vip_member_price 2.83

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020025
barcode_type UPC
col1 brown
col1_sortorder 798
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 119-60-0.jpg
cost 0.7
deal_of_the_week NO
description brown, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 83981
list_price 2.32
map NO
mfr_num 2002
net_weight 0.16
non_member_discount 40
non_member_price 1.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 83981
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.81
ta_dealer_c_price 0.81
ta_price 1.21
text
array
1 83981
2 2002
3 brown, 2 oz.
timestamp 2015-03-26T14:52:16.206Z
vip_member_price 1.16

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022029
barcode_type UPC
col1 brown
col1_sortorder 798
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 119-60-0.jpg
cost 1.27
deal_of_the_week NO
description brown, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 87224
list_price 4
map NO
mfr_num 2202
net_weight 0.74
non_member_discount 40
non_member_price 2.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 87224
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.08
text
array
1 87224
2 2202
3 brown, 8 oz.
timestamp 2015-03-26T14:52:19.042Z
vip_member_price 2

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200026027
barcode_type UPC
col1 brown
col1_sortorder 798
col2 32 oz.
col2_sortorder 1660
col3 [empty string]
color_swatch 119-60-0.jpg
cost 3.44
deal_of_the_week NO
description brown, 32 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 87900
list_price 10.46
map NO
mfr_num 2602
net_weight 2.32
non_member_discount 40
non_member_price 6.28
prop65 NO
ship_rule_desc STD
shipping STD
sku 87900
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.77
ta_dealer_c_price 3.77
ta_price 5.65
text
array
1 87900
2 2602
3 brown, 32 oz.
timestamp 2015-03-26T14:52:19.61Z
vip_member_price 5.23

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022142
barcode_type UPC
col1 fluorescent blue
col1_sortorder 2210
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 0-86-255.jpg
cost 1.65
deal_of_the_week NO
description fluorescent blue, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 43924
list_price 4.93
map NO
mfr_num 2214
net_weight 0.74
non_member_discount 40
non_member_price 2.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 43924
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.73
ta_dealer_c_price 1.73
ta_price 2.56
text
array
1 43924
2 2214
3 fluorescent blue, 8 oz.
timestamp 2015-03-26T14:51:13.513Z
vip_member_price 2.47

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020148
barcode_type UPC
col1 fluorescent blue
col1_sortorder 2210
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-86-255.jpg
cost 0.92
deal_of_the_week NO
description fluorescent blue, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 70900
list_price 2.87
map NO
mfr_num 2014
net_weight 0.16
non_member_discount 40
non_member_price 1.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 70900
sku_pix YES
supplier_id 1
ta_dealer_a_price 1
ta_dealer_c_price 1
ta_price 1.49
text
array
1 70900
2 2014
3 fluorescent blue, 2 oz.
timestamp 2015-03-26T14:51:59.074Z
vip_member_price 1.44

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024146
barcode_type UPC
col1 fluorescent blue
col1_sortorder 2210
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 0-86-255.jpg
cost 3.09
deal_of_the_week NO
description fluorescent blue, 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 80888
list_price 7.52
map NO
mfr_num 2414
net_weight 1.3
non_member_discount 40
non_member_price 4.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 80888
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.38
ta_dealer_c_price 3.38
ta_price 4.89
text
array
1 80888
2 2414
3 fluorescent blue, 16.9 oz.
timestamp 2015-03-26T14:52:13.876Z
vip_member_price 3.76

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022159
barcode_type UPC
col1 fluorescent green
col1_sortorder 2215
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 177-210-77.jpg
cost 1.65
deal_of_the_week NO
description fluorescent green, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 26979
list_price 4.93
map NO
mfr_num 2215
net_weight 0.74
non_member_discount 40
non_member_price 2.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 26979
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.73
ta_dealer_c_price 1.73
ta_price 2.56
text
array
1 26979
2 2215
3 fluorescent green, 8 oz.
timestamp 2015-03-26T14:50:50.595Z
vip_member_price 2.47

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024153
barcode_type UPC
col1 fluorescent green
col1_sortorder 2215
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 177-210-77.jpg
cost 3.09
deal_of_the_week NO
description fluorescent green, 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 47508
list_price 7.52
map NO
mfr_num 2415
net_weight 1.3
non_member_discount 40
non_member_price 4.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 47508
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.38
ta_dealer_c_price 3.38
ta_price 4.89
text
array
1 47508
2 2415
3 fluorescent green, 16.9 oz.
timestamp 2015-03-26T14:51:19.604Z
vip_member_price 3.76

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020155
barcode_type UPC
col1 fluorescent green
col1_sortorder 2215
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 177-210-77.jpg
cost 0.92
deal_of_the_week NO
description fluorescent green, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 54701
list_price 2.87
map NO
mfr_num 2015
net_weight 0.16
non_member_discount 40
non_member_price 1.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 54701
sku_pix YES
supplier_id 1
ta_dealer_a_price 1
ta_dealer_c_price 1
ta_price 1.49
text
array
1 54701
2 2015
3 fluorescent green, 2 oz.
timestamp 2015-03-26T14:51:30.315Z
vip_member_price 1.44

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020162
barcode_type UPC
col1 fluorescent orange
col1_sortorder 2221
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 255-173-77.jpg
cost 0.92
deal_of_the_week NO
description fluorescent orange, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 15224
list_price 2.87
map NO
mfr_num 2016
net_weight 0.16
non_member_discount 40
non_member_price 1.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 15224
sku_pix YES
supplier_id 1
ta_dealer_a_price 1
ta_dealer_c_price 1
ta_price 1.49
text
array
1 15224
2 2016
3 fluorescent orange, 2 oz.
timestamp 2015-03-26T14:50:34.996Z
vip_member_price 1.44

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024160
barcode_type UPC
col1 fluorescent orange
col1_sortorder 2221
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 255-173-77.jpg
cost 3.09
deal_of_the_week NO
description fluorescent orange, 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 30989
list_price 7.52
map NO
mfr_num 2416
net_weight 1.3
non_member_discount 40
non_member_price 4.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 30989
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.38
ta_dealer_c_price 3.38
ta_price 4.89
text
array
1 30989
2 2416
3 fluorescent orange, 16.9 oz.
timestamp 2015-03-26T14:50:56.645Z
vip_member_price 3.76

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022166
barcode_type UPC
col1 fluorescent orange
col1_sortorder 2221
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 255-173-77.jpg
cost 1.65
deal_of_the_week NO
description fluorescent orange, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 53729
list_price 4.93
map NO
mfr_num 2216
net_weight 0.74
non_member_discount 40
non_member_price 2.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 53729
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.73
ta_dealer_c_price 1.73
ta_price 2.56
text
array
1 53729
2 2216
3 fluorescent orange, 8 oz.
timestamp 2015-03-26T14:51:29.19Z
vip_member_price 2.47

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024184
barcode_type UPC
col1 fluorescent pink (violet)
col1_sortorder 2223
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 185-77-210.jpg
cost 3.09
deal_of_the_week NO
description fluorescent pink (violet), 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 52825
list_price 7.52
map NO
mfr_num 2418
net_weight 1.3
non_member_discount 40
non_member_price 4.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 52825
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.38
ta_dealer_c_price 3.38
ta_price 4.89
text
array
1 52825
2 2418
3 fluorescent pink (violet), 16.9 oz.
timestamp 2015-03-26T14:51:27.994Z
vip_member_price 3.76

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020186
barcode_type UPC
col1 fluorescent pink (violet)
col1_sortorder 2223
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 185-77-210.jpg
cost 0.92
deal_of_the_week NO
description fluorescent pink (violet), 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 62751
list_price 2.87
map NO
mfr_num 2018
net_weight 0.16
non_member_discount 40
non_member_price 1.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 62751
sku_pix YES
supplier_id 1
ta_dealer_a_price 1
ta_dealer_c_price 1
ta_price 1.49
text
array
1 62751
2 2018
3 fluorescent pink (violet), 2 oz.
timestamp 2015-03-26T14:51:43.283Z
vip_member_price 1.44

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022180
barcode_type UPC
col1 fluorescent pink (violet)
col1_sortorder 2223
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 185-77-210.jpg
cost 1.65
deal_of_the_week NO
description fluorescent pink (violet), 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 85000
list_price 4.93
map NO
mfr_num 2218
net_weight 0.74
non_member_discount 40
non_member_price 2.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 85000
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.73
ta_dealer_c_price 1.73
ta_price 2.56
text
array
1 85000
2 2218
3 fluorescent pink (violet), 8 oz.
timestamp 2015-03-26T14:52:16.968Z
vip_member_price 2.47

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024177
barcode_type UPC
col1 fluorescent red
col1_sortorder 2225
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 240-47-47.jpg
cost 3.09
deal_of_the_week NO
description fluorescent red, 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 34499
list_price 7.52
map NO
mfr_num 2417
net_weight 1.3
non_member_discount 40
non_member_price 4.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 34499
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.38
ta_dealer_c_price 3.38
ta_price 4.89
text
array
1 34499
2 2417
3 fluorescent red, 16.9 oz.
timestamp 2015-03-26T14:51:04.305Z
vip_member_price 3.76

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020179
barcode_type UPC
col1 fluorescent red
col1_sortorder 2225
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 240-47-47.jpg
cost 0.92
deal_of_the_week NO
description fluorescent red, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 74147
list_price 2.87
map NO
mfr_num 2017
net_weight 0.16
non_member_discount 40
non_member_price 1.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 74147
sku_pix YES
supplier_id 1
ta_dealer_a_price 1
ta_dealer_c_price 1
ta_price 1.49
text
array
1 74147
2 2017
3 fluorescent red, 2 oz.
timestamp 2015-03-26T14:52:04.491Z
vip_member_price 1.44

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022173
barcode_type UPC
col1 fluorescent red
col1_sortorder 2225
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 240-47-47.jpg
cost 1.65
deal_of_the_week NO
description fluorescent red, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 77980
list_price 4.93
map NO
mfr_num 2217
net_weight 0.74
non_member_discount 40
non_member_price 2.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 77980
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.73
ta_dealer_c_price 1.73
ta_price 2.56
text
array
1 77980
2 2217
3 fluorescent red, 8 oz.
timestamp 2015-03-26T14:52:09.73Z
vip_member_price 2.47

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200024191
barcode_type UPC
col1 fluorescent yellow
col1_sortorder 2233
col2 16.9 oz.
col2_sortorder 1019
col3 [empty string]
color_swatch 240-226-47.jpg
cost 3.09
deal_of_the_week NO
description fluorescent yellow, 16.9 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 22209
list_price 7.52
map NO
mfr_num 2419
net_weight 1.3
non_member_discount 40
non_member_price 4.51
prop65 NO
ship_rule_desc STD
shipping STD
sku 22209
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.38
ta_dealer_c_price 3.38
ta_price 4.89
text
array
1 22209
2 2419
3 fluorescent yellow, 16.9 oz.
timestamp 2015-03-26T14:50:44.769Z
vip_member_price 3.76

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020193
barcode_type UPC
col1 fluorescent yellow
col1_sortorder 2233
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 240-226-47.jpg
cost 0.92
deal_of_the_week NO
description fluorescent yellow, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 25397
list_price 2.87
map NO
mfr_num 2019
net_weight 0.16
non_member_discount 40
non_member_price 1.72
prop65 NO
ship_rule_desc STD
shipping STD
sku 25397
sku_pix YES
supplier_id 1
ta_dealer_a_price 1
ta_dealer_c_price 1
ta_price 1.49
text
array
1 25397
2 2019
3 fluorescent yellow, 2 oz.
timestamp 2015-03-26T14:50:48.781Z
vip_member_price 1.44

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022197
barcode_type UPC
col1 fluorescent yellow
col1_sortorder 2233
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 240-226-47.jpg
cost 1.65
deal_of_the_week NO
description fluorescent yellow, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 81873
list_price 4.93
map NO
mfr_num 2219
net_weight 0.74
non_member_discount 40
non_member_price 2.96
prop65 NO
ship_rule_desc STD
shipping STD
sku 81873
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.73
ta_dealer_c_price 1.73
ta_price 2.56
text
array
1 81873
2 2219
3 fluorescent yellow, 8 oz.
timestamp 2015-03-26T14:52:14.72Z
vip_member_price 2.47

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200020032
barcode_type UPC
col1 green
col1_sortorder 2621
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-164-123.jpg
cost 0.7
deal_of_the_week NO
description green, 2 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 26029
list_price 2.32
map NO
mfr_num 2003
net_weight 0.16
non_member_discount 40
non_member_price 1.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 26029
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.81
ta_dealer_c_price 0.81
ta_price 1.21
text
array
1 26029
2 2003
3 green, 2 oz.
timestamp 2015-03-26T14:50:49.323Z
vip_member_price 1.16

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList:
AvailQtyList:

struct
FLAGS 0
VIP_member_discount 50
barcode 092200022036
barcode_type UPC
col1 green
col1_sortorder 2621
col2 8 oz.
col2_sortorder 2317
col3 [empty string]
color_swatch 0-164-123.jpg
cost 1.27
deal_of_the_week NO
description green, 8 oz.
group_id 110
group_uname chroma-inc-chromatemp-artists-tempera-paint
id 37845
list_price 4
map NO
mfr_num 2203
net_weight 0.74
non_member_discount 40
non_member_price 2.4
prop65 NO
ship_rule_desc STD
shipping STD
sku 37845
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.4
ta_dealer_c_price 1.4
ta_price 2.08
text
array
1 37845
2 2203
3 green, 8 oz.
timestamp 2015-03-26T14:51:07.701Z
vip_member_price 2

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

URL: www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 17:41:31'}
sessionid e0306342f43907f35a337d4616659d69a601
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=tempera&CatC=fp~4-6~&gr=chroma-inc-chromatemp-artists-tempera-paint.html
urltoken CFID=29199924&CFTOKEN=58271191&jsessionid=e0306342f43907f35a337d4616659d69a601
validationerror [empty string]


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

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

ItemIDList: