Поиск

SELECT `data`
FROM `session`
WHERE `session_id` = 'cad7b65c5bff7766267295bb70' AND `expire` > '2026-01-21 21:44:27'

SELECT *
FROM store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://sila-s.ru/'

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

SELECT f1.offname f1_name, f1.level f1_level, f1.fias_id f1_fias_id
FROM fias f1
WHERE f1.offname = 'США' AND f1.level = 0

SELECT *
FROM country c
WHERE c.iso_code_2 = 'US'

SELECT code
FROM prmn_cm_currency
WHERE country_id = 223

SELECT *
FROM currency

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '223' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '223' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2785')
ORDER BY tr1.priority ASC

SELECT *
FROM weight_class wc
LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'

SELECT *
FROM length_class mc
LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'

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

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

SELECT *
FROM prmn_cm_city
ORDER BY sort, name

SELECT count(*) AS total
FROM `journal3_skin`

SELECT *
FROM layout_route
WHERE 'product/search' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT layout_id, layout_data
FROM `journal3_layout`
WHERE `layout_id` = '13' OR `layout_id` = -1
ORDER BY `layout_id` DESC

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '64' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '59' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '60' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '61' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '65' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '63' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ( pd.tag LIKE '%WA%' AND pd.tag LIKE '%0812%' AND pd.tag LIKE '%2782%' AND pd.tag LIKE '%5310%' AND pd.tag LIKE '%Perusahaan%' AND pd.tag LIKE '%Jasa%' AND pd.tag LIKE '%Pembuatan%' AND pd.tag LIKE '%Air%' AND pd.tag LIKE '%Mancur%' AND pd.tag LIKE '%Taman%' AND pd.tag LIKE '%Kota%' AND pd.tag LIKE '%Murah%' AND pd.tag LIKE '%Tulungagung%' AND pd.tag LIKE '%Jawa%' AND pd.tag LIKE '%Timur%')

SELECT p.product_id, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ( pd.tag LIKE '%WA%' AND pd.tag LIKE '%0812%' AND pd.tag LIKE '%2782%' AND pd.tag LIKE '%5310%' AND pd.tag LIKE '%Perusahaan%' AND pd.tag LIKE '%Jasa%' AND pd.tag LIKE '%Pembuatan%' AND pd.tag LIKE '%Air%' AND pd.tag LIKE '%Mancur%' AND pd.tag LIKE '%Taman%' AND pd.tag LIKE '%Kota%' AND pd.tag LIKE '%Murah%' AND pd.tag LIKE '%Tulungagung%' AND pd.tag LIKE '%Jawa%' AND pd.tag LIKE '%Timur%') GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,12

SELECT COUNT(DISTINCT p.product_id) total
FROM `product` p
LEFT JOIN `product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '1'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '0'

SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cad7b65c5bff7766267295bb70'

SELECT *
FROM bundle_expert_widget w
LEFT JOIN bundle_expert_widget_to_store w2s ON (w.widget_id = w2s.widget_id)
WHERE w.display_mode='custom_page' AND w2s.store_id = '0' AND w.status = 1
ORDER BY w.sort_order

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

SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cad7b65c5bff7766267295bb70'

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

SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cad7b65c5bff7766267295bb70'

SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cad7b65c5bff7766267295bb70'

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

SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cad7b65c5bff7766267295bb70'

SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cad7b65c5bff7766267295bb70'

SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cad7b65c5bff7766267295bb70'

SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cad7b65c5bff7766267295bb70'