Căutare

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

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 ("225364", "1", "1000", "124", "1", "165.450000000000", "1"),("235003", "1", "1003", "11", "1", "135.270000000000", "2"),("233561", "1", "1001", "87", "1", "125.200000000000", "3"),("207455", "1", "1002", "124", "1", "61.330000000000", "4"),("59817", "2", "1001", "188", "1", "90.660000000000", "5"),("109313", "2", "1000", "163", "1", "96.910000000000", "6"),("235002", "1", "1003", "11", "1", "185.690000000000", "7"),("238006", "10", "1001", "87", "1", "160.490000000000", "8"),("109320", "2", "1000", "163", "1", "150.790000000000", "9"),("235004", "1", "1000", "11", "1", "84.850000000000", "10"),("235005", "1", "1000", "11", "1", "93.260000000000", "11"),("94406", "2", "1", "67", "1", "46.210000000000", "12"),("234001", "1", "1000", "119", "1", "146.040000000000", "13"),("201901", "2", "1000", "11", "1", "229.680000000000", "14"),("225474", "1", "1000", "17", "1", "42.760000000000", "15"),("233560", "1", "1001", "87", "1", "89.900000000000", "16"),("238616", "1", "1", "124", "1", "44.140000000000", "17"),("117051", "10", "2", "280", "1", "150.440000000000", "18"),("220382", "1", "1000", "299", "1", "33.510000000000", "19"),("17649", "2", "1000", "42", "1", "19.310000000000", "20"),("17682", "2", "1000", "42", "1", "24.360000000000", "21"),("59815", "2", "1000", "188", "1", "88.140000000000", "22"),("96126", "2", "1", "105", "1", "99.900000000000", "23"),("165658", "1", "1000", "224", "1", "202.420000000000", "24"),("95404", "2", "1006", "24", "1", "67.970000000000", "25"),("59818", "2", "1004", "188", "1", "101.590000000000", "26"),("80254", "2", "1001", "115", "1", "198.310000000000", "27"),("80251", "2", "1001", "115", "1", "164.690000000000", "28"),("80255", "2", "1000", "115", "1", "311.750000000000", "29"),("80256", "2", "1000", "115", "1", "378.980000000000", "30"),("207453", "1", "997", "124", "1", "36.960000000000", "31"),("80252", "2", "2", "115", "1", "181.500000000000", "32"),("80250", "2", "1", "115", "1", "143.690000000000", "33"),("207457", "1", "1", "124", "1", "76.450000000000", "34"),("169102", "2", "1007", "87", "1", "72.260000000000", "35"),("23090", "2", "1000", "163", "1", "44.460000000000", "36"),("109314", "2", "1000", "163", "1", "125.470000000000", "37"),("109312", "2", "2", "163", "1", "71.680000000000", "38"),("53042", "2", "1", "67", "1", "21.250000000000", "39"),("205661", "1", "1000", "224", "1", "164.610000000000", "40"),("116370", "2", "1001", "58", "1", "332.760000000000", "41"),("201899", "2", "1000", "11", "1", "155.940000000000", "42"),("39669", "2", "4", "42", "1", "45.200000000000", "43"),("77570", "2", "1", "11", "1", "355.170000000000", "44"),("228201", "1", "1000", "49", "1", "1354.520000000000", "45"),("219933", "1", "1", "370", "1", "151.360000000000", "46"),("84093", "2", "1000", "75", "1", "126.790000000000", "47"),("84094", "2", "1000", "75", "1", "135.200000000000", "48"),("234002", "1", "1000", "119", "1", "159.860000000000", "49"),("201903", "2", "1000", "11", "1", "276.770000000000", "50"),("84091", "2", "1", "75", "1", "118.390000000000", "51"),("206739", "1", "1005", "13", "1", "57.880000000000", "52"),("228416", "2", "1000", "476", "1", "28.020000000000", "53"),("216333", "2", "1000", "188", "1", "94.020000000000", "54"),("216345", "2", "1000", "188", "1", "99.900000000000", "55"),("236037", "2", "1000", "224", "1", "39.400000000000", "56"),("194149", "1", "1002", "87", "1", "213.430000000000", "57"),("230670", "2", "1000", "105", "1", "220.070000000000", "58"),("194151", "1", "1000", "87", "1", "195.790000000000", "59"),("183305", "1", "1000", "20", "1", "18.650000000000", "60"),("188695", "2", "1000", "20", "1", "18.650000000000", "61"),("222170", "2", "1005", "476", "1", "24.240000000000", "62"),("222172", "2", "1000", "476", "1", "24.240000000000", "63"),("222178", "2", "1000", "476", "1", "28.020000000000", "64"),("216467", "2", "1000", "188", "1", "110.830000000000", "65"),("238726", "2", "1000", "27", "1", "151.340000000000", "66"),("238727", "2", "1000", "27", "1", "162.830000000000", "67"),("238728", "2", "1000", "27", "1", "174.420000000000", "68"),("176184", "2", "1000", "124", "1", "94.710000000000", "69"),("176187", "2", "1000", "124", "1", "199.190000000000", "70"),("109156", "2", "1000", "163", "1", "168.060000000000", "71"),("116784", "4", "4", "280", "1", "89.060000000000", "72"),("56235", "2", "1002", "123", "1", "8.640000000000", "73"),("164867", "1", "1006", "168", "1", "23.480000000000", "74"),("177490", "1", "1003", "13", "1", "241.080000000000", "75"),("111035", "2", "1000", "49", "1", "1219.230000000000", "76"),("111041", "2", "1000", "49", "1", "783.100000000000", "77"),("216327", "2", "1000", "30", "1", "167.130000000000", "78"),("248046", "1", "1000", "808", "1", "227.640000000000", "79"),("248166", "1", "1000", "808", "1", "118.470000000000", "80"),("93101", "2", "1000", "163", "1", "69.830000000000", "81"),("109158", "2", "1000", "163", "1", "293.040000000000", "82"),("216473", "2", "1000", "27", "1", "148.640000000000", "83"),("216485", "2", "1000", "27", "1", "134.360000000000", "84"),("87690", "2", "1000", "49", "1", "126.790000000000", "85"),("68193", "2", "1000", "163", "1", "56.830000000000", "86"),("228197", "1", "1000", "49", "1", "1253.690000000000", "87"),("216497", "2", "1000", "27", "1", "162.090000000000", "88"),("248071", "1", "1000", "808", "1", "319.310000000000", "89"),("250092", "1", "1000", "115", "1", "412.400000000000", "90"),("186247", "1", "1000", "357", "1", "136.930000000000", "91"),("186249", "1", "1000", "357", "1", "159.620000000000", "92"),("9707", "2", "1000", "163", "1", "144.000000000000", "93"),("41239", "2", "23", "115", "1", "2.500000000000", "94"),("131669", "2", "1007", "559", "1", "24.360000000000", "95"),("131667", "2", "1005", "559", "1", "24.360000000000", "96"),("131677", "2", "1001", "559", "1", "25.120000000000", "97"),("131665", "2", "1000", "559", "1", "25.120000000000", "98"),("131671", "2", "1000", "559", "1", "25.120000000000", "99"),("131673", "2", "1000", "559", "1", "25.120000000000", "100"),("131681", "2", "3", "559", "1", "17.550000000000", "101"),("131683", "2", "3", "559", "1", "17.550000000000", "102"),("131685", "2", "3", "559", "1", "17.550000000000", "103"),("131679", "2", "2", "559", "1", "17.550000000000", "104"),("246279", "2", "1000", "224", "1", "183.930000000000", "105"),("114805", "2", "1005", "188", "1", "60.400000000000", "106"),("176415", "2", "1", "191", "1", "57.070000000000", "107"),("235569", "2", "1000", "85", "1", "12.600000000000", "108"),("53607", "2", "1000", "382", "1", "31.920000000000", "109"),("81641", "2", "1002", "67", "1", "88.980000000000", "110"),("40608", "2", "1", "67", "1", "226.030000000000", "111"),("69781", "2", "1000", "24", "1", "43.600000000000", "112"),("53565", "2", "1000", "382", "1", "24.690000000000", "113"),("53650", "2", "1000", "382", "1", "44.520000000000", "114"),("69871", "2", "1000", "27", "1", "42.930000000000", "115"),("91186", "2", "1000", "42", "1", "92.420000000000", "116"),("165651", "1", "1000", "224", "1", "240.240000000000", "117"),("117052", "10", "1", "280", "1", "188.140000000000", "118"),("156493", "2", "1016", "517", "1", "9.040000000000", "119"),("242817", "2", "1000", "368", "1", "549.870000000000", "120"),("156495", "2", "1008", "517", "1", "9.040000000000", "121"),("114793", "2", "1006", "24", "1", "6.630000000000", "122"),("23853", "10", "1000", "222", "1", "248.170000000000", "123"),("23854", "10", "1000", "222", "1", "248.170000000000", "124"),("23855", "10", "1000", "222", "1", "248.170000000000", "125"),("249304", "2", "1000", "58", "1", "3.300000000000", "126"),("249307", "2", "1000", "58", "1", "3.300000000000", "127"),("249308", "2", "1000", "58", "1", "3.300000000000", "128"),("249309", "2", "1000", "58", "1", "4.880000000000", "129"),("249310", "2", "1000", "58", "1", "4.880000000000", "130"),("188533", "1", "1003", "87", "1", "89.900000000000", "131"),("205659", "1", "1001", "224", "1", "138.760000000000", "132"),("88101", "2", "1000", "423", "1", "222.680000000000", "133"),("225860", "1", "1000", "113", "1", "362.930000000000", "134"),("210103", "1", "1000", "476", "1", "105.830000000000", "135"),("205663", "1", "1000", "224", "1", "206.630000000000", "136"),("49987", "10", "1", "376", "1", "286.420000000000", "137"),("230643", "1", "1002", "360", "1", "68.860000000000", "138"),("188593", "1", "1001", "656", "1", "39.910000000000", "139"),("188595", "1", "1001", "656", "1", "39.910000000000", "140"),("188597", "1", "1001", "656", "1", "39.020000000000", "141"),("228200", "1", "1000", "49", "1", "1774.690000000000", "142"),("188591", "1", "1000", "656", "1", "39.910000000000", "143"),("243072", "1", "1000", "162", "1", "135.240000000000", "144"),("243076", "1", "1000", "162", "1", "34.400000000000", "145"),("228852", "1", "1000", "423", "1", "420.990000000000", "146"),("242947", "2", "1005", "73", "1", "34.400000000000", "147"),("206737", "1", "1003", "13", "1", "47.800000000000", "148"),("129803", "2", "1002", "73", "1", "34.400000000000", "149"),("54098", "2", "1000", "382", "1", "36.120000000000", "150"),("145099", "2", "1000", "73", "1", "32.000000000000", "151"),("228196", "1", "1000", "49", "1", "1606.630000000000", "152"),("216331", "2", "1000", "188", "1", "82.260000000000", "153"),("216335", "2", "1000", "188", "1", "104.940000000000", "154"),("216343", "2", "1000", "188", "1", "88.140000000000", "155"),("216347", "2", "1000", "188", "1", "116.710000000000", "156"),("242944", "2", "1000", "73", "1", "34.400000000000", "157"),("242948", "2", "1000", "73", "1", "33.430000000000", "158"),("243073", "1", "1000", "162", "1", "135.240000000000", "159"),("243077", "1", "1000", "162", "1", "34.400000000000", "160"),("110798", "10", "1000", "246", "1", "330.210000000000", "161"),("110799", "10", "1000", "246", "1", "118.150000000000", "162"),("95855", "2", "1", "98", "1", "47.040000000000", "163"),("95857", "2", "1", "98", "1", "84.850000000000", "164"),("177495", "1", "1003", "13", "1", "225.950000000000", "165"),("93013", "10", "1001", "246", "1", "330.210000000000", "166"),("35443", "2", "1000", "58", "1", "194.860000000000", "167"),("233870", "1", "1000", "360", "1", "322.220000000000", "168"),("216465", "2", "1000", "188", "1", "99.900000000000", "169"),("216469", "2", "1000", "188", "1", "128.470000000000", "170"),("238236", "1", "1000", "123", "1", "460.600000000000", "171"),("238238", "1", "1000", "123", "1", "535.510000000000", "172"),("184341", "1", "1006", "168", "1", "18.940000000000", "173"),("177491", "1", "1002", "13", "1", "292.340000000000", "174"),("150597", "1", "1002", "58", "1", "19.230000000000", "175"),("177492", "1", "1001", "13", "1", "336.880000000000", "176"),("165218", "1", "1000", "354", "1", "7.460000000000", "177"),("111036", "2", "1000", "49", "1", "1420.910000000000", "178"),("216325", "2", "1000", "30", "1", "129.310000000000", "179"),("216329", "2", "1000", "30", "1", "215.020000000000", "180"),("248045", "1", "1000", "808", "1", "178.050000000000", "181"),("248047", "1", "1000", "808", "1", "286.450000000000", "182"),("248160", "1", "1000", "808", "1", "99.980000000000", "183"),("248215", "1", "1000", "808", "1", "176.450000000000", "184"),("177494", "1", "1000", "13", "1", "393.180000000000", "185"),("150593", "1", "1000", "58", "1", "19.230000000000", "186"),("127199", "1", "1000", "217", "1", "20.910000000000", "187"),("127201", "1", "1000", "217", "1", "20.910000000000", "188"),("216471", "2", "1000", "27", "1", "117.550000000000", "189"),("216475", "2", "1000", "27", "1", "168.810000000000", "190"),("216483", "2", "1000", "27", "1", "110.830000000000", "191"),("216487", "2", "1000", "27", "1", "174.690000000000", "192"),("242512", "2", "1000", "73", "1", "34.400000000000", "193"),("222194", "1", "1000", "745", "1", "21.750000000000", "194"),("216495", "2", "1000", "27", "1", "125.120000000000", "195"),("216499", "2", "1000", "27", "1", "207.460000000000", "196"),("242988", "2", "1000", "73", "1", "47.000000000000", "197"),("242990", "2", "1000", "73", "1", "47.000000000000", "198"),("248070", "1", "1000", "808", "1", "235.280000000000", "199"),("248072", "1", "1000", "808", "1", "504.190000000000", "200"),("250081", "1", "1000", "115", "1", "175.210000000000", "201"),("250088", "1", "1000", "115", "1", "195.040000000000", "202"),("250090", "1", "1000", "115", "1", "290.910000000000", "203"),("250939", "1", "1000", "58", "1", "46.200000000000", "204"),("250940", "1", "1000", "58", "1", "58.600000000000", "205"),("250941", "1", "1000", "58", "1", "81.740000000000", "206"),("206745", "1", "1000", "13", "1", "67.970000000000", "207"),("242989", "2", "1000", "73", "1", "47.000000000000", "208"),("73253", "2", "1", "465", "1", "20.490000000000", "209"),("66942", "2", "1055", "168", "1", "42.390000000000", "210"),("172782", "1", "1000", "261", "1", "519.240000000000", "211"),("89636", "2", "1009", "362", "1", "3.850000000000", "212"),("246278", "2", "1000", "224", "1", "222.600000000000", "213"),("236969", "2", "1000", "124", "1", "274.780000000000", "214"),("89646", "2", "1011", "362", "1", "6.030000000000", "215"),("226539", "1", "1001", "58", "1", "420.910000000000", "216"),("226541", "1", "1000", "58", "1", "417.550000000000", "217"),("226542", "1", "1000", "58", "1", "409.150000000000", "218"),("77569", "2", "0", "11", "1", "183.510000000000", "219"),("229075", "1", "0", "17", "1", "34.360000000000", "220"),("176182", "2", "0", "124", "1", "97.910000000000", "221"),("176186", "2", "0", "124", "1", "91.420000000000", "222"),("109157", "2", "0", "163", "1", "224.780000000000", "223"),("22728", "2", "0", "163", "1", "32.780000000000", "224"),("88100", "2", "0", "423", "1", "129.540000000000", "225"),("77565", "2", "0", "11", "1", "155.320000000000", "226"),("77568", "2", "0", "11", "1", "147.930000000000", "227"),("238454", "2", "0", "357", "1", "119.400000000000", "228"),("238456", "2", "0", "357", "1", "208.770000000000", "229"),("228851", "1", "0", "423", "1", "323.510000000000", "230"),("176180", "2", "0", "124", "1", "65.260000000000", "231"),("176181", "2", "0", "124", "1", "84.300000000000", "232"),("176183", "2", "0", "124", "1", "119.670000000000", "233"),("95856", "2", "0", "98", "1", "46.820000000000", "234"),("176185", "2", "0", "124", "1", "108.610000000000", "235"),("59610", "2", "0", "67", "1", "48.860000000000", "236"),("250768", "1", "0", "170", "1", "349.750000000000", "237"),("230611", "2", "0", "528", "1", "5.020000000000", "238"),("175158", "2", "0", "191", "1", "103.340000000000", "239"),("176414", "2", "0", "191", "1", "54.360000000000", "240"),("141093", "1", "0", "285", "1", "73.293300000000", "241"),("131001", "2", "0", "287", "1", "65.430000000000", "242"),("81642", "2", "0", "67", "1", "74.780000000000", "243"),("40606", "2", "0", "67", "1", "105.690000000000", "244"),("87160", "2", "0", "469", "1", "7.010000000000", "245"),("117050", "10", "0", "280", "1", "71.447000000000", "246"),("218413", "1", "0", "749", "1", "67.970000000000", "247"),("218415", "1", "0", "749", "1", "67.970000000000", "248"),("218417", "1", "0", "749", "1", "67.970000000000", "249"),("218419", "1", "0", "749", "1", "67.970000000000", "250"),("218421", "1", "0", "749", "1", "67.970000000000", "251"),("190599", "2", "0", "287", "1", "11.000000000000", "252"),("70503", "2", "0", "24", "1", "375.000000000000", "253"),("87163", "2", "0", "469", "1", "7.460000000000", "254"),("176431", "1", "0", "191", "1", "59.830000000000", "255"),("249311", "2", "0", "58", "1", "3.300000000000", "256"),("87863", "2", "0", "423", "1", "90.780000000000", "257"),("205667", "1", "0", "224", "1", "247.220000000000", "258"),("173800", "1", "0", "191", "1", "231.190000000000", "259"),("235892", "2", "0", "59", "1", "1177.290000000000", "260"),("235251", "2", "0", "59", "1", "20.150000000000", "261"),("251498", "1", "0", "294", "1", "493.100000000000", "262"),("251502", "1", "0", "294", "1", "493.100000000000", "263")

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'