Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '4623410c278774f72c8eb291cf'

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 ("175311", "1", "5", "358", "1", "53.510000000000", "1"),("175310", "1", "8", "358", "1", "52.790000000000", "2"),("247702", "1", "1000", "370", "1", "9.290000000000", "3"),("172336", "2", "1000", "20", "1", "33.480000000000", "4"),("172339", "2", "1000", "20", "1", "29.580000000000", "5"),("172345", "2", "1000", "20", "1", "24.200000000000", "6"),("172346", "2", "1000", "20", "1", "27.120000000000", "7"),("172347", "2", "1000", "20", "1", "29.580000000000", "8"),("172363", "2", "1000", "20", "1", "27.720000000000", "9"),("172364", "2", "1000", "20", "1", "26.160000000000", "10"),("172365", "2", "1000", "20", "1", "28.620000000000", "11"),("172386", "2", "1000", "20", "1", "24.220000000000", "12"),("172387", "2", "1000", "20", "1", "27.120000000000", "13"),("172388", "2", "1000", "20", "1", "29.580000000000", "14"),("172337", "2", "1000", "20", "1", "24.490000000000", "15"),("172338", "2", "1000", "20", "1", "27.400000000000", "16"),("4471", "2", "8", "96", "1", "7.380000000000", "17"),("172352", "2", "1002", "20", "1", "31.830000000000", "18"),("172384", "2", "1002", "20", "1", "32.970000000000", "19"),("172360", "2", "1001", "20", "1", "33.550000000000", "20"),("172341", "2", "1001", "20", "1", "36.400000000000", "21"),("172340", "2", "1000", "20", "1", "34.450000000000", "22"),("172342", "2", "1000", "20", "1", "40.300000000000", "23"),("172343", "2", "1000", "20", "1", "30.670000000000", "24"),("172344", "2", "1000", "20", "1", "30.560000000000", "25"),("172348", "2", "1000", "20", "1", "34.920000000000", "26"),("172349", "2", "1000", "20", "1", "37.380000000000", "27"),("172350", "2", "1000", "20", "1", "41.260000000000", "28"),("172351", "2", "1000", "20", "1", "43.680000000000", "29"),("172353", "2", "1000", "20", "1", "34.730000000000", "30"),("172354", "2", "1000", "20", "1", "31.540000000000", "31"),("172355", "2", "1000", "20", "1", "43.510000000000", "32"),("172356", "2", "1000", "20", "1", "38.810000000000", "33"),("172357", "2", "1000", "20", "1", "42.660000000000", "34"),("172358", "2", "1000", "20", "1", "44.650000000000", "35"),("172359", "2", "1000", "20", "1", "48.600000000000", "36"),("172362", "2", "1000", "20", "1", "38.830000000000", "37"),("172367", "2", "1000", "20", "1", "38.350000000000", "38"),("172368", "2", "1000", "20", "1", "40.760000000000", "39"),("172369", "2", "1000", "20", "1", "44.200000000000", "40"),("172370", "2", "1000", "20", "1", "46.650000000000", "41"),("172371", "2", "1000", "20", "1", "60.490000000000", "42"),("172372", "2", "1000", "20", "1", "67.500000000000", "43"),("172373", "2", "1000", "20", "1", "34.730000000000", "44"),("172374", "2", "1000", "20", "1", "38.230000000000", "45"),("172375", "2", "1000", "20", "1", "34.450000000000", "46"),("172376", "2", "1000", "20", "1", "40.300000000000", "47"),("172377", "2", "1000", "20", "1", "42.710000000000", "48"),("172379", "2", "1000", "20", "1", "46.140000000000", "49"),("172380", "2", "1000", "20", "1", "48.600000000000", "50"),("172381", "2", "1000", "20", "1", "62.830000000000", "51"),("172382", "2", "1000", "20", "1", "69.800000000000", "52"),("172383", "2", "1000", "20", "1", "31.540000000000", "53"),("172385", "2", "1000", "20", "1", "35.430000000000", "54"),("172389", "2", "1000", "20", "1", "43.680000000000", "55"),("172390", "2", "1000", "20", "1", "46.140000000000", "56"),("172391", "2", "1000", "20", "1", "50.040000000000", "57"),("172392", "2", "1000", "20", "1", "52.500000000000", "58"),("172393", "2", "1000", "20", "1", "55.880000000000", "59"),("172394", "2", "1000", "20", "1", "62.230000000000", "60"),("172395", "2", "1000", "20", "1", "68.550000000000", "61"),("172396", "2", "1000", "20", "1", "36.400000000000", "62"),("172397", "2", "1000", "20", "1", "38.810000000000", "63"),("165", "2", "1000", "19", "1", "22.780000000000", "64"),("182", "2", "1000", "19", "1", "32.930000000000", "65"),("11723", "2", "1000", "19", "1", "18.140000000000", "66"),("145815", "1", "26", "28", "1", "19.310000000000", "67"),("201421", "1", "15", "28", "1", "19.310000000000", "68"),("240423", "2", "1003", "20", "1", "28.400000000000", "69"),("240424", "2", "1003", "20", "1", "28.400000000000", "70"),("234166", "2", "1014", "68", "1", "7.970000000000", "71"),("184257", "2", "1011", "168", "1", "19.700000000000", "72"),("234168", "2", "1008", "68", "1", "7.970000000000", "73"),("234167", "2", "1008", "68", "1", "7.970000000000", "74"),("231982", "1", "1003", "19", "1", "15.120000000000", "75"),("222785", "1", "1002", "19", "1", "15.120000000000", "76"),("222594", "1", "1001", "58", "1", "16.710000000000", "77"),("222595", "1", "1001", "58", "1", "16.710000000000", "78"),("202031", "1", "1001", "19", "1", "17.040000000000", "79"),("222596", "1", "1000", "58", "1", "16.710000000000", "80"),("222597", "1", "1000", "58", "1", "16.710000000000", "81"),("222598", "1", "1000", "58", "1", "16.710000000000", "82"),("222599", "1", "1000", "58", "1", "16.710000000000", "83"),("222600", "1", "1000", "58", "1", "16.710000000000", "84"),("222601", "1", "1000", "58", "1", "16.710000000000", "85"),("222602", "1", "1000", "58", "1", "16.710000000000", "86"),("222603", "1", "1000", "58", "1", "16.710000000000", "87"),("202021", "1", "1000", "19", "1", "14.270000000000", "88"),("202023", "1", "1000", "19", "1", "14.270000000000", "89"),("202025", "1", "1000", "19", "1", "17.040000000000", "90"),("202027", "1", "1000", "19", "1", "17.040000000000", "91"),("202029", "1", "1000", "19", "1", "17.040000000000", "92"),("203913", "1", "1000", "19", "1", "22.930000000000", "93"),("203921", "1", "1000", "19", "1", "22.930000000000", "94"),("203923", "2", "1000", "19", "1", "16.790000000000", "95"),("203925", "2", "1000", "19", "1", "16.790000000000", "96"),("203927", "2", "1000", "19", "1", "16.790000000000", "97"),("203929", "2", "1000", "19", "1", "22.930000000000", "98"),("237310", "1", "1000", "19", "1", "12.930000000000", "99"),("237311", "1", "1000", "19", "1", "12.930000000000", "100"),("237312", "1", "1000", "19", "1", "12.930000000000", "101"),("237322", "1", "1000", "19", "1", "32.500000000000", "102"),("237323", "1", "1000", "19", "1", "32.500000000000", "103"),("237324", "1", "1000", "19", "1", "26.290000000000", "104"),("237325", "1", "1000", "19", "1", "26.290000000000", "105"),("237329", "1", "1000", "19", "1", "12.930000000000", "106"),("237330", "1", "1000", "19", "1", "12.930000000000", "107"),("237331", "1", "1000", "19", "1", "12.930000000000", "108"),("234", "2", "1000", "19", "1", "52.830000000000", "109"),("231834", "2", "1000", "19", "1", "16.040000000000", "110"),("234165", "2", "10", "68", "1", "8.310000000000", "111"),("185239", "2", "1008", "168", "1", "19.690000000000", "112"),("185243", "2", "1006", "168", "1", "18.930000000000", "113"),("184255", "1", "1004", "168", "1", "20.450000000000", "114"),("185241", "2", "1004", "168", "1", "19.690000000000", "115"),("177679", "1", "1000", "58", "1", "23.430000000000", "116"),("177680", "1", "1000", "58", "1", "20.070000000000", "117"),("177681", "1", "1000", "58", "1", "19.230000000000", "118"),("177682", "1", "1000", "58", "1", "18.390000000000", "119"),("177683", "1", "1000", "58", "1", "18.390000000000", "120"),("177684", "1", "1000", "58", "1", "18.390000000000", "121"),("177685", "1", "1000", "58", "1", "18.390000000000", "122"),("228312", "1", "1000", "455", "1", "22.350000000000", "123"),("9518", "2", "1000", "19", "1", "41.680000000000", "124"),("9520", "2", "1000", "19", "1", "67.830000000000", "125"),("176364", "-100", "45", "26", "1", "16.450000000000", "126"),("233", "2", "4", "19", "1", "39.400000000000", "127"),("9519", "2", "2", "19", "1", "49.480000000000", "128"),("188589", "2", "1004", "656", "1", "17.320000000000", "129"),("48634", "2", "1001", "19", "1", "18.120000000000", "130"),("229973", "2", "1000", "455", "1", "18.560000000000", "131"),("233466", "2", "1000", "85", "1", "106.710000000000", "132"),("233467", "2", "1000", "85", "1", "119.310000000000", "133"),("233468", "2", "1000", "85", "1", "129.400000000000", "134"),("184289", "1", "1003", "168", "1", "19.700000000000", "135"),("113", "2", "1001", "19", "1", "15.010000000000", "136"),("243721", "2", "1000", "170", "1", "29.040000000000", "137"),("243725", "2", "1000", "170", "1", "29.040000000000", "138"),("243726", "2", "1000", "170", "1", "29.040000000000", "139"),("243727", "2", "1000", "170", "1", "29.040000000000", "140"),("243728", "2", "1000", "170", "1", "29.040000000000", "141"),("243729", "2", "1000", "170", "1", "29.040000000000", "142"),("243722", "2", "1000", "170", "1", "29.040000000000", "143"),("243723", "2", "1000", "170", "1", "29.040000000000", "144"),("243724", "2", "1000", "170", "1", "29.040000000000", "145"),("108", "2", "3", "19", "1", "11.670000000000", "146"),("184299", "1", "1004", "168", "1", "28.020000000000", "147"),("187", "2", "1005", "19", "1", "18.890000000000", "148"),("243689", "2", "1000", "170", "1", "18.330000000000", "149"),("243690", "2", "1000", "170", "1", "18.330000000000", "150"),("243691", "2", "1000", "170", "1", "18.330000000000", "151"),("243692", "2", "1000", "170", "1", "18.330000000000", "152"),("243694", "2", "1000", "170", "1", "18.330000000000", "153"),("243695", "2", "1000", "170", "1", "18.330000000000", "154"),("243698", "2", "1000", "170", "1", "18.330000000000", "155"),("243704", "2", "1000", "170", "1", "18.330000000000", "156"),("243709", "2", "1000", "170", "1", "26.540000000000", "157"),("243710", "2", "1000", "170", "1", "26.540000000000", "158"),("243874", "2", "1000", "73", "1", "23.050000000000", "159"),("243701", "2", "1000", "170", "1", "18.330000000000", "160"),("243702", "2", "1000", "170", "1", "18.330000000000", "161"),("243703", "2", "1000", "170", "1", "18.330000000000", "162"),("243705", "2", "1000", "170", "1", "18.330000000000", "163"),("243707", "2", "1000", "170", "1", "26.540000000000", "164"),("243877", "2", "1000", "73", "1", "23.050000000000", "165"),("246599", "1", "17", "28", "1", "15.620000000000", "166"),("184297", "1", "1007", "168", "1", "24.240000000000", "167"),("229975", "1", "1000", "204", "1", "22.350000000000", "168"),("243730", "2", "1000", "170", "1", "44.040000000000", "169"),("243731", "2", "1000", "170", "1", "44.040000000000", "170"),("243732", "2", "1000", "170", "1", "44.040000000000", "171"),("246843", "1", "2", "809", "1", "14.270000000000", "172"),("232812", "2", "1003", "785", "1", "16.710000000000", "173"),("232811", "2", "1000", "785", "1", "16.710000000000", "174"),("243711", "2", "1000", "170", "1", "43.690000000000", "175"),("243712", "2", "1000", "170", "1", "43.690000000000", "176"),("243713", "2", "1000", "170", "1", "43.690000000000", "177"),("246597", "1", "12", "28", "1", "15.620000000000", "178"),("246596", "1", "11", "28", "1", "15.620000000000", "179"),("246594", "1", "3", "28", "1", "19.830000000000", "180"),("236818", "1", "2", "356", "1", "71.410000000000", "181"),("225", "2", "1017", "19", "1", "17.380000000000", "182"),("224", "2", "1011", "19", "1", "17.380000000000", "183"),("221", "2", "1004", "19", "1", "16.370000000000", "184"),("229968", "2", "1000", "19", "1", "16.370000000000", "185"),("229969", "2", "1000", "19", "1", "16.370000000000", "186"),("220", "2", "7", "19", "1", "16.370000000000", "187"),("244310", "2", "1000", "54", "1", "13.430000000000", "188"),("244311", "2", "1000", "54", "1", "13.430000000000", "189"),("244312", "2", "1000", "54", "1", "13.430000000000", "190"),("241231", "2", "0", "19", "1", "8.540000000000", "191"),("172361", "2", "0", "20", "1", "35.880000000000", "192"),("230610", "2", "0", "528", "1", "5.020000000000", "193"),("230611", "2", "0", "528", "1", "5.020000000000", "194"),("230612", "2", "0", "528", "1", "5.020000000000", "195"),("203915", "1", "0", "19", "1", "22.930000000000", "196"),("203917", "1", "0", "19", "1", "22.930000000000", "197"),("203919", "1", "0", "19", "1", "22.930000000000", "198"),("203931", "2", "0", "19", "1", "22.930000000000", "199"),("203933", "2", "0", "19", "1", "22.930000000000", "200"),("203935", "2", "0", "19", "1", "22.930000000000", "201"),("243693", "2", "0", "170", "1", "18.330000000000", "202"),("243697", "2", "0", "170", "1", "18.330000000000", "203"),("243699", "2", "0", "170", "1", "18.330000000000", "204"),("243700", "2", "0", "170", "1", "18.330000000000", "205"),("243706", "2", "0", "170", "1", "26.540000000000", "206"),("243708", "2", "0", "170", "1", "26.540000000000", "207"),("243696", "2", "0", "170", "1", "18.330000000000", "208"),("246598", "1", "0", "28", "1", "8.960000000000", "209"),("246595", "1", "0", "28", "1", "11.920000000000", "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 *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'

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'