<?
require_once('/home/www/artlimited/include/i_declare.php');
if ($_SESSION['Admin']) no_cache(__FILE__);
// errors();

require_once(AL_PATH.'/include/i_session.php');
require_once(AL_PATH.'/image/i_declare.php');
require_once(AL_PATH.'/include/i_database.php');
require_once(AL_PATH.'/include/i_library.php');
require_once(AL_PATH.'/image/i_declare.php');
require_once(AL_PATH.'/include/i_admin_statistic.php');
require_once(AL_PATH.'selections/i_tabs_definition.php');
require_once(AL_PATH.'selections/i_resources_'.$_SESSION['UserLang'].'.php');
require_once(AL_PATH.'user/i_function.php');

// errors();

// ---- Prepare filters

/*
$Filter=array(

  NAME (
  	url var,
  	default value,
  	query image selector,
  	type,
  	Distinct,
  	NoIndex
  )

  'OFFSET' => array('offset',0,0,'I',0,'NoIndex' => 0),
  'KEYWORD' => array('kw','',1,'S',1,'NoIndex' => 1),
  'TAGS' => array('tags','',1,'S',1,'NoIndex' => 1),
  'CATEGORY_ID' => array('c',0,1,'I',0,'NoIndex' => 1),
  'CATEGORY_MEDIUM' => array('medium','',1,'S',0,'NoIndex' => 1),
  'CATEGORY' => array('category','',1,'S',0,'NoIndex' => 1),
  'POINT_MIN'	=> array('ptmin',0,1,'I',0,'NoIndex' => 1),
  'POINT_MAX'	=> array('ptmax',0,1,'I',0,'NoIndex' => 1),
  'FEATURED' => array('ftd',0,1,'I',0,'NoIndex' => 1),
  'ADMIN' => array('adm',0,1,'I',0,'NoIndex' => 1),
	'SEEN' => array('se',0,1,'I',0,'NoIndex' => 1),
	'SORT' => array('o',0,1,'I',0,'NoIndex' => 1),
	'SELL' => array('s',0,1,'I',0,'NoIndex' => 1),
	'FORMAT' => array('f',0,1,'I',0,'NoIndex' => 1),
	'CTI' => array('ci',0,1,'I',0,'NoIndex' => 1),
	'CTG' => array('cg',0,1,'I',0,'NoIndex' => 1),
	'CTE' => array('ct',0,1,'I',0,'NoIndex' => 1),
	'CPR' => array('cp',0,1,'I',0,'NoIndex' => 1),
	'TONE' => array('to',0,1,'I',0,'NoIndex' => 1),
	'CATS' => array('cs',0,1,'I',0,'NoIndex' => 1),
	'CATE' => array('ce',0,1,'I',0,'NoIndex' => 1),
	'CAT1' => array('c1',0,1,'I',0,'NoIndex' => 1),
	'CAT2' => array('c2',0,1,'I',0,'NoIndex' => 1),
	'CAT3' => array('c3',0,1,'I',0,'NoIndex' => 1),
	'PERIOD' => array('ts',0,1,'I',0,'NoIndex' => 1),
	'BESTOF' => array('bo',0,1,'I',0,'NoIndex' => 1),
	'ADVANCED' => array('adv',0,1,'I',0,'NoIndex' => 1),
	'OUTCHARTER' => array('ach',0,1,'I',0,'NoIndex' => 1),
	'COMPETITION' => array('cptt',0,1,'I',0,'NoIndex' => 1),
	'PROMOTION' => array('promo',0,1,'I',0,'NoIndex' => 1),
	'VISA' => array('visa',0,1,'I',0,'NoIndex' => 1),
	'PROJECT' => array('prj',0,1,'I',0,'NoIndex' => 1),
	'ADULT' => array('adult',0,1,'I',0,'NoIndex' => 1),
	'SCOREUSER' => array('asu',0,1,'I',0,'NoIndex' => 1),
	'ACCOUNT' => array('act',0,1,'I',0,'NoIndex' => 1),
	'ACCOUNT_EXPIRE' => array('acex',0,1,'I',0,'NoIndex' => 1),
	'SCORE_IMAGE_MIN' => array('scrartwmin',0,1,'I',0,'NoIndex' => 1),
  'SCORE_IMAGE_MAX' => array('scrartwmax',0,1,'I',0,'NoIndex' => 1),
	'BUYPRICEMIN' => array('bupmin',0,1,'I',1,'NoIndex' => 1),
	'BUYPRICEMAX' => array('bupmax',0,1,'I',1,'NoIndex' => 1),
	'BUYCURRENCY' => array('bucurr',0,1,'I',0,'NoIndex' => 1),
	'FEATURED_TIME' => array('featim',0,1,'I',0,'NoIndex' => 1),
	'USER_EXCELLENCE_TIME' => array('uxlstime',0,1,'I',0,'NoIndex' => 1),
	'IMG_EXCELLENCE_TIME' => array('ixlstime',0,1,'I',0,'NoIndex' => 1),
	'ACCOUNT_ACCESS_TIME' => array('acstim',0,1,'I',0,'NoIndex' => 1),
	'CFEED_DATE_DAY' => array('cfcd',0,1,'I',0,'NoIndex' => 1),
	'CFEED_DATE_MONTH' => array('cfcm',0,1,'I',0,'NoIndex' => 1),
	'CFEED_DATE_YEAR' => array('cfcy',0,1,'I',0,'NoIndex' => 1),
	'VISA_TIME' => array('tsvisa',0,1,'I',0,'NoIndex' => 1),
	'HARDBOUNCE' => array('hbounce',0,1,'I',0,'NoIndex' => 1),
	'GROUP_BY_ARTIST' => array('grpa',0,1,'I',0,'NoIndex' => 1),
	'EDITOR_REMOVE_FEATURED' => array('erfu',0,1,'I',0,'NoIndex' => 1),
	'ISVISA' => array('isvisa',0,1,'I',0,'NoIndex' => 1),
	'GALLERY' => array('galid',0,1,'I',0,'NoIndex' => 1),
	'EMAIL_TIME' => array('emtime',0,1,'I',0,'NoIndex' => 1),
	'USER_COUNTRY' => array('usrcy',0,1,'I',0,'NoIndex' => 1),
	'USER_CONTINENT' => array('usrctn',0,1,'I',0,'NoIndex' => 1),
	'ARTWORK_CREATED_DAY' => array('cd',0,1,'I',0,'NoIndex' => 1),
	'ARTWORK_CREATED_MONTH' => array('cm',0,1,'I',0,'NoIndex' => 1),
	'ARTWORK_CREATED_YEAR' => array('cy',0,1,'I',0,'NoIndex' => 1),
	'ARTWORK_LIMIT_DAY_SCOPE' => array('asdl',0,1,'I',0,'NoIndex' => 1),
	'PAGE_TITLE' => array('title','',1,'S',0,'NoIndex' => 1),
	'USER_ID' => array('uid',0,1,'I',0,'NoIndex' => 1),
	'IMAGE_X' => array('imgx',0,1,'I',0,'NoIndex' => 1),
	'IMAGE_Y' => array('imgy',0,1,'I',0,'NoIndex' => 1),
);
*/

