Carti din domeniul LITERATURA SF

Va pasioneaza genul literar stiintifico-fantastic? In Anticariat Ursu gasiti numerosi autori straini, dar si romani de literatura de anticipatie: carti SF scrise de Isaac Asimov, carti Frank Herbert, carti Arthur C. Clarke, carti H.G. Wells, etc.


CAINELE NEGRU

Stoc limitat
CAINII RAZBOIULUI

Stoc limitat
CAMERA OBSCURA

Stoc limitat
CANIONUL TIRANOZAURULUI

Stoc limitat
CAPCANA KRYANILOR

În stoc
CARANTINA

CARANTINA GREG EGAN

Pret:9,99lei


Stoc limitat
CARTEA LUI VAN VOGT

Stoc limitat
CARTEA PIERDUTA A VRAJITOARELOR

Stoc limitat
CASA DE LA RASCRUCE

Stoc limitat
CASA JUDECATORULUI

Stoc limitat
CASA SECRETA

Stoc limitat
CASA TUNETULUI

CASA TUNETULUI DEAN R. KOONTZ

Pret de la:3,99lei


În stoc
CASA VESNICIEI

În stoc
CAVALERII LUI TAU

În stoc
Afişare 46 - 60 din 1649 (110 pagini)
Queries: 55, Total time: 212.737 ms [By time] [By id] [By file]
1 (0.124)
SELECT `data`
FROM `oc_session`
WHERE session_id = 'bbf0cf86ee16a70d92d6204c03' AND expire > 1711670284
/var/www/clients/client1/web1/web/system/library/session/db.php:41
2 (0.174)
SELECT `data`
FROM `oc_session`
WHERE session_id = '310139974f010fbdaa9ac0fa72' AND expire > 1711670284
/var/www/clients/client1/web1/web/system/library/session/db.php:41
3 (0.156)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://anticariat-ursu.ro/'
/var/www/clients/client1/web1/web/catalog/controller/startup/startup.php:6
4 (0.665)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/clients/client1/web1/web/catalog/controller/startup/startup.php:25
5 (0.117)
SELECT *
FROM oc_currency
/var/www/clients/client1/web1/web/storage/modification/system/library/cart/currency.php:10
6 (0.195)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'payment' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2703')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/cart/tax.php:30
7 (0.226)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2703')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/cart/tax.php:44
8 (0.140)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/var/www/clients/client1/web1/web/system/library/cart/weight.php:10
9 (0.117)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/var/www/clients/client1/web1/web/system/library/cart/length.php:10
10 (1.400)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 DAY)
/var/www/clients/client1/web1/web/system/library/cart/cart.php:29
11 (0.124)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/var/www/clients/client1/web1/web/catalog/model/setting/event.php:4
12 (0.078)
SELECT *
FROM oc_seo_url
WHERE keyword = 'LITERATURA' AND store_id = '0'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:37
13 (0.167)
SELECT *
FROM oc_seo_url
WHERE keyword = 'LITERATURA-SF' AND store_id = '0'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:37
14 (0.174)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '63' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:7
15 (0.142)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '23' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:7
16 (0.291)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '23' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:19
17 (58.799)
SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, p.tax_class_id, "1" AS match_filters
FROM `oc_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
INNER JOIN `oc_category_path` AS cp ON (cp.category_id = p2c.category_id)
WHERE p.date_available <= NOW() AND cp.path_id = '23' GROUP BY p.product_id HAVING match_filters = 1) AS t
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1145
18 (62.771)
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, p.tax_class_id, "1" AS match_filters, pp.sort_order, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
INNER JOIN `oc_category_path` AS cp ON (cp.category_id = p2c.category_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p.date_available <= NOW() AND cp.path_id = '23' AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pd.name ASC, IF ((p.quantity) > 0, 1, 0) LIMIT 45, 15
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:179
19 (0.173)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=61235' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
20 (0.097)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '23' AND store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:108
21 (0.136)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
22 (0.122)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'column_left'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
23 (0.131)
SELECT *
FROM oc_module
WHERE module_id = '36'
/var/www/clients/client1/web1/web/catalog/model/setting/module.php:4
24 (74.481)
SELECT a.attribute_group_id AS group_id, av.attribute_id AS attr_id, av.attribute_value_id AS val_id, ad.name AS attr_name, av.sort_order AS val_sort, av.value
FROM ( SELECT afc.*
FROM `oc_bf_product_attribute_value` AS afc) AS af
INNER JOIN ( SELECT p.*
FROM `oc_product` AS p
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
INNER JOIN `oc_category_path` AS cp ON (cp.category_id = p2c.category_id)
WHERE cp.path_id = '23') AS p ON (af.product_id = p.product_id)
INNER JOIN `oc_bf_attribute_value` AS av ON (af.attribute_value_id = av.attribute_value_id)
INNER JOIN `oc_attribute` AS a ON (a.attribute_id = av.attribute_id)
INNER JOIN `oc_attribute_description` AS ad ON (ad.attribute_id = a.attribute_id)
WHERE ad.language_id = '2' AND av.language_id = '2' AND p.status = 1 GROUP BY av.attribute_value_id
ORDER BY a.sort_order, ad.name, av.sort_order, av.value
/var/www/clients/client1/web1/web/catalog/model/extension/module/brainyfilter.php:1129
25 (4.673)
SELECT DISTINCT m.manufacturer_id AS id, m.name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
INNER JOIN `oc_category_path` AS cp ON (cp.category_id = p2c.category_id)
WHERE p.status = 1 AND p.date_available <= NOW() AND cp.path_id = '23'
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/extension/module/brainyfilter.php:1230
26 (0.176)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/extension/module/brainyfilter.php:1251
27 (0.317)
SELECT cd.name, c.category_id AS id, c.parent_id AS pid
FROM `oc_category` AS c
INNER JOIN `oc_category_description` AS cd ON (c.category_id = cd.category_id)
WHERE cd.language_id = '2'
ORDER BY c.parent_id, c.sort_order, LCASE(cd.name)
/var/www/clients/client1/web1/web/catalog/model/extension/module/brainyfilter.php:1413
28 (0.126)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '23' AND store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:108
29 (0.165)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
30 (0.144)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'column_right'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
31 (0.097)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '23' AND store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:108
32 (0.139)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
33 (0.136)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_top'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
34 (0.063)
SELECT *
FROM oc_module
WHERE module_id = '47'
/var/www/clients/client1/web1/web/catalog/model/setting/module.php:4
35 (0.120)
SELECT *
FROM `oc_pb_bundles`
WHERE `store_id`='0' AND `products` != '' AND `status`= '1' AND `date_available` <= NOW() AND `categories_show` LIKE '%"23"%' LIMIT 0, 2
/var/www/clients/client1/web1/web/catalog/model/extension/module/productbundles.php:92
36 (0.098)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '23' AND store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:108
37 (0.148)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
38 (0.128)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
39 (0.124)
SELECT *
FROM oc_module
WHERE module_id = '46'
/var/www/clients/client1/web1/web/catalog/model/setting/module.php:4
40 (1.681)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/information.php:10
41 (0.135)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=6' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
42 (0.158)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=3' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
43 (0.165)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=5' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
44 (0.064)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/clients/client1/web1/web/catalog/model/setting/extension.php:4
45 (0.179)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '310139974f010fbdaa9ac0fa72'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
46 (0.182)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/clients/client1/web1/web/catalog/model/setting/extension.php:4
47 (0.163)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '310139974f010fbdaa9ac0fa72'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
48 (0.116)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '310139974f010fbdaa9ac0fa72'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
49 (0.105)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '310139974f010fbdaa9ac0fa72'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
50 (0.120)
SELECT *
FROM `oc_pb_bundles`
WHERE `store_id`='0' AND `products` != '' AND `status`= '1' AND `date_available` <= NOW()
ORDER BY `sort_order` ASC
/var/www/clients/client1/web1/web/catalog/model/extension/module/productbundles.php:92
51 (0.118)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '310139974f010fbdaa9ac0fa72'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
52 (0.059)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/clients/client1/web1/web/system/library/cart/customer.php:243
53 (1.679)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/information.php:10
54 (0.100)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=7' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
55 (0.058)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=4' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169