Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '135e637f2618ca369e6caca404'

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 ("232772", "1", "1000", "338", "1", "677.300000000000", "1"),("232773", "1", "1000", "338", "1", "677.300000000000", "2"),("161667", "1", "1000", "150", "1", "932.910000000000", "3"),("205033", "1", "1000", "150", "1", "1037.620000000000", "4"),("161645", "1", "1000", "150", "1", "640.880000000000", "5"),("168168", "1", "1000", "150", "1", "901.730000000000", "6"),("142375", "2", "1013", "48", "1", "9.230000000000", "7"),("93144", "2", "3", "48", "1", "15.120000000000", "8"),("139885", "2", "1000", "48", "1", "15.120000000000", "9"),("197781", "2", "1000", "48", "1", "20.990000000000", "10"),("140011", "2", "1", "48", "1", "12.930000000000", "11"),("241639", "2", "1015", "48", "1", "9.230000000000", "12"),("241632", "2", "1015", "48", "1", "9.230000000000", "13"),("138771", "2", "1009", "48", "1", "10.910000000000", "14"),("241640", "2", "1009", "48", "1", "9.230000000000", "15"),("149071", "1", "1006", "48", "1", "10.070000000000", "16"),("44772", "2", "1005", "48", "1", "10.910000000000", "17"),("149083", "1", "1000", "48", "1", "8.390000000000", "18"),("138885", "2", "1000", "48", "1", "10.070000000000", "19"),("138949", "2", "1000", "48", "1", "10.070000000000", "20"),("141949", "2", "1000", "48", "1", "8.390000000000", "21"),("142161", "2", "1000", "48", "1", "8.390000000000", "22"),("142163", "2", "1000", "48", "1", "9.230000000000", "23"),("142209", "2", "1000", "48", "1", "8.390000000000", "24"),("142211", "2", "1000", "48", "1", "8.390000000000", "25"),("141727", "2", "8", "48", "1", "8.390000000000", "26"),("148949", "2", "3", "48", "1", "12.600000000000", "27"),("148947", "2", "1", "48", "1", "12.600000000000", "28"),("241606", "2", "1010", "48", "1", "9.230000000000", "29"),("241645", "2", "1005", "48", "1", "10.910000000000", "30"),("197843", "2", "1010", "48", "1", "8.390000000000", "31"),("197849", "2", "1010", "48", "1", "8.390000000000", "32"),("197845", "2", "1000", "48", "1", "8.390000000000", "33"),("44820", "2", "2", "48", "1", "17.640000000000", "34"),("48284", "2", "1001", "48", "1", "15.120000000000", "35"),("44287", "2", "1", "48", "1", "20.990000000000", "36"),("247712", "1", "1000", "150", "1", "1998.010000000000", "37"),("63614", "2", "5", "98", "1", "57.880000000000", "38"),("42886", "2", "2", "98", "1", "57.880000000000", "39"),("63613", "2", "2", "98", "1", "57.880000000000", "40"),("49639", "2", "1000", "168", "1", "152.810000000000", "41"),("131891", "2", "1", "67", "1", "5.450000000000", "42"),("211783", "2", "1002", "370", "1", "226.690000000000", "43"),("227292", "2", "1000", "528", "1", "7.380000000000", "44"),("175554", "1", "1005", "47", "1", "76.450000000000", "45"),("229306", "2", "1000", "583", "1", "672.260000000000", "46"),("247554", "1", "1000", "370", "1", "334.620000000000", "47"),("166257", "2", "1000", "47", "1", "137.330000000000", "48"),("223002", "1", "1000", "17", "1", "160.400000000000", "49"),("223013", "1", "1000", "17", "1", "143.600000000000", "50"),("201827", "1", "1000", "17", "1", "168.810000000000", "51"),("161647", "1", "1000", "150", "1", "655.160000000000", "52"),("111475", "2", "1000", "553", "1", "1514.190000000000", "53"),("127085", "2", "1", "48", "1", "13.430000000000", "54"),("211171", "10", "1001", "751", "1", "265.420000000000", "55"),("239254", "10", "1001", "751", "1", "272.420000000000", "56"),("240990", "1", "1000", "17", "1", "345.280000000000", "57"),("205031", "1", "1000", "150", "1", "997.830000000000", "58"),("168154", "1", "1000", "150", "1", "961.830000000000", "59"),("169529", "1", "1", "122", "1", "1363.770000000000", "60"),("211163", "10", "1001", "751", "1", "265.420000000000", "61"),("250483", "1", "1001", "16", "1", "681.820000000000", "62"),("196295", "1", "1000", "122", "1", "745.360000000000", "63"),("217003", "1", "1000", "751", "1", "281.590000000000", "64"),("247729", "2", "1000", "370", "1", "95.640000000000", "65"),("128185", "1", "1009", "13", "1", "8.310000000000", "66"),("223059", "1", "1000", "370", "1", "75.990000000000", "67"),("226308", "1", "1000", "370", "1", "25.790000000000", "68"),("202109", "1", "1000", "17", "1", "404.110000000000", "69"),("217613", "1", "1000", "370", "1", "22.210000000000", "70"),("205039", "1", "1000", "150", "1", "2996.650000000000", "71"),("222407", "1", "1030", "528", "1", "7.300000000000", "72"),("181203", "2", "1004", "13", "1", "7.130000000000", "73"),("235664", "1", "1000", "370", "1", "17.270000000000", "74"),("247709", "1", "1000", "150", "1", "1998.010000000000", "75"),("142359", "2", "0", "48", "1", "6.500000000000", "76"),("142361", "2", "0", "48", "1", "6.500000000000", "77"),("142381", "2", "0", "48", "1", "6.500000000000", "78"),("197785", "2", "0", "48", "1", "12.000000000000", "79"),("44768", "2", "0", "48", "1", "4.500000000000", "80"),("160633", "1", "0", "583", "1", "521.850000000000", "81"),("141647", "2", "0", "48", "1", "7.000000000000", "82"),("141729", "2", "0", "48", "1", "3.780000000000", "83"),("141905", "2", "0", "48", "1", "3.780000000000", "84"),("141903", "2", "0", "48", "1", "3.780000000000", "85"),("141725", "2", "0", "48", "1", "3.780000000000", "86"),("44302", "2", "0", "48", "1", "13.770000000000", "87"),("247716", "1", "0", "150", "1", "2031.580000000000", "88"),("247719", "1", "0", "150", "1", "2048.460000000000", "89"),("42853", "2", "0", "98", "1", "57.020000000000", "90"),("27950", "2", "0", "49", "1", "3.800000000000", "91"),("88068", "2", "0", "423", "1", "141.780000000000", "92"),("99674", "1", "0", "17", "1", "122.000000000000", "93"),("173874", "2", "0", "47", "1", "147.710000000000", "94"),("131173", "1", "0", "17", "1", "63.470000000000", "95"),("197327", "1", "0", "79", "1", "1181.610000000000", "96"),("146907", "1", "0", "17", "1", "142.000000000000", "97"),("143455", "1", "0", "17", "1", "103.000000000000", "98"),("240890", "2", "0", "151", "1", "1089.000000000000", "99")

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 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 p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id

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