Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '9289f34f0a3436b8f19f22b020'

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 ("137167", "1", "1000", "296", "1", "33.600000000000", "1"),("137165", "1", "1000", "296", "1", "33.600000000000", "2"),("137359", "2", "1000", "296", "1", "34.440000000000", "3"),("9629", "2", "1004", "160", "1", "20.250000000000", "4"),("77866", "2", "1000", "160", "1", "17.520000000000", "5"),("158015", "1", "1000", "177", "1", "22.600000000000", "6"),("158035", "1", "1000", "177", "1", "17.550000000000", "7"),("125075", "1", "1001", "117", "1", "57.130000000000", "8"),("26945", "2", "1000", "117", "1", "48.640000000000", "9"),("124265", "2", "1000", "337", "1", "42.000000000000", "10"),("228705", "2", "1000", "117", "1", "54.520000000000", "11"),("228734", "2", "1000", "117", "1", "39.400000000000", "12"),("207753", "1", "1000", "117", "1", "39.400000000000", "13"),("207771", "1", "1000", "117", "1", "67.970000000000", "14"),("207797", "2", "1000", "117", "1", "59.560000000000", "15"),("34757", "2", "1001", "117", "1", "52.840000000000", "16"),("171116", "2", "1000", "337", "1", "68.050000000000", "17"),("171172", "2", "1000", "337", "1", "47.880000000000", "18"),("124347", "2", "1000", "337", "1", "38.640000000000", "19"),("124359", "2", "1000", "337", "1", "38.640000000000", "20"),("124371", "2", "1000", "337", "1", "38.640000000000", "21"),("124383", "2", "1000", "337", "1", "38.640000000000", "22"),("124395", "2", "1000", "337", "1", "42.000000000000", "23"),("124405", "2", "1000", "337", "1", "46.210000000000", "24"),("228723", "2", "1000", "117", "1", "39.400000000000", "25"),("223014", "2", "1000", "117", "1", "67.970000000000", "26"),("228744", "1", "1000", "117", "1", "49.480000000000", "27"),("175697", "1", "1000", "117", "1", "36.880000000000", "28"),("175709", "1", "1000", "117", "1", "36.880000000000", "29"),("137179", "2", "1000", "296", "1", "33.600000000000", "30"),("137181", "2", "1000", "296", "1", "33.600000000000", "31"),("224317", "1", "1000", "337", "1", "58.810000000000", "32"),("243926", "2", "1000", "117", "1", "59.560000000000", "33"),("224228", "1", "1000", "337", "1", "42.000000000000", "34"),("224231", "1", "1000", "337", "1", "42.000000000000", "35"),("224236", "1", "1000", "337", "1", "42.000000000000", "36"),("224238", "1", "1000", "337", "1", "42.000000000000", "37"),("230771", "1", "1000", "117", "1", "36.030000000000", "38"),("120010", "1", "1000", "11", "1", "4.710000000000", "39"),("48817", "2", "2", "160", "1", "14.090000000000", "40"),("100608", "1", "1", "59", "1", "177.290000000000", "41"),("193069", "1", "1000", "268", "1", "88.600000000000", "42"),("193217", "10", "1000", "268", "1", "71.040000000000", "43"),("193219", "1", "1000", "268", "1", "71.640000000000", "44"),("151445", "1", "1008", "11", "1", "10.890000000000", "45"),("160545", "1", "1008", "11", "1", "12.730000000000", "46"),("160547", "1", "1008", "11", "1", "15.120000000000", "47"),("235088", "1", "1000", "11", "1", "310.580000000000", "48"),("100607", "1", "3", "59", "1", "146.120000000000", "49"),("100604", "1", "1", "59", "1", "146.120000000000", "50"),("149869", "2", "1", "11", "1", "75.670000000000", "51"),("86062", "2", "1000", "115", "1", "36.030000000000", "52"),("193103", "1", "1000", "268", "1", "529.700000000000", "53"),("15180", "2", "1000", "115", "1", "30.160000000000", "54"),("65058", "2", "1000", "185", "1", "58.270000000000", "55"),("48401", "2", "1000", "105", "1", "23.430000000000", "56"),("193099", "1", "1000", "268", "1", "529.700000000000", "57"),("120009", "2", "1000", "11", "1", "26.360000000000", "58"),("193081", "2", "1000", "268", "1", "84.360000000000", "59"),("193211", "1", "1000", "268", "1", "598.700000000000", "60"),("223711", "1", "4", "59", "1", "210.910000000000", "61"),("223712", "1", "2", "59", "1", "210.910000000000", "62"),("223713", "1", "2", "59", "1", "210.910000000000", "63"),("160537", "1", "1012", "11", "1", "19.440000000000", "64"),("160539", "1", "1012", "11", "1", "18.360000000000", "65"),("160541", "1", "1012", "11", "1", "20.310000000000", "66"),("160543", "1", "1012", "11", "1", "22.260000000000", "67"),("160529", "1", "1011", "11", "1", "16.200000000000", "68"),("160531", "1", "1007", "11", "1", "17.600000000000", "69"),("86078", "2", "1000", "115", "1", "55.360000000000", "70"),("128953", "1", "1000", "117", "1", "57.880000000000", "71"),("160535", "1", "1000", "11", "1", "18.360000000000", "72"),("160533", "1", "1", "11", "1", "12.500000000000", "73"),("49825", "2", "1020", "160", "1", "17.880000000000", "74"),("49823", "2", "1012", "160", "1", "16.400000000000", "75"),("100326", "1", "1003", "160", "1", "14.090000000000", "76"),("177449", "2", "1000", "117", "1", "51.170000000000", "77"),("233523", "1", "1000", "73", "1", "734.970000000000", "78"),("131945", "1", "1042", "11", "1", "2.960000000000", "79"),("224812", "1", "1000", "11", "1", "15.870000000000", "80"),("224813", "1", "1000", "11", "1", "15.440000000000", "81"),("224814", "1", "1000", "11", "1", "17.060000000000", "82"),("224815", "1", "1000", "11", "1", "16.200000000000", "83"),("224816", "1", "1000", "11", "1", "18.360000000000", "84"),("30959", "2", "1000", "117", "1", "34.360000000000", "85"),("29180", "2", "1000", "117", "1", "36.030000000000", "86"),("74697", "2", "1003", "468", "1", "6.290000000000", "87"),("224817", "1", "1000", "11", "1", "14.570000000000", "88"),("224818", "1", "1000", "11", "1", "13.700000000000", "89"),("224819", "1", "1000", "11", "1", "14.460000000000", "90"),("224820", "1", "1000", "11", "1", "15.440000000000", "91"),("224821", "1", "1000", "11", "1", "16.630000000000", "92"),("224822", "1", "1000", "11", "1", "16.630000000000", "93"),("224823", "1", "1000", "11", "1", "15.760000000000", "94"),("224824", "1", "1000", "11", "1", "16.630000000000", "95"),("74916", "2", "5", "468", "1", "6.290000000000", "96"),("74836", "2", "3", "468", "1", "6.290000000000", "97"),("98487", "2", "1001", "117", "1", "36.880000000000", "98"),("98490", "2", "1001", "117", "1", "42.760000000000", "99"),("160491", "2", "1013", "11", "1", "27.560000000000", "100"),("160493", "2", "1006", "11", "1", "29.670000000000", "101"),("160489", "2", "1005", "11", "1", "26.150000000000", "102"),("235610", "2", "1000", "54", "1", "31.920000000000", "103"),("235618", "2", "1000", "54", "1", "31.920000000000", "104"),("160487", "2", "1000", "11", "1", "25.290000000000", "105"),("160495", "2", "1000", "11", "1", "32.790000000000", "106"),("175456", "1", "1000", "117", "1", "51.170000000000", "107"),("177206", "2", "1000", "117", "1", "53.690000000000", "108"),("177199", "2", "1000", "117", "1", "53.690000000000", "109"),("235264", "1", "1000", "85", "1", "37.800000000000", "110"),("222228", "1", "1000", "342", "1", "17.410000000000", "111"),("236125", "1", "5", "85", "1", "41.170000000000", "112"),("178808", "1", "1000", "160", "1", "24.150000000000", "113"),("250607", "1", "1000", "435", "1", "194.960000000000", "114"),("250608", "1", "1000", "435", "1", "210.660000000000", "115"),("181261", "2", "1012", "13", "1", "10.830000000000", "116"),("171272", "2", "1000", "388", "1", "22.680000000000", "117"),("9622", "2", "1002", "160", "1", "18.310000000000", "118"),("111262", "1", "1000", "73", "1", "67.180000000000", "119"),("94775", "2", "1", "467", "1", "25.200000000000", "120"),("233571", "2", "1009", "787", "1", "29.980000000000", "121"),("233572", "2", "1009", "787", "1", "42.600000000000", "122"),("233573", "2", "1005", "787", "1", "34.190000000000", "123"),("21904", "2", "1005", "160", "1", "17.520000000000", "124"),("233570", "2", "1001", "787", "1", "294.690000000000", "125"),("201869", "2", "1001", "24", "1", "173.670000000000", "126"),("144075", "2", "1000", "83", "1", "2992.930000000000", "127"),("76657", "2", "1000", "475", "1", "631.830000000000", "128"),("85372", "2", "1000", "115", "1", "15.950000000000", "129"),("85373", "2", "1000", "115", "1", "15.950000000000", "130"),("85374", "2", "1000", "115", "1", "16.370000000000", "131"),("85378", "2", "1000", "115", "1", "15.950000000000", "132"),("85379", "2", "1000", "115", "1", "15.950000000000", "133"),("85380", "2", "1000", "115", "1", "16.370000000000", "134"),("85381", "2", "1000", "115", "1", "16.370000000000", "135"),("85382", "2", "1000", "115", "1", "17.640000000000", "136"),("177447", "2", "1000", "117", "1", "51.170000000000", "137"),("134817", "1", "1000", "117", "1", "53.690000000000", "138"),("204909", "1", "1000", "476", "1", "89.020000000000", "139"),("227952", "1", "1000", "168", "1", "58.270000000000", "140"),("182671", "1", "1002", "701", "1", "69.740000000000", "141"),("244070", "1", "1000", "73", "1", "80.620000000000", "142"),("169421", "1", "1000", "554", "1", "113.400000000000", "143"),("169418", "1", "1000", "554", "1", "117.690000000000", "144"),("169419", "1", "1000", "554", "1", "117.690000000000", "145"),("169422", "1", "1000", "554", "1", "110.790000000000", "146"),("169424", "1", "1000", "554", "1", "110.790000000000", "147"),("169426", "1", "1000", "554", "1", "97.860000000000", "148"),("182795", "1", "2", "701", "1", "69.740000000000", "149"),("85479", "2", "1001", "115", "1", "18.890000000000", "150"),("85473", "2", "1000", "115", "1", "18.890000000000", "151"),("85476", "2", "1000", "115", "1", "18.890000000000", "152"),("85477", "2", "1000", "115", "1", "18.890000000000", "153"),("85478", "2", "1000", "115", "1", "18.890000000000", "154"),("85480", "2", "1000", "115", "1", "18.890000000000", "155"),("85481", "2", "1000", "115", "1", "18.890000000000", "156"),("183989", "1", "1000", "701", "1", "36.030000000000", "157"),("183005", "1", "1002", "701", "1", "34.440000000000", "158"),("247375", "1", "1000", "353", "1", "54.790000000000", "159"),("137357", "2", "0", "296", "1", "22.690000000000", "160"),("221363", "1", "0", "117", "1", "36.030000000000", "161"),("124035", "2", "0", "117", "1", "41.000000000000", "162"),("177180", "2", "0", "117", "1", "35.000000000000", "163"),("177186", "2", "0", "117", "1", "35.000000000000", "164"),("228168", "2", "0", "117", "1", "59.560000000000", "165"),("34767", "2", "0", "117", "1", "39.000000000000", "166"),("124251", "2", "0", "337", "1", "26.050000000000", "167"),("230828", "2", "0", "117", "1", "61.250000000000", "168"),("137191", "2", "0", "296", "1", "22.610000000000", "169"),("137193", "2", "0", "296", "1", "22.610000000000", "170"),("137215", "2", "0", "296", "1", "22.610000000000", "171"),("116981", "1", "0", "280", "1", "35.700000000000", "172"),("100611", "1", "0", "59", "1", "177.290000000000", "173"),("100613", "1", "0", "59", "1", "177.290000000000", "174"),("166196", "1", "0", "59", "1", "177.290000000000", "175"),("120018", "1", "0", "160", "1", "14.340000000000", "176"),("193085", "2", "0", "268", "1", "66.290000000000", "177"),("193213", "1", "0", "268", "1", "474.500000000000", "178"),("193083", "2", "0", "268", "1", "66.290000000000", "179"),("193091", "2", "0", "268", "1", "66.290000000000", "180"),("193097", "1", "0", "268", "1", "407.510000000000", "181"),("193101", "1", "0", "268", "1", "407.510000000000", "182"),("177424", "2", "0", "117", "1", "30.000000000000", "183"),("177517", "2", "0", "117", "1", "35.000000000000", "184"),("177519", "2", "0", "117", "1", "35.000000000000", "185"),("177448", "2", "0", "117", "1", "30.000000000000", "186"),("117277", "2", "0", "280", "1", "58.650000000000", "187"),("159313", "2", "0", "160", "1", "137.700000000000", "188"),("74915", "2", "0", "468", "1", "4.130000000000", "189"),("74696", "2", "0", "468", "1", "4.130000000000", "190"),("98486", "2", "0", "117", "1", "27.000000000000", "191"),("228713", "2", "0", "117", "1", "54.520000000000", "192"),("112497", "2", "0", "117", "1", "36.000000000000", "193"),("207385", "2", "0", "59", "1", "6.910000000000", "194"),("151539", "2", "0", "364", "1", "7.240000000000", "195"),("239402", "1", "0", "59", "1", "74.900000000000", "196"),("113094", "2", "0", "83", "1", "5528.000000000000", "197"),("138315", "2", "0", "83", "1", "3401.600000000000", "198"),("113093", "2", "0", "83", "1", "4627.270000000000", "199"),("85375", "2", "0", "115", "1", "11.700000000000", "200"),("85377", "2", "0", "115", "1", "11.700000000000", "201"),("148207", "1", "0", "353", "1", "38.610000000000", "202"),("234439", "1", "0", "59", "1", "74.770000000000", "203"),("221626", "1", "0", "168", "1", "31.350000000000", "204"),("85376", "2", "0", "115", "1", "12.000000000000", "205"),("177515", "2", "0", "117", "1", "35.000000000000", "206"),("134851", "1", "0", "605", "1", "180.000000000000", "207"),("138347", "2", "0", "83", "1", "7303.860000000000", "208"),("74790", "2", "0", "468", "1", "2.040000000000", "209"),("85475", "2", "0", "115", "1", "13.900000000000", "210")

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'