Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '981a9ce1c6694fc9eccc665517'

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 ("226550", "1", "1001", "58", "1", "589.17", "1"),("226548", "1", "1000", "58", "1", "615.62", "2"),("227570", "1", "1000", "58", "1", "573.47", "3"),("226539", "1", "1001", "58", "1", "421.4", "4"),("226541", "1", "1000", "58", "1", "418.1", "5"),("226542", "1", "1000", "58", "1", "409.83", "6"),("170457", "2", "1005", "58", "1", "161.07", "7"),("170456", "2", "1001", "58", "1", "153.64", "8"),("264831", "2", "1000", "58", "1", "145.37", "9"),("236533", "1", "1000", "58", "1", "287.52", "10"),("236543", "1", "1000", "58", "1", "304.88", "11"),("236545", "1", "1000", "58", "1", "313.14", "12"),("252337", "2", "1000", "58", "1", "2190.83", "13"),("253206", "2", "1001", "58", "1", "13.97", "14"),("263456", "1", "1000", "58", "1", "298.26", "15"),("150209", "2", "1001", "58", "1", "245.37", "16"),("250898", "2", "1000", "58", "1", "147.85", "17"),("150213", "2", "1", "58", "1", "182.56", "18"),("250934", "2", "1000", "58", "1", "73.47", "19"),("119598", "2", "1002", "58", "1", "14.79", "20"),("119599", "2", "1001", "58", "1", "13.97", "21"),("236574", "1", "1000", "58", "1", "74.3", "22"),("226544", "1", "1001", "58", "1", "140.41", "23"),("48157", "2", "1000", "58", "1", "287.52", "24"),("226545", "1", "1000", "58", "1", "134.63", "25"),("226546", "1", "1000", "58", "1", "123.88", "26"),("269653", "1", "1000", "58", "1", "73.47", "27"),("269654", "1", "1000", "58", "1", "75.12", "28"),("269655", "1", "1000", "58", "1", "81.74", "29"),("269656", "1", "1000", "58", "1", "112.31", "30"),("269657", "1", "1000", "58", "1", "116.45", "31"),("269658", "1", "1000", "58", "1", "120.58", "32"),("269677", "1", "1000", "58", "1", "120.58", "33"),("269678", "1", "1000", "58", "1", "120.58", "34"),("269679", "1", "1000", "58", "1", "145.37", "35"),("269680", "1", "1000", "58", "1", "128.84", "36"),("269681", "1", "1000", "58", "1", "128.84", "37"),("269682", "1", "1000", "58", "1", "182.56", "38"),("269693", "1", "1000", "58", "1", "153.64", "39"),("269694", "1", "1000", "58", "1", "149.5", "40"),("269697", "1", "1000", "58", "1", "81.74", "41"),("269698", "1", "1000", "58", "1", "99.92", "42"),("250909", "2", "1000", "58", "1", "54.46", "43"),("250911", "2", "1000", "58", "1", "71.82", "44"),("250912", "2", "1000", "58", "1", "91.65", "45"),("249340", "1", "1001", "58", "1", "82.56", "46"),("263469", "1", "1000", "58", "1", "2934.63", "47"),("269572", "1", "1000", "58", "1", "18.93", "48"),("244836", "1", "1001", "58", "1", "148.68", "49"),("263455", "1", "1001", "58", "1", "247.85", "50"),("244833", "1", "1000", "58", "1", "136.28", "51"),("244834", "1", "1000", "58", "1", "144.55", "52"),("244837", "1", "1000", "58", "1", "166.03", "53"),("244839", "1", "1000", "58", "1", "178.43", "54"),("263453", "1", "1000", "58", "1", "157.77", "55"),("263454", "1", "1000", "58", "1", "207.36", "56"),("269644", "1", "1000", "58", "1", "223.88", "57"),("244841", "1", "1004", "58", "1", "18.1", "58"),("244840", "1", "1003", "58", "1", "18.1", "59"),("66893", "2", "1000", "58", "1", "153.64", "60"),("269696", "1", "1000", "58", "1", "73.47", "61"),("9061", "2", "1000", "58", "1", "18.93", "62"),("244845", "2", "1000", "58", "1", "421.4", "63"),("244847", "2", "1000", "58", "1", "472.64", "64"),("244849", "2", "1000", "58", "1", "547.85", "65"),("244850", "2", "1000", "58", "1", "456.12", "66"),("244852", "2", "1000", "58", "1", "556.94", "67"),("249300", "2", "1000", "58", "1", "6.53", "68"),("249301", "2", "1000", "58", "1", "6.53", "69"),("249304", "2", "1000", "58", "1", "3.22", "70"),("249307", "2", "1000", "58", "1", "3.22", "71"),("249308", "2", "1000", "58", "1", "3.22", "72"),("249309", "2", "1000", "58", "1", "4.88", "73"),("249310", "2", "1000", "58", "1", "4.88", "74"),("250897", "2", "1002", "58", "1", "182.56", "75"),("106356", "1", "1000", "58", "1", "62.73", "76"),("106357", "1", "1000", "58", "1", "79.26", "77"),("106359", "1", "1000", "58", "1", "99.09", "78"),("106360", "1", "1000", "58", "1", "106.53", "79"),("106362", "1", "1000", "58", "1", "39.59", "80"),("106363", "1", "1000", "58", "1", "45.37", "81"),("108533", "1", "1000", "58", "1", "73.47", "82"),("119613", "2", "1000", "58", "1", "14.79", "83"),("250892", "2", "1000", "58", "1", "95.79", "84"),("250894", "2", "1000", "58", "1", "132.15", "85"),("106358", "1", "999", "58", "1", "86.69", "86"),("250895", "2", "1", "58", "1", "186.69", "87"),("270216", "1", "1000", "58", "1", "54.46", "88"),("270214", "1", "1001", "58", "1", "48.68", "89"),("270210", "1", "1000", "58", "1", "48.68", "90"),("270215", "1", "1000", "58", "1", "54.46", "91"),("270226", "1", "1000", "58", "1", "74.3", "92"),("270227", "1", "1000", "58", "1", "87.52", "93"),("270233", "1", "1000", "58", "1", "87.52", "94"),("270235", "1", "1000", "58", "1", "99.92", "95"),("81287", "2", "1003", "58", "1", "16.45", "96"),("250943", "1", "1001", "58", "1", "82.56", "97"),("250944", "1", "1001", "58", "1", "107.36", "98"),("122839", "2", "1000", "58", "1", "279.26", "99"),("122841", "2", "1000", "58", "1", "337.11", "100"),("250942", "1", "1000", "58", "1", "66.03", "101"),("152595", "2", "1", "58", "1", "161.07", "102"),("250939", "1", "1001", "58", "1", "46.2", "103"),("250940", "1", "1001", "58", "1", "58.6", "104"),("250941", "1", "1000", "58", "1", "81.74", "105"),("104975", "2", "7", "58", "1", "9.83", "106"),("250902", "2", "1001", "58", "1", "247.85", "107"),("255566", "2", "1001", "58", "1", "419.75", "108"),("250891", "2", "1000", "58", "1", "186.69", "109"),("250901", "2", "1000", "58", "1", "223.88", "110"),("250903", "2", "1000", "58", "1", "269.34", "111"),("270246", "1", "1000", "58", "1", "62.73", "112"),("270254", "1", "1000", "58", "1", "66.03", "113"),("270255", "1", "1000", "58", "1", "66.86", "114"),("270257", "1", "1000", "58", "1", "66.86", "115"),("150547", "2", "1001", "58", "1", "60.25", "116"),("263646", "1", "1001", "58", "1", "190.83", "117"),("150533", "2", "1000", "58", "1", "56.94", "118"),("150535", "2", "1000", "58", "1", "47.85", "119"),("150537", "2", "1000", "58", "1", "47.85", "120"),("150539", "2", "1000", "58", "1", "60.25", "121"),("150541", "2", "1000", "58", "1", "60.25", "122"),("150543", "2", "1000", "58", "1", "60.25", "123"),("150545", "2", "1000", "58", "1", "60.25", "124"),("150549", "2", "1000", "58", "1", "60.25", "125"),("150551", "2", "1000", "58", "1", "60.25", "126"),("263645", "1", "1000", "58", "1", "174.3", "127"),("263647", "1", "1000", "58", "1", "199.09", "128"),("263648", "1", "1000", "58", "1", "190.83", "129"),("263650", "1", "1000", "58", "1", "199.09", "130"),("258047", "1", "1000", "58", "1", "4.05", "131"),("9092", "2", "1000", "58", "1", "39.59", "132"),("9101", "2", "1000", "58", "1", "18.1", "133"),("150393", "2", "1000", "58", "1", "45.37", "134"),("150395", "2", "1000", "58", "1", "51.98", "135"),("9121", "2", "1000", "58", "1", "9.83", "136"),("258267", "2", "1000", "58", "1", "290", "137"),("258272", "1", "1000", "58", "1", "182.56", "138"),("150211", "2", "1006", "58", "1", "266.86", "139"),("249228", "2", "1002", "58", "1", "13.14", "140"),("222635", "1", "1001", "58", "1", "523.06", "141"),("150487", "2", "1000", "58", "1", "73.47", "142"),("150775", "2", "1000", "58", "1", "107.36", "143"),("252339", "1", "1000", "58", "1", "112.31", "144"),("252340", "1", "1000", "58", "1", "120.58", "145"),("252341", "1", "1000", "58", "1", "128.84", "146"),("249227", "2", "1000", "58", "1", "13.14", "147"),("249229", "2", "1000", "58", "1", "13.14", "148"),("249230", "2", "1000", "58", "1", "13.14", "149"),("249231", "2", "1000", "58", "1", "13.14", "150"),("249232", "2", "1000", "58", "1", "13.14", "151"),("249235", "2", "1000", "58", "1", "12.31", "152"),("249236", "2", "1000", "58", "1", "12.31", "153"),("249237", "2", "1000", "58", "1", "12.31", "154"),("249238", "2", "1000", "58", "1", "12.31", "155"),("222634", "1", "1000", "58", "1", "497.44", "156"),("222639", "1", "1000", "58", "1", "547.85", "157"),("258264", "2", "1000", "58", "1", "265.21", "158"),("269641", "1", "1000", "58", "1", "116.45", "159"),("269642", "1", "1000", "58", "1", "149.5", "160"),("269643", "1", "1000", "58", "1", "190.83", "161"),("150483", "2", "2", "58", "1", "56.94", "162"),("263638", "1", "1000", "58", "1", "47.85", "163"),("263640", "1", "1000", "58", "1", "58.6", "164"),("263641", "1", "1000", "58", "1", "70.99", "165"),("258046", "1", "1000", "58", "1", "5.7", "166"),("261944", "2", "1000", "58", "1", "61.9", "167"),("269699", "1", "1000", "58", "1", "1777.6", "168"),("269700", "1", "1000", "58", "1", "1447.02", "169"),("270263", "2", "1000", "58", "1", "57.77", "170"),("270270", "2", "1000", "58", "1", "57.77", "171"),("270271", "2", "1000", "58", "1", "57.77", "172"),("270272", "2", "1000", "58", "1", "57.77", "173"),("270202", "1", "1000", "58", "1", "82.56", "174"),("270204", "1", "1000", "58", "1", "87.52", "175"),("270205", "1", "1000", "58", "1", "91.65", "176"),("270206", "1", "1000", "58", "1", "99.92", "177"),("270207", "1", "1000", "58", "1", "107.36", "178"),("258024", "1", "1000", "58", "1", "4.05", "179"),("258042", "2", "1000", "58", "1", "7.36", "180"),("258043", "2", "1000", "58", "1", "7.36", "181"),("258044", "2", "1000", "58", "1", "4.88", "182"),("258045", "2", "1000", "58", "1", "4.88", "183"),("269674", "1", "1000", "58", "1", "190.83", "184"),("269675", "1", "1000", "58", "1", "240.41", "185"),("270337", "2", "1000", "58", "1", "37.93", "186"),("270343", "2", "1000", "58", "1", "37.93", "187"),("270344", "2", "1000", "58", "1", "37.93", "188"),("270345", "2", "1000", "58", "1", "37.93", "189"),("270346", "2", "1000", "58", "1", "37.93", "190"),("270348", "2", "1000", "58", "1", "37.93", "191"),("150479", "2", "1001", "58", "1", "169.34", "192"),("252348", "1", "1001", "58", "1", "157.77", "193"),("269659", "1", "1001", "58", "1", "120.58", "194"),("269661", "1", "1001", "58", "1", "132.98", "195"),("269664", "1", "1001", "58", "1", "145.37", "196"),("219889", "2", "1000", "58", "1", "168.51", "197"),("252349", "1", "1000", "58", "1", "165.21", "198"),("252350", "1", "1000", "58", "1", "174.3", "199"),("236549", "1", "1000", "58", "1", "489.17", "200"),("236552", "1", "1000", "58", "1", "497.44", "201"),("236553", "1", "1000", "58", "1", "514.79", "202"),("269702", "2", "1000", "58", "1", "70.99", "203"),("168250", "1", "1", "58", "1", "430.5", "204"),("258266", "2", "1000", "58", "1", "298.26", "205"),("117880", "2", "1", "58", "1", "204.05", "206"),("82258", "2", "1004", "58", "1", "14.79", "207"),("9053", "2", "1003", "58", "1", "30.5", "208"),("48112", "2", "1002", "58", "1", "29.67", "209"),("36137", "2", "1002", "58", "1", "47.02", "210"),("107917", "1", "1001", "58", "1", "51.98", "211"),("108442", "1", "1001", "58", "1", "40.41", "212"),("117888", "2", "1001", "58", "1", "42.89", "213"),("9063", "2", "1000", "58", "1", "32.77", "214"),("117911", "2", "1000", "58", "1", "59.42", "215"),("117912", "2", "1000", "58", "1", "59.42", "216"),("117913", "2", "1000", "58", "1", "59.42", "217"),("117910", "2", "1", "58", "1", "59.42", "218"),("263651", "1", "1000", "58", "1", "397.44", "219"),("263654", "1", "1000", "58", "1", "413.14", "220"),("263655", "1", "1000", "58", "1", "438.76", "221"),("263656", "1", "1000", "58", "1", "455.29", "222"),("269670", "2", "1000", "58", "1", "81.74", "223"),("269671", "2", "1000", "58", "1", "82.56", "224"),("244582", "1", "1000", "58", "1", "106.53", "225"),("236557", "1", "1000", "58", "1", "262.73", "226"),("236561", "1", "1000", "58", "1", "270.99", "227"),("269645", "2", "1000", "58", "1", "57.77", "228"),("269651", "2", "1000", "58", "1", "66.03", "229"),("269652", "2", "1000", "58", "1", "74.3", "230"),("269703", "2", "1000", "58", "1", "82.56", "231"),("150391", "2", "1005", "58", "1", "190.83", "232"),("95604", "2", "1001", "58", "1", "228.84", "233"),("150387", "2", "1001", "58", "1", "270.99", "234"),("150347", "1", "1000", "58", "1", "324.71", "235"),("150363", "1", "1000", "58", "1", "115.62", "236"),("150385", "2", "1000", "58", "1", "182.56", "237"),("150389", "2", "1000", "58", "1", "131.32", "238"),("270375", "1", "1000", "58", "1", "11.49", "239"),("152585", "2", "1", "58", "1", "670.17", "240"),("263636", "1", "1000", "58", "1", "372.64", "241"),("263637", "1", "1000", "58", "1", "430.5", "242"),("250906", "1", "1000", "58", "1", "75.12", "243"),("250907", "1", "1000", "58", "1", "80.08", "244"),("250908", "1", "1000", "58", "1", "81.74", "245"),("117903", "2", "1001", "58", "1", "94.13", "246"),("150611", "2", "1001", "58", "1", "42.89", "247"),("11384", "2", "1000", "58", "1", "9.01", "248"),("117874", "2", "1000", "58", "1", "185.87", "249"),("117877", "2", "1000", "58", "1", "190.83", "250"),("117879", "2", "1000", "58", "1", "190.83", "251"),("117902", "2", "1000", "58", "1", "94.13", "252"),("117905", "2", "1000", "58", "1", "94.13", "253"),("117906", "2", "1000", "58", "1", "94.13", "254"),("117907", "2", "1000", "58", "1", "94.13", "255"),("146349", "2", "1000", "58", "1", "21.4", "256"),("177688", "2", "1000", "58", "1", "48.68", "257"),("9042", "2", "5", "58", "1", "9.83", "258"),("5516", "2", "1", "58", "1", "70.99", "259"),("82280", "2", "1", "58", "1", "31.32", "260"),("177692", "2", "1", "58", "1", "48.68", "261"),("252027", "1", "1005", "58", "1", "218.93", "262"),("252026", "1", "1002", "58", "1", "227.19", "263"),("252029", "1", "1000", "58", "1", "235.45", "264"),("237074", "1", "1000", "58", "1", "178.43", "265"),("237075", "1", "1000", "58", "1", "186.69", "266"),("237077", "1", "1000", "58", "1", "194.96", "267"),("269796", "1", "1000", "58", "1", "40.41", "268"),("269802", "1", "1000", "58", "1", "40.41", "269"),("95150", "2", "1001", "58", "1", "447.02", "270"),("66635", "2", "1001", "58", "1", "190", "271"),("150217", "2", "1001", "58", "1", "168.51", "272"),("184867", "1", "1000", "58", "1", "104.88", "273"),("8921", "2", "5", "58", "1", "13.14", "274"),("48144", "2", "1010", "58", "1", "13.97", "275"),("48151", "2", "1009", "58", "1", "14.79", "276"),("48150", "2", "1006", "58", "1", "13.97", "277"),("48145", "2", "1005", "58", "1", "13.97", "278"),("131857", "2", "1000", "58", "1", "186.69", "279"),("94148", "2", "1009", "58", "1", "13.14", "280"),("94156", "2", "1004", "58", "1", "13.14", "281"),("81373", "2", "1004", "58", "1", "14.79", "282"),("66886", "2", "1003", "58", "1", "274.3", "283"),("95603", "2", "1002", "58", "1", "224.71", "284"),("150605", "2", "1002", "58", "1", "11.49", "285"),("150609", "2", "1002", "58", "1", "18.1", "286"),("117883", "2", "1001", "58", "1", "190.83", "287"),("150607", "2", "1001", "58", "1", "14.79", "288"),("152581", "1", "1001", "58", "1", "118.1", "289"),("9043", "2", "1000", "58", "1", "13.97", "290"),("95602", "2", "1000", "58", "1", "177.13", "291"),("107981", "1", "1000", "58", "1", "34.63", "292"),("108440", "1", "1000", "58", "1", "573.47", "293"),("66765", "2", "1000", "58", "1", "632.15", "294"),("66885", "2", "1000", "58", "1", "266.86", "295"),("66891", "2", "1000", "58", "1", "178.43", "296"),("124557", "1", "1000", "58", "1", "355.29", "297"),("124559", "1", "1000", "58", "1", "380.08", "298"),("124563", "1", "1000", "58", "1", "371.82", "299"),("124565", "1", "1000", "58", "1", "384.21", "300"),("124569", "1", "1000", "58", "1", "405.7", "301"),("124573", "1", "1000", "58", "1", "388.35", "302"),("73276", "2", "1000", "58", "1", "9.83", "303"),("73278", "2", "1000", "58", "1", "11.49", "304"),("73279", "2", "1000", "58", "1", "11.49", "305"),("82259", "2", "1000", "58", "1", "9.83", "306"),("82262", "2", "1000", "58", "1", "9.01", "307"),("82264", "2", "1000", "58", "1", "9.01", "308"),("82265", "2", "1000", "58", "1", "9.83", "309"),("82266", "2", "1000", "58", "1", "9.83", "310"),("82267", "2", "1000", "58", "1", "9.83", "311"),("82269", "2", "1000", "58", "1", "9.01", "312"),("198439", "2", "1000", "58", "1", "144.55", "313"),("182509", "2", "1000", "58", "1", "295.79", "314"),("150257", "2", "1000", "58", "1", "59.42", "315"),("150529", "1", "1000", "58", "1", "31.32", "316"),("150591", "2", "1000", "58", "1", "47.85", "317"),("228784", "2", "1000", "58", "1", "237.11", "318"),("222861", "2", "1000", "58", "1", "1766.86", "319"),("224602", "1", "1000", "58", "1", "9.83", "320"),("224603", "1", "1000", "58", "1", "9.83", "321"),("224604", "1", "1000", "58", "1", "9.83", "322"),("66887", "2", "3", "58", "1", "294.96", "323"),("124561", "1", "2", "58", "1", "387.52", "324"),("12683", "2", "1", "58", "1", "9", "325"),("96164", "2", "1", "58", "1", "256.94", "326"),("96165", "2", "1", "58", "1", "256.94", "327"),("66982", "2", "1", "58", "1", "405.7", "328"),("150227", "2", "1", "58", "1", "313.14", "329"),("95148", "2", "1000", "58", "1", "493.31", "330"),("95146", "2", "1", "58", "1", "310.66", "331"),("168253", "1", "1", "58", "1", "355.29", "332"),("48170", "2", "1011", "58", "1", "13.97", "333"),("48171", "2", "1010", "58", "1", "13.97", "334"),("48169", "2", "1004", "58", "1", "13.97", "335"),("182589", "1", "1000", "58", "1", "313.14", "336"),("117929", "2", "1013", "58", "1", "10.66", "337"),("117927", "2", "1008", "58", "1", "10.66", "338"),("107354", "1", "1007", "58", "1", "4.88", "339"),("117925", "2", "1006", "58", "1", "9.01", "340"),("117928", "2", "1006", "58", "1", "10.66", "341"),("59438", "2", "1006", "58", "1", "33.8", "342"),("107355", "1", "1005", "58", "1", "4.88", "343"),("117926", "2", "1005", "58", "1", "8.18", "344"),("94147", "2", "1005", "58", "1", "13.14", "345"),("9051", "2", "1004", "58", "1", "11.49", "346"),("107353", "1", "1004", "58", "1", "4.88", "347"),("107929", "1", "1004", "58", "1", "7.36", "348"),("8942", "2", "1003", "58", "1", "58.6", "349"),("107357", "1", "1003", "58", "1", "4.88", "350"),("107931", "1", "1003", "58", "1", "5.7", "351"),("117924", "2", "1003", "58", "1", "9.01", "352"),("107356", "1", "1002", "58", "1", "4.88", "353"),("146815", "1", "1002", "58", "1", "31.32", "354"),("242464", "2", "1002", "58", "1", "14.79", "355"),("117889", "2", "1001", "58", "1", "65.21", "356"),("181003", "2", "1001", "58", "1", "107.36", "357"),("181005", "2", "1001", "58", "1", "152.81", "358"),("8943", "2", "1000", "58", "1", "72.26", "359"),("46032", "2", "1000", "58", "1", "28.84", "360"),("48233", "2", "1000", "58", "1", "103.22", "361"),("96162", "2", "1000", "58", "1", "111.49", "362"),("107358", "1", "1000", "58", "1", "4.88", "363"),("107930", "1", "1000", "58", "1", "5.7", "364"),("108433", "1", "1000", "58", "1", "42.89", "365"),("66634", "2", "1000", "58", "1", "182.56", "366"),("66637", "2", "1000", "58", "1", "198.26", "367"),("66894", "2", "1000", "58", "1", "161.07", "368"),("93766", "2", "1000", "58", "1", "12.31", "369"),("94163", "2", "1000", "58", "1", "15.62", "370"),("94167", "2", "1000", "58", "1", "15.62", "371"),("94175", "2", "1000", "58", "1", "13.14", "372"),("72739", "2", "1000", "58", "1", "47.85", "373"),("183837", "1", "1000", "58", "1", "9.83", "374"),("178924", "2", "1000", "58", "1", "148.68", "375"),("150557", "1", "1000", "58", "1", "81.74", "376"),("150561", "1", "1000", "58", "1", "81.74", "377"),("150563", "1", "1000", "58", "1", "81.74", "378"),("150587", "2", "1000", "58", "1", "33.8", "379"),("152605", "2", "1000", "58", "1", "140.41", "380"),("237071", "1", "1000", "58", "1", "220.58", "381"),("237072", "1", "1000", "58", "1", "224.71", "382"),("237073", "1", "1000", "58", "1", "228.84", "383"),("94169", "2", "8", "58", "1", "8.18", "384"),("94173", "2", "7", "58", "1", "10.66", "385"),("94172", "2", "3", "58", "1", "13.97", "386"),("82274", "2", "1", "58", "1", "26.36", "387"),("150585", "2", "1", "58", "1", "26.36", "388"),("158185", "2", "1008", "58", "1", "14.79", "389"),("158187", "2", "1008", "58", "1", "14.79", "390"),("158189", "2", "1004", "58", "1", "14.79", "391"),("158191", "2", "1000", "58", "1", "15.62", "392"),("146853", "2", "1000", "58", "1", "151.98", "393"),("146855", "2", "1000", "58", "1", "166.03", "394"),("66997", "2", "1000", "58", "1", "12.31", "395"),("105088", "2", "1025", "58", "1", "11.49", "396"),("107380", "1", "1023", "58", "1", "6.53", "397"),("107918", "1", "1016", "58", "1", "6.53", "398"),("107919", "1", "1011", "58", "1", "6.53", "399"),("107920", "1", "1009", "58", "1", "6.53", "400"),("107379", "1", "1008", "58", "1", "6.53", "401"),("107375", "1", "1006", "58", "1", "8.18", "402"),("107346", "1", "1005", "58", "1", "26.36", "403"),("94180", "2", "1005", "58", "1", "9.83", "404"),("107376", "1", "1003", "58", "1", "7.36", "405"),("107932", "1", "1003", "58", "1", "7.36", "406"),("108312", "1", "1003", "58", "1", "20.58", "407"),("71642", "2", "1003", "58", "1", "17.27", "408"),("94181", "2", "1003", "58", "1", "9.83", "409"),("104621", "1", "1003", "58", "1", "15.62", "410"),("105091", "2", "1003", "58", "1", "10.66", "411"),("199711", "1", "1003", "58", "1", "274.3", "412"),("8967", "2", "1002", "58", "1", "20.58", "413"),("107359", "1", "1002", "58", "1", "9.83", "414"),("107377", "1", "1002", "58", "1", "6.53", "415"),("108305", "1", "1002", "58", "1", "18.93", "416"),("108343", "1", "1002", "58", "1", "19.75", "417"),("71641", "2", "1002", "58", "1", "14.79", "418"),("105092", "2", "1002", "58", "1", "10.66", "419"),("180951", "1", "1002", "58", "1", "383.39", "420"),("180955", "1", "1002", "58", "1", "395.79", "421"),("150601", "2", "1002", "58", "1", "26.36", "422"),("107347", "1", "1001", "58", "1", "32.15", "423"),("107381", "1", "1001", "58", "1", "6.53", "424"),("108306", "1", "1001", "58", "1", "20.58", "425"),("108315", "1", "1001", "58", "1", "23.06", "426"),("108428", "1", "1001", "58", "1", "212.31", "427"),("71645", "2", "1001", "58", "1", "17.27", "428"),("105093", "2", "1001", "58", "1", "10.66", "429"),("105096", "2", "1001", "58", "1", "9.83", "430"),("72660", "2", "1001", "58", "1", "60.25", "431"),("72775", "2", "1001", "58", "1", "32.98", "432"),("146821", "1", "1001", "58", "1", "56.94", "433"),("150603", "2", "1001", "58", "1", "26.36", "434"),("166492", "1", "1001", "58", "1", "107.36", "435"),("237538", "1", "1001", "58", "1", "161.07", "436"),("5627", "2", "1000", "58", "1", "210.08", "437"),("8918", "2", "1000", "58", "1", "14.79", "438"),("8919", "2", "1000", "58", "1", "14.79", "439"),("46260", "2", "1000", "58", "1", "28.84", "440"),("36138", "2", "1000", "58", "1", "110.66", "441"),("107345", "1", "1000", "58", "1", "17.27", "442"),("107378", "1", "1000", "58", "1", "6.53", "443"),("107935", "1", "1000", "58", "1", "15.62", "444"),("108001", "1", "1000", "58", "1", "18.1", "445"),("108002", "1", "1000", "58", "1", "18.93", "446"),("108165", "1", "1000", "58", "1", "9.83", "447"),("108302", "1", "1000", "58", "1", "20.58", "448"),("108303", "1", "1000", "58", "1", "18.93", "449"),("108304", "1", "1000", "58", "1", "18.93", "450"),("108307", "1", "1000", "58", "1", "22.23", "451"),("108309", "1", "1000", "58", "1", "28.84", "452"),("108313", "1", "1000", "58", "1", "23.88", "453"),("108314", "1", "1000", "58", "1", "23.06", "454"),("108341", "1", "1000", "58", "1", "18.93", "455"),("108342", "1", "1000", "58", "1", "18.93", "456"),("108352", "1", "1000", "58", "1", "28.02", "457"),("108353", "1", "1000", "58", "1", "31.32", "458"),("119570", "2", "1000", "58", "1", "14.79", "459"),("117890", "1", "1000", "58", "1", "216.45", "460"),("117892", "1", "1000", "58", "1", "216.45", "461"),("117893", "1", "1000", "58", "1", "216.45", "462"),("117894", "1", "1000", "58", "1", "216.45", "463"),("71622", "2", "1000", "58", "1", "17.27", "464"),("71624", "2", "1000", "58", "1", "15.62", "465"),("71625", "2", "1000", "58", "1", "15.62", "466"),("71627", "2", "1000", "58", "1", "15.62", "467"),("71628", "2", "1000", "58", "1", "15.62", "468"),("71629", "2", "1000", "58", "1", "15.62", "469"),("71630", "2", "1000", "58", "1", "15.62", "470"),("71631", "2", "1000", "58", "1", "15.62", "471"),("71632", "2", "1000", "58", "1", "14.79", "472"),("71633", "2", "1000", "58", "1", "15.62", "473"),("71634", "2", "1000", "58", "1", "14.79", "474"),("71635", "2", "1000", "58", "1", "14.79", "475"),("71636", "2", "1000", "58", "1", "14.79", "476"),("71637", "2", "1000", "58", "1", "14.79", "477"),("71640", "2", "1000", "58", "1", "17.27", "478"),("71643", "2", "1000", "58", "1", "17.27", "479"),("71644", "2", "1000", "58", "1", "17.27", "480"),("71649", "2", "1000", "58", "1", "14.79", "481"),("71655", "2", "1000", "58", "1", "14.79", "482"),("71657", "2", "1000", "58", "1", "14.79", "483"),("71660", "2", "1000", "58", "1", "17.27", "484"),("71661", "2", "1000", "58", "1", "17.27", "485"),("94176", "2", "1000", "58", "1", "13.14", "486"),("94177", "2", "1000", "58", "1", "12.31", "487"),("94178", "2", "1000", "58", "1", "12.31", "488"),("104623", "1", "1000", "58", "1", "15.62", "489"),("104624", "1", "1000", "58", "1", "15.62", "490"),("104625", "1", "1000", "58", "1", "15.62", "491"),("105070", "2", "1000", "58", "1", "9.83", "492"),("105073", "2", "1000", "58", "1", "9.83", "493"),("105075", "2", "1000", "58", "1", "9.83", "494"),("105081", "2", "1000", "58", "1", "15.62", "495"),("105085", "2", "1000", "58", "1", "14.79", "496"),("105087", "2", "1000", "58", "1", "13.14", "497"),("105089", "2", "1000", "58", "1", "11.49", "498"),("105095", "2", "1000", "58", "1", "9.83", "499"),("72658", "2", "1000", "58", "1", "60.25", "500")

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 *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '250898' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'

SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '250898' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '250898' AND a.attribute_group_id = '16' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

SELECT *
FROM oc_product_image
WHERE product_id = '250898'
ORDER BY sort_order ASC

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%GIVADI COM SRL%' AND language_id = '2'

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%GIVADI COM SRL%' AND language_id = '2'

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%GIVADI COM SRL%' AND language_id = '2'

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%GIVADI COM SRL%' AND language_id = '2'

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%GIVADI COM SRL%' AND language_id = '2'

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%GIVADI COM SRL%' AND language_id = '2'

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%GIVADI COM SRL%' AND language_id = '2'

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%GIVADI COM SRL%' AND language_id = '2'

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%GIVADI COM SRL%' AND language_id = '2'

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%GIVADI COM SRL%' AND language_id = '2'

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%GIVADI COM SRL%' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=250898'

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%GIVADI COM SRL%' 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 = '0' AND name = 'lichidare_stoc'