SELECT * FROM market_language
0.00037908554077148

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

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

        SELECT COUNT(*) AS cnt 
        FROM market_index i 
        JOIN market_ad a ON a.id = i.ad_id 
        WHERE i.model_id = 10552 AND i.category_id = 0 AND i.top_category_id = 0 AND i.manufacturer_id = 0 AND i.country_id = 'FR'
    
0.21459007263184

        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.model_id = 10552 AND i.category_id = 0 AND i.top_category_id = 0 AND i.manufacturer_id = 0 AND i.country_id = 'FR'
        ORDER BY b.views ASC
     LIMIT 0, 32
1.1229650974274

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

        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 =971328  AND mu.manufacturer_id =982836  AND mu.model_id =10552  AND mu.country_id ='FR'  AND mu.top_category_id = 970001;
    
0.016577959060669

        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 =971328  AND mu.manufacturer_id =982836  AND mu.model_id =10552  AND mu.country_id = mc.id AND mu.top_category_id = 970001 
        ORDER BY `name` ASC;
    
0.0012478828430176

        SELECT mu.url 
        FROM market_url mu
        WHERE mu.language_id = :language_id AND mu.category_id =971328  AND mu.manufacturer_id =982836  AND mu.model_id =10552  AND mu.country_id IS NULL  AND mu.top_category_id = 970001;
    
0.00037002563476562

        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 =971328  AND mu.manufacturer_id = sm.id AND mu.model_id =10552  AND mu.country_id ='FR'  AND mu.top_category_id = 970001
        ORDER BY cnt DESC
        LIMIT 4;
    
0.0008540153503418

        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 =971328  AND mu.manufacturer_id = sm.id AND mu.model_id =10552  AND mu.country_id ='FR'  AND mu.top_category_id = 970001
        ORDER BY sm.`name` ASC;
    
0.00072097778320312

        SELECT mu.url 
        FROM market_url mu
        WHERE mu.language_id = :language_id AND mu.category_id =971328  AND mu.manufacturer_id IS NULL  AND mu.model_id =10552  AND mu.country_id ='FR'  AND mu.top_category_id = 970001;
    
0.0003049373626709

        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 =971328  AND mu.manufacturer_id =982836  AND mu.model_id = sm.id AND mu.country_id ='FR'  AND mu.top_category_id = 970001
        GROUP BY name
        ORDER BY cnt DESC
        LIMIT 5;
    
0.0013160705566406

        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 =971328  AND mu.manufacturer_id =982836  AND mu.model_id = sm.id AND mu.country_id ='FR'  AND mu.top_category_id = 970001
        GROUP BY name
        ORDER BY sm.`name` ASC;
    
0.0010581016540527

        SELECT mu.url 
        FROM market_url mu
        WHERE mu.language_id = :language_id AND mu.category_id =971328  AND mu.manufacturer_id =982836  AND mu.model_id IS NULL  AND mu.country_id ='FR'  AND mu.top_category_id = 970001;
    
0.00040793418884277

        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 =982836  AND mu.model_id =10552  AND mu.country_id ='FR'  AND mu.top_category_id = 970001
        WHERE scu.`name` > ''
        ORDER BY mu.cnt DESC
        LIMIT 5;
    
0.0017280578613281

        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 =982836  AND mu.model_id =10552  AND mu.country_id ='FR'  AND mu.top_category_id = 970001
        WHERE scu.`name` > ''
        ORDER BY scu.`name` ASC;
    
0.00307297706604

        SELECT mu.url 
        FROM market_url mu
        WHERE mu.language_id = :language_id AND mu.category_id IS NULL  AND mu.manufacturer_id =982836  AND mu.model_id =10552  AND mu.country_id ='FR'  AND mu.top_category_id = 970001;
    
0.00032520294189453

        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.model_id = 10552 AND i.category_id = 0 AND i.top_category_id = 0 AND i.manufacturer_id = 0 AND i.country_id = 'FR'
    
0.00085711479187012

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

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

        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.model_id = 10552 AND i.category_id = 0 AND i.top_category_id = 0 AND i.manufacturer_id = 0 AND i.country_id = 'FR'
        GROUP BY a.dealer_id
        ORDER BY dealer_name ASC
    
0.00076603889465332

Buy used 580SK Case Backhoe Loaders in France | LECTURA market

Market

LECTURA market Construction machinery Used 580SK Case Backhoe Loaders for sale in France

Used 580SK Case Backhoe Loaders for sale in France

There are currently 1 used 580SK Case machines Backhoe Loaders in France for sale. See offers from TradeMachines. The average price of used 580SK Case machines Backhoe Loaders in France is 20.000 €

Filter   
  • Engine power (kW)

  • to
  • Year of manufacture

  • to
  • Price (€)

  • to

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