Regisztráció

SET time_zone = '+00:00'

SELECT `data`
FROM `oc_session`
WHERE `session_id` = '379ac4adb4f7877eaa06d2d162' AND `expire` > '2024-09-08 00:43:20'

SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://szegimedshop.com/'

SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC

SET time_zone = '+02:00'

SELECT *
FROM oc_currency

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 = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '97' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4259')
ORDER BY tr1.priority ASC

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 = '97' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4259')
ORDER BY tr1.priority ASC

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 = '1'

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 = '1'

DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)

SELECT new_url , code, store_id
FROM oc_redirect_manager
WHERE old_url = 'index.php?route=account/register' AND status = 1 AND store_id = 0 LIMIT 1

SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '379ac4adb4f7877eaa06d2d162'

CREATE TABLE IF NOT EXISTS `oc_xtensions` (`setting_id` int(11) NOT NULL AUTO_INCREMENT, `store_id` int(11) NOT NULL DEFAULT '0', `module` varchar(256) NOT NULL, `key` varchar(64) NOT NULL, `value` longtext NOT NULL, `serialized` tinyint(4) NOT NULL, PRIMARY KEY (`setting_id`)) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

SELECT *
FROM oc_xtensions
WHERE `key`='version_installed' AND store_id = '0' AND module = 'xtensions_best_checkout'

SELECT *
FROM `oc_xtensions`
WHERE store_id = 0 AND `key` <> 'version_installed'

SELECT *
FROM `oc_store`

SELECT *
FROM oc_xtensions
WHERE `key`='status' AND store_id = '0' AND module = 'xtensions_best_checkout'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1'

SELECT *
FROM oc_xtensions
WHERE store_id = '0' AND module = 'xtensions_best_checkout'

SELECT *, cf.custom_field_id, cfd.language_id
FROM `oc_custom_field` cf
LEFT JOIN `oc_xcustom_field` xcf ON (cf.custom_field_id = xcf.custom_field_id)
LEFT JOIN `oc_custom_field_description` cfd ON (cf.custom_field_id = cfd.custom_field_id)
LEFT JOIN `oc_xcustom_field_description` xcfd ON (cfd.custom_field_id = xcfd.custom_field_id AND cfd.language_id = xcfd.language_id)
WHERE cf.status = '1' AND cfd.language_id = '1' AND cf.status = '1'
ORDER BY cf.sort_order ASC

SELECT *
FROM oc_theme
WHERE store_id = '0'

SELECT DISTINCT *
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 i.information_id = '3' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'

SELECT *
FROM oc_layout_route
WHERE 'account/register' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT p.product_id
FROM `oc_product` p
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE p.product_id IN (0) AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 481

SELECT *
FROM oc_product_to_category
WHERE product_id = '481'
ORDER BY category_id DESC LIMIT 1

SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '1'

SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 515

SELECT *
FROM oc_product_to_category
WHERE product_id = '515'
ORDER BY category_id DESC LIMIT 1

SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '4'

SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 204

SELECT *
FROM oc_product_to_category
WHERE product_id = '204'
ORDER BY category_id DESC LIMIT 1

SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '1'

SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 316

SELECT *
FROM oc_product_to_category
WHERE product_id = '316'
ORDER BY category_id DESC LIMIT 1

SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '1'

SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 320

SELECT *
FROM oc_product_to_category
WHERE product_id = '320'
ORDER BY category_id DESC LIMIT 1

SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '1'

SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 298

SELECT *
FROM oc_product_to_category
WHERE product_id = '298'
ORDER BY category_id DESC LIMIT 1

SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '2'

SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 295

SELECT *
FROM oc_product_to_category
WHERE product_id = '295'
ORDER BY category_id DESC LIMIT 1

SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '2'

SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 214

SELECT *
FROM oc_product_to_category
WHERE product_id = '214'
ORDER BY category_id DESC LIMIT 1

SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '1'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM `oc_journal3_module`

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM oc_extension
WHERE `type` = 'analytics'

SELECT *
FROM oc_country
WHERE country_id = '97'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '379ac4adb4f7877eaa06d2d162'

SELECT *
FROM oc_extension
WHERE `type` = 'total'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '379ac4adb4f7877eaa06d2d162'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '379ac4adb4f7877eaa06d2d162'

SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '379ac4adb4f7877eaa06d2d162'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '379ac4adb4f7877eaa06d2d162'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '379ac4adb4f7877eaa06d2d162'

SELECT *
FROM oc_extension
WHERE `type` = 'total'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '379ac4adb4f7877eaa06d2d162'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '379ac4adb4f7877eaa06d2d162'

SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '379ac4adb4f7877eaa06d2d162'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'