Site Map

SELECT `data`
FROM `session`
WHERE `session_id` = '8b24e72eca724f202a29d900b6' AND `expire` > '2026-02-08 13:17:01'

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

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

SELECT code
FROM prmn_cm_currency
WHERE country_id = 0

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 = '0' 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 = '0' 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 = '2'

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

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 'information/sitemap' LIKE route AND store_id = '1'
ORDER BY route DESC LIMIT 1

SELECT layout_id, layout_data
FROM `journal3_layout`
WHERE `layout_id` = '9' 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 = '2' AND c2s.store_id = '1' 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 = '2' AND c2s.store_id = '1' 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 = '2' AND c2s.store_id = '1' 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 = '2' AND c2s.store_id = '1' 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 = '2' AND c2s.store_id = '1' 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 = '2' AND c2s.store_id = '1' 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 = '2' AND c2s.store_id = '1' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '1' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC

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

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

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

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

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

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

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 = '8b24e72eca724f202a29d900b6'

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

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

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

SELECT *
FROM journal3_setting
WHERE store_id = '1' AND `setting_name` = 'blogPageKeyword'

SELECT c.category_id, cd.name
FROM `journal3_blog_category` c
LEFT JOIN `journal3_blog_category_description` cd ON c.category_id = cd.category_id
LEFT JOIN `journal3_blog_category_to_store` c2s ON c.category_id = c2s.category_id
WHERE c.status = 1 AND cd.language_id = '2' AND c2s.store_id = '1'
ORDER BY c.sort_order