Broń długa

1 ogłoszeń

Typ

Cena od-do

Województwo

Sortuj

Kaliber

Typ broni

Długość lufy (mm)

Tylko od zweryfikowanych sprzedawców

Wyczyść filtry

📷

Sprzedam

Tikka T3x Lite .308 Win - lekki karabin myśliwski

4 800 zł

Cała Polska 15.12.2025

(0.3ms) CREATE TABLE IF NOT EXISTS `brazar`.`sessions` ( `session_id` VARCHAR(255), `data` TEXT, `ip` VARCHAR(45), `agen... (0.8ms) SELECT `session_id`,`data`,`ip`,`agent`,`stamp` FROM `sessions` WHERE session_id='5d849b363ea9edaec584da1b49ddde... (2.3ms) INSERT INTO log_activity (user_id, ip_address, url, hour_key, hits) VALUES (NULL, '216.73.216.120', '/o/k/bron-d... (0.9ms) SELECT id, parent_id, slug, name, icon, status, position, date_added FROM categories WHERE status < 99 (1.4ms) SELECT ca.category_id, a.id AS attribute_id, a.slug AS attribute_slug, a.name AS attribute_name, a.type AS attri... (1.8ms) SELECT ao.attribute_id, ao.id AS option_id, ao.slug AS option_slug, ao.value AS option_value, ao.position FROM a... (0.9ms) SELECT COUNT(DISTINCT a.id) as total FROM ads a LEFT JOIN categories c ON a.category_id = c.id LEFT JOIN users u... (1.0ms) SELECT a.*, c.name as category_name, c.slug as category_slug, um_name.mval as user_name, um_verified.mval as is_...

(0.3ms) CREATE TABLE IF NOT EXISTS `brazar`.`sessions` ( `session_id` VARCHAR(255), `data` TEXT, `ip` VARCHAR(45), `agent` VARCHAR(300), `stamp` INTEGER, PRIMARY KEY (`session_id`) ); (0.8ms) SELECT `session_id`,`data`,`ip`,`agent`,`stamp` FROM `sessions` WHERE session_id='5d849b363ea9edaec584da1b49dddec6' (2.3ms) INSERT INTO log_activity (user_id, ip_address, url, hour_key, hits) VALUES (NULL, '216.73.216.120', '/o/k/bron-dluga', '2026-01-09 17', 1) ON DUPLICATE KEY UPDATE hits = hits + 1, date_added = NOW() (0.9ms) SELECT id, parent_id, slug, name, icon, status, position, date_added FROM categories WHERE status < 99 (1.4ms) SELECT ca.category_id, a.id AS attribute_id, a.slug AS attribute_slug, a.name AS attribute_name, a.type AS attribute_type, a.unit, a.position AS attribute_position, ca.is_required, ca.is_filterable, ca.position AS category_position FROM category_attributes ca JOIN attributes a ON ca.attribute_id = a.id ORDER BY ca.category_id, ca.position, a.position (1.8ms) SELECT ao.attribute_id, ao.id AS option_id, ao.slug AS option_slug, ao.value AS option_value, ao.position FROM attribute_options ao ORDER BY ao.attribute_id, ao.position (0.9ms) SELECT COUNT(DISTINCT a.id) as total FROM ads a LEFT JOIN categories c ON a.category_id = c.id LEFT JOIN users u ON a.user_id = u.id LEFT JOIN user_meta um_verified ON u.id = um_verified.user_id AND um_verified.mkey = 'is_verified_member' LEFT JOIN ad_meta am_postcode ON a.id = am_postcode.ad_id AND am_postcode.mkey = 'postcode' WHERE a.status = "active" AND (a.category_id = 8 OR c.parent_id = 8) AND NOT EXISTS ( SELECT 1 FROM global_blacklist gb WHERE gb.user_id = a.user_id AND NOT EXISTS ( SELECT 1 FROM global_whitelist_exceptions gwe WHERE gwe.blacklist_id = gb.id AND gwe.category_id = a.category_id ) ) (1.0ms) SELECT a.*, c.name as category_name, c.slug as category_slug, um_name.mval as user_name, um_verified.mval as is_verified_member, am_city.mval as city, am_postcode.mval as postcode, (SELECT filename FROM ad_images WHERE ad_id = a.id ORDER BY id LIMIT 1) as main_image FROM ads a LEFT JOIN categories c ON a.category_id = c.id LEFT JOIN users u ON a.user_id = u.id LEFT JOIN user_meta um_name ON u.id = um_name.user_id AND um_name.mkey = 'name' LEFT JOIN user_meta um_verified ON u.id = um_verified.user_id AND um_verified.mkey = 'is_verified_member' LEFT JOIN ad_meta am_city ON a.id = am_city.ad_id AND am_city.mkey = 'city' LEFT JOIN ad_meta am_postcode ON a.id = am_postcode.ad_id AND am_postcode.mkey = 'postcode' WHERE a.status = "active" AND (a.category_id = 8 OR c.parent_id = 8) AND NOT EXISTS ( SELECT 1 FROM global_blacklist gb WHERE gb.user_id = a.user_id AND NOT EXISTS ( SELECT 1 FROM global_whitelist_exceptions gwe WHERE gwe.blacklist_id = gb.id AND gwe.category_id = a.category_id ) ) ORDER BY a.date_added DESC LIMIT 20 OFFSET 0