SELECT * FROM market_language
0.00040984153747559

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

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

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

        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 = 18
        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.97370100021362

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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