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 = '12896' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
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 = '20837' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
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 = '36676' 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 = '36676' 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 = '36676' OR d2c.category_id = '36676') 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` >= 1732407034)
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` >= 1732407034)
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '0' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '112' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '166' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '167' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '168' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '169' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '170' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '171' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '172' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '173' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '174' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '175' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '176' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '177' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '178' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '179' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '180' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '181' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '182' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '183' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '184' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '185' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '186' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '187' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '188' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '189' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '190' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '191' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '192' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '193' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '194' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '195' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '196' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '197' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '198' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '199' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '200' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '201' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '202' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '203' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '204' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '205' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '206' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '207' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '208' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '209' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '211' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '210' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '165' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '257' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '214' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '215' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '216' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '217' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '218' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '219' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '220' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '221' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '222' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '223' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '224' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '225' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '226' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '227' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '228' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '229' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '230' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '231' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '232' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '233' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '234' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '235' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '236' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '237' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '238' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '239' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '240' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '241' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '242' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '243' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '244' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '245' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '246' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '247' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '248' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '249' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '250' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '251' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '252' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '253' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '254' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '255' AND menu_id = '15' ORDER BY sort_order ASC
SELECT * FROM `oc_mz_menu_item` WHERE `status` = '1' AND customer <= 0 AND (customer_group_id = '1' OR customer_group_id = 0) AND parent_item_id = '256' AND menu_id = '15' ORDER BY sort_order ASC
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout.3_g.shortcode_data_assets' AND (`timestamp` = 0 OR `timestamp` >= 1732407035)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_component.3_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732407035)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_component.3_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732407035)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_component.3_g.assets' AND (`timestamp` = 0 OR `timestamp` >= 1732407035)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_component.3_g.shortcode_data_assets' AND (`timestamp` = 0 OR `timestamp` >= 1732407035)
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 = '36676' AND cd.language_id = '1' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECTCOUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND cp.path_id = '36676'
SELECT p.product_id FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND cp.path_id = '36676' GROUP BY p.product_id ORDER BY sort_order ASC, product_id ASCLIMIT 0,30
SELECT * FROM oc_banner b LEFT JOIN oc_banner_image bi ON (b.banner_id = bi.banner_id) WHERE b.banner_id = '6' AND b.status = '1' AND bi.language_id = '1' ORDER BY bi.sort_order 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` >= 1732407036)
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` >= 1732407036)
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` >= 1732407036)
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` >= 1732407036)
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` >= 1732407036)
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` >= 1732407036)
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` >= 1732407036)
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` >= 1732407036)
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` >= 1732407036)
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` >= 1732407036)
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` >= 1732407036)
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` >= 1732407036)
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` >= 1732407036)
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` >= 1732407036)
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` >= 1732407036)
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/category' 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)