SELECT * FROM market_language
0.00027298927307129

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

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

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

        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 = 10
        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
0.99340415000916

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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