Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '7b6ad405fa149ce6912c3483ed'

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 ("143053", "2", "1000", "17", "1", "152.000000000000", "1"),("143051", "2", "1000", "17", "1", "140.410000000000", "2"),("119993", "2", "8", "17", "1", "126.030000000000", "3"),("143049", "2", "1000", "17", "1", "136.960000000000", "4"),("36531", "2", "1004", "17", "1", "211.830000000000", "5"),("147861", "2", "1000", "17", "1", "212.600000000000", "6"),("64", "2", "1", "17", "1", "204.190000000000", "7"),("112712", "2", "1000", "17", "1", "129.310000000000", "8"),("239587", "1", "1000", "17", "1", "244.440000000000", "9"),("239588", "1", "1000", "17", "1", "261.250000000000", "10"),("239589", "1", "1000", "17", "1", "278.050000000000", "11"),("239590", "1", "1000", "17", "1", "278.050000000000", "12"),("131189", "2", "0", "17", "1", "99.000000000000", "13"),("90755", "2", "0", "17", "1", "174.000000000000", "14"),("63", "2", "0", "17", "1", "161.250000000000", "15"),("36514", "2", "0", "17", "1", "151.200000000000", "16"),("147859", "2", "0", "17", "1", "174.000000000000", "17"),("143057", "2", "0", "17", "1", "165.000000000000", "18"),("239591", "1", "0", "17", "1", "336.880000000000", "19"),("239592", "1", "0", "17", "1", "345.280000000000", "20"),("180523", "1", "1000", "682", "1", "211.670000000000", "21"),("180525", "1", "1000", "682", "1", "236.880000000000", "22"),("179655", "1", "1000", "677", "1", "41.920000000000", "23"),("233768", "1", "1000", "357", "1", "16.900000000000", "24"),("91663", "2", "1000", "115", "1", "46.120000000000", "25"),("91672", "2", "1000", "115", "1", "54.520000000000", "26"),("151729", "2", "1000", "364", "1", "110.830000000000", "27"),("223256", "2", "1002", "768", "1", "84.780000000000", "28"),("15073", "2", "1000", "115", "1", "52.760000000000", "29"),("52967", "2", "1000", "115", "1", "28.640000000000", "30"),("79958", "4", "7", "13", "1", "202.420000000000", "31"),("110902", "-100", "9", "26", "1", "13.420000000000", "32"),("5920", "2", "1000", "42", "1", "108.390000000000", "33"),("175784", "2", "1000", "124", "1", "132.760000000000", "34"),("166161", "2", "1", "59", "1", "219.230000000000", "35"),("239868", "1", "9", "802", "1", "22.740000000000", "36"),("239867", "1", "4", "802", "1", "86.500000000000", "37"),("166173", "2", "4", "59", "1", "127.820000000000", "38"),("47192", "2", "33", "28", "1", "12.830000000000", "39"),("86399", "2", "9", "28", "1", "12.830000000000", "40"),("211279", "1", "1002", "224", "1", "22.600000000000", "41"),("211273", "1", "1000", "224", "1", "22.600000000000", "42"),("211275", "1", "1000", "224", "1", "22.600000000000", "43"),("211277", "1", "1000", "224", "1", "22.600000000000", "44"),("211281", "1", "1000", "224", "1", "22.600000000000", "45"),("211283", "1", "1000", "224", "1", "22.600000000000", "46"),("211285", "1", "1000", "224", "1", "22.600000000000", "47"),("211287", "1", "1000", "224", "1", "22.600000000000", "48"),("211289", "1", "1000", "224", "1", "22.600000000000", "49"),("211291", "1", "1000", "224", "1", "22.600000000000", "50"),("211293", "1", "1000", "224", "1", "22.600000000000", "51"),("92480", "2", "1000", "278", "1", "19.880000000000", "52"),("100177", "1", "20", "28", "1", "17.410000000000", "53"),("100132", "1", "17", "28", "1", "21.080000000000", "54"),("2951", "2", "14", "28", "1", "18.330000000000", "55"),("244018", "1", "7", "802", "1", "19.250000000000", "56"),("247226", "1", "1000", "285", "1", "17.370000000000", "57"),("128429", "2", "1000", "85", "1", "131.920000000000", "58"),("42973", "2", "1000", "163", "1", "84.060000000000", "59"),("66657", "2", "1005", "30", "1", "13.660000000000", "60"),("10829", "2", "1001", "30", "1", "25.680000000000", "61"),("68613", "4", "1001", "30", "1", "12.460000000000", "62"),("57179", "2", "1000", "30", "1", "12.830000000000", "63"),("211261", "1", "1000", "224", "1", "33.510000000000", "64"),("211263", "1", "1000", "224", "1", "33.510000000000", "65"),("211295", "1", "1000", "224", "1", "22.600000000000", "66"),("211297", "1", "1000", "224", "1", "33.510000000000", "67"),("100127", "1", "34", "28", "1", "18.330000000000", "68"),("86318", "2", "18", "28", "1", "22.920000000000", "69"),("100299", "1", "9", "28", "1", "23.840000000000", "70"),("128427", "2", "2", "85", "1", "152.630000000000", "71"),("68606", "2", "1005", "30", "1", "11.450000000000", "72"),("61345", "2", "1002", "30", "1", "15.030000000000", "73"),("209283", "1", "1002", "654", "1", "13.630000000000", "74"),("94943", "2", "1000", "516", "1", "23.850000000000", "75"),("211265", "1", "1000", "224", "1", "28.470000000000", "76"),("211267", "1", "1000", "224", "1", "28.470000000000", "77"),("211269", "1", "1000", "224", "1", "28.470000000000", "78"),("211271", "1", "1000", "224", "1", "28.470000000000", "79"),("118041", "1", "10", "28", "1", "27.500000000000", "80"),("200419", "1", "9", "28", "1", "42.190000000000", "81"),("173973", "1", "7", "28", "1", "21.080000000000", "82"),("173941", "1", "2", "28", "1", "21.080000000000", "83"),("68612", "2", "1", "30", "1", "20.630000000000", "84"),("173930", "1", "4", "28", "1", "21.080000000000", "85"),("119684", "1", "1000", "30", "1", "16.410000000000", "86"),("47514", "2", "7", "342", "1", "42.190000000000", "87"),("200415", "1", "6", "28", "1", "27.500000000000", "88"),("118055", "2", "1", "28", "1", "13.560000000000", "89"),("68866", "4", "1006", "30", "1", "14.670000000000", "90"),("237738", "1", "1001", "30", "1", "29.250000000000", "91"),("162205", "1", "1001", "354", "1", "23.750000000000", "92"),("162207", "1", "1000", "354", "1", "20.070000000000", "93"),("237728", "1", "1000", "30", "1", "29.250000000000", "94"),("149255", "1", "37", "625", "1", "25.680000000000", "95"),("200401", "1", "16", "28", "1", "17.410000000000", "96"),("149257", "1", "14", "625", "1", "25.680000000000", "97"),("200367", "1", "11", "28", "1", "28.420000000000", "98"),("237397", "1", "10", "28", "1", "13.750000000000", "99"),("174024", "1", "5", "28", "1", "21.080000000000", "100"),("173980", "1", "2", "28", "1", "24.760000000000", "101"),("49942", "10", "1000", "372", "1", "115.830000000000", "102"),("174007", "1", "6", "28", "1", "21.080000000000", "103"),("47513", "2", "6", "342", "1", "44.020000000000", "104"),("174033", "1", "4", "28", "1", "30.260000000000", "105"),("39145", "10", "1000", "238", "1", "1073.070000000000", "106"),("100570", "1", "1000", "545", "1", "2215.600000000000", "107"),("49961", "10", "1000", "268", "1", "210.260000000000", "108"),("179156", "2", "1000", "354", "1", "59.520000000000", "109"),("5124", "2", "19", "69", "1", "17.410000000000", "110"),("49352", "2", "6", "342", "1", "18.330000000000", "111"),("249962", "1", "10", "100", "1", "27.840000000000", "112"),("70571", "10", "1000", "222", "1", "1280.100000000000", "113"),("70600", "10", "1000", "261", "1", "210.260000000000", "114"),("49959", "10", "1000", "222", "1", "220.730000000000", "115"),("249964", "1", "10", "100", "1", "27.840000000000", "116"),("249966", "1", "10", "100", "1", "27.840000000000", "117"),("22152", "2", "1000", "17", "1", "79.960000000000", "118"),("110811", "10", "1000", "557", "1", "433.300000000000", "119"),("183327", "10", "1000", "703", "1", "415.260000000000", "120"),("249965", "1", "10", "100", "1", "27.840000000000", "121"),("114379", "2", "1000", "190", "1", "6.120000000000", "122"),("95742", "10", "1000", "261", "1", "309.760000000000", "123"),("110815", "10", "1000", "557", "1", "557.000000000000", "124"),("70492", "10", "1000", "445", "1", "178.060000000000", "125"),("179797", "1", "1000", "290", "1", "588.980000000000", "126"),("110809", "10", "1000", "557", "1", "352.780000000000", "127"),("110813", "10", "1000", "557", "1", "352.780000000000", "128"),("110814", "10", "1000", "557", "1", "433.300000000000", "129"),("110817", "10", "1000", "557", "1", "557.000000000000", "130"),("70599", "10", "1000", "261", "1", "210.260000000000", "131"),("81000", "10", "1000", "445", "1", "132.880000000000", "132"),("180389", "2", "1000", "682", "1", "165.450000000000", "133"),("110806", "10", "1000", "445", "1", "305.680000000000", "134"),("110807", "10", "1000", "445", "1", "322.060000000000", "135"),("115486", "10", "1000", "557", "1", "433.300000000000", "136"),("159319", "10", "1000", "557", "1", "1416.010000000000", "137"),("81005", "10", "1000", "445", "1", "136.360000000000", "138"),("92116", "10", "1000", "445", "1", "181.540000000000", "139"),("92117", "10", "1000", "445", "1", "185.010000000000", "140"),("166988", "1", "7", "280", "1", "46.120000000000", "141"),("237958", "1", "1000", "13", "1", "30.370000000000", "142"),("178791", "2", "5", "672", "1", "161.590000000000", "143"),("179523", "2", "1", "672", "1", "105.950000000000", "144"),("179526", "2", "1", "672", "1", "259.230000000000", "145"),("104465", "1", "1001", "13", "1", "122.260000000000", "146"),("190707", "1", "1000", "13", "1", "131.920000000000", "147"),("93859", "2", "0", "467", "1", "152.590000000000", "148"),("193049", "1", "0", "238", "1", "2339.300000000000", "149"),("215759", "2", "0", "656", "1", "33.540000000000", "150"),("215761", "2", "0", "656", "1", "26.170000000000", "151"),("100145", "1", "0", "28", "1", "3.670000000000", "152"),("65873", "2", "0", "28", "1", "9.790000000000", "153"),("243798", "1", "0", "802", "1", "7.340000000000", "154"),("173969", "1", "0", "28", "1", "13.460000000000", "155"),("68611", "2", "0", "30", "1", "12.500000000000", "156"),("201393", "1", "0", "28", "1", "25.680000000000", "157"),("47530", "2", "0", "342", "1", "16.510000000000", "158"),("224057", "1", "0", "13", "1", "7.500000000000", "159"),("236009", "2", "0", "654", "1", "13.140000000000", "160"),("173794", "2", "0", "28", "1", "15.900000000000", "161"),("59424", "2", "0", "342", "1", "27.523000000000", "162"),("2426", "2", "0", "45", "1", "4.600000000000", "163"),("49658", "2", "0", "342", "1", "16.520000000000", "164"),("222233", "2", "0", "342", "1", "15.590000000000", "165"),("33967", "2", "0", "60", "1", "7.760000000000", "166"),("229581", "2", "0", "342", "1", "26.610000000000", "167"),("178441", "1", "0", "487", "1", "12.000000000000", "168"),("178442", "1", "0", "487", "1", "11.000000000000", "169"),("22183", "2", "0", "17", "1", "62.940000000000", "170"),("110812", "10", "0", "557", "1", "420.440000000000", "171"),("80999", "10", "0", "445", "1", "99.410000000000", "172"),("149797", "10", "0", "557", "1", "943.740000000000", "173"),("149795", "10", "0", "557", "1", "1083.320000000000", "174"),("121271", "1", "0", "13", "1", "115.000000000000", "175")

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'