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 m.manufacturer_id = '286' AND m2s.store_id = '0'
SELECT d.data_id, d.hook, d.sort_order, d.setting FROM `oc_mz_catalog_data_to_manufacturer` d2m LEFT JOIN `oc_mz_catalog_data` d ON (d.data_id = d2m.data_id) LEFT JOIN `oc_mz_catalog_data_to_store` d2s ON (d.data_id = d2s.data_id) WHERE d2m.manufacturer_id = '286' AND d.page = 'manufacturer' 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 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.15_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732188530)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout.15_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732188530)
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.15_g.shortcode_data_assets' AND (`timestamp` = 0 OR `timestamp` >= 1732188532)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_component.15_g.shortcode_data' AND (`timestamp` = 0 OR `timestamp` >= 1732188532)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_component.15_g.entry_layout-l1TRY0' AND (`timestamp` = 0 OR `timestamp` >= 1732188532)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_component.15_g.assets' AND (`timestamp` = 0 OR `timestamp` >= 1732188532)
SELECT value FROM `oc_mz_cache` WHERE `key` = 'mz_poco.megastore-4.27.0.layout.layout_component.15_g.shortcode_data_assets' AND (`timestamp` = 0 OR `timestamp` >= 1732188532)
SELECTCOUNT(DISTINCT p.product_id) AS total FROM oc_product p 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 p.manufacturer_id = '286'
SELECT p.product_id FROM oc_product p 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 p.manufacturer_id = '286' GROUP BY p.product_id ORDER BY sort_order ASC, product_id ASCLIMIT 0,30
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` >= 1732188532)
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` >= 1732188532)
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` >= 1732188532)
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` >= 1732188532)
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` >= 1732188532)
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` >= 1732188532)
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` >= 1732188532)
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` >= 1732188532)
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` >= 1732188532)
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` >= 1732188532)
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` >= 1732188532)
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` >= 1732188532)
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` >= 1732188532)
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` >= 1732188532)
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` >= 1732188532)
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/info' 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)
SELECT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '286' AND m2s.store_id = '0'