Рейтинг производительности процессоров в bitcoin

Мы составили рейтинг процессоров по их производительности в майнинге Bitcoin. Учитываются процессоры всех производителей и для всех рынков (десктопные, ноутбучные и серверные). Процессоры, для которых скорость майнинга Bitcoin неизвестна, в рейтинге не участвуют.

Ошибка: Запрос select i._id, i._number, i.title, if(isnull(custom.type) or custom.type="", i.type, custom.type) as type, if(isnull(custom.date_of_announcement) or year(custom.date_of_announcement)=0, year(i.date_of_announcement), year(custom.date_of_announcement)) as year, if(isnull(custom.date_of_announcement) or year(custom.date_of_announcement)=0, i.date_of_announcement, custom.date_of_announcement) as date, i.date_of_announcement_raw as date_raw, if(isnull(custom.prof) or !custom.prof, i.prof, custom.prof) as prof, if(isnull(custom.price) or custom.price="", i.price_current, custom.price) as price, if(isnull(custom.power_consumption) or custom.power_consumption="", if(isnull(pow_value.value), i.power_consumption, pow_value.value), custom.power_consumption) as power_consumption, i.codename as architecture, i.filename, if(isnull(mining_custom.result) OR mining_custom.result=0, if(isnull(n_value.value), b.result, n_value.value), mining_custom.result) as benchmarks, if(isnull(custom.cores) or custom.cores="", i.cores, custom.cores) as cores_threads, if(isnull(custom.Socket) or custom.Socket="", i.Socket, custom.Socket) as socket from ss_cpu as i left join ss_cpu_custom as custom on custom.filename=i.filename and custom._disabled=0 left join ss_compubench_bitcoin as b on b.id=replace(i.title," (Desktop)","") left join ss_nicehash as n_value on n_value.type="cpu" and n_value.name=replace(i.title," (Desktop)","") and n_value.field="Bitcoin" left join ss_nicehash as pr_value on pr_value.type="cpu" and pr_value.name=replace(i.title," (Desktop)","") and pr_value.field="price" left join ss_nicehash as pow_value on pow_value.type="cpu" and pow_value.name=replace(i.title," (Desktop)","") and pow_value.field="power" left join ss_cards_custom as custom on custom.filename=i.filename left join ss_video_mining_results_custom as mining_custom on mining_custom._master_id = custom._id and mining_id=6 where i._disabled=0 and if(isnull(mining_custom.result) OR mining_custom.result=0, if(isnull(n_value.value), b.result, n_value.value), mining_custom.result)>0 and i.redirect_to=0 order by 1*if(isnull(mining_custom.result) OR mining_custom.result=0, if(isnull(n_value.value), b.result, n_value.value), mining_custom.result) desc, i._number, i.title вызвал ошибку Not unique table/alias: 'custom'

