Processors bitcoin performance rating

We rated the CPUs based on their Bitcoin mining performance. CPUs of all vendors and markets (desktop, notebook, server) participate. CPUs with unknown Bitcoin mining speed are not present in the rating.

Ошибка: Запрос 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
        )

)
Swipe the table to the right to see full info
# CPU Type Socket Mh/s Cores/threads Year Price Power consumption

Advices and comments