SELECT * FROM market_language
0.0003821849822998

SELECT * FROM market_url mu WHERE mu.url = :url
0.00053596496582031

        SELECT su.category_id AS id FROM specs_url su
        WHERE su.url = :url
    
0.00035595893859863

        SELECT COUNT(*) AS cnt 
        FROM market_index i 
        JOIN market_ad a ON a.id = i.ad_id 
        WHERE i.category_id = 0 AND i.model_id = 0 AND i.top_category_id = 971512 AND i.manufacturer_id = 985105
    
0.0010638236999512

        SELECT i.*, a.*, b.*, d.url AS dealer_url, d.logo_file AS dealer_logo
        FROM market_index i 
        JOIN market_ad a ON a.id = i.ad_id
        JOIN market_balance b FORCE INDEX (views) ON b.ad_id = a.id AND b.hour_id = 11
        JOIN market_dealer d ON d.id = a.dealer_id
        WHERE i.category_id = 0 AND i.model_id = 0 AND i.top_category_id = 971512 AND i.manufacturer_id = 985105
        ORDER BY b.views ASC
     LIMIT 0, 32
0.72832798957825

        SELECT IF(scu.`name` IS NOT NULL, scu.`name`, sp.phrase) as `name` FROM specs_category sc
        INNER JOIN specs_phrase sp ON sp.id = sc.phrase_id AND sp.language_id = :language_id
        LEFT JOIN specs_category_url scu ON scu.category_id = sc.id AND scu.language_id = :language_id
        WHERE sc.id = :category_id
    
0.00096702575683594

        SELECT mu.url, ml.id, ml.iso_code, ml.language_name as `name`, su.url as top_category_url
        FROM market_url mu
        INNER JOIN market_language ml ON ml.id = mu.language_id
        INNER JOIN specs_url su ON su.category_id = mu.top_category_id AND su.manufacturer_id IS NULL AND su.redirect_url IS NULL AND su.redirect_404 = 0 AND su.language_id =  mu.language_id
        WHERE mu.category_id IS NULL  AND mu.manufacturer_id =985105  AND mu.model_id IS NULL  AND mu.country_id IS NULL  AND mu.top_category_id = 971512;
    
0.0007169246673584

        SELECT
            mc.id, mu.url, sp.phrase AS `name`, mu.cnt
        FROM market_country mc
        INNER JOIN specs_phrase sp ON sp.id = mc.phrase_id AND sp.language_id=:language_id
        INNER JOIN market_url mu ON mu.language_id = :language_id AND mu.category_id IS NULL  AND mu.manufacturer_id =985105  AND mu.model_id IS NULL  AND mu.country_id = mc.id AND mu.top_category_id = 971512 
        ORDER BY `name` ASC;
    
0.00068306922912598

        SELECT 
            sm.id, mu.url, sm.`name`, mu.cnt
        FROM specs_manufacturer sm
        INNER JOIN market_url mu ON mu.language_id = :language_id AND mu.category_id IS NULL  AND mu.manufacturer_id = sm.id AND mu.model_id IS NULL  AND mu.country_id IS NULL  AND mu.top_category_id = 971512
        ORDER BY cnt DESC
        LIMIT 4;
    
0.00098204612731934

        SELECT 
            sm.id, mu.url, sm.`name`, mu.cnt
        FROM specs_manufacturer sm
        INNER JOIN market_url mu ON mu.language_id = :language_id AND mu.category_id IS NULL  AND mu.manufacturer_id = sm.id AND mu.model_id IS NULL  AND mu.country_id IS NULL  AND mu.top_category_id = 971512
        ORDER BY sm.`name` ASC;
    
0.0008389949798584

        SELECT mu.url 
        FROM market_url mu
        WHERE mu.language_id = :language_id AND mu.category_id IS NULL  AND mu.manufacturer_id IS NULL  AND mu.model_id IS NULL  AND mu.country_id IS NULL  AND mu.top_category_id = 971512;
    
0.0016520023345947

        SELECT 
            sm.id, mu.url, concat(sm.`name`, ' ', sma.`name`) as `name`, mu.cnt
        FROM specs_model sm
        INNER JOIN specs_manufacturer sma on sma.id = sm.manufacturer_id
        INNER JOIN market_url mu ON mu.language_id = :language_id AND mu.category_id IS NULL  AND mu.manufacturer_id =985105  AND mu.model_id = sm.id AND mu.country_id IS NULL  AND mu.top_category_id = 971512
        GROUP BY name
        ORDER BY cnt DESC
        LIMIT 5;
    
0.000640869140625

        SELECT 
            sm.id, mu.url, concat(sm.`name`, ' ', sma.`name`) as `name`, mu.cnt
        FROM specs_model sm
        INNER JOIN specs_manufacturer sma on sma.id = sm.manufacturer_id
        INNER JOIN market_url mu ON mu.language_id = :language_id AND mu.category_id IS NULL  AND mu.manufacturer_id =985105  AND mu.model_id = sm.id AND mu.country_id IS NULL  AND mu.top_category_id = 971512
        GROUP BY name
        ORDER BY sm.`name` ASC;
    
