Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '5f06f6bbd8438515641491b485'

SELECT `trigger`, `action`
FROM oc_event

CREATE TEMPORARY TABLE oc_tmp_elastic ( product_id int PRIMARY KEY, sort_order int, quantity int, manufacturer_id int, match_filters int, actual_price DECIMAL(10, 4), sort int, INDEX my_index (match_filters, sort_order, manufacturer_id) ) ENGINE=MEMORY

INSERT INTO oc_tmp_elastic (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("89316", "2", "1005", "423", "1", "2.940000000000", "1"),("89317", "4", "1004", "423", "1", "2.940000000000", "2"),("89314", "2", "1002", "423", "1", "3.530000000000", "3"),("89311", "2", "1002", "423", "1", "4.290000000000", "4"),("89313", "2", "1001", "423", "1", "4.290000000000", "5"),("89318", "2", "1001", "423", "1", "2.940000000000", "6"),("89312", "2", "1001", "423", "1", "2.940000000000", "7"),("89315", "2", "1000", "423", "1", "2.940000000000", "8"),("89319", "4", "1005", "423", "1", "2.940000000000", "9"),("175138", "1", "1019", "124", "1", "36.130000000000", "10"),("149365", "2", "1001", "423", "1", "326.890000000000", "11"),("119873", "2", "1001", "423", "1", "378.150000000000", "12"),("207117", "1", "1003", "224", "1", "175.630000000000", "13"),("207119", "1", "1001", "224", "1", "147.900000000000", "14"),("207121", "1", "1000", "224", "1", "134.450000000000", "15"),("110784", "4", "1001", "86", "1", "24.140000000000", "16"),("155329", "2", "1002", "124", "1", "71.430000000000", "17"),("96729", "2", "1002", "484", "1", "571.430000000000", "18"),("116407", "2", "1", "86", "1", "34.080000000000", "19"),("207445", "1", "0", "224", "1", "85.720000000000", "20")

CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, if (SUM(if((f.filter_group = "m0" AND filter_id IN (423)), 1, 0)) > 0, 1, 0) AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
INNER JOIN `oc_tmp_elastic` AS te ON (te.product_id = p.product_id)
WHERE p2s.store_id = '0' AND p.manufacturer_id = '423' AND p.status_filtru > 0 AND p.price > 0 AND te.product_id IS NOT NULL GROUP BY p.product_id
ORDER BY te.sort ASC

SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t

SELECT p.*
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2' LIMIT 60, 20

SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name

SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1

SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS tp
INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id)
WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.filter_group IN ('m0') GROUP BY filter_group, filter_id

SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS tp
INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id)
WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.filter_group IN ('m0') GROUP BY filter_group, filter_id

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'