dd Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT

SET time_zone = '+03:00'

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 = '117' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4060')
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 = '117' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4060')
ORDER BY tr1.priority ASC

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '60d3a564618962ac58c407bf092d301c'

SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `event_id` ASC

SELECT p.*, pd.*, m.*, pd.name AS name, p.image, m.name AS manufacturer, md.seo_keyword AS manufacturer_seo_keyword, prw.points AS reward, wcd.unit AS weight_class, lcd.unit AS length_class, AVG(r.rating) AS rating, COUNT(DISTINCT r.review_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN oc_manufacturer_description md ON (p.manufacturer_id = md.manufacturer_id AND md.language_id = '1')
LEFT JOIN oc_product_reward prw ON (prw.product_id = p.product_id AND prw.customer_group_id = '1')
LEFT JOIN oc_weight_class_description wcd ON (p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1')
LEFT JOIN oc_length_class_description lcd ON (p.length_class_id = lcd.length_class_id AND lcd.language_id = '1')
LEFT JOIN oc_review r ON (r.product_id = p.product_id AND r.status = '1')
WHERE p.product_id = '336' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() GROUP BY p.product_id

WITH RECURSIVE cgd AS ( SELECT cgd.percentage
FROM `oc_customer_group_discount` AS cgd
WHERE cgd.status = '1' AND cgd.customer_group_id = '0' AND (cgd.date_start = '0000-00-00' OR cgd.date_start < NOW())
ORDER BY cgd.priority ASC, cgd.percentage ASC LIMIT 0, 1), cat_anc AS (SELECT c.category_id AS desc_id, c.category_id AS anc_id, 0 AS depth
FROM `oc_category` c UNION ALL SELECT a.desc_id, c.parent_id AS anc_id, a.depth + 1
FROM cat_anc a
INNER JOIN `oc_category` c ON c.category_id = a.anc_id
WHERE c.parent_id != 0) SELECT p.product_id, CASE WHEN psf.price IS NOT NULL THEN p.price WHEN psp.percentage IS NOT NULL THEN p.price WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END AS `before`, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END) AS discount, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END * IF(psf.price IS NULL AND psp.percentage IS NULL AND (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)) + MAX(IFNULL(vnd.percentage, 0))) < 100, (100 - (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)) + MAX(IFNULL(vnd.percentage, 0)))) / 100, 1)) AS final
FROM `oc_product` AS p
LEFT JOIN cgd ON (1)
LEFT JOIN `oc_product_special` AS psf ON (psf.product_id = p.product_id AND psf.discount_type = 'F' AND psf.price > 0 AND (psf.date_start = '0000-00-00' OR psf.date_start < NOW()) AND (psf.date_end = '0000-00-00' OR psf.date_end >= CURDATE()) AND psf.customer_group_id = '1')
LEFT JOIN `oc_product_special` AS psp ON (psp.product_id = p.product_id AND psp.discount_type = 'P' AND psp.percentage > 0 AND (psp.date_start = '0000-00-00' OR psp.date_start < NOW()) AND (psp.date_end = '0000-00-00' OR psp.date_end >= CURDATE()) AND psp.customer_group_id = '1')
LEFT JOIN `oc_product_discount` AS pdf ON (pdf.product_id = p.product_id AND pdf.quantity <= p.minimum AND pdf.discount_type = 'F' AND pdf.price > 0 AND (pdf.date_start = '0000-00-00' OR pdf.date_start < NOW()) AND pdf.customer_group_id = '1')
LEFT JOIN `oc_product_discount` AS pdp ON (pdp.product_id = p.product_id AND pdp.quantity <= p.minimum AND pdp.discount_type = 'P' AND pdp.percentage > 0 AND (pdp.date_start = '0000-00-00' OR pdp.date_start < NOW()) AND pdp.customer_group_id = '1')
LEFT JOIN `oc_product_to_category` AS ptc ON (ptc.product_id = p.product_id)
LEFT JOIN cat_anc ON (cat_anc.desc_id = ptc.category_id)
LEFT JOIN `oc_category_discount` AS cd ON ((cd.category_id = cat_anc.anc_id AND (cat_anc.depth = 0 OR cd.affect = '1')) AND cd.status = '1' AND cd.customer_group_id = '1' AND cd.qty <= p.minimum AND cd.qty IS NOT NULL AND (cd.date_start = '0000-00-00' OR cd.date_start < NOW()))
LEFT JOIN `oc_vendor_discount` AS vnd ON (vnd.vendor = p.vendor AND vnd.status = '1' AND vnd.customer_group_id = '1' AND vnd.qty <= p.minimum AND (vnd.date_start = '0000-00-00' OR vnd.date_start <= CURDATE()) AND (vnd.date_end = '0000-00-00' OR vnd.date_end >= CURDATE()))
WHERE p.status = '1' AND p.date_available <= NOW() AND p.product_id IN ('336') GROUP BY p.product_id
ORDER BY psf.priority ASC, psp.priority ASC, psf.price ASC, psp.percentage DESC, pdf.priority ASC, pdp.priority ASC, pdf.price ASC, pdp.percentage DESC, cd.priority ASC, cd.percentage DESC, vnd.priority ASC, vnd.percentage DESC

SELECT *
FROM oc_product p
WHERE p.product_id IN (336)

