Căutare - PAPUCI FOX

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

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 ("196713", "2", "1002", "168", "1", "141.460000000000", "1"),("241149", "2", "1002", "168", "1", "77.180000000000", "2"),("241145", "2", "1001", "168", "1", "77.180000000000", "3"),("241150", "2", "1001", "168", "1", "77.180000000000", "4"),("196715", "2", "1000", "168", "1", "141.460000000000", "5"),("196717", "2", "1000", "168", "1", "141.460000000000", "6"),("196719", "2", "1000", "168", "1", "141.460000000000", "7"),("196721", "2", "1000", "168", "1", "141.460000000000", "8"),("196723", "2", "1000", "168", "1", "141.460000000000", "9"),("241148", "2", "1000", "168", "1", "77.180000000000", "10"),("241151", "2", "1000", "168", "1", "77.180000000000", "11"),("241147", "2", "1000", "168", "1", "77.180000000000", "12"),("241191", "2", "1000", "455", "1", "73.400000000000", "13"),("241193", "2", "1000", "455", "1", "73.400000000000", "14"),("241194", "2", "1000", "455", "1", "73.400000000000", "15"),("241195", "2", "1000", "455", "1", "73.400000000000", "16"),("241196", "2", "1000", "455", "1", "73.400000000000", "17"),("241197", "2", "1000", "455", "1", "73.400000000000", "18"),("93480", "2", "1001", "168", "1", "772.980000000000", "19"),("93481", "2", "1000", "168", "1", "611.500000000000", "20"),("230174", "1", "1000", "168", "1", "1816.680000000000", "21"),("242807", "2", "1000", "168", "1", "1249.450000000000", "22"),("242808", "2", "1000", "168", "1", "984.740000000000", "23"),("242809", "2", "1000", "168", "1", "1098.190000000000", "24"),("34504", "2", "3", "168", "1", "965.080000000000", "25"),("230173", "1", "1000", "168", "1", "2459.530000000000", "26"),("227992", "1", "1001", "168", "1", "265.500000000000", "27"),("64613", "2", "1000", "168", "1", "65.830000000000", "28"),("228081", "1", "1000", "168", "1", "227.690000000000", "29"),("228228", "2", "1000", "168", "1", "209.530000000000", "30"),("161725", "2", "1001", "168", "1", "227.090000000000", "31"),("227949", "2", "1001", "168", "1", "246.600000000000", "32"),("227950", "2", "1001", "168", "1", "208.780000000000", "33"),("227991", "1", "1001", "168", "1", "322.220000000000", "34"),("228080", "1", "1001", "168", "1", "265.500000000000", "35"),("229973", "2", "1000", "455", "1", "18.560000000000", "36"),("247745", "2", "1000", "455", "1", "16.210000000000", "37"),("241471", "2", "1000", "455", "1", "12.890000000000", "38"),("185673", "2", "1000", "455", "1", "14.790000000000", "39"),("185675", "2", "1000", "455", "1", "14.790000000000", "40"),("127541", "1", "1", "455", "1", "425.020000000000", "41"),("153837", "1", "3", "455", "1", "183.060000000000", "42"),("153833", "1", "1", "455", "1", "103.660000000000", "43"),("153835", "1", "1", "455", "1", "160.370000000000", "44"),("185653", "2", "1000", "105", "1", "24.240000000000", "45"),("185655", "2", "1000", "105", "1", "22.350000000000", "46"),("185657", "2", "1000", "105", "1", "20.450000000000", "47"),("246075", "1", "1002", "650", "1", "16.790000000000", "48"),("246101", "1", "1002", "650", "1", "20.990000000000", "49"),("246122", "1", "1002", "650", "1", "20.990000000000", "50"),("169327", "1", "3", "174", "1", "84.020000000000", "51"),("97384", "2", "1005", "48", "1", "105.020000000000", "52"),("166336", "1", "1003", "54", "1", "139.480000000000", "53"),("246638", "2", "0", "168", "1", "82.540000000000", "54"),("246639", "2", "0", "168", "1", "82.540000000000", "55"),("246640", "2", "0", "168", "1", "82.540000000000", "56"),("246641", "2", "0", "168", "1", "82.540000000000", "57"),("246642", "2", "0", "168", "1", "82.540000000000", "58"),("246643", "2", "0", "168", "1", "82.540000000000", "59"),("131361", "2", "0", "168", "1", "59.560000000000", "60"),("131363", "2", "0", "168", "1", "69.640000000000", "61"),("93479", "2", "-1", "168", "1", "676.550000000000", "62"),("29085", "2", "0", "168", "1", "909.120000000000", "63"),("93482", "2", "0", "168", "1", "1031.450000000000", "64"),("34487", "2", "0", "168", "1", "749.970000000000", "65"),("97598", "2", "0", "168", "1", "1126.550000000000", "66"),("98712", "2", "0", "168", "1", "1724.060000000000", "67"),("98710", "2", "0", "168", "1", "1561.540000000000", "68"),("161727", "2", "0", "168", "1", "223.880000000000", "69"),("161733", "2", "0", "168", "1", "180.530000000000", "70"),("82390", "2", "0", "168", "1", "136.800000000000", "71"),("161773", "2", "0", "168", "1", "159.450000000000", "72"),("161775", "2", "0", "168", "1", "180.530000000000", "73"),("59307", "2", "0", "168", "1", "136.790000000000", "74"),("127551", "1", "0", "455", "1", "37.480000000000", "75"),("83111", "2", "0", "455", "1", "217.530000000000", "76"),("83154", "2", "0", "455", "1", "277.750000000000", "77"),("157907", "2", "0", "631", "1", "41.600000000000", "78"),("200783", "2", "0", "11", "1", "22.320000000000", "79")

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_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'