0.00060486793518066

        SELECT mu.url 
        FROM market_url mu
        WHERE mu.language_id = :language_id AND mu.category_id IS NULL  AND mu.manufacturer_id =985105  AND mu.model_id IS NULL  AND mu.country_id IS NULL  AND mu.top_category_id = 971512;
    
0.00031709671020508

        SELECT
            sc.id, mu.url, scu.`name` as `name`, mu.cnt
        FROM specs_category sc
        LEFT JOIN specs_category_url scu ON scu.category_id = sc.id AND scu.language_id=:language_id
        INNER JOIN market_url mu ON mu.language_id = :language_id AND mu.category_id = sc.id AND mu.manufacturer_id =985105  AND mu.model_id IS NULL  AND mu.country_id IS NULL  AND mu.top_category_id = 971512
        WHERE scu.`name` > ''
        ORDER BY mu.cnt DESC
        LIMIT 5;
    
0.0018908977508545

        SELECT
            sc.id, mu.url, scu.`name` as `name`, mu.cnt
        FROM specs_category sc
        LEFT JOIN specs_category_url scu ON scu.category_id = sc.id AND scu.language_id=:language_id
        INNER JOIN market_url mu ON mu.language_id = :language_id AND mu.category_id = sc.id AND mu.manufacturer_id =985105  AND mu.model_id IS NULL  AND mu.country_id IS NULL  AND mu.top_category_id = 971512
        WHERE scu.`name` > ''
        ORDER BY scu.`name` ASC;
    
0.0029630661010742

        SELECT
            MIN(a.price) AS min_price,
            MAX(a.price) AS max_price,
            AVG(a.price) AS avg_price,
            MIN(a.year_of_manufacture) AS min_year,
            MAX(a.year_of_manufacture) AS max_year,
            MIN(a.operating_hours) AS min_operating_hours,
            MAX(a.operating_hours) AS max_operating_hours,
            MIN(a.mileage) AS min_mileage,
            MAX(a.mileage) AS max_mileage,
            MIN(i.classon_min) AS min_classon,
            MAX(i.classon_max) AS max_classon
        FROM market_index i 
        JOIN market_ad a ON i.ad_id = a.id
        WHERE i.category_id = 0 AND i.model_id = 0 AND i.top_category_id = 971512 AND i.manufacturer_id = 985105
    
0.00074601173400879

        SELECT up.phrase AS unit, cp.phrase AS classon_name
        FROM specs_tech_data td
        JOIN specs_phrase up ON up.id = td.unit_phrase_id AND up.language_id = :language_id
        JOIN specs_phrase cp ON cp.id = td.phrase_id AND cp.language_id = :language_id
        WHERE td.category_id = :category_id
    
0.00062012672424316

        SELECT
        (
            SELECT IF(scu.`name` IS NOT NULL, scu.`name`, sp.phrase) as `name` FROM specs_category sc
            INNER JOIN specs_phrase sp ON sp.id = sc.phrase_id AND sp.language_id = :language_id
            LEFT JOIN specs_category_url scu ON scu.category_id = sc.id AND scu.language_id = :language_id
            WHERE sc.id = mu.category_id
        ) AS category_name,
        (
            SELECT sm.`name` FROM specs_manufacturer sm WHERE sm.id=mu.manufacturer_id
        ) AS manufacturer_name,
        (
            SELECT sm.`name` FROM specs_model sm WHERE sm.id=mu.model_id
        ) AS model_name,
        (
            SELECT sp.phrase FROM market_country mc
            INNER JOIN specs_phrase sp ON sp.id = mc.phrase_id AND sp.language_id = :language_id
            WHERE mc.id = mu.country_id
        ) AS country,
        mu.cnt,
	mu.robots
        FROM market_url mu
        WHERE mu.url = :url
    
0.00067782402038574

        SELECT d.id, d.name AS dealer_name 
        FROM market_index i
        JOIN market_ad a ON i.ad_id = a.id
        JOIN market_dealer d ON a.dealer_id = d.id
        WHERE i.category_id = 0 AND i.model_id = 0 AND i.top_category_id = 971512 AND i.manufacturer_id = 985105
        GROUP BY a.dealer_id
        ORDER BY dealer_name ASC
    
0.00077509880065918

Buy used Moffett-Kooi | LECTURA market

Market

LECTURA market Forklifts Used Moffett-Kooi for sale

Used Moffett-Kooi for sale

There are currently 1 used Moffett-Kooi machines for sale. See offers from TradeMachines. The average price of used Moffett-Kooi machines is 8.750 €

This site is using cookies to ensure a better experience for you. By using this website, you accept the usage of cookies. More info

I understand