Array
(
    [0] => Array
        (
            [file] => /var/www/web/data/www/technical.city/system/lib/db.php
            [line] => 89
            [function] => db_query
            [args] => Array
                (
                    [0] => select i._id, i._number, i.title,
	if(isnull(custom.type) or custom.type="", i.type, custom.type) as type,
	if(isnull(custom.date_of_announcement) or year(custom.date_of_announcement)=0, year(i.date_of_announcement), year(custom.date_of_announcement)) as year,
	if(isnull(custom.date_of_announcement) or year(custom.date_of_announcement)=0, i.date_of_announcement, custom.date_of_announcement) as date,
	i.date_of_announcement_raw as date_raw,
	if(isnull(custom.prof) or !custom.prof, i.prof, custom.prof) as prof,
	if(isnull(custom.price) or custom.price="", i.price_current, custom.price) as price,
	if(isnull(custom.power_consumption) or custom.power_consumption="", if(isnull(pow_value.value), i.power_consumption, pow_value.value), custom.power_consumption) as power_consumption,
	i.codename as architecture,
	i.filename,
	if(isnull(mining_custom.result) OR mining_custom.result=0, if(isnull(n_value.value), b.result, n_value.value), mining_custom.result) as benchmarks,
	if(isnull(custom.cores) or custom.cores="", i.cores, custom.cores) as cores_threads,
	if(isnull(custom.Socket) or custom.Socket="", i.Socket, custom.Socket) as socket
	from ss_cpu as i
	left join 
	ss_cpu_custom as custom on custom.filename=i.filename and custom._disabled=0
	left join
	ss_compubench_bitcoin as b
	on b.id=replace(i.title," (Desktop)","")
	left join
	ss_nicehash as n_value
	on n_value.type="cpu" and n_value.name=replace(i.title," (Desktop)","") and n_value.field="Bitcoin"

	left join
	ss_nicehash as pr_value
	on pr_value.type="cpu" and pr_value.name=replace(i.title," (Desktop)","") and pr_value.field="price"

	left join
	ss_nicehash as pow_value
	on pow_value.type="cpu" and pow_value.name=replace(i.title," (Desktop)","") and pow_value.field="power"
	
	left join
	ss_cards_custom as custom
	on custom.filename=i.filename	
	
	left join
	ss_video_mining_results_custom as mining_custom
	on mining_custom._master_id = custom._id and mining_id=6

	where i._disabled=0 and if(isnull(mining_custom.result) OR mining_custom.result=0, if(isnull(n_value.value), b.result, n_value.value), mining_custom.result)>0 and i.redirect_to=0
	order by 1*if(isnull(mining_custom.result) OR mining_custom.result=0, if(isnull(n_value.value), b.result, n_value.value), mining_custom.result) desc, i._number, i.title
                )

        )

    [1] => Array
        (
            [file] => /var/www/web/data/www/technical.city/_content/textblocks/text/68/68
            [line] => 356
            [function] => db_getAssocs
            [args] => Array
                (
                    [0] => select i._id, i._number, i.title,
	if(isnull(custom.type) or custom.type="", i.type, custom.type) as type,
	if(isnull(custom.date_of_announcement) or year(custom.date_of_announcement)=0, year(i.date_of_announcement), year(custom.date_of_announcement)) as year,
	if(isnull(custom.date_of_announcement) or year(custom.date_of_announcement)=0, i.date_of_announcement, custom.date_of_announcement) as date,
	i.date_of_announcement_raw as date_raw,
	if(isnull(custom.prof) or !custom.prof, i.prof, custom.prof) as prof,
	if(isnull(custom.price) or custom.price="", i.price_current, custom.price) as price,
	if(isnull(custom.power_consumption) or custom.power_consumption="", if(isnull(pow_value.value), i.power_consumption, pow_value.value), custom.power_consumption) as power_consumption,
	i.codename as architecture,
	i.filename,
	if(isnull(mining_custom.result) OR mining_custom.result=0, if(isnull(n_value.value), b.result, n_value.value), mining_custom.result) as benchmarks,
	if(isnull(custom.cores) or custom.cores="", i.cores, custom.cores) as cores_threads,
	if(isnull(custom.Socket) or custom.Socket="", i.Socket, custom.Socket) as socket
	from ss_cpu as i
	left join 
	ss_cpu_custom as custom on custom.filename=i.filename and custom._disabled=0
	left join
	ss_compubench_bitcoin as b
	on b.id=replace(i.title," (Desktop)","")
	left join
	ss_nicehash as n_value
	on n_value.type="cpu" and n_value.name=replace(i.title," (Desktop)","") and n_value.field="Bitcoin"

	left join
	ss_nicehash as pr_value
	on pr_value.type="cpu" and pr_value.name=replace(i.title," (Desktop)","") and pr_value.field="price"

	left join
	ss_nicehash as pow_value
	on pow_value.type="cpu" and pow_value.name=replace(i.title," (Desktop)","") and pow_value.field="power"
	
	left join
	ss_cards_custom as custom
	on custom.filename=i.filename	
	
	left join
	ss_video_mining_results_custom as mining_custom
	on mining_custom._master_id = custom._id and mining_id=6

	where i._disabled=0 and if(isnull(mining_custom.result) OR mining_custom.result=0, if(isnull(n_value.value), b.result, n_value.value), mining_custom.result)>0 and i.redirect_to=0
	order by 1*if(isnull(mining_custom.result) OR mining_custom.result=0, if(isnull(n_value.value), b.result, n_value.value), mining_custom.result) desc, i._number, i.title
                )

        )

    [2] => Array
        (
            [file] => /var/www/web/data/www/technical.city/_content/pages/text/35/335_1
            [line] => 4
            [args] => Array
                (
                    [0] => /var/www/web/data/www/technical.city/_content/textblocks/text/68/68
                )

            [function] => include
        )

    [3] => Array
        (
            [file] => /var/www/web/data/www/technical.city/system/handler/index.php
            [line] => 373
            [args] => Array
                (
                    [0] => /var/www/web/data/www/technical.city/_content/pages/text/35/335_1
                )

            [function] => require
        )

)
Прокрутите таблицу вправо, чтобы увидеть все данные
Процессор Тип Сокет Mh/s Ядра/потоки Год выпуска Цена Энергопотребление

Советы и комментарии