SELECT * FROM market_language
0.00019693374633789

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

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

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

        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 = 971363 AND i.model_id = 0 AND i.top_category_id = 0 AND i.manufacturer_id = 0
        ORDER BY b.views ASC
     LIMIT 0, 32
0.99377512931824

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

        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 =971363  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.0137779712677

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

        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 =971363  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.00077009201049805

        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 =971363  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.00092005729675293

        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 =971363  AND mu.manufacturer_id IS NULL  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.00072407722473145

        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 =971363  AND mu.manufacturer_id IS NULL  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.00083208084106445

        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 IS NULL  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.0026710033416748

        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 IS NULL  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.0038609504699707

        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 = 970001;
    
0.0011160373687744

        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 = 971363 AND i.model_id = 0 AND i.top_category_id = 0 AND i.manufacturer_id = 0
    
0.0025699138641357

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

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

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

Buy used Combination Rollers | LECTURA market

Market

LECTURA market Construction machinery Used Combination Rollers for sale

Used Combination Rollers for sale

There are currently 15 used Combination Rollers for sale. See offers from TradeMachines. The average price of used Combination Rollers is 14.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