Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '9266c53d9bd85dc738d64a5fa4'

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 ("99624", "2", "1000", "117", "1", "41.080000000000", "1"),("99625", "2", "1000", "117", "1", "41.080000000000", "2"),("10144", "2", "1000", "117", "1", "41.080000000000", "3"),("10145", "2", "1000", "117", "1", "41.080000000000", "4"),("10202", "2", "1000", "117", "1", "41.080000000000", "5"),("29962", "2", "1000", "117", "1", "41.080000000000", "6"),("29969", "2", "1000", "117", "1", "41.080000000000", "7"),("99621", "2", "1000", "117", "1", "41.080000000000", "8"),("10692", "2", "1", "185", "1", "38.640000000000", "9"),("160769", "1", "1000", "637", "1", "19.310000000000", "10"),("160785", "1", "1000", "637", "1", "19.310000000000", "11"),("160799", "1", "1000", "637", "1", "21.830000000000", "12"),("160813", "1", "1000", "637", "1", "21.830000000000", "13"),("160855", "1", "1000", "637", "1", "17.640000000000", "14"),("160871", "1", "1000", "637", "1", "17.640000000000", "15"),("228750", "2", "1000", "117", "1", "39.400000000000", "16"),("139931", "2", "1001", "48", "1", "16.790000000000", "17"),("99630", "2", "1000", "117", "1", "45.280000000000", "18"),("139827", "2", "1000", "48", "1", "15.120000000000", "19"),("139863", "2", "1000", "48", "1", "15.120000000000", "20"),("139871", "2", "1000", "48", "1", "15.120000000000", "21"),("139903", "2", "1000", "48", "1", "16.790000000000", "22"),("139917", "2", "1000", "48", "1", "16.790000000000", "23"),("140007", "2", "1000", "48", "1", "12.930000000000", "24"),("166821", "2", "1", "48", "1", "19.310000000000", "25"),("241652", "2", "1009", "48", "1", "9.230000000000", "26"),("241629", "2", "1009", "48", "1", "9.230000000000", "27"),("160397", "2", "1006", "48", "1", "10.070000000000", "28"),("44848", "2", "1003", "48", "1", "10.070000000000", "29"),("148889", "2", "1003", "48", "1", "12.600000000000", "30"),("148919", "2", "1003", "48", "1", "12.600000000000", "31"),("44837", "2", "1000", "48", "1", "10.070000000000", "32"),("138929", "2", "1000", "48", "1", "10.070000000000", "33"),("140647", "2", "1000", "48", "1", "15.120000000000", "34"),("141717", "2", "1000", "48", "1", "6.710000000000", "35"),("141723", "2", "1000", "48", "1", "6.710000000000", "36"),("141885", "2", "1000", "48", "1", "6.710000000000", "37"),("141923", "2", "1000", "48", "1", "6.710000000000", "38"),("148937", "2", "2", "48", "1", "12.600000000000", "39"),("160289", "10", "1010", "48", "1", "9.230000000000", "40"),("160295", "10", "1002", "48", "1", "8.390000000000", "41"),("184697", "1", "1000", "48", "1", "7.550000000000", "42"),("197793", "2", "1010", "48", "1", "8.390000000000", "43"),("160201", "2", "1005", "48", "1", "10.910000000000", "44"),("197825", "2", "1000", "48", "1", "8.390000000000", "45"),("197851", "2", "1000", "48", "1", "8.390000000000", "46"),("45609", "2", "2", "48", "1", "19.310000000000", "47"),("121763", "2", "1000", "297", "1", "9.230000000000", "48"),("123865", "2", "1000", "297", "1", "9.230000000000", "49"),("123877", "2", "1000", "297", "1", "9.230000000000", "50"),("10182", "2", "1001", "117", "1", "42.760000000000", "51"),("62539", "2", "1000", "24", "1", "176.370000000000", "52"),("127341", "-100", "30", "26", "1", "8.920000000000", "53"),("91177", "1", "1001", "42", "1", "23.840000000000", "54"),("29917", "2", "1001", "117", "1", "36.880000000000", "55"),("10205", "2", "1000", "117", "1", "42.760000000000", "56"),("29913", "2", "1000", "117", "1", "36.880000000000", "57"),("29927", "2", "1000", "117", "1", "39.400000000000", "58"),("29929", "2", "1000", "117", "1", "39.400000000000", "59"),("159235", "1", "1012", "437", "1", "6.880000000000", "60"),("30113", "2", "1003", "117", "1", "42.760000000000", "61"),("30136", "2", "1002", "117", "1", "42.000000000000", "62"),("105111", "1", "1000", "42", "1", "23.840000000000", "63"),("30104", "2", "1000", "117", "1", "42.760000000000", "64"),("30140", "2", "1000", "117", "1", "42.760000000000", "65"),("210349", "2", "1000", "196", "1", "67.640000000000", "66"),("39780", "2", "1007", "42", "1", "8.810000000000", "67"),("11849", "2", "1001", "117", "1", "42.760000000000", "68"),("31091", "2", "1001", "117", "1", "41.920000000000", "69"),("11842", "2", "1000", "117", "1", "42.760000000000", "70"),("11843", "2", "1000", "117", "1", "42.760000000000", "71"),("81416", "2", "1000", "421", "1", "47.800000000000", "72"),("167649", "2", "1000", "117", "1", "42.760000000000", "73"),("11853", "2", "1", "117", "1", "42.760000000000", "74"),("40786", "2", "1004", "45", "1", "7.550000000000", "75"),("98642", "2", "1002", "117", "1", "41.920000000000", "76"),("31092", "2", "1001", "117", "1", "41.920000000000", "77"),("98640", "2", "1000", "117", "1", "41.920000000000", "78"),("81425", "2", "1000", "421", "1", "52.000000000000", "79"),("99642", "2", "1000", "117", "1", "42.760000000000", "80"),("177530", "2", "1000", "117", "1", "59.560000000000", "81"),("229294", "2", "1000", "583", "1", "53.770000000000", "82"),("177473", "2", "1", "117", "1", "59.560000000000", "83"),("91138", "2", "1000", "42", "1", "27.500000000000", "84"),("99627", "2", "1000", "117", "1", "46.960000000000", "85"),("177464", "2", "1000", "117", "1", "59.560000000000", "86"),("177465", "2", "1000", "117", "1", "59.560000000000", "87"),("177469", "2", "1000", "117", "1", "59.560000000000", "88"),("177521", "2", "1000", "117", "1", "59.560000000000", "89"),("177528", "2", "1000", "117", "1", "59.560000000000", "90"),("229614", "2", "1000", "117", "1", "59.560000000000", "91"),("6268", "2", "1000", "117", "1", "202.420000000000", "92"),("6267", "2", "2", "117", "1", "202.420000000000", "93"),("6270", "2", "1", "117", "1", "135.200000000000", "94"),("87751", "2", "1001", "75", "1", "44.520000000000", "95"),("168315", "2", "1000", "115", "1", "28.550000000000", "96"),("143435", "2", "1", "17", "1", "106.710000000000", "97"),("143437", "2", "1", "17", "1", "121.830000000000", "98"),("186159", "1", "1001", "353", "1", "250.370000000000", "99"),("171089", "2", "1000", "126", "1", "46.210000000000", "100"),("171090", "2", "1000", "126", "1", "47.040000000000", "101"),("171091", "2", "1000", "126", "1", "48.730000000000", "102"),("171092", "2", "1000", "126", "1", "50.400000000000", "103"),("171093", "2", "1000", "126", "1", "50.400000000000", "104"),("171094", "2", "1000", "126", "1", "29.400000000000", "105"),("213517", "2", "1000", "126", "1", "55.450000000000", "106"),("213519", "2", "1000", "126", "1", "82.340000000000", "107"),("186011", "1", "1000", "353", "1", "241.920000000000", "108"),("234095", "1", "1000", "163", "1", "38.420000000000", "109"),("50437", "2", "1003", "42", "1", "14.690000000000", "110"),("50438", "2", "1002", "42", "1", "15.950000000000", "111"),("50439", "2", "1002", "42", "1", "17.210000000000", "112"),("50435", "2", "1000", "42", "1", "12.600000000000", "113"),("50436", "2", "1000", "42", "1", "13.430000000000", "114"),("50440", "2", "1000", "42", "1", "20.160000000000", "115"),("50441", "2", "1000", "42", "1", "25.200000000000", "116"),("171096", "2", "1000", "126", "1", "31.920000000000", "117"),("59509", "2", "11", "287", "1", "5.020000000000", "118"),("77858", "2", "1000", "19", "1", "48.560000000000", "119"),("77860", "2", "1000", "19", "1", "48.560000000000", "120"),("77861", "2", "1000", "19", "1", "48.560000000000", "121"),("77862", "2", "1000", "19", "1", "48.560000000000", "122"),("77859", "2", "1", "19", "1", "48.550000000000", "123"),("186013", "2", "1005", "353", "1", "227.690000000000", "124"),("83871", "2", "1000", "17", "1", "234.390000000000", "125"),("108654", "4", "1000", "75", "1", "25.950000000000", "126"),("108655", "4", "1000", "75", "1", "25.950000000000", "127"),("108656", "4", "1000", "75", "1", "25.950000000000", "128"),("108657", "4", "1000", "75", "1", "25.950000000000", "129"),("186155", "2", "1000", "353", "1", "106.680000000000", "130"),("186157", "2", "1000", "353", "1", "152.050000000000", "131"),("186161", "1", "1000", "353", "1", "61.300000000000", "132"),("186163", "1", "1000", "353", "1", "80.210000000000", "133"),("94238", "2", "6", "516", "1", "19.230000000000", "134"),("247377", "2", "1000", "353", "1", "54.790000000000", "135"),("247493", "1", "1000", "353", "1", "232.210000000000", "136"),("247636", "1", "1000", "353", "1", "139.640000000000", "137"),("55851", "2", "5", "389", "1", "8.460000000000", "138"),("247494", "2", "1000", "353", "1", "185.930000000000", "139"),("247497", "2", "1000", "353", "1", "232.210000000000", "140"),("185107", "1", "1006", "353", "1", "106.680000000000", "141"),("185103", "1", "1000", "353", "1", "114.240000000000", "142"),("185105", "1", "1000", "353", "1", "125.590000000000", "143"),("247465", "1", "1000", "353", "1", "54.790000000000", "144"),("247637", "1", "1000", "353", "1", "162.790000000000", "145"),("244154", "1", "1000", "62", "1", "213.710000000000", "146"),("244155", "1", "1000", "62", "1", "195.940000000000", "147"),("185109", "1", "1002", "353", "1", "378.940000000000", "148"),("185111", "1", "1000", "353", "1", "360.030000000000", "149"),("247375", "1", "1000", "353", "1", "54.790000000000", "150"),("247454", "1", "1000", "353", "1", "463.640000000000", "151"),("247455", "1", "1000", "353", "1", "371.070000000000", "152"),("247610", "2", "1000", "353", "1", "139.640000000000", "153"),("244695", "1", "1000", "53", "1", "149.160000000000", "154"),("247501", "1", "1000", "353", "1", "255.360000000000", "155"),("247506", "1", "1000", "353", "1", "301.640000000000", "156"),("247507", "1", "1000", "353", "1", "324.790000000000", "157"),("247508", "1", "1000", "353", "1", "371.070000000000", "158"),("29958", "2", "0", "117", "1", "31.000000000000", "159"),("29970", "2", "0", "117", "1", "31.000000000000", "160"),("99620", "2", "0", "117", "1", "31.000000000000", "161"),("160827", "1", "0", "637", "1", "10.000000000000", "162"),("160841", "1", "0", "637", "1", "10.000000000000", "163"),("63015", "2", "0", "185", "1", "28.000000000000", "164"),("142337", "2", "0", "48", "1", "6.500000000000", "165"),("98984", "2", "0", "117", "1", "34.000000000000", "166"),("59413", "2", "0", "48", "1", "13.770000000000", "167"),("136509", "2", "0", "48", "1", "11.340000000000", "168"),("229239", "2", "0", "117", "1", "45.280000000000", "169"),("229240", "2", "0", "117", "1", "45.280000000000", "170"),("229241", "2", "0", "117", "1", "45.280000000000", "171"),("200907", "2", "0", "583", "1", "57.130000000000", "172"),("84354", "2", "0", "48", "1", "11.010000000000", "173"),("44865", "2", "0", "48", "1", "8.000000000000", "174"),("30025", "2", "0", "117", "1", "34.000000000000", "175"),("149067", "1", "0", "48", "1", "5.000000000000", "176"),("141705", "2", "0", "48", "1", "3.780000000000", "177"),("141941", "2", "0", "48", "1", "6.500000000000", "178"),("99626", "2", "0", "117", "1", "34.000000000000", "179"),("99639", "2", "0", "117", "1", "30.000000000000", "180"),("121899", "2", "0", "297", "1", "5.920000000000", "181"),("44309", "2", "0", "48", "1", "13.770000000000", "182"),("44323", "2", "0", "48", "1", "13.770000000000", "183"),("121661", "2", "0", "297", "1", "5.920000000000", "184"),("121645", "2", "0", "297", "1", "5.920000000000", "185"),("62529", "2", "0", "24", "1", "169.000000000000", "186"),("10153", "2", "0", "117", "1", "30.000000000000", "187"),("31246", "2", "0", "117", "1", "34.000000000000", "188"),("30123", "2", "0", "117", "1", "30.000000000000", "189"),("99633", "2", "0", "117", "1", "34.000000000000", "190"),("31088", "2", "0", "117", "1", "31.000000000000", "191"),("99631", "2", "0", "117", "1", "34.000000000000", "192"),("98635", "2", "0", "117", "1", "31.000000000000", "193"),("98636", "2", "0", "117", "1", "31.000000000000", "194"),("98639", "2", "0", "117", "1", "31.000000000000", "195"),("177482", "2", "0", "117", "1", "35.000000000000", "196"),("177483", "2", "0", "117", "1", "35.000000000000", "197"),("177515", "2", "0", "117", "1", "35.000000000000", "198"),("177525", "2", "0", "117", "1", "35.000000000000", "199"),("98638", "2", "0", "117", "1", "31.000000000000", "200"),("177466", "2", "0", "117", "1", "40.505000000000", "201"),("177468", "2", "0", "117", "1", "35.000000000000", "202"),("177472", "2", "0", "117", "1", "35.000000000000", "203"),("177478", "2", "0", "117", "1", "35.000000000000", "204"),("177479", "2", "0", "117", "1", "35.000000000000", "205"),("177485", "2", "0", "117", "1", "35.000000000000", "206"),("177517", "2", "0", "117", "1", "35.000000000000", "207"),("177519", "2", "0", "117", "1", "35.000000000000", "208"),("177522", "2", "0", "117", "1", "35.000000000000", "209"),("177524", "2", "0", "117", "1", "35.000000000000", "210"),("177481", "2", "0", "117", "1", "35.000000000000", "211"),("177462", "2", "0", "117", "1", "35.000000000000", "212"),("177527", "2", "0", "117", "1", "35.000000000000", "213"),("177470", "2", "0", "117", "1", "35.000000000000", "214"),("177484", "2", "0", "117", "1", "35.000000000000", "215"),("6269", "2", "0", "117", "1", "140.000000000000", "216"),("177463", "2", "0", "117", "1", "35.000000000000", "217"),("177480", "2", "0", "117", "1", "35.000000000000", "218"),("143433", "2", "0", "17", "1", "84.000000000000", "219"),("10710", "2", "0", "185", "1", "36.000000000000", "220"),("162153", "2", "0", "368", "1", "559.950000000000", "221"),("162158", "2", "0", "368", "1", "719.950000000000", "222"),("213515", "2", "0", "126", "1", "70.570000000000", "223"),("55902", "2", "0", "124", "1", "4.440000000000", "224"),("50433", "2", "0", "42", "1", "8.500000000000", "225"),("207537", "1", "0", "96", "1", "181.500000000000", "226")

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 = '0' AND name = 'lichidare_stoc'