WITH RECURSIVE cgd AS ( SELECT cgd.percentage
FROM `oc_customer_group_discount` AS cgd
WHERE cgd.status = '1' AND cgd.customer_group_id = '11' AND (cgd.date_start = '0000-00-00' OR cgd.date_start < NOW())
ORDER BY cgd.priority ASC, cgd.percentage ASC LIMIT 0, 1), cat_anc AS (SELECT c.category_id AS desc_id, c.category_id AS anc_id, 0 AS depth
FROM `oc_category` c UNION ALL SELECT a.desc_id, c.parent_id AS anc_id, a.depth + 1
FROM cat_anc a
INNER JOIN `oc_category` c ON c.category_id = a.anc_id
WHERE c.parent_id != 0) SELECT p.product_id, CASE WHEN psf.price IS NOT NULL THEN p.price WHEN psp.percentage IS NOT NULL THEN p.price WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END AS `before`, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END) AS discount, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END * IF(psf.price IS NULL AND psp.percentage IS NULL AND (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)) + MAX(IFNULL(vnd.percentage, 0))) < 100, (100 - (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)) + MAX(IFNULL(vnd.percentage, 0)))) / 100, 1)) AS final
FROM `oc_product` AS p
LEFT JOIN cgd ON (1)
LEFT JOIN `oc_product_special` AS psf ON (psf.product_id = p.product_id AND psf.discount_type = 'F' AND psf.price > 0 AND (psf.date_start = '0000-00-00' OR psf.date_start < NOW()) AND (psf.date_end = '0000-00-00' OR psf.date_end >= CURDATE()) AND psf.customer_group_id = '11')
LEFT JOIN `oc_product_special` AS psp ON (psp.product_id = p.product_id AND psp.discount_type = 'P' AND psp.percentage > 0 AND (psp.date_start = '0000-00-00' OR psp.date_start < NOW()) AND (psp.date_end = '0000-00-00' OR psp.date_end >= CURDATE()) AND psp.customer_group_id = '11')
LEFT JOIN `oc_product_discount` AS pdf ON (pdf.product_id = p.product_id AND pdf.quantity <= p.minimum AND pdf.discount_type = 'F' AND pdf.price > 0 AND (pdf.date_start = '0000-00-00' OR pdf.date_start < NOW()) AND pdf.customer_group_id = '11')
LEFT JOIN `oc_product_discount` AS pdp ON (pdp.product_id = p.product_id AND pdp.quantity <= p.minimum AND pdp.discount_type = 'P' AND pdp.percentage > 0 AND (pdp.date_start = '0000-00-00' OR pdp.date_start < NOW()) AND pdp.customer_group_id = '11')
LEFT JOIN `oc_product_to_category` AS ptc ON (ptc.product_id = p.product_id)
LEFT JOIN cat_anc ON (cat_anc.desc_id = ptc.category_id)
LEFT JOIN `oc_category_discount` AS cd ON ((cd.category_id = cat_anc.anc_id AND (cat_anc.depth = 0 OR cd.affect = '1')) AND cd.status = '1' AND cd.customer_group_id = '11' AND cd.qty <= p.minimum AND cd.qty IS NOT NULL AND (cd.date_start = '0000-00-00' OR cd.date_start < NOW()))
LEFT JOIN `oc_vendor_discount` AS vnd ON (vnd.vendor = p.vendor AND vnd.status = '1' AND vnd.customer_group_id = '11' AND vnd.qty <= p.minimum AND (vnd.date_start = '0000-00-00' OR vnd.date_start <= CURDATE()) AND (vnd.date_end = '0000-00-00' OR vnd.date_end >= CURDATE()))
WHERE p.status = '1' AND p.date_available <= NOW() AND p.product_id IN ('336') GROUP BY p.product_id
ORDER BY psf.priority ASC, psp.priority ASC, psf.price ASC, psp.percentage DESC, pdf.priority ASC, pdp.priority ASC, pdf.price ASC, pdp.percentage DESC, cd.priority ASC, cd.percentage DESC, vnd.priority ASC, vnd.percentage DESC

SHOW TABLES LIKE 'oc_vehicle_application'

SHOW TABLES LIKE 'oc_product_fitment'

SELECT COUNT(*) AS total
FROM `oc_product_fitment`
WHERE product_id = '336'

SELECT pf.note, va.year, va.make, va.model, va.trim, va.engine
FROM `oc_product_fitment` pf
INNER JOIN `oc_vehicle_application` va ON (va.vehicle_application_id = pf.vehicle_application_id)
WHERE pf.product_id = '336'
ORDER BY va.year DESC, va.make ASC, va.model ASC, va.trim ASC, va.engine ASC LIMIT 0, 20

SELECT *
FROM oc_product_to_category
WHERE product_id = '336'

SELECT pc.category_id, t1.parent_id, (!ISNULL(t1.parent_id) + !ISNULL(t2.parent_id) + !ISNULL(t3.parent_id) + !ISNULL(t4.parent_id) + !ISNULL(t5.parent_id))*1000 + IF(t1.sort_order>0,(1000-t1.sort_order),0) + IF(t2.sort_order>0,(1000-t2.sort_order),0) + IF(t3.sort_order>0,(1000-t3.sort_order),0) + IF(t4.sort_order>0,(1000-t4.sort_order),0) + IF(t5.sort_order>0,(1000-t5.sort_order),0) AS priority
FROM oc_product_to_category pc
LEFT JOIN oc_category t1 ON t1.category_id = pc.category_id
LEFT JOIN oc_category t2 ON t1.parent_id = t2.category_id
LEFT JOIN oc_category t3 ON t2.parent_id = t3.category_id
LEFT JOIN oc_category t4 ON t3.parent_id = t4.category_id
LEFT JOIN oc_category t5 ON t4.parent_id = t5.category_id
WHERE product_id = '336'
ORDER BY priority DESC

SELECT cp.path_id AS category_id, cd.name, cd.seo_keyword
FROM oc_category_path cp
INNER JOIN oc_category c ON (cp.path_id = c.category_id)
INNER JOIN oc_category_description cd ON (cp.path_id = cd.category_id)
WHERE cp.category_id = '65' AND cd.language_id = '1' AND c.status = '1'
ORDER BY cp.level

SHOW TABLES LIKE 'oc_sales_document'

SHOW COLUMNS
FROM `oc_sales_document` LIKE 'code'

SHOW COLUMNS
FROM `oc_sales_document` LIKE 'name'

SHOW COLUMNS
FROM `oc_sales_document` LIKE 'filename'

SHOW COLUMNS
FROM `oc_sales_document` LIKE 'relative_path'

SHOW COLUMNS
FROM `oc_sales_document` LIKE 'extension'

SHOW COLUMNS
FROM `oc_sales_document` LIKE 'mime_type'

SHOW COLUMNS
FROM `oc_sales_document` LIKE 'source'

SHOW COLUMNS
FROM `oc_sales_document` LIKE 'date_added'

SHOW COLUMNS
FROM `oc_sales_document` LIKE 'date_modified'

SHOW INDEX
FROM `oc_sales_document`
WHERE Key_name = 'code'

SHOW INDEX
FROM `oc_sales_document`
WHERE Key_name = 'extension'

SHOW INDEX
FROM `oc_sales_document`
WHERE Key_name = 'source'

SHOW INDEX
FROM `oc_sales_document`
WHERE Key_name = 'date_added'

SHOW TABLES LIKE 'oc_sales_document_link'

SHOW COLUMNS
FROM `oc_sales_document_link` LIKE 'sales_document_id'

SHOW COLUMNS
FROM `oc_sales_document_link` LIKE 'entity_type'

SHOW COLUMNS
FROM `oc_sales_document_link` LIKE 'entity_id'

SHOW COLUMNS
FROM `oc_sales_document_link` LIKE 'context'

SHOW COLUMNS
FROM `oc_sales_document_link` LIKE 'date_added'

SHOW INDEX
FROM `oc_sales_document_link`
WHERE Key_name = 'uniq_link'

SHOW INDEX
FROM `oc_sales_document_link`
WHERE Key_name = 'entity_lookup'

SHOW INDEX
FROM `oc_sales_document_link`
WHERE Key_name = 'sales_document_id'

SELECT sd.*, GROUP_CONCAT(DISTINCT CONCAT(sdl.entity_type, ':', sdl.entity_id, ':', sdl.context) SEPARATOR '||') AS links
FROM `oc_sales_document` sd
INNER JOIN `oc_sales_document_link` sdl ON (sdl.sales_document_id = sd.sales_document_id)
WHERE sdl.entity_type = 'product' AND sdl.entity_id = '336' AND sdl.context = 'catalog_download' GROUP BY sd.sales_document_id
ORDER BY sd.date_added DESC, sd.sales_document_id DESC

