Stock

WP_Query Object
(
    [query] => Array
        (
            [product_tag] => stock
        )

    [query_vars] => Array
        (
            [product_tag] => stock
            [error] => 
            [m] => 
            [p] => 0
            [post_parent] => 
            [subpost] => 
            [subpost_id] => 
            [attachment] => 
            [attachment_id] => 0
            [name] => 
            [static] => 
            [pagename] => 
            [page_id] => 0
            [second] => 
            [minute] => 
            [hour] => 
            [day] => 0
            [monthnum] => 0
            [year] => 0
            [w] => 0
            [category_name] => 
            [tag] => 
            [cat] => 
            [tag_id] => 
            [author] => 
            [author_name] => 
            [feed] => 
            [tb] => 
            [paged] => 0
            [meta_key] => 
            [meta_value] => 
            [preview] => 
            [s] => 
            [sentence] => 
            [title] => 
            [fields] => 
            [menu_order] => 
            [embed] => 
            [category__in] => Array
                (
                )

            [category__not_in] => Array
                (
                )

            [category__and] => Array
                (
                )

            [post__in] => Array
                (
                )

            [post__not_in] => Array
                (
                )

            [post_name__in] => Array
                (
                )

            [tag__in] => Array
                (
                )

            [tag__not_in] => Array
                (
                )

            [tag__and] => Array
                (
                )

            [tag_slug__in] => Array
                (
                )

            [tag_slug__and] => Array
                (
                )

            [post_parent__in] => Array
                (
                )

            [post_parent__not_in] => Array
                (
                )

            [author__in] => Array
                (
                )

            [author__not_in] => Array
                (
                )

            [orderby] => menu_order title
            [order] => ASC
            [meta_query] => Array
                (
                )

            [tax_query] => Array
                (
                    [relation] => AND
                    [0] => Array
                        (
                            [taxonomy] => product_visibility
                            [field] => term_taxonomy_id
                            [terms] => Array
                                (
                                    [0] => 727
                                )

                            [operator] => NOT IN
                        )

                )

            [posts_per_page] => 64
            [wc_query] => product_query
            [ignore_sticky_posts] => 
            [suppress_filters] => 
            [cache_results] => 1
            [update_post_term_cache] => 1
            [lazy_load_term_meta] => 1
            [update_post_meta_cache] => 1
            [post_type] => 
            [nopaging] => 
            [comments_per_page] => 50
            [no_found_rows] => 
            [taxonomy] => product_tag
            [term] => stock
        )

    [tax_query] => WP_Tax_Query Object
        (
            [queries] => Array
                (
                    [relation] => AND
                    [0] => Array
                        (
                            [taxonomy] => product_visibility
                            [terms] => Array
                                (
                                    [0] => 727
                                )

                            [field] => term_taxonomy_id
                            [operator] => NOT IN
                            [include_children] => 1
                        )

                    [1] => Array
                        (
                            [taxonomy] => product_tag
                            [terms] => Array
                                (
                                    [0] => stock
                                )

                            [field] => slug
                            [operator] => IN
                            [include_children] => 1
                        )

                )

            [relation] => AND
            [table_aliases:protected] => Array
                (
                    [0] => afr7_term_relationships
                )

            [queried_terms] => Array
                (
                    [product_tag] => Array
                        (
                            [terms] => Array
                                (
                                    [0] => stock
                                )

                            [field] => slug
                        )

                )

            [primary_table] => afr7_posts
            [primary_id_column] => ID
        )

    [meta_query] => WP_Meta_Query Object
        (
            [queries] => Array
                (
                )

            [relation] => 
            [meta_table] => 
            [meta_id_column] => 
            [primary_table] => 
            [primary_id_column] => 
            [table_aliases:protected] => Array
                (
                )

            [clauses:protected] => Array
                (
                )

            [has_or_relation:protected] => 
        )

    [date_query] => 
    [queried_object] => WP_Term Object
        (
            [term_id] => 620
            [name] => Stock
            [slug] => stock
            [term_group] => 0
            [term_taxonomy_id] => 692
            [taxonomy] => product_tag
            [description] => 
            [parent] => 0
            [count] => 6
            [filter] => raw
        )

    [queried_object_id] => 620
    [request] => SELECT SQL_CALC_FOUND_ROWS  afr7_posts.ID FROM afr7_posts  LEFT JOIN afr7_term_relationships ON (afr7_posts.ID = afr7_term_relationships.object_id) WHERE 1=1  AND ( 
  afr7_posts.ID NOT IN (
				SELECT object_id
				FROM afr7_term_relationships
				WHERE term_taxonomy_id IN (727)
			) 
  AND 
  afr7_term_relationships.term_taxonomy_id IN (692)
) AND afr7_posts.post_type = 'product' AND (afr7_posts.post_status = 'publish') GROUP BY afr7_posts.ID ORDER BY afr7_posts.menu_order ASC, afr7_posts.post_title ASC LIMIT 0, 64
    [posts] => Array
        (
            [0] => WP_Post Object
                (
                    [ID] => 7466
                    [post_author] => 1
                    [post_date] => 2017-01-22 16:19:22
                    [post_date_gmt] => 2017-01-22 14:19:22
                    [post_content] => 
                    [post_title] => L'Ochestre Kyaddondo Int. and Mwenge Jazz
                    [post_excerpt] => Two tracks from the Doromy archives in Nairobi. Gkinumanze delivers a knockout bassriff in an uptempo frenzy of a tune sung by Charles Sonko from Uganda. Kizunguzungu is a a funky coastal groover from Mwenge Jazz band of Tanzania. Check it out on our Soundcloud page or hear them below if you have Flash!  [sc_embed_player_template1 fileurl="http://www.afroseven.net/songs/charles-songo-gkinumanze.mp3"][sc_embed_player_template1 fileurl="http://www.afroseven.net/songs/mwenge-jazz-kizunguzungu.mp3"]
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => ochestre-kyaddondo-int-mwenge-jazz-kizunguzungu
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2017-01-22 20:22:45
                    [post_modified_gmt] => 2017-01-22 18:22:45
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://afro7.net/product/ochestre-kyaddondo-int-mwenge-jazz-kizunguzungu/
                    [menu_order] => 61
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 1
                    [filter] => raw
                )

            [1] => WP_Post Object
                (
                    [ID] => 7461
                    [post_author] => 1
                    [post_date] => 2017-01-22 14:02:23
                    [post_date_gmt] => 2017-01-22 14:02:23
                    [post_content] => 
                    [post_title] => Loi Tok Tok Eboma
                    [post_excerpt] => Chakacha is a furious Afro-Rock funk bomb from this fantastic group, vocals by Kasim Kombo. Flip it and you have another unique track called Mungwana, wait for the horns to kick in ! Both tracks officially licensed on our inhouse label. Head over to the front page to read the whole story! Comes in tasty Afro7 sleeve with original label design. Check audio on out below! [sc_embed_player_template1 fileurl="http://www.afroseven.net/songs/loitoktok-mungwana.mp3"][sc_embed_player_template1 fileurl="http://www.afroseven.net/songs/loitoktok-chakacha"]
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => loi-tok-tok-eboma-chakacha
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2017-08-17 08:39:49
                    [post_modified_gmt] => 2017-08-17 08:39:49
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://afro7.net/product/loi-tok-tok-eboma-chakacha/
                    [menu_order] => 62
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [2] => WP_Post Object
                (
                    [ID] => 7434
                    [post_author] => 1
                    [post_date] => 2017-01-19 21:08:23
                    [post_date_gmt] => 2017-01-19 19:08:23
                    [post_content] => 
                    [post_title] => Mac & Party
                    [post_excerpt] => Taarab doublesider killer! Harambe with it's insane R&B groove riff, flip it and you have the crazy liverpool track. Originally from mid 60s aimed for the growing tourism in Mombasa and it's regions. Both tracks officially licensed on our inhouse label. Read the full story on our front page! Comes in tasty Afro7 sleeve with original label design. Check out on our Soundcloud page or hear them below if you have Flash! [sc_embed_player_template1 fileurl="http://www.afroseven.net/songs/mac-party-harambe.mp3"][sc_embed_player_template1 fileurl="http://www.afroseven.net/songs/mac-party-liverpool.mp3"]
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => mac-party-harambe-liverpool
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2017-01-23 12:38:39
                    [post_modified_gmt] => 2017-01-23 10:38:39
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://afro7.net/product/mac-party-harambe-liverpool/
                    [menu_order] => 63
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [3] => WP_Post Object
                (
                    [ID] => 6734
                    [post_author] => 1
                    [post_date] => 2016-05-16 13:37:14
                    [post_date_gmt] => 2016-05-16 10:37:14
                    [post_content] => 
                    [post_title] => Tanya Ria
                    [post_excerpt] => Another gem on our own inhouse label, ghetto styled female funk doublesider from the streets of Nairobi! Heavy drums, horns, synth and great vocals sung by the late Tanya Ria aka Rachel Wanjiru. Go to the frontpage for the for the full story. American pressed 45's with uk centre pullout (just like original Kenya singles!) Comes in custom Afro7 silkpressed sleeve from Thailand. Limited release, all rights reserved. Check full audio below! Note: Ships in week 21. [sc_embed_player_template1 fileurl="http://www.afroseven.net/snippet/afro7-7-02a.mp3"][sc_embed_player_template1 fileurl="http://www.afroseven.net/snippet/afro7-7-02b.mp3"]
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => tanya-ria-do-the-smasher
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2017-01-22 20:20:11
                    [post_modified_gmt] => 2017-01-22 18:20:11
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => http://afro7.net/shop/afro7-records/tanya-ria-do-the-smasher-2/
                    [menu_order] => 64
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [4] => WP_Post Object
                (
                    [ID] => 6732
                    [post_author] => 1
                    [post_date] => 2016-05-16 13:27:31
                    [post_date_gmt] => 2016-05-16 10:27:31
                    [post_content] => 
                    [post_title] => Faduma Kassim
                    [post_excerpt] => First release in our own East Africa reissue series. Fantastic doublesider from Somalia. Heavy backbone flipped sax and great vocals sung by the late Faadumo Qaasim. Flip it and you have the crazy Berflasana by Ahmed Sharief Yusuf. Top sound for your home stereo or play in the clubs. Limited release. American pressed 45's with uk centre pullout (just like original Kenya singles!) Comes in custom AFRO7 silkscreen pressed sleeves. Ships in week 21.
[sc_embed_player_template1 fileurl="http://www.afroseven.net/snippet/afro7-7-01a.mp3"][sc_embed_player_template1 fileurl="http://www.afroseven.net/snippet/afro7-7-01b.mp3"]
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => faduma-kassim-majogo
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2016-06-02 10:17:03
                    [post_modified_gmt] => 2016-06-02 07:17:03
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => http://afro7.net/shop/afro7-records/faduma-kassim-majogo/
                    [menu_order] => 65
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 1
                    [filter] => raw
                )

            [5] => WP_Post Object
                (
                    [ID] => 6616
                    [post_author] => 1
                    [post_date] => 2016-03-13 16:08:10
                    [post_date_gmt] => 2016-03-13 14:08:10
                    [post_content] => 
                    [post_title] => The Scorpios
                    [post_excerpt] => First contemporary release on our own in-house label. The Scorpios is a a London outfit combining new and old in a classic traditional setting. The percussive 'Yaelhajarok' leaves a mark with it's progressive keys climax while 'Yadob Yadob' has a more minimalistic static groove approach, both tracks feature stunning vocals by Regina, Babu and Osman. This is a teaser limited seven waiting for the full album to drop later this year 2016! Comes in brown vintage sleeve.
[sc_embed_player_template1 fileurl="http://www.afroseven.net/snippet/afro7-7-03a.mp3"][sc_embed_player_template1 fileurl="http://www.afroseven.net/snippet/afro7-7-03b.mp3"]
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => the-scorpios-yaelhajarok
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2016-08-25 09:16:44
                    [post_modified_gmt] => 2016-08-25 06:16:44
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => http://afro7.net/shop/afro7-records/the-scorpios-yaelhajarok/
                    [menu_order] => 79
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

        )

    [post_count] => 6
    [current_post] => -1
    [in_the_loop] => 
    [post] => WP_Post Object
        (
            [ID] => 7466
            [post_author] => 1
            [post_date] => 2017-01-22 16:19:22
            [post_date_gmt] => 2017-01-22 14:19:22
            [post_content] => 
            [post_title] => L'Ochestre Kyaddondo Int. and Mwenge Jazz
            [post_excerpt] => Two tracks from the Doromy archives in Nairobi. Gkinumanze delivers a knockout bassriff in an uptempo frenzy of a tune sung by Charles Sonko from Uganda. Kizunguzungu is a a funky coastal groover from Mwenge Jazz band of Tanzania. Check it out on our Soundcloud page or hear them below if you have Flash!  [sc_embed_player_template1 fileurl="http://www.afroseven.net/songs/charles-songo-gkinumanze.mp3"][sc_embed_player_template1 fileurl="http://www.afroseven.net/songs/mwenge-jazz-kizunguzungu.mp3"]
            [post_status] => publish
            [comment_status] => open
            [ping_status] => closed
            [post_password] => 
            [post_name] => ochestre-kyaddondo-int-mwenge-jazz-kizunguzungu
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2017-01-22 20:22:45
            [post_modified_gmt] => 2017-01-22 18:22:45
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => https://afro7.net/product/ochestre-kyaddondo-int-mwenge-jazz-kizunguzungu/
            [menu_order] => 61
            [post_type] => product
            [post_mime_type] => 
            [comment_count] => 1
            [filter] => raw
        )

    [comment_count] => 0
    [current_comment] => -1
    [found_posts] => 6
    [max_num_pages] => 1
    [max_num_comment_pages] => 0
    [is_single] => 
    [is_preview] => 
    [is_page] => 
    [is_archive] => 1
    [is_date] => 
    [is_year] => 
    [is_month] => 
    [is_day] => 
    [is_time] => 
    [is_author] => 
    [is_category] => 
    [is_tag] => 
    [is_tax] => 1
    [is_search] => 
    [is_feed] => 
    [is_comment_feed] => 
    [is_trackback] => 
    [is_home] => 
    [is_404] => 
    [is_embed] => 
    [is_paged] => 
    [is_admin] => 
    [is_attachment] => 
    [is_singular] => 
    [is_robots] => 
    [is_posts_page] => 
    [is_post_type_archive] => 
    [query_vars_hash:WP_Query:private] => 122fc30b57285e7c04c33ef25cca171c
    [query_vars_changed:WP_Query:private] => 1
    [thumbnails_cached] => 
    [stopwords:WP_Query:private] => 
    [compat_fields:WP_Query:private] => Array
        (
            [0] => query_vars_hash
            [1] => query_vars_changed
        )

    [compat_methods:WP_Query:private] => Array
        (
            [0] => init_query_flags
            [1] => parse_tax_query
        )

)

Showing all 5 results