$Filters=array(
  /*
  NAME (
  	url var,
  	default value,
  	query image selector,
  	type,
  	Distinct,
  	NoIndex
  )
  */
  'OFFSET' => array(
		'Var' => 'offset',
		'Value' => 0,
		'UseInQueryString' => 0,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 0
	),
  'KEYWORD' => array(
		'Var' => 'kw',
		'Value' => '',
		'UseInQueryString' => 1,
		'Type' => 'S',
		'Distinct' => 1,
		'NoIndex' => 1
	),
  'TAGS' => array(
		'Var' => 'tags',
		'Value' => '',
		'UseInQueryString' => 1,
		'Type' => 'S',
		'Distinct' => 1,
		'NoIndex' => 1
	),
  'CATEGORY_ID' => array(
		'Var' => 'c',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
  'CATEGORY_MEDIUM' => array(
		'Var' => 'medium',
		'Value' => '',
		'UseInQueryString' => 1,
		'Type' => 'S',
		'Distinct' => 0,
		'NoIndex' => 1
	),
  'CATEGORY' => array(
		'Var' => 'category',
		'Value' => '',
		'UseInQueryString' => 1,
		'Type' => 'S',
		'Distinct' => 0,
		'NoIndex' => 1
	),
  'POINT_MIN'	=> array(
		'Var' => 'ptmin',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
  'POINT_MAX'	=> array(
		'Var' => 'ptmax',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
  'FEATURED' => array(
		'Var' => 'ftd',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
  'ADMIN' => array(
		'Var' => 'adm',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'SEEN' => array(
		'Var' => 'se',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'SORT' => array(
		'Var' => 'o',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'SELL' => array(
		'Var' => 's',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'FORMAT' => array(
		'Var' => 'f',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'CTI' => array(
		'Var' => 'ci',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'CTG' => array(
		'Var' => 'cg',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'CTE' => array(
		'Var' => 'ct',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'CPR' => array(
		'Var' => 'cp',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'TONE' => array(
		'Var' => 'to',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'CATS' => array(
		'Var' => 'cs',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'CATE' => array(
		'Var' => 'ce',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'CAT1' => array(
		'Var' => 'c1',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'CAT2' => array(
		'Var' => 'c2',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'CAT3' => array(
		'Var' => 'c3',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'PERIOD' => array(
		'Var' => 'ts',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'BESTOF' => array(
		'Var' => 'bo',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'ADVANCED' => array(
		'Var' => 'adv',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'OUTCHARTER' => array(
		'Var' => 'ach',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'COMPETITION' => array(
		'Var' => 'cptt',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'PROMOTION' => array(
		'Var' => 'promo',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'VISA' => array(
		'Var' => 'visa',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'PROJECT' => array(
		'Var' => 'prj',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'ADULT' => array(
		'Var' => 'adult',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'SCOREUSER' => array(
		'Var' => 'asu',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'ACCOUNT' => array(
		'Var' => 'act',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'ACCOUNT_EXPIRE' => array(
		'Var' => 'acex',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'SCORE_IMAGE_MIN' => array(
		'Var' => 'scrartwmin',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
  'SCORE_IMAGE_MAX' => array(
		'Var' => 'scrartwmax',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'BUYPRICEMIN' => array(
		'Var' => 'bupmin',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 1,
		'NoIndex' => 1
	),
	'BUYPRICEMAX' => array(
		'Var' => 'bupmax',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 1,
		'NoIndex' => 1
	),
	'BUYCURRENCY' => array(
		'Var' => 'bucurr',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'FEATURED_TIME' => array(
		'Var' => 'featim',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'USER_EXCELLENCE_TIME' => array(
		'Var' => 'uxlstime',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'IMG_EXCELLENCE_TIME' => array(
		'Var' => 'ixlstime',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'ACCOUNT_ACCESS_TIME' => array(
		'Var' => 'acstim',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'CFEED_DATE_DAY' => array(
		'Var' => 'cfcd',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'CFEED_DATE_MONTH' => array(
		'Var' => 'cfcm',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'CFEED_DATE_YEAR' => array(
		'Var' => 'cfcy',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'VISA_TIME' => array(
		'Var' => 'tsvisa',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'HARDBOUNCE' => array(
		'Var' => 'hbounce',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'GROUP_BY_ARTIST' => array(
		'Var' => 'grpa',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'EDITOR_REMOVE_FEATURED' => array(
		'Var' => 'erfu',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'ISVISA' => array(
		'Var' => 'isvisa',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'GALLERY' => array(
		'Var' => 'galid',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'EMAIL_TIME' => array(
		'Var' => 'emtime',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'USER_COUNTRY' => array(
		'Var' => 'usrcy',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'USER_CONTINENT' => array(
		'Var' => 'usrctn',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'ARTWORK_CREATED_DAY' => array(
		'Var' => 'cd',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'ARTWORK_CREATED_MONTH' => array(
		'Var' => 'cm',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'ARTWORK_CREATED_YEAR' => array(
		'Var' => 'cy',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'ARTWORK_LIMIT_DAY_SCOPE' => array(
		'Var' => 'asdl',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'PAGE_TITLE' => array(
		'Var' => 'title',
		'Value' => '',
		'UseInQueryString' => 1,
		'Type' => 'S',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'USER_ID' => array(
		'Var' => 'uid',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'IMAGE_X' => array(
		'Var' => 'imgx',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'IMAGE_Y' => array(
		'Var' => 'imgy',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'USER_COUNT_EXCELLENCE' => array(
		'Var' => 'usrctex',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
	'USER_COUNT_FEATURED' => array(
		'Var' => 'usrctft',
		'Value' => 0,
		'UseInQueryString' => 1,
		'Type' => 'I',
		'Distinct' => 0,
		'NoIndex' => 1
	),
);

foreach ($Filters as $Key => $Val) {
	$Value='';
	if (!empty($_GET[$Filters[$Key]['Var']])) {
		$Value=urldecode($_GET[$Filters[$Key]['Var']]);
		$Filters[$Key]['QueryHide']=0;
		if ($Filters[$Key]['NoIndex']) $DesignParam['RobotsNoIndex']=1;
	}
	if (!empty($_LOCAL[$Filters[$Key]['Var']])) {
		$Value=$_LOCAL[$Filters[$Key]['Var']];
		$Filters[$Key]['QueryHide']=1;
	}
	// debug($Key.'='.$Value);
	if (!empty($Value)) {
		switch ($Filters[$Key]['Type']) {
			case 'I':
				if (is_numeric($Value) && is_int(intval($Value))) {
					$Filters[$Key]['Value']=intval($Value);
					if (!empty($Filters[$Key]['UseInQueryString'])) $QueryParam=1;
				}
				break;
			case 'S':
				if (is_string($Value)) {
					$Filters[$Key]['Value']=trim(strip_tags($Value));
					if (!empty($Filters[$Key]['UseInQueryString'])) $QueryParam=1;
				}
				break;
		}
		switch($Filters[$Key]['Distinct']) { // distinct
			case 1:
				$QueryDistinct=1;
				break;
		}
	}
}

$Param='';
if (intval($_GET['p'])>=0 && is_numeric($_GET['p']) && array_key_exists($_GET['p'],$CatTypeList)) $Param.='&p='.intval($_GET['p']);

foreach ($Filters as $Key => $Val) {
  if (!empty($Filters[$Key]['Value']) && $Filters[$Key]['QueryHide']==0 && $Filters[$Key]['UseInQueryString']) $Param.='&'.$Filters[$Key]['Var'].'='.$Filters[$Key]['Value'];
}

// ---- get user specific values

if ($_SESSION['UserId']>0) {
	$ArtscoreLimit=member_parameters_get($db_pf,$_SESSION['UserId'],USER_COMMON_FEED_FILTER_ARTSCORE_MIN);
	if ($ArtscoreLimit['Content']>0) $Filters['SCORE_IMAGE_MIN']['Value']=intval($ArtscoreLimit['Content']);
}

// ---- prepare query options

$PerRow=8;

$Offset=intval($Filters['OFFSET']['Value']);
if ($Offset<0) $Offset=0;
$Delta=$PerRow*($_SESSION['UserBrowseImgCount']>0 ? $_SESSION['UserBrowseImgCount']:4);

// ---- display pictures

$SQLFields=SQL_IMAGE_FIELDS;
if ($QueryDistinct) $SQLFields=str_replace(SQL_IMAGE_ID_FIELD,'DISTINCT '.SQL_IMAGE_ID_FIELD,$SQLFields);

if (in_array($_SESSION['UserId'],$VerifyMember)) $SQLFields.=',picbase_selection.Visa AS VisaState';

$SQL='  FROM';
if ($Filters['CTE']['Value']>0 ||
	$Filters['CPR']['Value']>0 ||
	$Filters['CTI']['Value']>0 ||
	$Filters['CTG']['Value']>0 ||
	$Filters['CATS']['Value']>0 ||
	$Filters['CATE']['Value']>0
) {
	$SQL.='	(
			SELECT Id
    	FROM picbase
  	  WHERE
	    UnixTSFeedAll>0
			';
		if ($Filters['CTE']['Value']>0) $SQL.=' AND picbase.CatTechnique='.$Filters['CTE']['Value'];
		if ($Filters['CPR']['Value']>0) $SQL.=' AND picbase.CatProcess='.$Filters['CPR']['Value'];
		if ($Filters['CTI']['Value']>0) $SQL.=' AND picbase.CatIntent='.$Filters['CTI']['Value'];
		if ($Filters['CTG']['Value']>0) $SQL.=' AND picbase.CatGenre='.$Filters['CTG']['Value'];
		if ($Filters['CATS']['Value']>0) $SQL.=' AND picbase.CatStyle='.$Filters['CATS']['Value'];
		if ($Filters['CATE']['Value']>0) $SQL.=' AND picbase.CatExperience='.$Filters['CATE']['Value'];
   	$SQL.=') tmp_picbase
   	INNER JOIN picbase ON picbase.Id=tmp_picbase.Id';
} else {
	$SQL.='	picbase';
}

$SQL.='	INNER JOIN members ON members.Id=picbase.uid AND members.Active=1'; //  AND members.PicCount>0 was slowing down the query
if ($Filters['ACCOUNT_ACCESS_TIME']['Value']>0) {
	$SQL.=' AND members.DateAccess<=FROM_UNIXTIME('.(TIME_STAMP_BY_5MN-30*24*3600*$Filters['ACCOUNT_ACCESS_TIME']['Value']).')';
}
$SQL.=SQL_IMAGE_JOIN;

if ($Filters['SCOREUSER']['Value']>0) {
	$SQL.=' INNER JOIN members_options MD_A ON MD_A.UserId=picbase.Uid AND MD_A.TypeId='.USER_FIELD_ACCOUNT_SCORE.' AND MD_A.Content>='.$Filters['SCOREUSER']['Value'];
}
if ($Filters['FEATURED_TIME']['Value']>0) {
	 $SQL.=' INNER JOIN members_options MD_B ON MD_B.UserId=picbase.Uid AND MD_B.TypeId='.USER_DATA_LAST_FEATURED_TIMESTAMP.' AND MD_B.Content'.($Filters['FEATURED_TIME']['Value']==9999 ? '=0':'<='.(TIME_STAMP_BY_5MN-24*3600*$Filters['FEATURED_TIME']['Value']));
}
if ($Filters['EMAIL_TIME']['Value']>0) {
	$SQL.=' INNER JOIN members_options MD'.USER_LATEST_EMAIL_SENT_DATETIME.' ON MD'.USER_LATEST_EMAIL_SENT_DATETIME.'.UserId=picbase.Uid AND MD'.USER_LATEST_EMAIL_SENT_DATETIME.'.TypeId='.USER_LATEST_EMAIL_SENT_DATETIME.' AND MD'.USER_LATEST_EMAIL_SENT_DATETIME.'.Content<='.(TIME_STAMP_BY_5MN-24*3600*$Filters['EMAIL_TIME']['Value']);
}
if ($Filters['USER_EXCELLENCE_TIME']['Value']>0) {
	$SQL.=' INNER JOIN members_options MD_C ON MD_C.UserId=picbase.Uid AND MD_C.TypeId='.USER_DATA_LAST_EXCELLENCE_TIMESTAMP.' AND MD_C.Content<='.(TIME_STAMP_BY_5MN-30*24*3600*$Filters['USER_EXCELLENCE_TIME']['Value']);
}
if ($Filters['VISA_TIME']['Value']>0) {
	$SQL.=' INNER JOIN members_options MD_D ON MD_D.UserId=picbase.Uid AND MD_D.TypeId='.USER_DATA_LAST_VISA_TIMESTAMP.' AND MD_D.Content<='.(TIME_STAMP_BY_5MN-30*24*3600*$Filters['VISA_TIME']['Value']);
}
$SQL.=' LEFT JOIN picbase_selection ON picbase_selection.Id=picbase.Id';
if ($_SESSION['UserId']>0) {
	if ($Filters['SEEN']['Value']==1) {
		if ($Filters['SEEN']['Value']==1) $SQL.=' INNER JOIN picbase_seen PISE ON PISE.MemberId='.$_SESSION['UserId'].' AND PISE.PictureId=picbase.Id';
	}
}

if ($Filters['USER_COUNT_FEATURED']['Value']>0) {
	$SQL.=' INNER JOIN members_options MO'.USER_FIELD_FEATURED_COUNT.' ON MO'.USER_FIELD_FEATURED_COUNT.'.UserId=members.Id AND MO'.USER_FIELD_FEATURED_COUNT.'.TypeId='.USER_FIELD_FEATURED_COUNT.' AND MO'.USER_FIELD_FEATURED_COUNT.'.Content>='.$Filters['USER_COUNT_FEATURED']['Value'];
}

if ($Filters['USER_COUNT_EXCELLENCE']['Value']>0) {
	$SQL.=' INNER JOIN members_options MO'.USER_FIELD_EXCELLENCE_COUNT.' ON MO'.USER_FIELD_EXCELLENCE_COUNT.'.UserId=members.Id AND MO'.USER_FIELD_EXCELLENCE_COUNT.'.TypeId='.USER_FIELD_EXCELLENCE_COUNT.' AND MO'.USER_FIELD_EXCELLENCE_COUNT.'.Content>='.$Filters['USER_COUNT_EXCELLENCE']['Value'];
}

if ($Filters['USER_CONTINENT']['Value']>0) {
	$SQL.=' INNER JOIN category_country ON category_country.Id=members.Country AND category_country.ContinentId='.$Filters['USER_CONTINENT']['Value'];
	// $SQL.=' INNER JOIN category_continent ON category_continent=category_country.ContinentId AND category_continent.Id='.$Filters['USER_CONTINENT']['Value'];
}

if (intval($_GET['s'])>0) $SQL.=' AND members.Account>'.ACCOUNT_BOOK;
if ($Filters['USER_ID']['Value']>0) $ConstraintUserId=$Filters['USER_ID']['Value'];
// ---- search in database
if ($Filters['KEYWORD']['Value']!='') {
	require_once(AL_PATH.'/include/i_ref_id.php');
	require_once(AL_PATH.'/tags/i_tags.php');
	$Filters['KEYWORD']['Value']=trim($Filters['KEYWORD']['Value']);
	$Filters['KEYWORD']['Value']=str_replace(',',' ',$Filters['KEYWORD']['Value']);
	$Keywords='';
  $Token=explode(' ',$Filters['KEYWORD']['Value']);
  for ($i=0;$i<=count($Token)-1;$i++) {
    if (mb_strstr($Token[$i],'[ref-')) {
    	$ConstraintUserId=get_ref_member_id($Token[$i]);
    } else {
    	$Keywords.=' '.$Token[$i];
    }
  }
  $Keywords=trim($Keywords);
  $KeywordsList=trim($KeywordsList,' ,');
  if (!empty($Keywords)) {
		$SQL.=' INNER JOIN keywords ON MATCH(keywords.Tag) AGAINST (\''.db_prepare_str($db_pf,$Keywords).'\' IN BOOLEAN MODE)';
		$SQL.=' INNER JOIN keywords_r ON keywords_r.TagId=keywords.Id AND picbase.Id=keywords_r.ObjectId AND keywords_r.TypeId IN ('.OBJ_IMAGE.','.OBJ_IMAGE_INDEX_TEXT.')';
  	increase_tag_counter($db_pf,$Keywords);
  	if (!$_LOCAL['State']) $Filters['PAGE_TITLE']['Value']=$RsDic['SEARCH_WORD'].' '.$Filters['KEYWORD']['Value'];
	}
}
if ($_GET['s']>0 || $Filters['BUYPRICEMIN']['Value']>0 || $Filters['BUYPRICEMAX']['Value']>0 || $Filters['BUYCURRENCY']['Value']>0) {
	$SQL.=' INNER JOIN picbase_sale ON picbase_sale.ImageId=picbase.id';
	switch ($_GET['s']) {
		case PROFILE_PRINT:
			$SQL.=' AND picbase_sale.TypeId='.PROFILE_PRINT;
			break;
		case PROFILE_DIGITAL:
			$SQL.=' AND picbase_sale.TypeId='.PROFILE_DIGITAL;
			break;
		case PROFILE_SELL_MISC:
			$SQL.=' AND picbase_sale.TypeId='.PROFILE_SELL_MISC;
			break;
		case PROFILE_SELL_ALL:
			$SQL.=' AND picbase_sale.TypeId IN ('.PROFILE_PRINT.','.PROFILE_DIGITAL.','.PROFILE_SELL_MISC.')';
			break;
	}

	if ($Filters['BUYPRICEMIN']['Value']>=0 && $Filters['BUYPRICEMAX']['Value']>0 || $Filters['BUYCURRENCY']['Value']>0 || $Filters['SELL']['Value']>0) {
		switch ($_GET['s']) {
  		case PROFILE_PRINT:
  			$SQL.=' INNER JOIN picbase_sale_print ON picbase_sale_print.Id=picbase_sale.SaleId';
  			if ($Filters['BUYCURRENCY']['Value']>0) $SQL.=' AND picbase_sale_print.Currency='.$Filters['BUYCURRENCY']['Value'];
  			break;
  		case PROFILE_DIGITAL:
  			$SQL.=' INNER JOIN picbase_sale_digital ON picbase_sale_digital.Id=picbase_sale.SaleId';
  			if ($Filters['BUYCURRENCY']['Value']>0) $SQL.=' AND picbase_sale_digital.Currency='.$Filters['BUYCURRENCY']['Value'];
  			break;
  		case PROFILE_SELL_MISC:
  			$SQL.=' INNER JOIN picbase_sale_misc ON picbase_sale_misc.Id=picbase_sale.SaleId';
  			if ($Filters['BUYCURRENCY']['Value']>0) $SQL.=' AND picbase_sale_misc.Currency='.$Filters['BUYCURRENCY']['Value'];
  			break;
  		case PROFILE_SELL_ALL:
  			$SQL.=' LEFT JOIN picbase_sale_print ON picbase_sale_print.Id=picbase_sale.SaleId';
  			$SQL.=' LEFT JOIN picbase_sale_digital ON picbase_sale_digital.Id=picbase_sale.SaleId';
  			$SQL.=' LEFT JOIN picbase_sale_misc ON picbase_sale_misc.Id=picbase_sale.SaleId';
  			break;
		}
	}
}

if ($Filters['COMPETITION']['Value']>0) {
  $SQL.=' INNER JOIN competition_image ON competition_image.ArtworkId=picbase.id AND competition_image.CompetitionId='.$Filters['COMPETITION']['Value'];
}
if ($Filters['PROJECT']['Value']>0) $SQL.=' INNER JOIN projects_r_pics ON projects_r_pics.PictureId=picbase.id AND projects_r_pics.ProjectId='.$Filters['PROJECT']['Value'].' AND projects_r_pics.Banned=0 AND projects_r_pics.Validated=1';
if ($Filters['CAT1']['Value']>0) {
	$SQL.=' INNER JOIN category_subject ON picbase.CatSubject=category_subject.Id AND category_subject.c1='.$Filters['CAT1']['Value'];
	if ($Filters['CAT2']['Value']>0) $SQL.=' AND category_subject.c2='.$Filters['CAT2']['Value'];
	if ($Filters['CAT3']['Value']>0) $SQL.=' AND category_subject.c3='.$Filters['CAT3']['Value'];
}

if ($Filters['IMG_EXCELLENCE_TIME']['Value']>0) {
	$SQL.=' INNER JOIN picbase_options PO'.IMAGE_EXCELLENCE.' ON PO'.IMAGE_EXCELLENCE.'.Id=picbase.Id AND PO'.IMAGE_EXCELLENCE.'.Type='.IMAGE_EXCELLENCE.' AND PO'.IMAGE_EXCELLENCE.'.Value>='.$Filters['IMG_EXCELLENCE_TIME']['Value'];
}
if ($Filters['PROMOTION']['Value']==1) {
	$SQL.=' INNER JOIN picbase_options ppo_promo ON ppo_promo.Id=picbase.Id AND ppo_promo.Type='.IMAGE_PROMOTION.' AND ppo_promo.Value=1';
}
if ($Filters['SCORE_IMAGE_MIN']['Value']>0 || $Filters['SORT']['Value']==10) {
	$SQL.=' INNER JOIN picbase_options PO_ASMIN ON PO_ASMIN.Id=picbase.Id AND PO_ASMIN.Type='.IMAGE_ARTSCORE;
	if ($Filters['SCORE_IMAGE_MIN']['Value']>0) $SQL.=' AND PO_ASMIN.Value>='.intval($Filters['SCORE_IMAGE_MIN']['Value']);
}
if ($Filters['SCORE_IMAGE_MAX']['Value']>0) {
	$SQL.=' INNER JOIN picbase_options PO_ASMAX ON PO_ASMAX.Id=picbase.Id AND PO_ASMAX.Type='.IMAGE_ARTSCORE.' AND PO_ASMAX.Value<='.intval($Filters['SCORE_IMAGE_MAX']['Value']);
}
if ($Filters['ADULT']['Value']>0) $SQL.=' INNER JOIN picbase_options POADULT ON POADULT.Id=picbase.Id AND POADULT.Type='.IMAGE_ADULT_CONTENT.' AND POADULT.Value'.($Filters['ADULT']['Value']==1 ? '>':'=').'0';
if (empty($_SESSION['Admin']) && empty($ConstraintUserId)) $SQL.=' INNER JOIN picbase_options PO19 ON PO19.Id=picbase.Id AND PO19.Type='.IMAGE_CHARTER_OUT.' AND PO19.Value=0';
if ($_SESSION['UserId']!=$ConstraintUserId) $SQL.=' INNER JOIN picbase_options PO16 ON PO16.Id=picbase.Id AND PO16.Type='.IMAGE_HIDDEN.' AND PO16.Value<1';

// -----------------------------------------------------------------------------------------------------
// -- STARTING WHERE QUERY -----------------------------------------------------------------------------
// -----------------------------------------------------------------------------------------------------

$SQL.=SQL_IMAGE_WHERE.CRLF.'AND UnixTSFeedAll>0'.CRLF;

if ($Filters['BUYPRICEMIN']['Value']>0 || $Filters['BUYPRICEMAX']['Value']>0 || $Filters['BUYCURRENCY']['Value']>0 || $Filters['BUYCURRENCY']['Value']>0) {
	switch ($_GET['s']) {
		case PROFILE_PRINT:
			if ($Filters['BUYPRICEMIN']['Value']>0) $SQL.=' AND picbase_sale_print.PrintPrice>='.$Filters['BUYPRICEMIN']['Value'];
			if ($Filters['BUYPRICEMAX']['Value']>0) $SQL.=' AND picbase_sale_print.PrintPrice<='.$Filters['BUYPRICEMAX']['Value'];
			if ($Filters['BUYCURRENCY']['Value']>0) $SQL.=' AND picbase_sale_print.Currency='.$Filters['BUYCURRENCY']['Value'];
			$SQL.=' AND picbase_sale_print.Uid=members.Id';
			break;
		case PROFILE_DIGITAL:
			if ($Filters['BUYPRICEMIN']['Value']>0) $SQL.=' AND picbase_sale_digital.Price>='.$Filters['BUYPRICEMIN']['Value'];
			if ($Filters['BUYPRICEMAX']['Value']>0) $SQL.=' AND picbase_sale_digital.Price<='.$Filters['BUYPRICEMAX']['Value'];
			if ($Filters['BUYCURRENCY']['Value']>0) $SQL.=' AND picbase_sale_digital.Currency='.$Filters['BUYCURRENCY']['Value'];
			$SQL.=' AND picbase_sale_digital.Uid=members.Id';
			break;
		case PROFILE_SELL_MISC:
			if ($Filters['BUYPRICEMIN']['Value']>0) $SQL.=' AND picbase_sale_misc.Price>='.$Filters['BUYPRICEMIN']['Value'];
			if ($Filters['BUYPRICEMAX']['Value']>0) $SQL.=' AND picbase_sale_misc.Price<='.$Filters['BUYPRICEMAX']['Value'];
			if ($Filters['BUYCURRENCY']['Value']>0) $SQL.=' AND picbase_sale_misc.Currency='.$Filters['BUYCURRENCY']['Value'];
			$SQL.=' AND picbase_sale_misc.Uid=members.Id';
			break;
		case PROFILE_SELL_ALL:
			$SQL.=' AND';
			$SQL.='(';
			$SQL.='picbase_sale_print.Uid=members.Id';
			if ($Filters['BUYPRICEMIN']['Value']>0) $SQL.=' AND picbase_sale_print.PrintPrice>='.$Filters['BUYPRICEMIN']['Value'];
			if ($Filters['BUYPRICEMAX']['Value']>0) $SQL.=' AND picbase_sale_print.PrintPrice<='.$Filters['BUYPRICEMAX']['Value'];
			if ($Filters['BUYCURRENCY']['Value']>0) $SQL.=' AND picbase_sale_print.Currency='.$Filters['BUYCURRENCY']['Value'];
			$SQL.=')';
			$SQL.=' OR (';
			$SQL.='picbase_sale_digital.Uid=members.Id';
			if ($Filters['BUYPRICEMIN']['Value']>0) $SQL.=' AND picbase_sale_digital.Price>='.$Filters['BUYPRICEMIN']['Value'];
			if ($Filters['BUYPRICEMAX']['Value']>0) $SQL.=' AND picbase_sale_digital.Price<='.$Filters['BUYPRICEMAX']['Value'];
			if ($Filters['BUYCURRENCY']['Value']>0) $SQL.=' AND picbase_sale_digital.Currency='.$Filters['BUYCURRENCY']['Value'];
			$SQL.=')';
			$SQL.=' OR (';
			$SQL.='picbase_sale_misc.Uid=members.Id';
			if ($Filters['BUYPRICEMIN']['Value']>0) $SQL.=' AND picbase_sale_misc.Price>='.$Filters['BUYPRICEMIN']['Value'];
			if ($Filters['BUYPRICEMAX']['Value']>0) $SQL.=' AND picbase_sale_misc.Price<='.$Filters['BUYPRICEMAX']['Value'];
			if ($Filters['BUYCURRENCY']['Value']>0) $SQL.=' AND picbase_sale_misc.Currency='.$Filters['BUYCURRENCY']['Value'];
			$SQL.=')';
			break;
	}
}
if ($Filters['ACCOUNT']['Value']>0) {
	$SQL.=' AND members.Account='.$Filters['ACCOUNT']['Value'];
}
if ($Filters['ACCOUNT_EXPIRE']['Value']>0) {
	$SQL.=' AND members.Account>'.ACCOUNT_BOOK.' AND members.Permanent=0';
	if ($Filters['ACCOUNT_EXPIRE']['Value']==1) $SQL.=' AND members.DateExpire<=\''.DATE_NOW_SS.'\'';
	if ($Filters['ACCOUNT_EXPIRE']['Value']==2) $SQL.=' AND members.DateExpire>\''.DATE_NOW_SS.'\'';
}
if ($Filters['HARDBOUNCE']['Value']>0) {
	if ($Filters['HARDBOUNCE']['Value']==1) $SQL.=' AND members.Bounce>0';
	if ($Filters['HARDBOUNCE']['Value']==2) $SQL.=' AND members.Bounce=0';
}
// if (!empty($Keywords)) $SQL.=' AND Validated=1 ';
if ($ConstraintUserId>0) $SQL.=' AND picbase.Uid='.$ConstraintUserId;
// $SQL.=' AND (picbase.Options & '.IMG_OPT_NO_DISPLAY.'=0';
// if (!empty($_SESSION['UserId'])) $SQL.=' OR picbase.Uid='.intval($_SESSION['UserId']);
// $SQL.=')';

if ($Filters['TONE']['Value']>0) {
	if ($Filters['TONE']['Value']==IMG_OPT_BLACKWHITE) $SQL.=CRLF.'AND picbase.CatTone='.IMG_OPT_BLACKWHITE;
	if ($Filters['TONE']['Value']==IMG_OPT_COLOR) $SQL.=CRLF.'AND picbase.CatTone='.IMG_OPT_COLOR;
	if ($Filters['TONE']['Value']==IMG_OPT_TONED) $SQL.=CRLF.'AND picbase.CatTone='.IMG_OPT_TONED;
	if ($Filters['TONE']['Value']==IMG_OPT_COLORIZED) $SQL.=CRLF.'AND picbase.CatTone='.IMG_OPT_COLORIZED;
}

// if (empty($ConstraintUserId)) $SQL.=' AND (picbase.Options & '.IMG_OPT_CHARTER_OUT.')=0';

if ($Filters['CATEGORY_ID']['Value']>0) $SQL.=' AND picbase.CatSubject='.$Filters['CATEGORY_ID']['Value'];
if ($_GET['f']>0) {
  switch($_GET['f']) {
    case 1: $SQL.=' AND picbase.width<picbase.height'; break;
    case 2: $SQL.=' AND picbase.width>picbase.height'; break;
    case 3: $SQL.=' AND (picbase.width/picbase.height>0.95 AND picbase.width/picbase.height<1.05)'; break;
    case 4: $SQL.=' AND 2*picbase.width<picbase.height'; break;
    case 5: $SQL.=' AND 2*picbase.height<picbase.width'; break;
  }
}

if ($Filters['GALLERY']['Value']>0) {
  $SQL.=' AND GalleryId='.$Filters['GALLERY']['Value'];
}

if ($Filters['SORT']['Value']==3) $SQL.=' AND (picbase_selection.Featured>0 AND picbase_selection.Featured<'.TIME_STAMP_BY_5MN.')';
if ($Filters['SORT']['Value']==7) $SQL.=' AND picbase_selection.Jury>0';
if ($Filters['SORT']['Value']==8) $SQL.=' AND picbase_selection.Visa>0';
if ($Filters['SORT']['Value']==7) $SQL.=' AND picbase_selection.Jury>0';

if ($Filters['ISVISA']['Value']>0) {
	if ($Filters['ISVISA']['Value']==1) $SQL.=' AND picbase_selection.Visa>0';
	if ($Filters['ISVISA']['Value']==2) $SQL.=' AND picbase_selection.Visa=0';
}

if ($_GET['cd']>=1 && $_GET['cd']<=31 && $_GET['cm']>=1 && $_GET['cm']<=12 && $_GET['cy']>=2005 && $_GET['cy']<=date('Y')) {
  $SQL.=' AND picbase.FirstDate>=\''.sprintf('%04d-%02d-%02d',intval($_GET['cy']),intval($_GET['cm']),intval($_GET['cd'])).' 00:00:00\'';
  $SQL.=' AND picbase.FirstDate<=\''.sprintf('%04d-%02d-%02d',intval($_GET['cy']),intval($_GET['cm']),intval($_GET['cd'])).' 23:59:59\'';
}

/*
if ($Filters['CFEED_DATE_DAY']['Value']>=1 && $Filters['CFEED_DATE_DAY']['Value']<=31 && $Filters['CFEED_DATE_MONTH']['Value']>=1 && $Filters['CFEED_DATE_MONTH']['Value']<=12 && $Filters['CFEED_DATE_YEAR']['Value']>=2005 && $Filters['CFEED_DATE_YEAR']['Value']<=date('Y')) {
  $SQL.=' AND picbase.UnixTSFeedAll>='.strtotime(sprintf('%04d-%02d-%02d 00:00:00',intval($Filters['CFEED_DATE_YEAR']['Value']),intval($Filters['CFEED_DATE_MONTH']['Value']),intval($Filters['CFEED_DATE_DAY']['Value'])));
  $SQL.=' AND picbase.UnixTSFeedAll<='.strtotime(sprintf('%04d-%02d-%02d 23:59:59',intval($Filters['CFEED_DATE_YEAR']['Value']),intval($Filters['CFEED_DATE_MONTH']['Value']),intval($Filters['CFEED_DATE_DAY']['Value'])));
}
*/

if ($Filters['CFEED_DATE_DAY']['Value']>=1 && $Filters['CFEED_DATE_DAY']['Value']<=31) $SQL.=' AND DAY(FROM_UNIXTIME(picbase.UnixTSFeedAll))='.intval($Filters['CFEED_DATE_DAY']['Value']);
if ($Filters['CFEED_DATE_MONTH']['Value']>=1 && $Filters['CFEED_DATE_MONTH']['Value']<=12) $SQL.=' AND MONTH(FROM_UNIXTIME(picbase.UnixTSFeedAll))='.intval($Filters['CFEED_DATE_MONTH']['Value']);
if ($Filters['CFEED_DATE_YEAR']['Value']>=2005 && $Filters['CFEED_DATE_YEAR']['Value']<=date('Y')) $SQL.=' AND YEAR(FROM_UNIXTIME(picbase.UnixTSFeedAll))='.intval($Filters['CFEED_DATE_YEAR']['Value']);

if ($Filters['USER_COUNTRY']['Value']>0) {
	$SQL.=' AND members.Country='.$Filters['USER_COUNTRY']['Value'];
}

if ($Filters['POINT_MIN']['Value']>0) $SQL.=' AND picbase.Rate>='.$Filters['POINT_MIN']['Value'];
if ($Filters['POINT_MAX']['Value']>0) $SQL.=' AND picbase.Rate<='.$Filters['POINT_MAX']['Value'];
if (empty($_SESSION['UserId']) && !$ConstraintUserId) $SQL.=' AND picbase.Rate>='.COMMON_THRESHOLD;

if ($ImageJuryRate>0) $SQL.=' AND picbase.RateJuryNoRelation+picbase.RateJuryRelation>='.$ImageJuryRate;

if (intval($_GET['p'])>0) $SQL.=' AND picbase.CatType='.intval($_GET['p']);

/*
if ($Filters['CTE']['Value']>0) $SQL.=' AND picbase.CatTechnique='.$Filters['CTE']['Value'];
if ($Filters['CPR']['Value']>0) $SQL.=' AND picbase.CatProcess='.$Filters['CPR']['Value'];
if ($Filters['CTI']['Value']>0) $SQL.=' AND picbase.CatIntent='.$Filters['CTI']['Value'];
if ($Filters['CTG']['Value']>0) $SQL.=' AND picbase.CatGenre='.$Filters['CTG']['Value'];
if ($Filters['CATS']['Value']>0) $SQL.=' AND picbase.CatStyle='.$Filters['CATS']['Value'];
if ($Filters['CATE']['Value']>0) $SQL.=' AND picbase.CatExperience='.$Filters['CATE']['Value'];
*/

if ($Filters['FEATURED']['Value']>0) {
  if ($Filters['FEATURED']['Value']==1) $SQL.=' AND picbase_selection.Featured>0';
  if ($Filters['FEATURED']['Value']==2) $SQL.=' AND picbase_selection.Featured=0';
}
if ($Filters['ADMIN']['Value']>0) {
  if ($Filters['ADMIN']['Value']==1) $SQL.=' AND picbase.Validated>0';
  if ($Filters['ADMIN']['Value']==2) $SQL.=' AND picbase.Validated=0';
}
if ($Filters['OUTCHARTER']['Value']>0) {
  if ($Filters['OUTCHARTER']['Value']==1) $SQL.=' AND picbase.Options & '.IMG_OPT_CHARTER_OUT.'=0';
  if ($Filters['OUTCHARTER']['Value']==2) $SQL.=' AND picbase.Options & '.IMG_OPT_CHARTER_OUT.'='.IMG_OPT_CHARTER_OUT;
}

if ($Filters['IMAGE_X']['Value']>0) $SQL.=' AND picbase.Width>='.$Filters['IMAGE_X']['Value'];
if ($Filters['IMAGE_Y']['Value']>0) $SQL.=' AND picbase.Height>='.$Filters['IMAGE_Y']['Value'];

if ($Filters['PERIOD']['Value']>0) {
  if ($Filters['PERIOD']['Value']==1) $SQL.=' AND picbase.FirstDate>\''.date('Y-m-d H:i:s',TIME_STAMP_BY_5MN-3600*8).'\'';
	if ($Filters['PERIOD']['Value']==2) $SQL.=' AND picbase.FirstDate>\''.date('Y-m-d H:i:s',TIME_STAMP_BY_5MN-3600*12).'\'';
	if ($Filters['PERIOD']['Value']==3) $SQL.=' AND picbase.FirstDate>\''.date('Y-m-d H:i:s',TIME_STAMP_BY_5MN-3600*24).'\'';
	if ($Filters['PERIOD']['Value']==4) $SQL.=' AND picbase.FirstDate>\''.date('Y-m-d H:i:s',TIME_STAMP_BY_5MN-3600*24*3).'\'';
	if ($Filters['PERIOD']['Value']==5) $SQL.=' AND picbase.FirstDate>\''.date('Y-m-d H:i:s',TIME_STAMP_BY_5MN-3600*24*7).'\'';
	if ($Filters['PERIOD']['Value']==6) $SQL.=' AND picbase.FirstDate>\''.date('Y-m-d H:i:s',TIME_STAMP_BY_5MN-3600*24*14).'\'';
	if ($Filters['PERIOD']['Value']==7) $SQL.=' AND picbase.FirstDate>\''.date('Y-m-d H:i:s',TIME_STAMP_BY_5MN-3600*24*31).'\'';
	if ($Filters['PERIOD']['Value']==8) $SQL.=' AND picbase.FirstDate>\''.date('Y-m-d H:i:s',TIME_STAMP_BY_5MN-3600*24*31*2).'\'';
	if ($Filters['PERIOD']['Value']==9) $SQL.=' AND picbase.FirstDate>\''.date('Y-m-d H:i:s',TIME_STAMP_BY_5MN-3600*24*31*3).'\'';
	if ($Filters['PERIOD']['Value']==10) $SQL.=' AND picbase.FirstDate>\''.date('Y-m-d H:i:s',TIME_STAMP_BY_5MN-3600*24*31*6).'\'';
	if ($Filters['PERIOD']['Value']==11) $SQL.=' AND picbase.FirstDate>\''.date('Y-m-d H:i:s',TIME_STAMP_BY_5MN-3600*24*365).'\'';
	if ($Filters['PERIOD']['Value']>=12) {
		$SQL.=' AND picbase.FirstDate>\''.date('Y-m-d H:i:s',TIME_STAMP_BY_5MN-3600*24*365*($Filters['PERIOD']['Value']-10)).'\'';
	}
}

if (!$QueryParam) {
	// if (!in_array($_SESSION['UserId'],$VerifyMember)) {
		$SQL.=' AND picbase.UnixTSFeedAll>'.strtotime('-8 days',TIME_STAMP_BY_DAY); // ---- try to accelerate the processus, don't take all images
	// }
	/*
	$SQLBis='SELECT MAX(Id) AS LastId FROM picbase LIMIT 1';
	$DBResult=db_query(__FILE__,__LINE__,$SQLBis,$db_pf);
	$RowId=db_fetch_assoc($DBResult);
	$SQL.=' AND picbase.Id>'.$RowId['LastId'].'-'.($Offset+$Delta).'*32';
	*/
}
if ($_SESSION['UserId']>0 && $Filters['SEEN']['Value']==2) {
	$SQL.=' AND picbase_seen.PictureId IS NULL';
}
if (empty($Filters['OFFSET']['Value']) && $_LOCAL['FastId']>0) $SQL.=' AND picbase.Id>'.$_LOCAL['FastId'];

if (/*!$QueryParam &&*/ empty($ConstraintUserId) && !in_array($_SESSION['UserId'],$VerifyMember)) {
	$SQL.=' AND UnixTSFeedAll<'.TIME_STAMP_BY_MIN;
}

if (!$QueryParam && $Filters['ARTWORK_LIMIT_DAY_SCOPE']['Value']>0) {
	$SQL.=' AND picbase.UnixTSFeedAll>'.strtotime('-'.$Filters['ARTWORK_LIMIT_DAY_SCOPE']['Value'].' DAYS',TIME_STAMP_BY_DAY); // ---- try to accelerate the processus, don't take all images
}

if ($Filters['EDITOR_REMOVE_FEATURED']['Value']>0) {
	$SQLBis='SELECT GROUP_CONCAT(DISTINCT pcef.Uid) AS ImagesId FROM editor_selections INNER JOIN picbase pcef ON pcef.Id=editor_selections.ArtworkId';
	$DBResult=db_query(__FILE__,__LINE__,$SQLBis,$db_pf);
	$RowWaiting=db_fetch_assoc($DBResult);
	$SQL.=' AND picbase.Uid NOT IN ('.$RowWaiting['ImagesId'].')';
}

// ---- sorting rules

if ($Filters['SORT']['Value']==2) {
	$SQL.=' AND picbase.SortValue IN ('.random_int(0,255).','.random_int(0,255).','.random_int(0,255).','.random_int(0,255).','.random_int(0,255).')';
}

$SQLSort=CRLF.'ORDER BY ';

switch ($Filters['SORT']['Value']) {
  case 1: $SQLSort.='picbase.Rate DESC'; break;
  // case 2: see in where condition for this one  $SQLSort.='RAND('.TIME_STAMP_BY_5MN.')'; break;
  case 2: $SQLSort.='RAND('.TIME_STAMP_BY_5MN.')'; break;
  case 4: $SQLSort.='CountFav DESC'; break;
  case 5: $SQLSort.='CommentCount DESC'; break;
  case 6: $SQLSort.='CatType DESC'; break;
  case 9:  $SQLSort.='picbase.'.($QueryParam ? 'Id':'UnixTSFeedAll').' ASC'; break;
  // case 10: $SQLSort.='CAST(PO_ASMIN.Value AS UNSIGNED) DESC'; break;
  case 10: $SQLSort.='PO_ASMIN.Value DESC'; break;
  case 11: $SQLSort.='RAND()'; break;
  default: $SQLSort.='picbase.'.($QueryParam || in_array($_SESSION['UserId'],$VerifyMember) ? 'Id':'UnixTSFeedAll').' DESC'; break;
}

if (!empty($QueryParam)) {
	if ($Filters['GROUP_BY_ARTIST']['Value']==1) $SQLGroup.='picbase.Uid';
	// if ($Filters['SELL']['Value']>0) $SQLGroup.=',picbase.Id';
	if ($SQLGroup) $SQLGroup=CRLF.'GROUP BY '.trim($SQLGroup,',');
}

$SQLLimit=CRLF.'LIMIT '.$Offset.','.$Delta;

$ArtworkSQL=$SQLFields.$SQL.$SQLGroup.$SQLSort.$SQLLimit;

// $time_start=microtime(true);
db_no_lock_set($db_pf);
$ResultThumb=db_query(__FILE__,__LINE__,$ArtworkSQL,$db_pf,0);
db_no_lock_reset($db_pf);

// ------------------------------------------------------------------------------------------
// ---- DISPLAY PAGE ------------------------------------------------------------------------
// ------------------------------------------------------------------------------------------

$DesignParam['FOOTER_IMAGE_FEATURED']=0;
if (db_num_rows($ResultThumb)==0 || $_LOCAL['NoIndex']==1 || ($QueryParam && !$_LOCAL['State'])) {
	header('X-Robots-Tag: noindex');
	$DesignParam['RobotsNoIndex']=1;
}

$MetaLink=HTTP_WWW.SITE_DOMAIN.$_SERVER['REQUEST_URI']; // $TabArray[$Data['PRIVATE']['SELECTED']]['URL'].($_SERVER['QUERY_STRING']>' ' ? '?'.$_SERVER['QUERY_STRING']:'');
$MetaHeadline=$MetaTitle;

if ($_LOCAL['State']==1) {
	$Filters['PAGE_TITLE']['Value']=strtr($Filters['PAGE_TITLE']['Value'],'_',' ');
	$MetaTitle=ucfirst(sprintf($RsDic['FILTER_TITLE_META_TITLE'],$Filters['PAGE_TITLE']['Value'])).$MetaTitlePage;
	$MetaDescription=$PageHeadline=($_LOCAL['description'] ? $_LOCAL['description']:ucfirst(sprintf($RsDic['FILTER_LOCAL_META_DESCRIPTION_'.$_LOCAL['Selector']],$Filters['PAGE_TITLE']['Value']))).$MetaTitlePage;
	$MetaHeadline=sprintf($RsDic['FILTER_TITLE_HEADLINE_TEXT'],$Filters['PAGE_TITLE']['Value']);
} else {
	if ($Filters['CATEGORY_MEDIUM']['Value']!=='') {
		$MetaTitle=sprintf($RsDic['FILTER_MEDIUM_META_TITLE'],$Filters['CATEGORY_MEDIUM']['Value']).$MetaTitlePage;
		$MetaDescription=ucfirst(sprintf($RsDic['FILTER_MEDIUM_META_DESCRIPTION'],$Filters['CATEGORY_MEDIUM']['Value'])).$MetaTitlePage;
		$MetaHeadline=sprintf($RsDic['FILTER_MEDIUM_HEADLINE_TEXT'],$Filters['CATEGORY_MEDIUM']['Value']);
	}
	if ($Filters['CATEGORY']['Value']!=='') {
		$MetaTitle=$RsDic['FILTER_CATEGORY_META_TITLE'].' '.$Filters['CATEGORY']['Value'].$MetaTitlePage;
		$MetaDescription=ucfirst(sprintf($RsDic['FILTER_CATEGORY_META_DESCRIPTION'],$Filters['CATEGORY']['Value'])).$MetaTitlePage;
		$MetaHeadline=sprintf($RsDic['FILTER_CATEGORY_HEADLINE_TEXT'],$Filters['CATEGORY']['Value']);
	}
	if (!$MetaTitle && $Keywords) {
		$MetaTitle=$RsDic['FILTER_KEYWORD_META_TITLE'].' '.ucfirst($Keywords).$MetaTitlePage;
		$MetaDescription=ucfirst(sprintf($RsDic['FILTER_KEYWORD_META_DESCRIPTION'],ucfirst($Keywords))).$MetaTitlePage;
		$MetaHeadline=sprintf($RsDic['FILTER_KEYWORD_HEADLINE_TEXT'],ucfirst($Keywords));
	}
	if (!$MetaTitle && $Filters['TAGS']['Value']!=='') {
		$MetaTitle=ucfirst(sprintf($RsDic['FILTER_TAGS_META_TITLE'],$Keywords)).$MetaTitlePage;
		$MetaDescription=ucfirst(sprintf($RsDic['FILTER_TAGS_META_DESCRIPTION'],$Keywords)).$MetaTitlePage;
		$MetaHeadline=ucfirst(sprintf($RsDic['FILTER_TAGS_HEADLINE_TEXT'],$Keywords));
	}
	if (!$MetaTitle && $Filters['PAGE_TITLE']['Value']!=='') {
		$Filters['PAGE_TITLE']['Value']=strtr($Filters['PAGE_TITLE']['Value'],'_',' ');
		$MetaTitle=ucfirst(sprintf($RsDic['FILTER_TITLE_META_TITLE'],$Filters['PAGE_TITLE']['Value'])).$MetaTitlePage;
		$MetaDescription=ucfirst(sprintf($RsDic['FILTER_TITLE_META_DESCRIPTION'],$Filters['PAGE_TITLE']['Value'])).$MetaTitlePage;
		$MetaHeadline=sprintf($RsDic['FILTER_TITLE_HEADLINE_TEXT'],$Filters['PAGE_TITLE']['Value']);
	}
}

// ---- After to avoid "page numbering" be displayed in category text

$MetaTitlePage=($Offset/$Delta>0 ? ' - Page '.intval(($Offset/$Delta)+1):'');
$MetaTitle.=$MetaTitlePage;

if ($ConstraintUserId>0) $MetaDescription=$Filters['PAGE_TITLE']['Value'].'. '.$MetaDescription;

require_once(AL_PATH.'/include/i_page_header.php');

if (empty($_LOCAL['State'])) {
	echo '<div class="AlignHC">';
	tab_display($TabArray);
	echo '</div>';
}

// ---- Signup for unregistered users

if ($_SESSION['UserId']==0) {
	require_once(AL_PATH.'/library/inputs/i_functions.php');
	echo '<div class="MaT20px AlignHC DisBL">';
	$This=array(
		'TYPE' => 'button',
		'SUBTYPE' => 'pseudo',
		'ID' => 'BrowseSignupBtn',
		'VALUE' => $RsDic['REGISTER_ACTION_STR_02'],
		'ICON' => 'picture-o-w',
		'CSS_CLASS' => 'Oswald',
		'CSS_STYLE' => 'font-weight:400;transform:scale(1.5);background-color:#b28d42;margin:20px 0 40px 0;',
		'EVENT_ONCLICK' => 'location.href="'.URL_USER_ACCOUNT_SIGNUP.'?account='.ACCOUNT_ARTIST.'&form=fast&source='.hash('sha256',session_id().UNIQUE_KEY_BIG.STAT_KEY_SIGNUP_BROWSE_COMMON_CLICK.STAT_KEY_SIGNUP_BROWSE_COMMON_SUCCESS).'-'.STAT_KEY_SIGNUP_BROWSE_COMMON_CLICK.'-'.STAT_KEY_SIGNUP_BROWSE_COMMON_SUCCESS.'";',
		'SUBMIT_VALUE' => '',
		'DELAY' => 0,
	);
	new_input($This);
	echo '</div>';
}

// ---- help et info message

echo '<div class="DisIB PosRE">';
$BaseLine=array(
	'DB_CONN' => '',
	'TEXT_ID' => 0,
	'STRING' => $MetaTitle,
	'CULTURE_ID' => $_SESSION['UserCulture'],
	'CLASS' => 'DisIN Pa0px FtUpper',
	'STYLE' => '',
	'RETURN' => 0,
);
display_base_line($BaseLine);
if (!$QueryParam) {
	echo '<img class="PosAB OpacityHover TransScale alttip" src="/img/icon/question-circle.svg" style="top:25px;right:0px;cursor:pointer;width:20px;height:20px;" onclick="$(\'#SelectionInfoBlock\').slideToggle();" alt="'.$RsDic['MORE_INFORMATION_STR'].'" />';
}
echo '</div>';

if ($_SESSION['UserId']==0 && !empty($_LOCAL)) {
	echo '<div class="AlignHJ Oswald FtSize20" style="margin:0 auto 20px 0;max-width:750px;color:#666;font-weight:300;line-height:1.3em;">';
	echo '<p class="instream">'.$PageHeadline.'</p>';

	if ($_LOCAL['history']) {
		expand_text(array(
			'Text' => nl2br($_LOCAL['history']),
			'Label' => strtolower($MetaHeadline),
			'Open' => ($_SESSION['UserBot'] ? 1:0),
			'TextClass' => 'MaT10px',
		));
	}
	echo '</div>';
}

require_once(AL_PATH.'selections/i_declare.php');
echo '<div id="SelectionInfoBlock" class="MaB10px DisNO">';
help_information(
	array(
		'Id' => '',
		'Title' => $Feeds[10]['Label'],
		'Text' => $Feeds[10]['Resume'],
		'Class' => '',
		'Icon' => $Feeds[10]['Icon'],
	)
);
echo '</div>';

// ---- Filters

if ($_SESSION['UserId']>0) require_once(AL_PATH.'/image/browse/filters/i_filter_main.php');

// ---- Display thumbnails

/*
debug(CRLF.CRLF.CRLF.CRLF.CRLF.CRLF.$ArtworkSQL);
debug(var_export($_GET,1));
debug(var_export($Filter,1));
if ($_SESSION['Admin']) mail(SITE_EMAIL,'SQL Selection new',$ArtworkSQL);
*/

// $ThumbSize=(intval($_SESSION['UserConfiguration']['USER_FIELD_THUMBSIZE_GALLERY'])>0 ? $_SESSION['UserConfiguration']['USER_FIELD_THUMBSIZE_GALLERY']:207);

$Thumb=array(
	'RowCount' => 6,
	'Categories' => ($_LOCAL['State']==1 ? $_LOCAL['TbCategories']:1),
	'Promotion' => 1,
);

require_once(PATH_BROWSE_CORE);

// ---- Visitor register message

// if ($_SESSION['UserId']==0)	require_once(AL_PATH.'image/visitors/index.php');

// ---- Footer

require_once(AL_PATH.'/include/i_page_footer.php');
?>