Căutare

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

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 ("73289", "2", "1004", "185", "1", "37.820000000000", "1"),("226578", "2", "1000", "459", "1", "60.500000000000", "2"),("107888", "1", "1000", "50", "1", "322.690000000000", "3"),("65526", "2", "2", "103", "1", "16.510000000000", "4"),("65521", "2", "1", "103", "1", "15.000000000000", "5"),("65515", "2", "1", "103", "1", "15.000000000000", "6"),("103254", "2", "1", "492", "1", "164.010000000000", "7"),("122899", "2", "1003", "19", "1", "29.210000000000", "8"),("8251", "2", "1002", "42", "1", "100.000000000000", "9"),("230276", "2", "1000", "20", "1", "27.080000000000", "10"),("230277", "2", "1000", "20", "1", "27.080000000000", "11"),("230278", "2", "1000", "20", "1", "27.080000000000", "12"),("230279", "2", "1000", "20", "1", "27.080000000000", "13"),("230280", "2", "1000", "20", "1", "27.080000000000", "14"),("230281", "2", "1000", "20", "1", "27.080000000000", "15"),("230282", "2", "1000", "20", "1", "27.080000000000", "16"),("8250", "2", "1000", "42", "1", "100.000000000000", "17"),("122901", "2", "3", "19", "1", "29.940000000000", "18"),("122903", "2", "2", "19", "1", "30.780000000000", "19"),("220886", "2", "1005", "654", "1", "20.170000000000", "20"),("170867", "2", "1000", "654", "1", "3.360000000000", "21"),("235917", "1", "1000", "654", "1", "28.185600000000", "22"),("39272", "2", "1002", "67", "1", "57.980000000000", "23"),("33422", "2", "1001", "19", "1", "90.760000000000", "24"),("39271", "2", "1001", "67", "1", "57.980000000000", "25"),("24818", "2", "1000", "19", "1", "23.750000000000", "26"),("24821", "2", "1000", "19", "1", "23.750000000000", "27"),("36594", "2", "1000", "19", "1", "73.370000000000", "28"),("33496", "2", "1000", "19", "1", "23.750000000000", "29"),("24470", "2", "1000", "19", "1", "34.540000000000", "30"),("24481", "2", "1000", "19", "1", "34.540000000000", "31"),("24815", "2", "1000", "19", "1", "21.780000000000", "32"),("24820", "2", "1000", "19", "1", "23.750000000000", "33"),("24822", "2", "1000", "19", "1", "23.340000000000", "34"),("39267", "2", "1000", "67", "1", "57.980000000000", "35"),("39270", "2", "1000", "67", "1", "57.980000000000", "36"),("65495", "2", "3", "103", "1", "15.000000000000", "37"),("24482", "2", "2", "19", "1", "34.540000000000", "38"),("65485", "2", "2", "103", "1", "15.000000000000", "39"),("65519", "2", "2", "103", "1", "15.000000000000", "40"),("5924", "2", "1001", "42", "1", "26.890000000000", "41"),("5928", "2", "1000", "42", "1", "26.890000000000", "42"),("158715", "1", "1000", "123", "1", "26.990000000000", "43"),("5927", "2", "1", "42", "1", "26.890000000000", "44"),("231440", "1", "1001", "294", "1", "268.740000000000", "45"),("23695", "2", "1000", "19", "1", "81.080000000000", "46"),("24825", "2", "1000", "19", "1", "27.630000000000", "47"),("119353", "2", "1000", "105", "1", "132.770000000000", "48"),("119354", "2", "1000", "105", "1", "132.770000000000", "49"),("119355", "2", "1000", "105", "1", "132.770000000000", "50"),("231436", "1", "1000", "294", "1", "238.320000000000", "51"),("231437", "1", "1000", "294", "1", "268.740000000000", "52"),("231441", "1", "1000", "294", "1", "184.710000000000", "53"),("231442", "1", "1000", "294", "1", "150.920000000000", "54"),("231445", "1", "1000", "294", "1", "184.710000000000", "55"),("197227", "2", "1000", "50", "1", "56.300000000000", "56"),("197229", "2", "1000", "50", "1", "56.300000000000", "57"),("197231", "2", "1000", "50", "1", "56.300000000000", "58"),("231438", "1", "1000", "294", "1", "155.450000000000", "59"),("231439", "1", "1000", "294", "1", "184.710000000000", "60"),("231443", "1", "1000", "294", "1", "268.820000000000", "61"),("231446", "1", "1000", "294", "1", "155.450000000000", "62"),("235398", "1", "1000", "294", "1", "268.480000000000", "63"),("341", "2", "1000", "19", "1", "49.880000000000", "64"),("53115", "2", "1000", "67", "1", "57.980000000000", "65"),("53117", "2", "1000", "67", "1", "57.980000000000", "66"),("338", "2", "5", "19", "1", "54.040000000000", "67"),("340", "2", "1", "19", "1", "49.880000000000", "68"),("5950", "2", "1002", "42", "1", "23.450000000000", "69"),("5944", "2", "1001", "42", "1", "20.920000000000", "70"),("5932", "2", "1000", "42", "1", "28.570000000000", "71"),("5930", "2", "1", "42", "1", "22.610000000000", "72"),("5943", "2", "1", "42", "1", "26.890000000000", "73"),("122185", "1", "1015", "58", "1", "16.810000000000", "74"),("122167", "1", "1015", "58", "1", "11.680000000000", "75"),("122181", "1", "1008", "58", "1", "16.390000000000", "76"),("122169", "1", "1007", "58", "1", "11.680000000000", "77"),("122187", "1", "1006", "58", "1", "16.810000000000", "78"),("122183", "1", "1005", "58", "1", "16.810000000000", "79"),("122175", "1", "1005", "58", "1", "11.680000000000", "80"),("122173", "1", "1005", "58", "1", "11.680000000000", "81"),("122171", "1", "1005", "58", "1", "11.680000000000", "82"),("122165", "1", "1004", "58", "1", "11.680000000000", "83"),("122163", "1", "1004", "58", "1", "11.680000000000", "84"),("122179", "1", "1004", "58", "1", "16.390000000000", "85"),("122195", "1", "1004", "58", "1", "16.810000000000", "86"),("122189", "1", "1004", "58", "1", "16.810000000000", "87"),("122197", "1", "1004", "58", "1", "16.390000000000", "88"),("122177", "1", "1003", "58", "1", "8.320000000000", "89"),("122193", "1", "1002", "58", "1", "16.810000000000", "90"),("122191", "1", "1001", "58", "1", "16.810000000000", "91"),("23661", "2", "1000", "19", "1", "54.040000000000", "92"),("33344", "2", "1000", "19", "1", "53.720000000000", "93"),("23662", "2", "1000", "19", "1", "54.040000000000", "94"),("91018", "2", "1003", "42", "1", "26.050000000000", "95"),("91013", "2", "1001", "42", "1", "26.050000000000", "96"),("105058", "2", "1001", "42", "1", "21.850000000000", "97"),("105063", "2", "1001", "42", "1", "22.690000000000", "98"),("105065", "2", "1001", "42", "1", "24.370000000000", "99"),("91017", "2", "1001", "42", "1", "26.050000000000", "100"),("113299", "2", "1000", "185", "1", "37.820000000000", "101"),("113300", "2", "1000", "185", "1", "37.820000000000", "102"),("91014", "2", "1000", "42", "1", "26.050000000000", "103"),("104993", "2", "1000", "42", "1", "21.850000000000", "104"),("105059", "2", "1000", "42", "1", "22.690000000000", "105"),("105061", "2", "1000", "42", "1", "22.690000000000", "106"),("105062", "2", "1000", "42", "1", "22.690000000000", "107"),("105067", "2", "1000", "42", "1", "24.370000000000", "108"),("105068", "2", "1000", "42", "1", "24.370000000000", "109"),("105069", "2", "1000", "42", "1", "24.370000000000", "110"),("105072", "2", "1000", "42", "1", "25.210000000000", "111"),("105074", "2", "1000", "42", "1", "25.210000000000", "112"),("105076", "2", "1000", "42", "1", "25.210000000000", "113"),("105078", "2", "1000", "42", "1", "26.050000000000", "114"),("105080", "2", "1000", "42", "1", "26.050000000000", "115"),("210809", "1", "1000", "224", "1", "37.820000000000", "116"),("231720", "2", "1000", "224", "1", "28.150000000000", "117"),("231725", "2", "1000", "224", "1", "31.510000000000", "118"),("231728", "2", "1000", "224", "1", "24.370000000000", "119"),("177374", "2", "1000", "117", "1", "49.580000000000", "120"),("177018", "2", "1000", "289", "1", "18.490000000000", "121"),("111108", "1", "1000", "67", "1", "36.890000000000", "122"),("111110", "1", "1000", "67", "1", "36.890000000000", "123"),("98759", "2", "9", "123", "1", "9.750000000000", "124"),("177029", "2", "1", "289", "1", "18.490000000000", "125"),("177028", "2", "1", "289", "1", "18.490000000000", "126"),("150411", "1", "1003", "58", "1", "11.680000000000", "127"),("150409", "1", "1001", "58", "1", "11.680000000000", "128"),("178727", "2", "1000", "27", "1", "19.330000000000", "129"),("178728", "2", "1000", "27", "1", "19.330000000000", "130"),("178729", "2", "1000", "27", "1", "20.170000000000", "131"),("178731", "2", "1000", "27", "1", "21.850000000000", "132"),("178732", "2", "1000", "27", "1", "21.850000000000", "133"),("178733", "2", "1000", "27", "1", "23.530000000000", "134"),("178734", "2", "1000", "27", "1", "24.370000000000", "135"),("178735", "2", "1000", "27", "1", "26.050000000000", "136"),("178736", "2", "1000", "27", "1", "26.050000000000", "137"),("177030", "2", "1000", "289", "1", "18.490000000000", "138"),("177032", "2", "1000", "289", "1", "18.490000000000", "139"),("177033", "2", "1000", "289", "1", "18.490000000000", "140"),("211521", "1", "1000", "224", "1", "33.610000000000", "141"),("201371", "1", "1002", "224", "1", "20.170000000000", "142"),("211509", "1", "1000", "224", "1", "54.620000000000", "143"),("10053", "2", "7", "100", "1", "23.488000000000", "144"),("65527", "2", "4", "103", "1", "16.510000000000", "145"),("25749", "2", "2", "19", "1", "11.310000000000", "146"),("65492", "2", "1", "103", "1", "15.000000000000", "147"),("65522", "2", "1", "103", "1", "15.000000000000", "148"),("108229", "1", "1000", "104", "1", "47.900000000000", "149"),("108231", "1", "1000", "104", "1", "38.660000000000", "150"),("201381", "1", "1000", "224", "1", "28.570000000000", "151"),("224330", "1", "1000", "224", "1", "26.890000000000", "152"),("235908", "2", "1000", "224", "1", "31.930000000000", "153"),("31093", "2", "1000", "117", "1", "35.290000000000", "154"),("145079", "2", "1000", "19", "1", "12.060000000000", "155"),("65520", "2", "4", "103", "1", "15.000000000000", "156"),("65514", "2", "4", "103", "1", "15.000000000000", "157"),("65525", "2", "2", "103", "1", "16.510000000000", "158"),("65490", "2", "2", "103", "1", "15.000000000000", "159"),("108234", "1", "1000", "104", "1", "33.870000000000", "160"),("226321", "2", "1000", "459", "1", "60.500000000000", "161"),("224004", "1", "1000", "224", "1", "30.250000000000", "162"),("207867", "2", "1000", "19", "1", "14.740000000000", "163"),("65484", "2", "5", "103", "1", "15.000000000000", "164"),("65523", "2", "4", "103", "1", "16.510000000000", "165"),("65518", "2", "3", "103", "1", "15.000000000000", "166"),("108232", "1", "1000", "104", "1", "37.900000000000", "167"),("108218", "1", "1000", "104", "1", "48.740000000000", "168"),("108219", "1", "1000", "104", "1", "52.940000000000", "169"),("108220", "1", "1000", "104", "1", "54.620000000000", "170"),("108221", "1", "1000", "104", "1", "48.740000000000", "171"),("108222", "1", "1000", "104", "1", "39.500000000000", "172"),("108223", "1", "1000", "104", "1", "54.620000000000", "173"),("108224", "1", "1000", "104", "1", "52.940000000000", "174"),("108225", "1", "1000", "104", "1", "52.940000000000", "175"),("108226", "1", "1000", "104", "1", "47.900000000000", "176"),("108227", "1", "1000", "104", "1", "52.830000000000", "177"),("108228", "1", "1000", "104", "1", "52.830000000000", "178"),("104280", "1", "1000", "104", "1", "21.010000000000", "179"),("65464", "2", "4", "103", "1", "17.980000000000", "180"),("65471", "2", "1", "103", "1", "17.980000000000", "181"),("36714", "2", "1001", "19", "1", "12.060000000000", "182"),("95503", "2", "1001", "19", "1", "12.060000000000", "183"),("244195", "1", "1000", "117", "1", "91.600000000000", "184"),("244179", "1", "1000", "117", "1", "60.500000000000", "185"),("65429", "2", "2", "103", "1", "17.980000000000", "186"),("165789", "2", "0", "322", "1", "10.510000000000", "187"),("65491", "2", "0", "103", "1", "8.500000000000", "188"),("98535", "2", "0", "117", "1", "34.000000000000", "189"),("42993", "2", "0", "331", "1", "29.200000000000", "190"),("32546", "2", "0", "50", "1", "202.350000000000", "191"),("28912", "2", "0", "49", "1", "42.440000000000", "192"),("207737", "2", "0", "468", "1", "29.920000000000", "193"),("36602", "2", "0", "19", "1", "26.560000000000", "194"),("342", "2", "0", "19", "1", "41.320000000000", "195"),("39266", "2", "0", "67", "1", "42.850000000000", "196"),("24483", "2", "0", "19", "1", "25.620000000000", "197"),("24484", "2", "0", "19", "1", "26.560000000000", "198"),("24589", "2", "0", "161", "1", "17.810000000000", "199"),("24468", "2", "0", "19", "1", "26.560000000000", "200"),("24583", "2", "0", "161", "1", "10.470000000000", "201"),("24469", "2", "0", "19", "1", "26.560000000000", "202"),("343", "2", "0", "19", "1", "47.150000000000", "203"),("5925", "2", "0", "42", "1", "20.500000000000", "204"),("5926", "2", "0", "42", "1", "20.500000000000", "205"),("73288", "2", "0", "185", "1", "28.000000000000", "206"),("337", "2", "0", "19", "1", "38.370000000000", "207"),("53114", "2", "0", "67", "1", "42.850000000000", "208"),("53118", "2", "0", "67", "1", "42.850000000000", "209"),("53119", "2", "0", "67", "1", "42.850000000000", "210"),("231444", "1", "0", "294", "1", "168.917000000000", "211"),("339", "2", "0", "19", "1", "38.370000000000", "212"),("5929", "2", "0", "42", "1", "22.000000000000", "213"),("5933", "2", "0", "42", "1", "22.000000000000", "214"),("5941", "2", "0", "42", "1", "20.500000000000", "215"),("5949", "2", "0", "42", "1", "23.000000000000", "216"),("5951", "2", "0", "42", "1", "23.000000000000", "217"),("91016", "2", "0", "42", "1", "20.000000000000", "218"),("177352", "2", "0", "117", "1", "30.000000000000", "219"),("104994", "2", "0", "42", "1", "17.000000000000", "220"),("105077", "2", "0", "42", "1", "20.000000000000", "221"),("105079", "2", "0", "42", "1", "20.000000000000", "222"),("230283", "2", "0", "42", "1", "19.200000000000", "223"),("230284", "2", "0", "42", "1", "20.000000000000", "224"),("230285", "2", "0", "42", "1", "20.500000000000", "225"),("230286", "2", "0", "42", "1", "20.500000000000", "226"),("230287", "2", "0", "42", "1", "20.500000000000", "227"),("230288", "2", "0", "42", "1", "20.500000000000", "228"),("230289", "2", "0", "42", "1", "20.500000000000", "229"),("230290", "2", "0", "42", "1", "20.500000000000", "230"),("104992", "2", "0", "42", "1", "17.000000000000", "231"),("105083", "2", "0", "42", "1", "20.500000000000", "232"),("105086", "2", "0", "42", "1", "20.500000000000", "233"),("177365", "2", "0", "117", "1", "30.000000000000", "234"),("178730", "2", "0", "27", "1", "15.000000000000", "235"),("65516", "2", "0", "103", "1", "8.500000000000", "236"),("147093", "2", "0", "177", "1", "15.000000000000", "237"),("147113", "2", "0", "177", "1", "12.830000000000", "238"),("147721", "2", "0", "177", "1", "15.000000000000", "239"),("147737", "2", "0", "177", "1", "15.000000000000", "240"),("31099", "2", "0", "117", "1", "29.000000000000", "241"),("156057", "2", "0", "19", "1", "10.370000000000", "242"),("65493", "2", "0", "103", "1", "8.500000000000", "243"),("108233", "1", "0", "104", "1", "28.000000000000", "244")

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'