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

Bisq-Stain Opaques

by Duncan


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997449
barcode_type UPC
col1 angel flesh
col1_sortorder 127
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 194-168-210.jpg
cost 1.02
deal_of_the_week NO
description angel flesh, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 30777
list_price 2.25
map NO
mfr_num OS492-2 99744
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 30777
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 30777
2 OS492-2 99744
3 angel flesh, 2 oz.
timestamp 2015-03-26T14:50:56.455Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997807
barcode_type UPC
col1 ash
col1_sortorder 210
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 135-135-135.jpg
cost 1.02
deal_of_the_week NO
description ash, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 29285
list_price 2.25
map NO
mfr_num OS567-2 99780
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 29285
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 29285
2 OS567-2 99780
3 ash, 2 oz.
timestamp 2015-03-26T14:50:53.757Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997241
barcode_type UPC
col1 avocado
col1_sortorder 266
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 126-149-92.jpg
cost 1.02
deal_of_the_week NO
description avocado, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 61928
list_price 2.25
map NO
mfr_num OS466-2 99724
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 61928
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 61928
2 OS466-2 99724
3 avocado, 2 oz.
timestamp 2015-03-26T14:51:41.14Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997722
barcode_type UPC
col1 azalea
col1_sortorder 268
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 164-0-129.jpg
cost 1.02
deal_of_the_week NO
description azalea, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 30223
list_price 2.25
map NO
mfr_num OS559-2 99772
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 30223
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 30223
2 OS559-2 99772
3 azalea, 2 oz.
timestamp 2015-03-26T14:50:55.071Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997173
barcode_type UPC
col1 baby blue
col1_sortorder 290
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 183-183-240.jpg
cost 1.02
deal_of_the_week NO
description baby blue, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 20744
list_price 2.25
map NO
mfr_num OS456-2 99717
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 20744
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 20744
2 OS456-2 99717
3 baby blue, 2 oz.
timestamp 2015-03-26T14:50:43.054Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997494
barcode_type UPC
col1 barnyard red
col1_sortorder 335
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 164-93-77.jpg
cost 1.02
deal_of_the_week NO
description barnyard red, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 29471
list_price 2.25
map NO
mfr_num OS503-2 99749
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 29471
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 29471
2 OS503-2 99749
3 barnyard red, 2 oz.
timestamp 2015-03-26T14:50:53.961Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997609
barcode_type UPC
col1 bisque white
col1_sortorder 398
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 239-213-255.jpg
cost 0.96
deal_of_the_week NO
description bisque white, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 17206
list_price 2.1
map NO
mfr_num OS547-2 99760
net_weight 0.2
non_member_discount 20
non_member_price 1.68
prop65 NO
ship_rule_desc STD
shipping STD
sku 17206
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.26
ta_dealer_c_price 1.05
ta_price 2.1
text
array
1 17206
2 OS547-2 99760
3 bisque white, 2 oz.
timestamp 2015-03-26T14:50:38.301Z
vip_member_price 1.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754920928
barcode_type UPC
col1 black
col1_sortorder 402
col2 4 oz.
col2_sortorder 1804
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.62
deal_of_the_week NO
description black, 4 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 13638
list_price 3.55
map NO
mfr_num OS476-4 92092
net_weight 0.4
non_member_discount 20
non_member_price 2.84
prop65 NO
ship_rule_desc STD
shipping STD
sku 13638
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.13
ta_dealer_c_price 1.78
ta_price 3.55
text
array
1 13638
2 OS476-4 92092
3 black, 4 oz.
timestamp 2015-03-26T14:50:31.297Z
vip_member_price 2.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997333
barcode_type UPC
col1 black
col1_sortorder 402
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.02
deal_of_the_week NO
description black, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 22916
list_price 2.25
map NO
mfr_num OS476-2 99733
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 22916
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 22916
2 OS476-2 99733
3 black, 2 oz.
timestamp 2015-03-26T14:50:45.639Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997302
barcode_type UPC
col1 black brown
col1_sortorder 420
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 119-60-0.jpg
cost 1.02
deal_of_the_week NO
description black brown, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 58688
list_price 2.25
map NO
mfr_num OS473-2 99730
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 58688
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 58688
2 OS473-2 99730
3 black brown, 2 oz.
timestamp 2015-03-26T14:51:35.036Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997197
barcode_type UPC
col1 bright blue
col1_sortorder 692
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-98-210.jpg
cost 1.02
deal_of_the_week NO
description bright blue, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 63125
list_price 2.25
map NO
mfr_num OS459-2 99719
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 63125
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 63125
2 OS459-2 99719
3 bright blue, 2 oz.
timestamp 2015-03-26T14:51:44.261Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997227
barcode_type UPC
col1 bright green
col1_sortorder 708
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-119-77.jpg
cost 1.02
deal_of_the_week NO
description bright green, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 86677
list_price 2.25
map NO
mfr_num OS464-2 99722
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 86677
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 86677
2 OS464-2 99722
3 bright green, 2 oz.
timestamp 2015-03-26T14:52:18.549Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997104
barcode_type UPC
col1 bright red
col1_sortorder 728
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 195-47-47.jpg
cost 1.02
deal_of_the_week NO
description bright red, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 43593
list_price 2.25
map NO
mfr_num OS449-2 99710
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 43593
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 43593
2 OS449-2 99710
3 bright red, 2 oz.
timestamp 2015-03-26T14:51:13.15Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997029
barcode_type UPC
col1 burnt orange
col1_sortorder 869
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 119-60-0.jpg
cost 1.02
deal_of_the_week NO
description burnt orange, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 32026
list_price 2.25
map NO
mfr_num OS440-1 99702
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 32026
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 32026
2 OS440-1 99702
3 burnt orange, 2 oz.
timestamp 2015-03-26T14:50:58.246Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997500
barcode_type UPC
col1 butterscotch
col1_sortorder 906
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 149-102-47.jpg
cost 1.02
deal_of_the_week NO
description butterscotch, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 37389
list_price 2.25
map NO
mfr_num OS508-2 99750
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 37389
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 37389
2 OS508-2 99750
3 butterscotch, 2 oz.
timestamp 2015-03-26T14:51:07.387Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997760
barcode_type UPC
col1 candy apple
col1_sortorder 1064
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 240-47-91.jpg
cost 0.96
deal_of_the_week NO
description candy apple, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 15445
list_price 2.1
map NO
mfr_num OS563-2 99776
net_weight 0.2
non_member_discount 20
non_member_price 1.68
prop65 NO
ship_rule_desc STD
shipping STD
sku 15445
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.26
ta_dealer_c_price 1.05
ta_price 2.1
text
array
1 15445
2 OS563-2 99776
3 candy apple, 2 oz.
timestamp 2015-03-26T14:50:35.239Z
vip_member_price 1.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997326
barcode_type UPC
col1 charcoal
col1_sortorder 1181
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 105-105-105.jpg
cost 1.02
deal_of_the_week NO
description charcoal, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 75249
list_price 2.25
map NO
mfr_num OS475-2 99732
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 75249
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 75249
2 OS475-2 99732
3 charcoal, 2 oz.
timestamp 2015-03-26T14:52:05.46Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997470
barcode_type UPC
col1 chocolate fudge
col1_sortorder 1224
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 119-60-0.jpg
cost 1.02
deal_of_the_week NO
description chocolate fudge, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 32547
list_price 2.25
map NO
mfr_num OS495-2 99747
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 32547
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 32547
2 OS495-2 99747
3 chocolate fudge, 2 oz.
timestamp 2015-03-26T14:50:58.812Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997418
barcode_type UPC
col1 Christmas green
col1_sortorder 1233
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 47-149-149.jpg
cost 1.02
deal_of_the_week NO
description Christmas green, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 49383
list_price 2.25
map NO
mfr_num OS488-2 99741
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 49383
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 49383
2 OS488-2 99741
3 Christmas green, 2 oz.
timestamp 2015-03-26T14:51:21.796Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997357
barcode_type UPC
col1 cinnamon
col1_sortorder 1287
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 119-60-0.jpg
cost 1.02
deal_of_the_week NO
description cinnamon, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 34536
list_price 2.25
map NO
mfr_num OS481-2 99735
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 34536
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 34536
2 OS481-2 99735
3 cinnamon, 2 oz.
timestamp 2015-03-26T14:51:04.32Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997821
barcode_type UPC
col1 concord
col1_sortorder 1477
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-0-210.jpg
cost 1.02
deal_of_the_week NO
description concord, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 11604
list_price 2.25
map NO
mfr_num OS569-2 99782
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 11604
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 11604
2 OS569-2 99782
3 concord, 2 oz.
timestamp 2015-03-26T14:50:28.651Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997784
barcode_type UPC
col1 confederate blue
col1_sortorder 1482
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 77-120-255.jpg
cost 1.02
deal_of_the_week NO
description confederate blue, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 81254
list_price 2.25
map NO
mfr_num OS565-2 99778
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 81254
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 81254
2 OS565-2 99778
3 confederate blue, 2 oz.
timestamp 2015-03-26T14:52:14.341Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754813725
barcode_type UPC
col1 cornsilk yellow
col1_sortorder 1556
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 240-240-240.jpg
cost 0.96
deal_of_the_week NO
description cornsilk yellow, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 83887
list_price 2.1
map NO
mfr_num OS499-2 81372
net_weight 0.2
non_member_discount 20
non_member_price 1.68
prop65 NO
ship_rule_desc STD
shipping STD
sku 83887
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.26
ta_dealer_c_price 1.05
ta_price 2.1
text
array
1 83887
2 OS499-2 81372
3 cornsilk yellow, 2 oz.
timestamp 2015-03-26T14:52:16.14Z
vip_member_price 1.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997647
barcode_type UPC
col1 cotton candy
col1_sortorder 1565
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 240-138-161.jpg
cost 1.02
deal_of_the_week NO
description cotton candy, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 15547
list_price 2.25
map NO
mfr_num OS551-2 99764
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 15547
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 15547
2 OS551-2 99764
3 cotton candy, 2 oz.
timestamp 2015-03-26T14:50:35.331Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754813749
barcode_type UPC
col1 country rose
col1_sortorder 1571
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 240-92-126.jpg
cost 0.96
deal_of_the_week NO
description country rose, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 39131
list_price 2.1
map NO
mfr_num OS504-2 81374
net_weight 0.2
non_member_discount 20
non_member_price 1.68
prop65 NO
ship_rule_desc STD
shipping STD
sku 39131
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.26
ta_dealer_c_price 1.05
ta_price 2.1
text
array
1 39131
2 OS504-2 81374
3 country rose, 2 oz.
timestamp 2015-03-26T14:51:09.197Z
vip_member_price 1.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997845
barcode_type UPC
col1 curry
col1_sortorder 1647
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 164-93-77.jpg
cost 1.02
deal_of_the_week NO
description curry, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 63370
list_price 2.25
map NO
mfr_num OS571-2 99784
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 63370
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 63370
2 OS571-2 99784
3 curry, 2 oz.
timestamp 2015-03-26T14:51:44.747Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754996978
barcode_type UPC
col1 dark yellow
col1_sortorder 1773
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 240-213-47.jpg
cost 1.02
deal_of_the_week NO
description dark yellow, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 44892
list_price 2.25
map NO
mfr_num OS435-2 99697
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 44892
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 44892
2 OS435-2 99697
3 dark yellow, 2 oz.
timestamp 2015-03-26T14:51:14.96Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997265
barcode_type UPC
col1 deep turquoise
col1_sortorder 1839
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 0-141-164.jpg
cost 1.02
deal_of_the_week NO
description deep turquoise, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 70495
list_price 2.25
map NO
mfr_num OS468-2 99726
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 70495
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 70495
2 OS468-2 99726
3 deep turquoise, 2 oz.
timestamp 2015-03-26T14:51:58.408Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754813732
barcode_type UPC
col1 Dresden flesh
col1_sortorder 1936
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 198-168-210.jpg
cost 1.02
deal_of_the_week NO
description Dresden flesh, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 55715
list_price 2.25
map NO
mfr_num OS441-2 81373
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 55715
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 55715
2 OS441-2 81373
3 Dresden flesh, 2 oz.
timestamp 2015-03-26T14:51:31.748Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997814
barcode_type UPC
col1 fire thorn
col1_sortorder 2142
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 119-60-0.jpg
cost 1.02
deal_of_the_week NO
description fire thorn, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 49335
list_price 2.25
map NO
mfr_num OS568-2 99781
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 49335
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 49335
2 OS568-2 99781
3 fire thorn, 2 oz.
timestamp 2015-03-26T14:51:21.768Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997388
barcode_type UPC
col1 French vanilla
col1_sortorder 2329
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 195-174-138.jpg
cost 1.02
deal_of_the_week NO
description French vanilla, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 53079
list_price 2.25
map NO
mfr_num OS485-2 99738
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 53079
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 53079
2 OS485-2 99738
3 French vanilla, 2 oz.
timestamp 2015-03-26T14:51:28.25Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e0303bfddb8e096a1c096b30767fc7339539
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=sort~1~fp~14-9999.99~&gr=sculpture-house-hydrocal-white.html
urltoken CFID=29215670&CFTOKEN=98912172&jsessionid=e0303bfddb8e096a1c096b30767fc7339539
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 19:09:30'}
sessionid e030edaa4a62b57911bb3b6e6c4e18457267
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html
urltoken CFID=29215669&CFTOKEN=97740583&jsessionid=e030edaa4a62b57911bb3b6e6c4e18457267
validationerror [empty string]


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

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

ItemIDList: 12950,16471
AvailQtyList: 7.000000000000,20.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754997340
barcode_type UPC
col1 garnet red
col1_sortorder 2382
col2 2 oz.
col2_sortorder 1211
col3 [empty string]
color_swatch 164-0-90.jpg
cost 1.02
deal_of_the_week NO
description garnet red, 2 oz.
group_id 1406
group_uname duncan-bisq-stain-opaques
id 70683
list_price 2.25
map NO
mfr_num OS480-2 99734
net_weight 0.2
non_member_discount 20
non_member_price 1.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 70683
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.35
ta_dealer_c_price 1.13
ta_price 2.25
text
array
1 70683
2 OS480-2 99734
3 garnet red, 2 oz.
timestamp 2015-03-26T14:51:58.708Z
vip_member_price 1.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 12950
2 20.000000000000 16471
CACHED false
EXECUTIONTIME 2
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] = '740' 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.163.105.38

URL: www.misterart.com:/index.cfm:module=ceramics&catB=sort~1~fb~duncan~&gr=duncan-bisq-stain-opaques.html

StartSessionVariables: