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

Kids 300-Piece Jigsaw Puzzles

by Pomegranate


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 717195234966
barcode_type UPC
col1 B. Kilban: Pool Cat
col1_sortorder 377
col2 [empty string]
col3 [empty string]
cost 9.13
deal_of_the_week NO
description B. Kilban: Pool Cat
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 44271
list_price 14.95
map NO
mfr_num JK001
net_weight 1.52
non_member_discount 10
non_member_price 13.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 44271
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.21
ta_dealer_c_price 11.21
ta_price 14.95
text
array
1 44271
2 JK001
3 B. Kilban: Pool Cat
timestamp 2015-03-31T17:53:29.508Z
vip_member_price 11.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 717195235154
barcode_type UPC
col1 Charley Harper: Biodiversity in the Burbs
col1_sortorder 598
col2 [empty string]
col3 [empty string]
cost 9.13
deal_of_the_week NO
description Charley Harper: Biodiversity in the Burbs
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 44275
list_price 14.95
map NO
mfr_num JK006
net_weight 1.56
non_member_discount 10
non_member_price 13.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 44275
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.21
ta_dealer_c_price 11.21
ta_price 14.95
text
array
1 44275
2 JK006
3 Charley Harper: Biodiversity in the Burbs
timestamp 2015-03-31T17:53:29.516Z
vip_member_price 11.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 717195235499
barcode_type UPC
col1 Chas Addams: The Addams Family
col1_sortorder 614
col2 [empty string]
col3 [empty string]
cost 9.13
deal_of_the_week NO
description Chas Addams: The Addams Family
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 44893
list_price 14.95
map NO
mfr_num JK007
net_weight 1.58
non_member_discount 10
non_member_price 13.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 44893
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.21
ta_dealer_c_price 11.21
ta_price 14.95
text
array
1 44893
2 JK007
3 Chas Addams: The Addams Family
timestamp 2015-03-31T17:53:30.274Z
vip_member_price 11.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 717195234980
barcode_type UPC
col1 David Sheskin: Jungle Beasts
col1_sortorder 841
col2 [empty string]
col3 [empty string]
cost 9.13
deal_of_the_week NO
description David Sheskin: Jungle Beasts
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 44273
list_price 14.95
map NO
mfr_num JK003
net_weight 1.53
non_member_discount 10
non_member_price 13.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 44273
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.21
ta_dealer_c_price 11.21
ta_price 14.95
text
array
1 44273
2 JK003
3 David Sheskin: Jungle Beasts
timestamp 2015-03-31T17:53:29.512Z
vip_member_price 11.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 717195239176
barcode_type uPC
col1 Edward Gorey: Seventeen Cats
col1_sortorder 1060
col2 [empty string]
col3 [empty string]
cost 9.13
deal_of_the_week NO
description Edward Gorey: Seventeen Cats
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 47822
list_price 14.95
map NO
mfr_num JK021
net_weight 1.51
non_member_discount 10
non_member_price 13.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 47822
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.21
ta_dealer_c_price 11.21
ta_price 14.95
text
array
1 47822
2 JK021
3 Edward Gorey: Seventeen Cats
timestamp 2015-03-31T17:53:33.687Z
vip_member_price 11.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 717195239589
barcode_type uPC
col1 Frank Lloyd Wright: May Basket
col1_sortorder 1254
col2 [empty string]
col3 [empty string]
cost 9.13
deal_of_the_week NO
description Frank Lloyd Wright: May Basket
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 47825
list_price 14.95
map NO
mfr_num JK022
net_weight 1.5
non_member_discount 10
non_member_price 13.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 47825
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.21
ta_dealer_c_price 11.21
ta_price 14.95
text
array
1 47825
2 JK022
3 Frank Lloyd Wright: May Basket
timestamp 2015-03-31T17:53:33.694Z
vip_member_price 11.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 717195225506
barcode_type UPC
col1 Charley Harper: Mystery of the Missing Migrants
col1_sortorder 1460
col2 [empty string]
col3 [empty string]
cost 10.96
deal_of_the_week NO
description Charley Harper: Mystery of the Missing Migrants
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 41172
list_price 17.95
map NO
mfr_num AA443
net_weight 2
non_member_discount 10
non_member_price 16.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 41172
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.46
ta_dealer_c_price 13.46
ta_price 17.95
text
array
1 41172
2 AA443
3 Charley Harper: Mystery of the Missing Migrants
timestamp 2015-03-31T17:53:24.731Z
vip_member_price 14.36

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 717195238131
barcode_type UPC
col1 Harry Clarke: The Garden of Paradise
col1_sortorder 1461
col2 [empty string]
col3 [empty string]
cost 9.13
deal_of_the_week NO
description Harry Clarke: The Garden of Paradise
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 46773
list_price 14.95
map NO
mfr_num JK017
net_weight 1.54
non_member_discount 10
non_member_price 13.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 46773
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.21
ta_dealer_c_price 11.21
ta_price 14.95
text
array
1 46773
2 JK017
3 Harry Clarke: The Garden of Paradise
timestamp 2015-03-31T17:53:32.225Z
vip_member_price 11.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 717195238506
barcode_type uPC
col1 Henri Rousseau: Exotic Forest
col1_sortorder 1472
col2 [empty string]
col3 [empty string]
cost 9.13
deal_of_the_week NO
description Henri Rousseau: Exotic Forest
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 47823
list_price 14.95
map NO
mfr_num JK019
net_weight 1.56
non_member_discount 10
non_member_price 13.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 47823
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.21
ta_dealer_c_price 11.21
ta_price 14.95
text
array
1 47823
2 JK019
3 Henri Rousseau: Exotic Forest
timestamp 2015-03-31T17:53:33.689Z
vip_member_price 11.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 717195238148
barcode_type UPC
col1 Herry Perry: The Zoo
col1_sortorder 1476
col2 [empty string]
col3 [empty string]
cost 9.13
deal_of_the_week NO
description Herry Perry: The Zoo
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 46772
list_price 14.95
map NO
mfr_num JK016
net_weight 1.53
non_member_discount 10
non_member_price 13.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 46772
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.21
ta_dealer_c_price 11.21
ta_price 14.95
text
array
1 46772
2 JK016
3 Herry Perry: The Zoo
timestamp 2015-03-31T17:53:32.222Z
vip_member_price 11.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 717195236212
barcode_type UPC
col1 Kathy DeZarn Beynette: Lions
col1_sortorder 1688
col2 [empty string]
col3 [empty string]
cost 9.13
deal_of_the_week NO
description Kathy DeZarn Beynette: Lions
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 45057
list_price 14.95
map NO
mfr_num JK010
net_weight 1.56
non_member_discount 10
non_member_price 13.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 45057
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.21
ta_dealer_c_price 11.21
ta_price 14.95
text
array
1 45057
2 JK010
3 Kathy DeZarn Beynette: Lions
timestamp 2015-03-31T17:53:30.47Z
vip_member_price 11.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9780764959752
barcode_type EAN
col1 Kathy DeZarn Beynette: Raccoons
col1_sortorder 1689
col2 [empty string]
col3 [empty string]
cost 9.13
deal_of_the_week NO
description Kathy DeZarn Beynette: Raccoons
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 46014
list_price 14.95
map NO
mfr_num JK013
net_weight 1.5
non_member_discount 10
non_member_price 13.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 46014
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.21
ta_dealer_c_price 11.21
ta_price 14.95
text
array
1 46014
2 JK013
3 Kathy DeZarn Beynette: Raccoons
timestamp 2015-03-31T17:53:31.47Z
vip_member_price 11.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 717195236045
barcode_type UPC
col1 Koo Schadler: Rabbit
col1_sortorder 1719
col2 [empty string]
col3 [empty string]
cost 9.13
deal_of_the_week NO
description Koo Schadler: Rabbit
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 45054
list_price 14.95
map NO
mfr_num JK008
net_weight 1.56
non_member_discount 10
non_member_price 13.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 45054
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.21
ta_dealer_c_price 11.21
ta_price 14.95
text
array
1 45054
2 JK008
3 Koo Schadler: Rabbit
timestamp 2015-03-31T17:53:30.468Z
vip_member_price 11.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 717195236236
barcode_type UPC
col1 Michael Hague: Fairies
col1_sortorder 1941
col2 [empty string]
col3 [empty string]
cost 9.13
deal_of_the_week NO
description Michael Hague: Fairies
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 45060
list_price 14.95
map NO
mfr_num JK009
net_weight 1.56
non_member_discount 10
non_member_price 13.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 45060
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.21
ta_dealer_c_price 11.21
ta_price 14.95
text
array
1 45060
2 JK009
3 Michael Hague: Fairies
timestamp 2015-03-31T17:53:30.475Z
vip_member_price 11.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9780764959813
barcode_type EAN
col1 Mimi Vang Olsen: Pooh & Bean
col1_sortorder 1948
col2 [empty string]
col3 [empty string]
cost 9.13
deal_of_the_week NO
description Mimi Vang Olsen: Pooh & Bean
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 46013
list_price 14.95
map NO
mfr_num JK015
net_weight 1.51
non_member_discount 10
non_member_price 13.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 46013
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.21
ta_dealer_c_price 11.21
ta_price 14.95
text
array
1 46013
2 JK015
3 Mimi Vang Olsen: Pooh & Bean
timestamp 2015-03-31T17:53:31.468Z
vip_member_price 11.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 717195234973
barcode_type UPC
col1 Robert Bissell: The Kiss
col1_sortorder 2372
col2 [empty string]
col3 [empty string]
cost 9.13
deal_of_the_week NO
description Robert Bissell: The Kiss
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 44272
list_price 14.95
map NO
mfr_num JK002
net_weight 1.55
non_member_discount 10
non_member_price 13.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 44272
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.21
ta_dealer_c_price 11.21
ta_price 14.95
text
array
1 44272
2 JK002
3 Robert Bissell: The Kiss
timestamp 2015-03-31T17:53:29.51Z
vip_member_price 11.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9780764965111
barcode_type EAN
col1 Toucan
col1_sortorder 2783
col2 [empty string]
col3 [empty string]
cost 9.13
deal_of_the_week NO
description Toucan
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 01077
list_price 14.95
map NO
mfr_num JK023
net_weight 1.52
non_member_discount 10
non_member_price 13.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 01077
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.21
ta_dealer_c_price 11.21
ta_price 14.95
text
array
1 01077
2 JK023
3 Toucan
timestamp 2015-03-31T17:52:13.734Z
vip_member_price 11.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


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

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

ItemIDList: 17006
AvailQtyList: 6.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9780764966088
barcode_type EAN
col1 zoo animals
col1_sortorder 2995
col2 [empty string]
col3 [empty string]
cost 9.13
deal_of_the_week NO
description zoo animals
group_id 15591
group_uname pomegranate-kids-300-piece-jigsaw-puzzles
id 02660
list_price 14.95
map NO
mfr_num JK026
net_weight 1.52
non_member_discount 10
non_member_price 13.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 02660
sku_pix YES
supplier_id 1
ta_dealer_a_price 11.21
ta_dealer_c_price 11.21
ta_price 14.95
text
array
1 02660
2 JK026
3 zoo animals
timestamp 2015-03-31T17:52:17.977Z
vip_member_price 11.95

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 17006
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] = '10789' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.171.164

URL: www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e0303e2a92afeaaca720a2b174935830633a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=paper-boards&catB=art-illustration&CatC=sumi&CatD=fb~yasutomo~&gr=yasutomo-kozo-sketch-pad.html
urltoken CFID=30577309&CFTOKEN=55159147&jsessionid=e0303e2a92afeaaca720a2b174935830633a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 17:25:23'}
sessionid e030b40f3d564f2a2472737a726c7b6d2521
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fp~11-15~&gr=pomegranate-kids-300-piece-jigsaw-puzzles.html
urltoken CFID=30577310&CFTOKEN=26413763&jsessionid=e030b40f3d564f2a2472737a726c7b6d2521
validationerror [empty string]


These high quality art puzzles feature a variety of kid friendly designs, comprised of 300 large interlocking pieces. Every puzzle features excellent color reproduction and sturdy construction for lasting enjoyment. Each puzzle measures 24 in. x 18 in.

Share on Facebook Twitter Pinterest

Ask a question about Kids 300-Piece Jigsaw Puzzles Ask a question about this product

Kids 300-Piece Jigsaw Puzzles

by Pomegranate

Be the first to write a review on this product!









  Item# Image title
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
44271
Kids 300-Piece Jigsaw Puzzles B. Kilban: Pool Cat
Zoom Image
B. Kilban: Pool Cat JK001 $14.95 $13.45 10% Off $11.95 20% Off Email When In Stock
Add to Favorites
44275
Kids 300-Piece Jigsaw Puzzles Charley Harper: Biodiversity in the Burbs
Zoom Image
Charley Harper: Biodiversity in the Burbs JK006 $14.95 $13.45 10% Off $11.95 20% Off Email When In Stock
Add to Favorites
44893
Kids 300-Piece Jigsaw Puzzles Chas Addams: The Addams Family
Zoom Image
Chas Addams: The Addams Family JK007 $14.95 $13.45 10% Off $11.95 20% Off Email When In Stock
Add to Favorites
44273
Kids 300-Piece Jigsaw Puzzles David Sheskin: Jungle Beasts
Zoom Image
David Sheskin: Jungle Beasts JK003 $14.95 $13.45 10% Off $11.95 20% Off Email When In Stock
Add to Favorites
47822
Kids 300-Piece Jigsaw Puzzles Edward Gorey: Seventeen Cats
Zoom Image
Edward Gorey: Seventeen Cats JK021 $14.95 $13.45 10% Off $11.95 20% Off Email When In Stock
Add to Favorites
47825
Kids 300-Piece Jigsaw Puzzles Frank Lloyd Wright: May Basket
Zoom Image
Frank Lloyd Wright: May Basket JK022 $14.95 $13.45 10% Off $11.95 20% Off Email When In Stock
Add to Favorites
41172
Kids 300-Piece Jigsaw Puzzles Charley Harper: Mystery of the Missing Migrants
Zoom Image
Charley Harper: Mystery of the Missing Migrants AA443 $17.95 $16.16 10% Off $14.36 20% Off Email When In Stock
Add to Favorites
46773
Kids 300-Piece Jigsaw Puzzles Harry Clarke: The Garden of Paradise
Zoom Image
Harry Clarke: The Garden of Paradise JK017 $14.95 $13.45 10% Off $11.95 20% Off Email When In Stock
Add to Favorites
47823
Kids 300-Piece Jigsaw Puzzles Henri Rousseau: Exotic Forest
Zoom Image
Henri Rousseau: Exotic Forest JK019 $14.95 $13.45 10% Off $11.95 20% Off Email When In Stock
Add to Favorites
46772
Kids 300-Piece Jigsaw Puzzles Herry Perry: The Zoo
Zoom Image
Herry Perry: The Zoo JK016 $14.95 $13.45 10% Off $11.95 20% Off Email When In Stock
Add to Favorites
45057
Kids 300-Piece Jigsaw Puzzles Kathy DeZarn Beynette: Lions
Zoom Image
Kathy DeZarn Beynette: Lions JK010 $14.95 $13.45 10% Off $11.95 20% Off Email When In Stock
Add to Favorites
46014
Kids 300-Piece Jigsaw Puzzles Kathy DeZarn Beynette: Raccoons
Zoom Image
Kathy DeZarn Beynette: Raccoons JK013 $14.95 $13.45 10% Off $11.95 20% Off Email When In Stock
Add to Favorites
45054
Kids 300-Piece Jigsaw Puzzles Koo Schadler: Rabbit
Zoom Image
Koo Schadler: Rabbit JK008 $14.95 $13.45 10% Off $11.95 20% Off Email When In Stock
Add to Favorites
45060
Kids 300-Piece Jigsaw Puzzles Michael Hague: Fairies
Zoom Image
Michael Hague: Fairies JK009 $14.95 $13.45 10% Off $11.95 20% Off Email When In Stock
Add to Favorites
46013
Kids 300-Piece Jigsaw Puzzles Mimi Vang Olsen: Pooh & Bean
Zoom Image
Mimi Vang Olsen: Pooh & Bean JK015 $14.95 $13.45 10% Off $11.95 20% Off Email When In Stock
Add to Favorites
44272
Kids 300-Piece Jigsaw Puzzles Robert Bissell: The Kiss
Zoom Image
Robert Bissell: The Kiss JK002 $14.95 $13.45 10% Off $11.95 20% Off Email When In Stock
Add to Favorites
01077
Kids 300-Piece Jigsaw Puzzles Toucan
Zoom Image
Toucan JK023 $14.95 $13.45 10% Off $11.95 20% Off Email When In Stock
Add to Favorites
02660
Kids 300-Piece Jigsaw Puzzles zoo animals
Zoom Image
zoo animals JK026 $14.95 $13.45 10% Off $11.95 20% Off Email When In Stock

Click the to add item to your Favorites.



Please wait...
You May Also Like...

The Styro Wonder Cutter

by FloraCraft

Cut foam with precision

From $7.92

Woodburner Kits

by Wall Lenk Corporation

Start woodburning today

From $5.09

Round Nose Pliers

by Cousin

Perfectly designed for delicate jewelry work

From $3.46

How to get VIP Club Prices
Anyone can be a VIP Member with:
  • Additional savings on all products
  • Express order handling
  • Exclusive promotions
  • Priority customer service
Only $25/year

Learn More »

Ask a Question About Kids 300-Piece Jigsaw Puzzles

Your email will not be shared. We will only use your email address to respond to your question. When asking your question, please be as descriptive as possible, it will allow us to give you the most accurate answer possible.

Write a Product Review for Kids 300-Piece Jigsaw Puzzles

Add Your Review

Tell us what you think. We appreciate you taking the time to share your opinion with other artists and crafters. Please keep your review detailed and specific.

Product reviews are intended to be a resource for artists interested in product quality and use. MisterArt.com reserves the right not to post any product review or to remove any published product review at any time without notice. Published reviews must conform to MisterArt.com guidelines. Your review may be posted on this page within five to ten business days.

Tips on Writing Reviews
Rating Scale
  • (5-Star) Excellent
  • (4-Star) Good
  • (3-Star) Average
  • (2-Star) Fair
  • (1-Star) Poor
Do:
  • Give your perspective on how you used the product and why you liked or disliked it.
  • Keep your reviews short enough to hold the audience's attention.
  • Be honest and mindful of others when providing editorial commentary.
Don't:
  • Include phone numbers, addresses, URLs, or HTML tags.
  • Write profanity, obscenities, vulgarities, or spiteful comments.
  • Make defamatory comments.
Please wait...
Please wait...