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 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 = '114' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '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 = '114' AND cd.language_id = '1' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT d.data_id, d.hook, d.sort_order, d.setting FROM `oc_mz_catalog_data_to_category` d2c LEFT JOIN `oc_mz_catalog_data` d ON (d.data_id = d2c.data_id) LEFT JOIN oc_category_path cp ON (cp.path_id = d2c.category_id AND d.sub_category = 1) LEFT JOIN `oc_mz_catalog_data_to_store` d2s ON (d.data_id = d2s.data_id) WHERE d.page = 'category' AND (d.customer_group_id = '1' OR d.customer_group_id = 0) AND d.customer <= 0 AND d.status = 1 AND (d.date_start IS NULL OR d.date_start <= NOW()) AND (d.date_end IS NULL OR d.date_end > NOW()) AND (cp.category_id = '114' OR d2c.category_id = '114') AND d2s.store_id = '0' GROUP BY d.data_id ORDER BY d.sort_order ASC
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout.3_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732523447)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout.3_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732523447)
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286245' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286246' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286247' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286248' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286249' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286250' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286251' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286252' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286253' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286254' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286255' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286256' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286257' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286258' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286259' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286260' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286261' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286262' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286263' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286264' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286265' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286266' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286267' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286268' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286269' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286270' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286271' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286272' AND `skin_id` = '27' ORDER BY entry_id ASC
SELECT * FROM oc_mz_layout_entry WHERE `group` = 'layout' AND group_owner = '3' AND parent_entry_id = '286273' AND `skin_id` = '27' ORDER BY entry_id ASC