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 = '215' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3354') 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 = '215' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3354') ORDER BY tr1.priority ASC
SELECT pl.*, (SELECT name FROM oc_mz_product_label_description pld WHERE pld.product_label_id = pl.product_label_id AND pld.language_id = '1') name FROM oc_mz_product_label pl LEFT JOIN oc_mz_product_label_customer_group pl2cg ON (pl2cg.product_label_id = pl.product_label_id) LEFT JOIN oc_mz_product_label_to_store pl2s ON (pl2s.product_label_id = pl.product_label_id) WHERE pl.status = 1 AND pl2cg.customer_group_id = '1' AND pl2s.store_id = '0' AND pl.customer <= 0 GROUP BY pl.product_label_id ORDER BY pl.sort_order ASC
SELECT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m2s.store_id = '0' ORDER BY name
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_column_left.5_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_column_left.5_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_column_left.5_g.assets' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout_column_left' AND group_owner = '5' AND parent_entry_id = '0' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_column_right.5_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_column_right.5_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_column_right.5_g.assets' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout_column_right' AND group_owner = '5' AND parent_entry_id = '0' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_content_top.5_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_content_top.5_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_content_top.5_g.assets' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout_content_top' AND group_owner = '5' AND parent_entry_id = '0' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_content_bottom.5_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_content_bottom.5_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_content_bottom.5_g.assets' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout_content_bottom' AND group_owner = '5' AND parent_entry_id = '0' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.top_header.31_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.top_header.31_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.top_header.31_g.assets' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.main_header.31_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.main_header.31_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.main_header.31_g.assets' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.main_header.31_g.shortcode_data_assets' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.main_navigation.31_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.main_navigation.31_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.main_navigation.31_g.assets' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.header_component.31_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.header_component.31_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.header_component.31_g.assets' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_component.5_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_component.5_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_component.5_g.assets' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout_component' AND group_owner = '5' AND parent_entry_id = '0' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT i.information_id, id.title, i.bottom 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 = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.footer.14_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.footer.14_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732178861)
SELECT * FROM oc_mz_document d LEFT JOIN oc_mz_document_description dd ON (d.document_id = dd.document_id) WHERE d.status = 1 AND d.route = 'product/manufacturer' AND d.store_id = '0' AND dd.language_id = '1'
SELECT c.category_id FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)