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.


IMPERIUL MARELUI JUDECATOR

În stoc
IMPERIUL. PRAF DE STELE

Stoc limitat
IMPOSIBILA OAZA. PROZE FANTASTICE

Stoc limitat
IN AFARA PAMANTULUI VOL.1-2

Stoc limitat
IN AFARA PAMANTULUI VOL.2

Stoc limitat
IN INIMA RAULUI. THRILLER

În stoc
INDIANA JONES SI TEMPLUL BLESTEMAT

Stoc limitat
INFERNO
Nou

INFERNO DAN BROWN

Pret:49,00lei


Stoc limitat
INGERII RAZBOIULUI AU VORBIT

Stoc limitat
INGINERII COSMOSULUI

În stoc
INSPECTORUL DICKINS DE LA SCOTLAND-YARD

Stoc limitat
INTAIUL CALARET AL APOCALIPSEI

Stoc limitat
INTOARCEREA

Stoc limitat
Afişare 151 - 165 din 1649 (110 pagini)
Queries: 54, Total time: 232.357 ms [By time] [By id] [By file]
1 (0.198)
SELECT `data`
FROM `oc_session`
WHERE session_id = 'd097324841391212c7d5066b03' AND expire > 1711643039
/var/www/clients/client1/web1/web/system/library/session/db.php:41
2 (0.694)
SELECT `data`
FROM `oc_session`
WHERE session_id = 'ef5cb3e8c48ca87df1d05a38ce' AND expire > 1711643039
/var/www/clients/client1/web1/web/system/library/session/db.php:41
3 (0.467)
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 (3.022)
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.451)
SELECT *
FROM oc_currency
/var/www/clients/client1/web1/web/storage/modification/system/library/cart/currency.php:10
6 (0.896)
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.669)
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.074)
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.098)
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.657)
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.845)
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.521)
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.464)
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.632)
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.497)
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 (1.035)
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 (65.968)
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 (64.522)
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 150, 15
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:179
19 (0.111)
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
20 (0.114)
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
21 (0.133)
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
22 (0.112)
SELECT *
FROM oc_module
WHERE module_id = '36'
/var/www/clients/client1/web1/web/catalog/model/setting/module.php:4
23 (77.847)
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
24 (5.213)
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
25 (0.134)
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
26 (0.259)
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
27 (0.165)
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
28 (0.153)
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
29 (0.169)
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
30 (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
31 (0.110)
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
32 (0.141)
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
33 (0.129)
SELECT *
FROM oc_module
WHERE module_id = '47'
/var/www/clients/client1/web1/web/catalog/model/setting/module.php:4
34 (0.123)
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
35 (0.089)
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
36 (0.067)
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
37 (0.076)
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
38 (0.062)
SELECT *
FROM oc_module
WHERE module_id = '46'
/var/www/clients/client1/web1/web/catalog/model/setting/module.php:4
39 (1.718)
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
40 (0.084)
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
41 (0.066)
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
42 (0.068)
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
43 (0.061)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/clients/client1/web1/web/catalog/model/setting/extension.php:4
44 (0.135)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ef5cb3e8c48ca87df1d05a38ce'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
45 (0.134)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/clients/client1/web1/web/catalog/model/setting/extension.php:4
46 (0.114)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ef5cb3e8c48ca87df1d05a38ce'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
47 (0.093)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ef5cb3e8c48ca87df1d05a38ce'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
48 (0.057)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ef5cb3e8c48ca87df1d05a38ce'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
49 (0.074)
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
50 (0.062)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ef5cb3e8c48ca87df1d05a38ce'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
51 (0.058)
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
52 (1.466)
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
53 (0.093)
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
54 (0.060)
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