Рейтинг видеокарт в майнинге Monero / XMR

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

Ошибка: Запрос 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.architecture, i.filename, if(isnull(mining_custom.result) OR mining_custom.result=0, n_value.value, mining_custom.result) as benchmarks from ss_cards as i left join ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0 left join ss_nicehash as n_value on n_value.type="video" and n_value.name=replace(i.title," (Desktop)","") and n_value.field="Monero" left join ss_nicehash as pr_value on pr_value.type="video" and pr_value.name=replace(i.title," (Desktop)","") and pr_value.field="price" left join ss_nicehash as pow_value on pow_value.type="video" 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=1 where i._disabled=0 and if(isnull(mining_custom.result) OR mining_custom.result=0, 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, 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.architecture,
	i.filename,
	if(isnull(mining_custom.result) OR mining_custom.result=0, n_value.value, mining_custom.result) as benchmarks
	from ss_cards as i
	left join 
	ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
	left join
	ss_nicehash as n_value
	on n_value.type="video" and n_value.name=replace(i.title," (Desktop)","") and n_value.field="Monero"
	left join
	ss_nicehash as pr_value
	on pr_value.type="video" and pr_value.name=replace(i.title," (Desktop)","") and pr_value.field="price"

	left join
	ss_nicehash as pow_value
	on pow_value.type="video" 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=1
	
	where i._disabled=0 and if(isnull(mining_custom.result) OR mining_custom.result=0, 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, 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] => 457
            [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.architecture,
	i.filename,
	if(isnull(mining_custom.result) OR mining_custom.result=0, n_value.value, mining_custom.result) as benchmarks
	from ss_cards as i
	left join 
	ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
	left join
	ss_nicehash as n_value
	on n_value.type="video" and n_value.name=replace(i.title," (Desktop)","") and n_value.field="Monero"
	left join
	ss_nicehash as pr_value
	on pr_value.type="video" and pr_value.name=replace(i.title," (Desktop)","") and pr_value.field="price"

	left join
	ss_nicehash as pow_value
	on pow_value.type="video" 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=1
	
	where i._disabled=0 and if(isnull(mining_custom.result) OR mining_custom.result=0, 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, n_value.value, mining_custom.result) desc, i._number, i.title
                )

        )

    [2] => Array
        (
            [file] => /var/www/web/data/www/technical.city/_content/pages/text/37/337_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/37/337_1
                )

            [function] => require
        )

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

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