Notice: Error: Table 'souq_souqprice.ti9jo39em_bf_filter' doesn't exist Error No: 1146 SELECT COUNT(*) AS total FROM ( SELECT p.product_id, p.sort_order, srch.search_rank, "1" AS match_filters FROM `ti9jo39em_product` AS p INNER JOIN `ti9jo39em_product_to_store` AS p2s ON (p2s.product_id = p.product_id) INNER JOIN `ti9jo39em_bf_filter` AS f ON (p.product_id = f.product_id) INNER JOIN ( SELECT p.product_id, 2 search_rank FROM `ti9jo39em_product` AS p INNER JOIN `ti9jo39em_product_description` AS pd ON (p.product_id = pd.product_id) WHERE ((pd.name LIKE '%toshiba%' AND pd.name LIKE '%smart%' AND pd.name LIKE '%tv%') OR (p.model LIKE '%toshiba%' AND p.model LIKE '%smart%' AND p.model LIKE '%tv%')) UNION SELECT p.product_id, 1 search_rank FROM `ti9jo39em_product` AS p INNER JOIN `ti9jo39em_product_description` AS pd ON (p.product_id = pd.product_id) WHERE ((pd.name REGEXP '[[:<:]]toshiba[[:>:]]' AND pd.name REGEXP '[[:<:]]smart[[:>:]]' AND pd.name REGEXP '[[:<:]]tv[[:>:]]') OR (p.model REGEXP '[[:<:]]toshiba[[:>:]]' AND p.model REGEXP '[[:<:]]smart[[:>:]]' AND p.model REGEXP '[[:<:]]tv[[:>:]]'))) AS srch ON (srch.product_id = p.product_id) WHERE p2s.store_id = '0' AND (p.quantity > 0) GROUP BY p.product_id HAVING match_filters = 1 ORDER BY srch.search_rank) AS t in /home/souqprice.com/public_html/jo/system/library/db/mysqli.php on line 44Notice: Trying to get property 'row' of non-object in /home/souqprice.com/public_html/jo/system/storage/modification/catalog/model/catalog/product.php on line 475Notice: Trying to access array offset on value of type null in /home/souqprice.com/public_html/jo/system/storage/modification/catalog/model/catalog/product.php on line 475Notice: Error: Table 'souq_souqprice.ti9jo39em_bf_filter' doesn't exist Error No: 1146 SELECT p.product_id, p.sort_order, srch.search_rank, "1" AS match_filters, pp.quantity, pp.stock_status_id, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), IF(MIN(pd2.price) IS NOT NULL, MIN(pd2.price), p.price))) AS actual_price FROM `ti9jo39em_product` AS p INNER JOIN `ti9jo39em_product_to_store` AS p2s ON (p2s.product_id = p.product_id) INNER JOIN `ti9jo39em_bf_filter` AS f ON (p.product_id = f.product_id) INNER JOIN ( SELECT p.product_id, 2 search_rank FROM `ti9jo39em_product` AS p INNER JOIN `ti9jo39em_product_description` AS pd ON (p.product_id = pd.product_id) WHERE ((pd.name LIKE '%toshiba%' AND pd.name LIKE '%smart%' AND pd.name LIKE '%tv%') OR (p.model LIKE '%toshiba%' AND p.model LIKE '%smart%' AND p.model LIKE '%tv%')) UNION SELECT p.product_id, 1 search_rank FROM `ti9jo39em_product` AS p INNER JOIN `ti9jo39em_product_description` AS pd ON (p.product_id = pd.product_id) WHERE ((pd.name REGEXP '[[:<:]]toshiba[[:>:]]' AND pd.name REGEXP '[[:<:]]smart[[:>:]]' AND pd.name REGEXP '[[:<:]]tv[[:>:]]') OR (p.model REGEXP '[[:<:]]toshiba[[:>:]]' AND p.model REGEXP '[[:<:]]smart[[:>:]]' AND p.model REGEXP '[[:<:]]tv[[:>:]]'))) AS srch ON (srch.product_id = p.product_id) INNER JOIN `ti9jo39em_product_description` AS pd ON (pd.product_id = p.product_id) INNER JOIN `ti9jo39em_product` AS pp ON (pp.product_id = p.product_id) LEFT JOIN `ti9jo39em_product_discount` AS pd2 ON (pd2.product_id = p.product_id
AND pd2.quantity = '1'
AND (pd2.date_start = '0000-00-00' OR pd2.date_start < NOW())
AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())
AND pd2.customer_group_id = '1') LEFT JOIN `ti9jo39em_product_special` AS ps ON (ps.product_id = p.product_id
AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())
AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND ps.customer_group_id = '1') WHERE p2s.store_id = '0' AND (p.quantity > 0) AND pd.language_id = '1' GROUP BY p.product_id HAVING match_filters = 1 ORDER BY srch.search_rank, CASE WHEN pp.quantity > 0 THEN 10 WHEN pp.quantity = 0 AND pp.stock_status_id = 8 THEN 9 WHEN pp.quantity = 0 AND pp.stock_status_id = 9 THEN 8 WHEN pp.quantity = 0 AND pp.stock_status_id = 10 THEN 7 WHEN pp.quantity = 0 AND pp.stock_status_id = 5 THEN 5 END DESC, actual_price ASC, pd.name ASC LIMIT 0, 16 in /home/souqprice.com/public_html/jo/system/library/db/mysqli.php on line 44Notice: Trying to get property 'rows' of non-object in /home/souqprice.com/public_html/jo/system/storage/modification/catalog/model/catalog/product.php on line 130Warning: Invalid argument supplied for foreach() in /home/souqprice.com/public_html/jo/system/storage/modification/catalog/model/catalog/product.php on line 130Toshiba Smart Tv in Jordan | Find the Lowest Prices
Find the best toshiba smart tv price in Jordan, browse the full range of toshiba smart tv in all stores in Jordan. SouqPrice is your ultimate shopping companion.
There is no product that matches the search criteria.
