Ceci n’est pas un site de e-commerce. Vous ne pourrez donc pas acheter des jeux directement via cette page. Après validation de votre panier, les Taverniers vous contacteront rapidement pour vous indiquer la disponibilité ou non des jeux demandés et définir avec vous les modalités de paiement et de mise à disposition dans notre boutique. Merci pour votre soutien !
array(6) {
["post_type"]=>
string(11) "gobelinshop"
["s"]=>
string(7) "pokemon"
["posts_per_page"]=>
int(12)
["paged"]=>
int(3)
["meta_query"]=>
array(2) {
["relation"]=>
string(3) "AND"
[0]=>
array(1) {
[0]=>
array(3) {
["key"]=>
string(15) "shop_visibility"
["value"]=>
int(1)
["compare"]=>
string(1) "="
}
}
}
["orderby"]=>
string(9) "relevance"
}
string(1570) "SELECT SQL_CALC_FOUND_ROWS wpevent_posts.ID
FROM wpevent_posts INNER JOIN wpevent_postmeta ON ( wpevent_posts.ID = wpevent_postmeta.post_id )
WHERE 1=1 AND (
(wpevent_posts.post_title LIKE '%pokemon%')
OR (wpevent_posts.post_content LIKE '%pokemon%')
OR EXISTS
(
SELECT * FROM wpevent_comments
WHERE comment_post_ID = wpevent_posts.ID
AND comment_content LIKE '%pokemon%'
)
OR EXISTS
(
SELECT * FROM wpevent_terms
INNER JOIN wpevent_term_taxonomy
ON wpevent_term_taxonomy.term_id = wpevent_terms.term_id
INNER JOIN wpevent_term_relationships
ON wpevent_term_relationships.term_taxonomy_id = wpevent_term_taxonomy.term_taxonomy_id
WHERE taxonomy = 'post_tag'
AND object_id = wpevent_posts.ID
AND wpevent_terms.name LIKE '%pokemon%'
)
) AND (
(
( wpevent_postmeta.meta_key = 'shop_visibility' AND wpevent_postmeta.meta_value = '1' )
)
) AND ((wpevent_posts.post_type = 'gobelinshop' AND (wpevent_posts.post_status = 'publish' OR wpevent_posts.post_status = 'acf-disabled')))
GROUP BY wpevent_posts.ID
ORDER BY wpevent_posts.post_title LIKE '{dc4dc74813f7b0f46000c1592f3da2f699b3b5d4bfdd0915bdf17352d49f753e}pokemon{dc4dc74813f7b0f46000c1592f3da2f699b3b5d4bfdd0915bdf17352d49f753e}' DESC, wpevent_posts.post_date DESC
LIMIT 24, 12"
Pokémon : Coffret Pins M. Glaquette de Galar EB4.5
20,00 €
Non Disponible
Pokémon : Coffret Pins Dedenne EB4.5
20,00 €
Non Disponible
Pokémon : Coffret Pikachu-V EB4.5
25,00 €
Non Disponible
Pokémon : Coffret Dresseur d’Élite Destinées Radieuses