SELECT DISTINCT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id AND md.language_id = '1')
WHERE m.manufacturer_id = '0' AND m.status = '1'

CREATE TABLE IF NOT EXISTS `oc_product_customtab` ( `product_customtab_id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) NOT NULL, `sort_order` int(11) NOT NULL, `status` tinyint(1) NOT NULL, PRIMARY KEY (`product_customtab_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE IF NOT EXISTS `oc_product_customtab_description` ( `product_customtab_id` int(11) NOT NULL, `language_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `title` varchar(255) CHARACTER SET utf8 NOT NULL, `description` text CHARACTER SET utf8 NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1

SELECT *
FROM oc_product_customtab pc
LEFT JOIN oc_product_customtab_description pcd ON (pc.product_customtab_id = pcd.product_customtab_id)
WHERE pc.product_id = '336' AND pcd.language_id = '1' AND pc.status > 0
ORDER BY pc.sort_order ASC

SELECT *
FROM oc_product_image
WHERE product_id = '336'
ORDER BY sort_order ASC

SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '4' AND ucd.language_id = '1'

SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '336' AND od.language_id = '1'
ORDER BY o.sort_order

SHOW TABLES LIKE 'oc_product_upsell'

SELECT pu.*, p.minimum AS upsell_minimum
FROM oc_product_upsell pu
INNER JOIN oc_product p ON (p.product_id = pu.upsell_product_id)
WHERE pu.product_id = '336' AND pu.status = '1' AND (pu.date_start = '0000-00-00' OR pu.date_start <= CURDATE()) AND (pu.date_end = '0000-00-00' OR pu.date_end >= CURDATE()) AND p.status = '1' AND p.date_available <= NOW() AND p.type NOT LIKE 'option'
ORDER BY pu.sort_order ASC, pu.product_upsell_id ASC

CREATE TABLE IF NOT EXISTS `oc_rental_reservation` ( `rental_reservation_id` int(11) NOT NULL AUTO_INCREMENT, `order_id` int(11) NOT NULL DEFAULT '0', `order_product_id` int(11) NOT NULL DEFAULT '0', `product_id` int(11) NOT NULL, `quantity` int(11) NOT NULL DEFAULT '0', `rental_unit` varchar(16) NOT NULL DEFAULT 'day', `starts_at_utc` datetime NOT NULL, `ends_at_utc` datetime NOT NULL, `blocked_from_utc` datetime NOT NULL, `blocked_until_utc` datetime NOT NULL, `billing_units` decimal(15,4) NOT NULL DEFAULT '0.0000', `base_rate` decimal(15,4) NOT NULL DEFAULT '0.0000', `unit_price` decimal(15,4) NOT NULL DEFAULT '0.0000', `discount_percent` decimal(15,4) NOT NULL DEFAULT '0.0000', `subtotal` decimal(15,4) NOT NULL DEFAULT '0.0000', `deposit_amount` decimal(15,4) NOT NULL DEFAULT '0.0000', `deposit_total` decimal(15,4) NOT NULL DEFAULT '0.0000', `deposit_status` varchar(32) NOT NULL DEFAULT 'pending', `order_status_id` int(11) NOT NULL DEFAULT '0', `is_blocking` tinyint(1) NOT NULL DEFAULT '0', `metadata_json` mediumtext, `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`rental_reservation_id`), UNIQUE KEY `order_product_id` (`order_product_id`), KEY `product_block_window` (`product_id`,`blocked_from_utc`,`blocked_until_utc`,`is_blocking`), KEY `order_id` (`order_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_rental_blackout` ( `rental_blackout_id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) NOT NULL, `blocked_qty` int(11) NOT NULL DEFAULT '0', `starts_at_utc` datetime NOT NULL, `ends_at_utc` datetime NOT NULL, `reason` varchar(255) NOT NULL DEFAULT '', `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`rental_blackout_id`), KEY `product_window` (`product_id`,`starts_at_utc`,`ends_at_utc`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_rental_maintenance_type` ( `maintenance_type_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(128) NOT NULL, `name_json` mediumtext, `color` varchar(16) NOT NULL DEFAULT '#7A8A99', `default_duration_minutes` int(11) NOT NULL DEFAULT '0', `sort_order` int(11) NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL DEFAULT '1', `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`maintenance_type_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_rental_maintenance_event` ( `maintenance_event_id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) NOT NULL, `maintenance_type_id` int(11) NOT NULL DEFAULT '0', `blocked_qty` int(11) NOT NULL DEFAULT '0', `starts_at_utc` datetime NOT NULL, `ends_at_utc` datetime NOT NULL, `note` text, `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`maintenance_event_id`), KEY `product_window` (`product_id`,`starts_at_utc`,`ends_at_utc`), KEY `maintenance_type_id` (`maintenance_type_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

SHOW COLUMNS
FROM `oc_rental_maintenance_type` LIKE 'name_json'

SELECT language_id, code
FROM `oc_language`

SELECT maintenance_type_id, name_json
FROM `oc_rental_maintenance_type`
WHERE name = 'Cleaning' OR name = 'Tirisana' LIMIT 1

SELECT maintenance_type_id, name_json
FROM `oc_rental_maintenance_type`
WHERE name = 'Full service' OR name = 'Pilna apkope' LIMIT 1

SELECT maintenance_type_id, name_json
FROM `oc_rental_maintenance_type`
WHERE name = 'Full technical service' OR name = 'Pilna tehniska apkope' LIMIT 1

SELECT maintenance_type_id, name_json
FROM `oc_rental_maintenance_type`
WHERE name = 'Other' OR name = 'Cits' LIMIT 1

SELECT `key`, `value`, `serialized`
FROM `oc_setting`
WHERE `code` = 'rental_inventory' AND store_id IN (0, '0')
ORDER BY store_id ASC

CREATE TABLE IF NOT EXISTS `oc_booking_location` ( `booking_location_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL, `slug` varchar(191) NOT NULL, `address_line` varchar(255) NOT NULL DEFAULT '', `city` varchar(128) NOT NULL DEFAULT '', `phone` varchar(64) NOT NULL DEFAULT '', `email` varchar(191) NOT NULL DEFAULT '', `description` mediumtext, `seo_title` varchar(255) NOT NULL DEFAULT '', `seo_description` varchar(255) NOT NULL DEFAULT '', `faq_json` mediumtext, `sort_order` int(11) NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL DEFAULT '1', `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`booking_location_id`), UNIQUE KEY `slug` (`slug`), KEY `status_sort` (`status`,`sort_order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_booking_service` ( `booking_service_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL, `slug` varchar(191) NOT NULL, `description` mediumtext, `seo_title` varchar(255) NOT NULL DEFAULT '', `seo_description` varchar(255) NOT NULL DEFAULT '', `price_from` decimal(15,4) NOT NULL DEFAULT '0.0000', `required_resource_type` varchar(16) NOT NULL DEFAULT '', `sort_order` int(11) NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL DEFAULT '1', `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`booking_service_id`), UNIQUE KEY `slug` (`slug`), KEY `status_sort` (`status`,`sort_order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_booking_service_location` ( `booking_service_location_id` int(11) NOT NULL AUTO_INCREMENT, `service_id` int(11) NOT NULL, `location_id` int(11) NOT NULL, `resource_id` int(11) NOT NULL DEFAULT '0', `duration_minutes` int(11) NOT NULL DEFAULT '60', `buffer_before` int(11) NOT NULL DEFAULT '0', `buffer_after` int(11) NOT NULL DEFAULT '0', `payment_mode` varchar(16) NOT NULL DEFAULT 'none', `allow_standalone` tinyint(1) NOT NULL DEFAULT '1', `allow_checkout_attach` tinyint(1) NOT NULL DEFAULT '0', `resource_type` varchar(16) NOT NULL DEFAULT '', `slot_step_minutes` int(11) NOT NULL DEFAULT '30', `checkout_product_id` int(11) NOT NULL DEFAULT '0', `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`booking_service_location_id`), UNIQUE KEY `service_location` (`service_id`,`location_id`), KEY `location_id` (`location_id`), KEY `resource_id` (`resource_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_booking_resource` ( `booking_resource_id` int(11) NOT NULL AUTO_INCREMENT, `location_id` int(11) NOT NULL, `name` varchar(191) NOT NULL, `type` varchar(16) NOT NULL DEFAULT 'bay', `capacity` int(11) NOT NULL DEFAULT '1', `status` tinyint(1) NOT NULL DEFAULT '1', `sort_order` int(11) NOT NULL DEFAULT '0', `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`booking_resource_id`), KEY `location_type_status` (`location_id`,`type`,`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_booking_resource_schedule` ( `booking_resource_schedule_id` int(11) NOT NULL AUTO_INCREMENT, `location_id` int(11) NOT NULL, `resource_id` int(11) NOT NULL DEFAULT '0', `day_of_week` tinyint(1) NOT NULL DEFAULT '1', `start_time_local` time NOT NULL, `end_time_local` time NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`booking_resource_schedule_id`), KEY `location_day` (`location_id`,`day_of_week`,`status`), KEY `resource_day` (`resource_id`,`day_of_week`,`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_booking_blackout` ( `booking_blackout_id` int(11) NOT NULL AUTO_INCREMENT, `location_id` int(11) NOT NULL, `service_id` int(11) NOT NULL DEFAULT '0', `resource_id` int(11) NOT NULL DEFAULT '0', `title` varchar(191) NOT NULL DEFAULT '', `reason` varchar(255) NOT NULL DEFAULT '', `start_at_utc` datetime NOT NULL, `end_at_utc` datetime NOT NULL, `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`booking_blackout_id`), KEY `window_lookup` (`location_id`,`resource_id`,`start_at_utc`,`end_at_utc`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_booking` ( `booking_id` int(11) NOT NULL AUTO_INCREMENT, `booking_service_location_id` int(11) NOT NULL DEFAULT '0', `location_id` int(11) NOT NULL, `service_id` int(11) NOT NULL, `resource_id` int(11) NOT NULL DEFAULT '0', `order_id` int(11) NOT NULL DEFAULT '0', `order_product_id` int(11) NULL DEFAULT NULL, `source_type` varchar(32) NOT NULL DEFAULT 'standalone', `tire_source` varchar(32) NOT NULL DEFAULT '', `payment_mode` varchar(16) NOT NULL DEFAULT 'none', `payment_state` varchar(32) NOT NULL DEFAULT 'not_required', `status` varchar(32) NOT NULL DEFAULT 'scheduled', `starts_at_utc` datetime NOT NULL, `ends_at_utc` datetime NOT NULL, `buffer_start_utc` datetime NOT NULL, `buffer_end_utc` datetime NOT NULL, `vehicle_registration_no` varchar(64) NOT NULL DEFAULT '', `vehicle_make` varchar(128) NOT NULL DEFAULT '', `vehicle_model` varchar(128) NOT NULL DEFAULT '', `vehicle_year` varchar(16) NOT NULL DEFAULT '', `customer_name` varchar(191) NOT NULL DEFAULT '', `customer_email` varchar(191) NOT NULL DEFAULT '', `customer_phone` varchar(64) NOT NULL DEFAULT '', `customer_comment` text, `consent_terms` tinyint(1) NOT NULL DEFAULT '0', `consent_marketing` tinyint(1) NOT NULL DEFAULT '0', `metadata_json` mediumtext, `order_status_id` int(11) NOT NULL DEFAULT '0', `is_blocking` tinyint(1) NOT NULL DEFAULT '0', `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`booking_id`), UNIQUE KEY `order_product_id` (`order_product_id`), KEY `location_window_status` (`location_id`,`starts_at_utc`,`ends_at_utc`,`status`,`is_blocking`), KEY `resource_window_status` (`resource_id`,`starts_at_utc`,`ends_at_utc`,`status`,`is_blocking`), KEY `order_id` (`order_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_booking_item` ( `booking_item_id` int(11) NOT NULL AUTO_INCREMENT, `booking_id` int(11) NOT NULL, `product_id` int(11) NOT NULL DEFAULT '0', `quantity` int(11) NOT NULL DEFAULT '1', `source` varchar(32) NOT NULL DEFAULT 'cart', `date_added` datetime NOT NULL, PRIMARY KEY (`booking_item_id`), KEY `booking_id` (`booking_id`), KEY `product_id` (`product_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_booking_status_history` ( `booking_status_history_id` int(11) NOT NULL AUTO_INCREMENT, `booking_id` int(11) NOT NULL, `status` varchar(32) NOT NULL, `comment` text, `actor` varchar(64) NOT NULL DEFAULT 'system', `date_added` datetime NOT NULL, PRIMARY KEY (`booking_status_history_id`), KEY `booking_id` (`booking_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

SHOW COLUMNS
FROM `oc_booking_service_location` LIKE 'resource_id'

SHOW COLUMNS
FROM `oc_booking` LIKE 'order_product_id'

UPDATE `oc_booking` SET order_product_id = NULL
WHERE order_product_id = '0'

SHOW INDEX
FROM `oc_booking`
WHERE Key_name = 'order_product_id'

SHOW TABLES LIKE 'oc_url_alias'

SELECT language_id, code
FROM `oc_language`
WHERE status = '1'

SELECT query
FROM `oc_url_alias`
WHERE query = 'booking/booking' AND language_id = '1' LIMIT 1

SELECT query
FROM `oc_url_alias`
WHERE query = 'booking/booking' AND language_id = '2' LIMIT 1

SELECT query
FROM `oc_url_alias`
WHERE query = 'booking/booking' AND language_id = '3' LIMIT 1

SELECT `key`, `value`, `serialized`
FROM `oc_setting`
WHERE `code` = 'booking_module' AND store_id IN (0, '0')
ORDER BY store_id ASC

CREATE TABLE IF NOT EXISTS `oc_booking_location` ( `booking_location_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL, `slug` varchar(191) NOT NULL, `address_line` varchar(255) NOT NULL DEFAULT '', `city` varchar(128) NOT NULL DEFAULT '', `phone` varchar(64) NOT NULL DEFAULT '', `email` varchar(191) NOT NULL DEFAULT '', `description` mediumtext, `seo_title` varchar(255) NOT NULL DEFAULT '', `seo_description` varchar(255) NOT NULL DEFAULT '', `faq_json` mediumtext, `sort_order` int(11) NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL DEFAULT '1', `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`booking_location_id`), UNIQUE KEY `slug` (`slug`), KEY `status_sort` (`status`,`sort_order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_booking_service` ( `booking_service_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL, `slug` varchar(191) NOT NULL, `description` mediumtext, `seo_title` varchar(255) NOT NULL DEFAULT '', `seo_description` varchar(255) NOT NULL DEFAULT '', `price_from` decimal(15,4) NOT NULL DEFAULT '0.0000', `required_resource_type` varchar(16) NOT NULL DEFAULT '', `sort_order` int(11) NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL DEFAULT '1', `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`booking_service_id`), UNIQUE KEY `slug` (`slug`), KEY `status_sort` (`status`,`sort_order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_booking_service_location` ( `booking_service_location_id` int(11) NOT NULL AUTO_INCREMENT, `service_id` int(11) NOT NULL, `location_id` int(11) NOT NULL, `resource_id` int(11) NOT NULL DEFAULT '0', `duration_minutes` int(11) NOT NULL DEFAULT '60', `buffer_before` int(11) NOT NULL DEFAULT '0', `buffer_after` int(11) NOT NULL DEFAULT '0', `payment_mode` varchar(16) NOT NULL DEFAULT 'none', `allow_standalone` tinyint(1) NOT NULL DEFAULT '1', `allow_checkout_attach` tinyint(1) NOT NULL DEFAULT '0', `resource_type` varchar(16) NOT NULL DEFAULT '', `slot_step_minutes` int(11) NOT NULL DEFAULT '30', `checkout_product_id` int(11) NOT NULL DEFAULT '0', `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`booking_service_location_id`), UNIQUE KEY `service_location` (`service_id`,`location_id`), KEY `location_id` (`location_id`), KEY `resource_id` (`resource_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_booking_resource` ( `booking_resource_id` int(11) NOT NULL AUTO_INCREMENT, `location_id` int(11) NOT NULL, `name` varchar(191) NOT NULL, `type` varchar(16) NOT NULL DEFAULT 'bay', `capacity` int(11) NOT NULL DEFAULT '1', `status` tinyint(1) NOT NULL DEFAULT '1', `sort_order` int(11) NOT NULL DEFAULT '0', `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`booking_resource_id`), KEY `location_type_status` (`location_id`,`type`,`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_booking_resource_schedule` ( `booking_resource_schedule_id` int(11) NOT NULL AUTO_INCREMENT, `location_id` int(11) NOT NULL, `resource_id` int(11) NOT NULL DEFAULT '0', `day_of_week` tinyint(1) NOT NULL DEFAULT '1', `start_time_local` time NOT NULL, `end_time_local` time NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`booking_resource_schedule_id`), KEY `location_day` (`location_id`,`day_of_week`,`status`), KEY `resource_day` (`resource_id`,`day_of_week`,`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_booking_blackout` ( `booking_blackout_id` int(11) NOT NULL AUTO_INCREMENT, `location_id` int(11) NOT NULL, `service_id` int(11) NOT NULL DEFAULT '0', `resource_id` int(11) NOT NULL DEFAULT '0', `title` varchar(191) NOT NULL DEFAULT '', `reason` varchar(255) NOT NULL DEFAULT '', `start_at_utc` datetime NOT NULL, `end_at_utc` datetime NOT NULL, `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`booking_blackout_id`), KEY `window_lookup` (`location_id`,`resource_id`,`start_at_utc`,`end_at_utc`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_booking` ( `booking_id` int(11) NOT NULL AUTO_INCREMENT, `booking_service_location_id` int(11) NOT NULL DEFAULT '0', `location_id` int(11) NOT NULL, `service_id` int(11) NOT NULL, `resource_id` int(11) NOT NULL DEFAULT '0', `order_id` int(11) NOT NULL DEFAULT '0', `order_product_id` int(11) NULL DEFAULT NULL, `source_type` varchar(32) NOT NULL DEFAULT 'standalone', `tire_source` varchar(32) NOT NULL DEFAULT '', `payment_mode` varchar(16) NOT NULL DEFAULT 'none', `payment_state` varchar(32) NOT NULL DEFAULT 'not_required', `status` varchar(32) NOT NULL DEFAULT 'scheduled', `starts_at_utc` datetime NOT NULL, `ends_at_utc` datetime NOT NULL, `buffer_start_utc` datetime NOT NULL, `buffer_end_utc` datetime NOT NULL, `vehicle_registration_no` varchar(64) NOT NULL DEFAULT '', `vehicle_make` varchar(128) NOT NULL DEFAULT '', `vehicle_model` varchar(128) NOT NULL DEFAULT '', `vehicle_year` varchar(16) NOT NULL DEFAULT '', `customer_name` varchar(191) NOT NULL DEFAULT '', `customer_email` varchar(191) NOT NULL DEFAULT '', `customer_phone` varchar(64) NOT NULL DEFAULT '', `customer_comment` text, `consent_terms` tinyint(1) NOT NULL DEFAULT '0', `consent_marketing` tinyint(1) NOT NULL DEFAULT '0', `metadata_json` mediumtext, `order_status_id` int(11) NOT NULL DEFAULT '0', `is_blocking` tinyint(1) NOT NULL DEFAULT '0', `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`booking_id`), UNIQUE KEY `order_product_id` (`order_product_id`), KEY `location_window_status` (`location_id`,`starts_at_utc`,`ends_at_utc`,`status`,`is_blocking`), KEY `resource_window_status` (`resource_id`,`starts_at_utc`,`ends_at_utc`,`status`,`is_blocking`), KEY `order_id` (`order_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_booking_item` ( `booking_item_id` int(11) NOT NULL AUTO_INCREMENT, `booking_id` int(11) NOT NULL, `product_id` int(11) NOT NULL DEFAULT '0', `quantity` int(11) NOT NULL DEFAULT '1', `source` varchar(32) NOT NULL DEFAULT 'cart', `date_added` datetime NOT NULL, PRIMARY KEY (`booking_item_id`), KEY `booking_id` (`booking_id`), KEY `product_id` (`product_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `oc_booking_status_history` ( `booking_status_history_id` int(11) NOT NULL AUTO_INCREMENT, `booking_id` int(11) NOT NULL, `status` varchar(32) NOT NULL, `comment` text, `actor` varchar(64) NOT NULL DEFAULT 'system', `date_added` datetime NOT NULL, PRIMARY KEY (`booking_status_history_id`), KEY `booking_id` (`booking_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

SHOW COLUMNS
FROM `oc_booking_service_location` LIKE 'resource_id'

SHOW COLUMNS
FROM `oc_booking` LIKE 'order_product_id'

UPDATE `oc_booking` SET order_product_id = NULL
WHERE order_product_id = '0'

SHOW INDEX
FROM `oc_booking`
WHERE Key_name = 'order_product_id'

SHOW TABLES LIKE 'oc_url_alias'

SELECT language_id, code
FROM `oc_language`
WHERE status = '1'

SELECT query
FROM `oc_url_alias`
WHERE query = 'booking/booking' AND language_id = '1' LIMIT 1

SELECT query
FROM `oc_url_alias`
WHERE query = 'booking/booking' AND language_id = '2' LIMIT 1

SELECT query
FROM `oc_url_alias`
WHERE query = 'booking/booking' AND language_id = '3' LIMIT 1

SELECT *
FROM `oc_booking_location`
WHERE status = '1'
ORDER BY sort_order ASC, name ASC

SELECT sl.*, l.name AS location_name, s.name AS service_name, s.slug AS service_slug, l.slug AS location_slug, s.description AS service_description, s.price_from, s.required_resource_type, r.name AS resource_name, r.type AS resource_rule_type
FROM `oc_booking_service_location` sl
INNER JOIN `oc_booking_location` l ON (l.booking_location_id = sl.location_id)
INNER JOIN `oc_booking_service` s ON (s.booking_service_id = sl.service_id)
LEFT JOIN `oc_booking_resource` r ON (r.booking_resource_id = sl.resource_id)
WHERE 1 = 1 AND sl.allow_checkout_attach = '1'
ORDER BY l.sort_order ASC, s.sort_order ASC, s.name ASC

SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '336' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

SELECT *
FROM oc_product_to_layout
WHERE product_id = '336'

SELECT *
FROM oc_layout_module
WHERE layout_id = '2'
ORDER BY sort_order

SELECT seo_keyword
FROM `oc_product_description`
WHERE `product_id` = '336' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC

SELECT seo_keyword
FROM `oc_product_description`
WHERE `product_id` = '336' AND (`language_id` = '2' OR `language_id` = 0)
ORDER BY language_id DESC

SELECT seo_keyword
FROM `oc_product_description`
WHERE `product_id` = '336' AND (`language_id` = '3' OR `language_id` = 0)
ORDER BY language_id DESC

SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'

SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE ucd.language_id = '1'

SELECT *
FROM oc_product_related pr
LEFT JOIN oc_product p ON (pr.related_id = p.product_id)
WHERE pr.product_id = '336' AND p.status = '1' AND p.date_available <= NOW() AND p.type NOT LIKE 'option'

SELECT *
FROM oc_product p
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.product_id != '336' AND p.status = '1' AND p.type NOT LIKE 'option'AND (p2c.category_id = '65'OR p2c.category_id = '243')
ORDER BY rand() LIMIT 5

WITH RECURSIVE cgd AS ( SELECT cgd.percentage
FROM `oc_customer_group_discount` AS cgd
WHERE cgd.status = '1' AND cgd.customer_group_id = '0' AND (cgd.date_start = '0000-00-00' OR cgd.date_start < NOW())
ORDER BY cgd.priority ASC, cgd.percentage ASC LIMIT 0, 1), cat_anc AS (SELECT c.category_id AS desc_id, c.category_id AS anc_id, 0 AS depth
FROM `oc_category` c UNION ALL SELECT a.desc_id, c.parent_id AS anc_id, a.depth + 1
FROM cat_anc a
INNER JOIN `oc_category` c ON c.category_id = a.anc_id
WHERE c.parent_id != 0) SELECT p.product_id, CASE WHEN psf.price IS NOT NULL THEN p.price WHEN psp.percentage IS NOT NULL THEN p.price WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END AS `before`, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END) AS discount, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END * IF(psf.price IS NULL AND psp.percentage IS NULL AND (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)) + MAX(IFNULL(vnd.percentage, 0))) < 100, (100 - (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)) + MAX(IFNULL(vnd.percentage, 0)))) / 100, 1)) AS final
FROM `oc_product` AS p
LEFT JOIN cgd ON (1)
LEFT JOIN `oc_product_special` AS psf ON (psf.product_id = p.product_id AND psf.discount_type = 'F' AND psf.price > 0 AND (psf.date_start = '0000-00-00' OR psf.date_start < NOW()) AND (psf.date_end = '0000-00-00' OR psf.date_end >= CURDATE()) AND psf.customer_group_id = '1')
LEFT JOIN `oc_product_special` AS psp ON (psp.product_id = p.product_id AND psp.discount_type = 'P' AND psp.percentage > 0 AND (psp.date_start = '0000-00-00' OR psp.date_start < NOW()) AND (psp.date_end = '0000-00-00' OR psp.date_end >= CURDATE()) AND psp.customer_group_id = '1')
LEFT JOIN `oc_product_discount` AS pdf ON (pdf.product_id = p.product_id AND pdf.quantity <= p.minimum AND pdf.discount_type = 'F' AND pdf.price > 0 AND (pdf.date_start = '0000-00-00' OR pdf.date_start < NOW()) AND pdf.customer_group_id = '1')
LEFT JOIN `oc_product_discount` AS pdp ON (pdp.product_id = p.product_id AND pdp.quantity <= p.minimum AND pdp.discount_type = 'P' AND pdp.percentage > 0 AND (pdp.date_start = '0000-00-00' OR pdp.date_start < NOW()) AND pdp.customer_group_id = '1')
LEFT JOIN `oc_product_to_category` AS ptc ON (ptc.product_id = p.product_id)
LEFT JOIN cat_anc ON (cat_anc.desc_id = ptc.category_id)
LEFT JOIN `oc_category_discount` AS cd ON ((cd.category_id = cat_anc.anc_id AND (cat_anc.depth = 0 OR cd.affect = '1')) AND cd.status = '1' AND cd.customer_group_id = '1' AND cd.qty <= p.minimum AND cd.qty IS NOT NULL AND (cd.date_start = '0000-00-00' OR cd.date_start < NOW()))
LEFT JOIN `oc_vendor_discount` AS vnd ON (vnd.vendor = p.vendor AND vnd.status = '1' AND vnd.customer_group_id = '1' AND vnd.qty <= p.minimum AND (vnd.date_start = '0000-00-00' OR vnd.date_start <= CURDATE()) AND (vnd.date_end = '0000-00-00' OR vnd.date_end >= CURDATE()))
WHERE p.status = '1' AND p.date_available <= NOW() AND p.product_id IN ('330','332','18','331','310') GROUP BY p.product_id
ORDER BY psf.priority ASC, psp.priority ASC, psf.price ASC, psp.percentage DESC, pdf.priority ASC, pdp.priority ASC, pdf.price ASC, pdp.percentage DESC, cd.priority ASC, cd.percentage DESC, vnd.priority ASC, vnd.percentage DESC

SELECT p.*, pd.*, m.*, pd.name AS name, p.image, m.name AS manufacturer, md.seo_keyword AS manufacturer_seo_keyword, prw.points AS reward, wcd.unit AS weight_class, lcd.unit AS length_class, AVG(r.rating) AS rating, COUNT(DISTINCT r.review_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN oc_manufacturer_description md ON (p.manufacturer_id = md.manufacturer_id AND md.language_id = '1')
LEFT JOIN oc_product_reward prw ON (prw.product_id = p.product_id AND prw.customer_group_id = '1')
LEFT JOIN oc_weight_class_description wcd ON (p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1')
LEFT JOIN oc_length_class_description lcd ON (p.length_class_id = lcd.length_class_id AND lcd.language_id = '1')
LEFT JOIN oc_review r ON (r.product_id = p.product_id AND r.status = '1')
WHERE p.product_id IN (330,332,18,331,310) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() GROUP BY p.product_id
ORDER BY FIELD(p.product_id,330,332,18,331,310)

SELECT *
FROM oc_product p
WHERE p.product_id IN (330,332,18,331,310)

WITH RECURSIVE cgd AS ( SELECT cgd.percentage
FROM `oc_customer_group_discount` AS cgd
WHERE cgd.status = '1' AND cgd.customer_group_id = '11' AND (cgd.date_start = '0000-00-00' OR cgd.date_start < NOW())
ORDER BY cgd.priority ASC, cgd.percentage ASC LIMIT 0, 1), cat_anc AS (SELECT c.category_id AS desc_id, c.category_id AS anc_id, 0 AS depth
FROM `oc_category` c UNION ALL SELECT a.desc_id, c.parent_id AS anc_id, a.depth + 1
FROM cat_anc a
INNER JOIN `oc_category` c ON c.category_id = a.anc_id
WHERE c.parent_id != 0) SELECT p.product_id, CASE WHEN psf.price IS NOT NULL THEN p.price WHEN psp.percentage IS NOT NULL THEN p.price WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END AS `before`, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END) AS discount, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END * IF(psf.price IS NULL AND psp.percentage IS NULL AND (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)) + MAX(IFNULL(vnd.percentage, 0))) < 100, (100 - (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)) + MAX(IFNULL(vnd.percentage, 0)))) / 100, 1)) AS final
FROM `oc_product` AS p
LEFT JOIN cgd ON (1)
LEFT JOIN `oc_product_special` AS psf ON (psf.product_id = p.product_id AND psf.discount_type = 'F' AND psf.price > 0 AND (psf.date_start = '0000-00-00' OR psf.date_start < NOW()) AND (psf.date_end = '0000-00-00' OR psf.date_end >= CURDATE()) AND psf.customer_group_id = '11')
LEFT JOIN `oc_product_special` AS psp ON (psp.product_id = p.product_id AND psp.discount_type = 'P' AND psp.percentage > 0 AND (psp.date_start = '0000-00-00' OR psp.date_start < NOW()) AND (psp.date_end = '0000-00-00' OR psp.date_end >= CURDATE()) AND psp.customer_group_id = '11')
LEFT JOIN `oc_product_discount` AS pdf ON (pdf.product_id = p.product_id AND pdf.quantity <= p.minimum AND pdf.discount_type = 'F' AND pdf.price > 0 AND (pdf.date_start = '0000-00-00' OR pdf.date_start < NOW()) AND pdf.customer_group_id = '11')
LEFT JOIN `oc_product_discount` AS pdp ON (pdp.product_id = p.product_id AND pdp.quantity <= p.minimum AND pdp.discount_type = 'P' AND pdp.percentage > 0 AND (pdp.date_start = '0000-00-00' OR pdp.date_start < NOW()) AND pdp.customer_group_id = '11')
LEFT JOIN `oc_product_to_category` AS ptc ON (ptc.product_id = p.product_id)
LEFT JOIN cat_anc ON (cat_anc.desc_id = ptc.category_id)
LEFT JOIN `oc_category_discount` AS cd ON ((cd.category_id = cat_anc.anc_id AND (cat_anc.depth = 0 OR cd.affect = '1')) AND cd.status = '1' AND cd.customer_group_id = '11' AND cd.qty <= p.minimum AND cd.qty IS NOT NULL AND (cd.date_start = '0000-00-00' OR cd.date_start < NOW()))
LEFT JOIN `oc_vendor_discount` AS vnd ON (vnd.vendor = p.vendor AND vnd.status = '1' AND vnd.customer_group_id = '11' AND vnd.qty <= p.minimum AND (vnd.date_start = '0000-00-00' OR vnd.date_start <= CURDATE()) AND (vnd.date_end = '0000-00-00' OR vnd.date_end >= CURDATE()))
WHERE p.status = '1' AND p.date_available <= NOW() AND p.product_id IN ('18','310','330','331','332') GROUP BY p.product_id
ORDER BY psf.priority ASC, psp.priority ASC, psf.price ASC, psp.percentage DESC, pdf.priority ASC, pdp.priority ASC, pdf.price ASC, pdp.percentage DESC, cd.priority ASC, cd.percentage DESC, vnd.priority ASC, vnd.percentage DESC

SELECT *
FROM oc_product_to_category
WHERE product_id = '330'

SELECT DISTINCT c.*, cd.*, GROUP_CONCAT(cep.parent_id
ORDER BY cep.sort_order ASC) as parent_ids
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_extra_parents cep ON (c.category_id = cep.category_id)
WHERE c.category_id = '65' AND cd.language_id = '1' AND c.status = '1' GROUP BY c.category_id

SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '330' AND od.language_id = '1'
ORDER BY o.sort_order

SELECT *
FROM oc_product_label pl
WHERE pl.status = 1
ORDER BY pl.sort_order ASC

SELECT manufacturer_id
FROM oc_product
WHERE product_id = '330'

SELECT *
FROM oc_product_to_category
WHERE product_id = '332'

SELECT DISTINCT c.*, cd.*, GROUP_CONCAT(cep.parent_id
ORDER BY cep.sort_order ASC) as parent_ids
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_extra_parents cep ON (c.category_id = cep.category_id)
WHERE c.category_id = '65' AND cd.language_id = '1' AND c.status = '1' GROUP BY c.category_id

SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '332' AND od.language_id = '1'
ORDER BY o.sort_order

SELECT manufacturer_id
FROM oc_product
WHERE product_id = '332'

SELECT *
FROM oc_product_to_category
WHERE product_id = '18'

SELECT DISTINCT c.*, cd.*, GROUP_CONCAT(cep.parent_id
ORDER BY cep.sort_order ASC) as parent_ids
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_extra_parents cep ON (c.category_id = cep.category_id)
WHERE c.category_id = '65' AND cd.language_id = '1' AND c.status = '1' GROUP BY c.category_id

SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '18' AND od.language_id = '1'
ORDER BY o.sort_order

SELECT *
FROM oc_product_to_category
WHERE product_id = '331'

SELECT DISTINCT c.*, cd.*, GROUP_CONCAT(cep.parent_id
ORDER BY cep.sort_order ASC) as parent_ids
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_extra_parents cep ON (c.category_id = cep.category_id)
WHERE c.category_id = '65' AND cd.language_id = '1' AND c.status = '1' GROUP BY c.category_id

SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '331' AND od.language_id = '1'
ORDER BY o.sort_order

SELECT manufacturer_id
FROM oc_product
WHERE product_id = '331'

SELECT *
FROM oc_product_to_category
WHERE product_id = '310'

SELECT DISTINCT c.*, cd.*, GROUP_CONCAT(cep.parent_id
ORDER BY cep.sort_order ASC) as parent_ids
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_extra_parents cep ON (c.category_id = cep.category_id)
WHERE c.category_id = '65' AND cd.language_id = '1' AND c.status = '1' GROUP BY c.category_id

SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '310' AND od.language_id = '1'
ORDER BY o.sort_order

SELECT manufacturer_id
FROM oc_product
WHERE product_id = '336'

SELECT product_id
FROM `oc_product_option_value`
WHERE o2p_ids = '336'

CREATE TABLE IF NOT EXISTS `oc_tabs` ( `tabs_id` int(11) NOT NULL AUTO_INCREMENT, `products` text NOT NULL, `categories` text NOT NULL, `manufactures` text NOT NULL, `vendors` text NOT NULL, `stock_statuses` text NOT NULL, `special_filter` tinyint(1) NOT NULL DEFAULT '0', `customer_groups` text NOT NULL, `customer_group_all` tinyint(1) NOT NULL DEFAULT '1', `include_subcategories` tinyint(1) NOT NULL DEFAULT '0', `ingore_products` text NOT NULL, `ignore_categories` text NOT NULL, `ignore_manufacturers` text NOT NULL, `ignore_vendors` text NOT NULL, `stores` text NOT NULL, `allproducts` tinyint(4) NOT NULL, `status` int(11) NOT NULL, `sort_order` int(11) NOT NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`tabs_id`) ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci

CREATE TABLE IF NOT EXISTS `oc_tabs_description` ( `tabs_id` int(11) NOT NULL, `language_id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `description` text NOT NULL ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci

CREATE TABLE IF NOT EXISTS `oc_blocks` ( `blocks_id` int(11) NOT NULL AUTO_INCREMENT, `products` text NOT NULL, `categories` text NOT NULL, `manufacturers` text NOT NULL, `vendors` text NOT NULL, `stock_statuses` text NOT NULL, `special_filter` tinyint(1) NOT NULL DEFAULT '0', `customer_groups` text NOT NULL, `customer_group_all` tinyint(1) NOT NULL DEFAULT '1', `include_subcategories` tinyint(1) NOT NULL DEFAULT '0', `ingore_products` text NOT NULL, `ignore_categories` text NOT NULL, `ignore_manufacturers` text NOT NULL, `ignore_vendors` text NOT NULL, `stores` text NOT NULL, `allproducts` tinyint(4) NOT NULL, `status` int(11) NOT NULL, `sort_order` int(11) NOT NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`blocks_id`) ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci

CREATE TABLE IF NOT EXISTS `oc_blocks_description` ( `blocks_id` int(11) NOT NULL, `language_id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `description` text NOT NULL ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci

SELECT *
FROM oc_product_to_category
WHERE product_id = '336'

SELECT *
FROM oc_tabs t
LEFT JOIN oc_tabs_description td ON (t.tabs_id = td.tabs_id)
WHERE t.status = 1 AND td.language_id = '1'
ORDER BY t.sort_order ASC

SELECT *
FROM oc_product_to_category
WHERE product_id = '336'

SELECT *
FROM oc_blocks t
LEFT JOIN oc_blocks_description td ON (t.blocks_id = td.blocks_id)
WHERE t.status = 1 AND td.language_id = '1'
ORDER BY t.sort_order ASC

SELECT DISTINCT c.*, cd.*, GROUP_CONCAT(cep.parent_id
ORDER BY cep.sort_order ASC) as parent_ids
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_extra_parents cep ON (c.category_id = cep.category_id)
WHERE c.category_id = '65' AND cd.language_id = '1' AND c.status = '1' GROUP BY c.category_id

SELECT DISTINCT pd.quantity AS product_quantity
FROM `oc_product_discount` AS pd
WHERE pd.product_id = '336' AND pd.customer_group_id = '1' AND pd.quantity > '1' AND (pd.date_start = '0000-00-00' OR pd.date_start < NOW())

SELECT ISNULL(psf.price) AND ISNULL(psp.percentage) AS apply_discounts
FROM `oc_product` AS p
LEFT JOIN `oc_product_special` AS psf ON (psf.product_id = p.product_id AND psf.discount_type = 'F' AND psf.price > 0 AND (psf.date_start = '0000-00-00' OR psf.date_start < NOW()) AND (psf.date_end = '0000-00-00' OR psf.date_end >= CURDATE()) AND psf.customer_group_id = '1')
LEFT JOIN `oc_product_special` AS psp ON (psp.product_id = p.product_id AND psp.discount_type = 'P' AND psp.percentage > 0 AND (psp.date_start = '0000-00-00' OR psp.date_start < NOW()) AND (psp.date_end = '0000-00-00' OR psp.date_end >= CURDATE()) AND psp.customer_group_id = '1')
WHERE p.product_id = '336' AND p.status = '1' AND p.date_available <= NOW() GROUP BY p.product_id

WITH RECURSIVE cat_anc AS (SELECT c.category_id AS desc_id, c.category_id AS anc_id, 0 AS depth
FROM `oc_category` c UNION ALL SELECT a.desc_id, c.parent_id AS anc_id, a.depth + 1
FROM cat_anc a
INNER JOIN `oc_category` c ON c.category_id = a.anc_id
WHERE c.parent_id != 0) SELECT DISTINCT cd.qty AS category_quantity
FROM `oc_product_to_category` AS ptc
INNER JOIN cat_anc ON (cat_anc.desc_id = ptc.category_id)
LEFT JOIN `oc_category_discount` AS cd ON (cd.category_id = cat_anc.anc_id AND (cat_anc.depth = 0 OR cd.affect = '1'))
WHERE ptc.product_id = '336' AND cd.status = '1' AND cd.customer_group_id = '1' AND cd.qty > '1' AND cd.qty IS NOT NULL AND (cd.date_start = '0000-00-00' OR cd.date_start <= NOW())

SELECT DISTINCT vnd.qty AS vendor_quantity
FROM `oc_vendor_discount` AS vnd
LEFT JOIN `oc_product` AS p ON (vnd.vendor = p.vendor)
WHERE p.product_id = '336' AND vnd.status = '1' AND vnd.customer_group_id = '1' AND vnd.qty > '1' AND (vnd.date_start = '0000-00-00' OR vnd.date_start <= CURDATE()) AND (vnd.date_end = '0000-00-00' OR vnd.date_end >= CURDATE())