Căutare - Plumbi EnergoTeam

SELECT data
FROM `oc_session`
WHERE session_id = 'e3804f302145ccdb4f45e7e75f'

SELECT `trigger`, `action`
FROM oc_event

CREATE TEMPORARY TABLE oc_bf_tmp_product ( 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_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("70727", "4", "1017", "24", "1", "12.610000000000", "1"),("70726", "2", "1014", "24", "1", "9.240000000000", "2"),("113619", "2", "1005", "24", "1", "6.720000000000", "3"),("113614", "2", "1000", "24", "1", "5.460000000000", "4"),("113615", "2", "1000", "24", "1", "5.880000000000", "5"),("113617", "2", "1034", "24", "1", "7.560000000000", "6"),("113616", "2", "1030", "24", "1", "6.720000000000", "7"),("113618", "2", "1018", "24", "1", "8.400000000000", "8"),("66612", "2", "1025", "24", "1", "2.520000000000", "9"),("66611", "2", "1009", "24", "1", "2.520000000000", "10"),("113527", "2", "1012", "24", "1", "6.720000000000", "11"),("113530", "2", "1011", "24", "1", "8.400000000000", "12"),("113613", "2", "1010", "24", "1", "5.460000000000", "13"),("113528", "2", "1007", "24", "1", "6.300000000000", "14"),("113526", "2", "1006", "24", "1", "5.040000000000", "15"),("61636", "2", "1005", "24", "1", "3.360000000000", "16"),("166344", "2", "1005", "24", "1", "4.200000000000", "17"),("113529", "2", "1003", "24", "1", "7.560000000000", "18"),("61634", "2", "8", "24", "1", "2.520000000000", "19"),("61831", "2", "1", "24", "1", "3.360000000000", "20"),("61883", "2", "1070", "24", "1", "3.360000000000", "21"),("61879", "2", "1004", "24", "1", "5.040000000000", "22"),("113523", "10", "1000", "24", "1", "6.720000000000", "23"),("113524", "10", "1000", "24", "1", "7.560000000000", "24"),("61640", "4", "1013", "24", "1", "8.400000000000", "25"),("61641", "2", "1010", "24", "1", "10.080000000000", "26"),("61642", "2", "1003", "24", "1", "8.400000000000", "27"),("216453", "10", "1000", "24", "1", "23.530000000000", "28"),("220201", "10", "1000", "24", "1", "21.010000000000", "29"),("73773", "2", "1000", "24", "1", "6.640000000000", "30"),("69333", "2", "1003", "24", "1", "7.980000000000", "31"),("69331", "2", "1002", "24", "1", "7.980000000000", "32"),("69332", "2", "1002", "24", "1", "7.980000000000", "33"),("69328", "2", "1001", "24", "1", "7.980000000000", "34"),("69329", "2", "17", "24", "1", "7.980000000000", "35"),("69327", "2", "5", "24", "1", "7.980000000000", "36"),("69330", "2", "2", "24", "1", "7.980000000000", "37"),("61707", "2", "1000", "24", "1", "14.290000000000", "38"),("62514", "2", "1001", "24", "1", "10.080000000000", "39"),("69335", "2", "1000", "189", "1", "9.240000000000", "40"),("113874", "2", "1002", "24", "1", "7.560000000000", "41"),("69326", "2", "0", "24", "1", "5.950000000000", "42")

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 0, 20

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