192.168.0.105 en 19:31 27 jul 2006

2006-07-27T19:31:24Z

Página nueva

= Consultas a la base =

== Ver hardware de incripto: ==
<pre><nowiki>
SELECT `rpd_first_name` , `rpd_last_name` , `rgo_caption`
FROM `xoops_myconference_reg_personal_data` , `xoops_myconference_reg_response_general_value` , `xoops_myconference_reg_response_general_options`
WHERE xoops_myconference_reg_personal_data.rpd_id = xoops_myconference_reg_response_general_value.rgv_rpd_id AND xoops_myconference_reg_response_general_value.rgv_rq_id
IN ( 8, 9, 10 ) AND xoops_myconference_reg_response_general_value.rgv_rgo_id = xoops_myconference_reg_response_general_options.rgo_id
ORDER BY xoops_myconference_reg_personal_data.rpd_id
</nowiki></pre>

=== Idem pero agrupado ===
<pre><nowiki>
SELECT `rgo_caption` , count( * )
FROM `xoops_myconference_reg_personal_data` , `xoops_myconference_reg_response_general_value` , `xoops_myconference_reg_response_general_options`
WHERE xoops_myconference_reg_personal_data.rpd_id = xoops_myconference_reg_response_general_value.rgv_rpd_id AND xoops_myconference_reg_response_general_value.rgv_rq_id
IN ( 8, 9, 10 ) AND xoops_myconference_reg_response_general_value.rgv_rgo_id = xoops_myconference_reg_response_general_options.rgo_id
GROUP BY rgo_caption
</nowiki></pre>

=== Ver comentarios por por inscripto: ===
<pre><nowiki>
SELECT CONCAT( rpd_first_name, ' ', rpd_last_name ) , rpd_email, rta_value
FROM xoops_myconference_reg_response_textarea, xoops_myconference_reg_personal_data, xoops_myconference_reg_questions
WHERE rpd_id = rta_rpd_id AND rq_id = rta_rq_id AND rpd_cid = 2
</nowiki></pre>

Xoops - Historial de revisiones

192.168.0.105 en 19:31 27 jul 2006