SELECT u.`id` FROM `#_comprofiler` AS c INNER JOIN `#_users` AS u ON u.`id` = c.`id` WHERE ( u.`username` = 'xxxxxxx' OR c.`alias` = 'xxxxxxx' ) LIMIT 0, 1
Please Log in to join the conversation.
Please Log in to join the conversation.
SELECT u.`id` FROM `#_comprofiler` AS c INNER JOIN `#_users` AS u ON u.`id` = c.`id` WHERE ( u.`username` = 'XXXXX') LIMIT 0, 1
or mebbe to even simplify it more
SELECT `id` FROM `#_comprofiler` WHERE `username` = 'XXXXX' LIMIT 0, 1
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
if ( $_CB_database->isDbCollationCaseInsensitive() ) {
$query .= "\n WHERE ( u." . $_CB_database->NameQuote( 'username' ) . " = " . $_CB_database->Quote( trim( $username ) )
. ' OR c.' . $_CB_database->NameQuote( 'alias' ) . ' = ' . $_CB_database->Quote( trim( $username ) ) . ' )';
Please Log in to join the conversation.