SELECT * FROM market_language
0.00094389915466309

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

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

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

        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 = 12
        JOIN market_dealer d ON d.id = a.dealer_id
        WHERE i.category_id = 971329 AND i.model_id = 0 AND i.top_category_id = 0 AND i.manufacturer_id = 982838
        ORDER BY b.views ASC
     LIMIT 0, 32
1.0665109157562

        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.0009620189666748

        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 =971329  AND mu.manufacturer_id =982838  AND mu.model_id IS NULL  AND mu.country_id IS NULL  AND mu.top_category_id = 970001;
    
0.00081682205200195

        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 =971329  AND mu.manufacturer_id =982838  AND mu.model_id IS NULL  AND mu.country_id = mc.id AND mu.top_category_id = 970001 
        ORDER BY `name` ASC;
    
0.00094890594482422

        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 =971329  AND mu.manufacturer_id = sm.id AND mu.model_id IS NULL  AND mu.country_id IS NULL  AND mu.top_category_id = 970001
        ORDER BY cnt DESC
        LIMIT 4;
    
0.00076794624328613

        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 =971329  AND mu.manufacturer_id = sm.id AND mu.model_id IS NULL  AND mu.country_id IS NULL  AND mu.top_category_id = 970001
        ORDER BY sm.`name` ASC;
    
0.0005340576171875

        SELECT mu.url 
        FROM market_url mu
        WHERE mu.language_id = :language_id AND mu.category_id =971329  AND mu.manufacturer_id IS NULL  AND mu.model_id IS NULL  AND mu.country_id IS NULL  AND mu.top_category_id = 970001;
    
0.00032877922058105

        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 =971329  AND mu.manufacturer_id =982838  AND mu.model_id = sm.id AND mu.country_id IS NULL  AND mu.top_category_id = 970001
        GROUP BY name
        ORDER BY cnt DESC
        LIMIT 5;
    
0.0016698837280273

        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 =971329  AND mu.manufacturer_id =982838  AND mu.model_id = sm.id AND mu.country_id IS NULL  AND mu.top_category_id = 970001
        GROUP BY name
        ORDER BY sm.`name` ASC;
    
0.0010700225830078

        SELECT mu.url 
        FROM market_url mu
        WHERE mu.language_id = :language_id AND mu.category_id =971329  AND mu.manufacturer_id =982838  AND mu.model_id IS NULL  AND mu.country_id IS NULL  AND mu.top_category_id = 970001;
    
0.00038790702819824

        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 =982838  AND mu.model_id IS NULL  AND mu.country_id IS NULL  AND mu.top_category_id = 970001
        WHERE scu.`name` > ''
        ORDER BY mu.cnt DESC
        LIMIT 5;
    
0.0020458698272705

        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 =982838  AND mu.model_id IS NULL  AND mu.country_id IS NULL  AND mu.top_category_id = 970001
        WHERE scu.`name` > ''
        ORDER BY scu.`name` ASC;
    
0.0034000873565674

        SELECT mu.url 
        FROM market_url mu
        WHERE mu.language_id = :language_id AND mu.category_id IS NULL  AND mu.manufacturer_id =982838  AND mu.model_id IS NULL  AND mu.country_id IS NULL  AND mu.top_category_id = 970001;
    
0.00034999847412109

        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 = 971329 AND i.model_id = 0 AND i.top_category_id = 0 AND i.manufacturer_id = 982838
    
0.0087118148803711

        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.00086116790771484

        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.00072503089904785

        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 = 971329 AND i.model_id = 0 AND i.top_category_id = 0 AND i.manufacturer_id = 982838
        GROUP BY a.dealer_id
        ORDER BY dealer_name ASC
    
0.0089550018310547

Buy used Caterpillar Graders | LECTURA market

Market

LECTURA market Construction machinery Used Caterpillar Graders for sale

Used Caterpillar Graders for sale

There are currently 56 used Caterpillar machines Graders for sale. See offers from TradeMachines. The average price of used Caterpillar machines Graders is 73.795 €

Filter   
  • Engine power (kW)

  • to
  • Year of manufacture

  • to
  • Price (€)

  • to
Prev Next

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