Categoria Hobby {arijtablesorter} {arisqltable} {ariconnectionstring dbHost="192.168.124.3" dbName="cpnt_marathon2" dbUser="cpnt_main2" dbPass="efo=~Mp!)4Ra" dbType="mysqli" persistent="false"} {arisqltablecolumns} {arisqltablecolumn id="ID" alias="ID" width="20%" className="idg"} {arisqltablecolumn id="NAME" alias="UserName" headerClassName="head"} {arisqltablecolumn alias="Virtual Column" headerClassName="head" virtual="true" pos="1"} {/arisqltablecolumn} {/arisqltablecolumns} {arisqltablequery} SELECT h.field_value "Nume Echipa", a.field_value "Nume", b.field_value "Prenume", d.field_value "Nume2", e.field_value "Prenume2", f.field_value "Categoria" FROM `jos_aicontactsafe_fieldvalues` a, `jos_aicontactsafe_fieldvalues` b, `jos_aicontactsafe_fieldvalues` c, `jos_aicontactsafe_fieldvalues` d, `jos_aicontactsafe_fieldvalues` e, `jos_aicontactsafe_fieldvalues` f, `jos_aicontactsafe_messages` g, `jos_aicontactsafe_fieldvalues` h WHERE a.field_id = '7' AND b.field_id = '8' AND f.field_id = '22' AND d.field_id = '14' AND e.field_id = '16' AND h.field_id = '27' AND a.message_id = b.message_id AND b.message_id = c.message_id AND c.message_id = d.message_id AND d.message_id = e.message_id AND e.message_id = f.message_id AND f.message_id = g.id AND f.message_id = h.message_id AND c.field_value = 'Hobby' AND g.status_id = '4' {/arisqltablequery} {/arisqltable} {/arijtablesorter}

Categoria Elita {arijtablesorter} {arisqltable} {ariconnectionstring dbHost="192.168.124.3" dbName="cpnt_marathon2" dbUser="cpnt_main2" dbPass="efo=~Mp!)4Ra" dbType="mysqli" persistent="false"} {arisqltablecolumns} {arisqltablecolumn id="ID" alias="ID" width="20%" className="idg"} {arisqltablecolumn id="NAME" alias="UserName" headerClassName="head"} {arisqltablecolumn alias="Virtual Column" headerClassName="head" virtual="true" pos="1"} {/arisqltablecolumn} {/arisqltablecolumns} {arisqltablequery} SELECT h.field_value "Nume Echipa", a.field_value "Nume", b.field_value "Prenume", d.field_value "Nume2", e.field_value "Prenume2", f.field_value "Categoria" FROM `jos_aicontactsafe_fieldvalues` a, `jos_aicontactsafe_fieldvalues` b, `jos_aicontactsafe_fieldvalues` c, `jos_aicontactsafe_fieldvalues` d, `jos_aicontactsafe_fieldvalues` e, `jos_aicontactsafe_fieldvalues` f, `jos_aicontactsafe_messages` g, `jos_aicontactsafe_fieldvalues` h WHERE a.field_id = '7' AND b.field_id = '8' AND f.field_id = '22' AND d.field_id = '14' AND e.field_id = '16' AND h.field_id = '27' AND a.message_id = b.message_id AND b.message_id = c.message_id AND c.message_id = d.message_id AND d.message_id = e.message_id AND e.message_id = f.message_id AND f.message_id = g.id AND f.message_id = h.message_id AND c.field_value = 'Elita' AND g.status_id = '4' {/arisqltablequery} {/arisqltable} {/arijtablesorter}