How i difference between:
<?php
$path = MODX_CORE_PATH . 'components/pepish2/';
$result = $modx->addPackage('pepish2',$path . 'model/','pp_');
$query = $modx->newQuery('Galerie');
$query->select($modx->getSelectColumns('Galerie', 'galerie', '', array('galerie_id', 'name_cz', 'kde', 'kde')));
$query->where(array(
'galerie_id:>=' => 10,
'display:!=' => 2,
'kde:IN' => array('Mostecko','Chomutovsko%','ZOO Plzeň'),
));
$query->sortby('kdy','DESC');
$query->limit(16);
$vysledek = $modx->getCollection('Galerie',$query);
$query->prepare();
echo 'SQL QUERY: '.$query->toSql().'<hr>';
echo 'Results: '.count($vysledek ).'<hr>';
$query2 = $modx->newQuery('Galerie');
//$query2->select($modx->getSelectColumns('Galerie', 'galerie', '', array('galerie_id', 'name_cz', 'kde', 'kde')));
$query2->where(array(
'galerie_id:>=' => 10,
'display:!=' => 2,
'kde:IN' => array('Mostecko','Chomutovsko%','ZOO Plzeň'),
));
$query2->sortby('kdy','DESC');
$query2->limit(16);
$vysledek2 = $modx->getCollection('Galerie',$query2);
$query2->prepare();
echo 'SQL QUERY: '.$query2->toSql().'<hr>';
echo 'Results: '.count($vysledek2 ).'<hr>';
first result is:
SQL QUERY:
SELECT `pp_galerie`.`galerie_id`, `pp_galerie`.`name_cz`, `pp_galerie`.`kde` FROM `pp_galerie` AS `Galerie` WHERE ( `Galerie`.`galerie_id` >= 10 AND `Galerie`.`display` != 2 AND `Galerie`.`kde` IN ('Mostecko','Chomutovsko%','ZOO Plzeň') ) ORDER BY kdy DESC LIMIT 16
Results: 0
and second:
SQL QUERY:
SELECT `Galerie`.`galerie_id` AS `Galerie_galerie_id`, `Galerie`.`title` AS `Galerie_title`, `Galerie`.`name_cz` AS `Galerie_name_cz`, `Galerie`.`name_lat` AS `Galerie_name_lat`, `Galerie`.`kategorie` AS `Galerie_kategorie`, `Galerie`.`kde` AS `Galerie_kde`, `Galerie`.`kdy` AS `Galerie_kdy`, `Galerie`.`upload_date_time` AS `Galerie_upload_date_time`, `Galerie`.`copyright` AS `Galerie_copyright`, `Galerie`.`permission` AS `Galerie_permission`, `Galerie`.`display` AS `Galerie_display`, `Galerie`.`short_text` AS `Galerie_short_text`, `Galerie`.`picture_name` AS `Galerie_picture_name`, `Galerie`.`thumbs_name` AS `Galerie_thumbs_name`, `Galerie`.`path_large` AS `Galerie_path_large`, `Galerie`.`path_thumbs` AS `Galerie_path_thumbs` FROM `pp_galerie` AS `Galerie` WHERE ( `Galerie`.`galerie_id` >= 10 AND `Galerie`.`display` != 2 AND `Galerie`.`kde` IN ('Mostecko','Chomutovsko%','ZOO Plzeň') ) ORDER BY kdy DESC LIMIT 16
Results: 16
pepish2.mysql.schema.xml
<?xml version="1.0" encoding="UTF-8"?>
<model package="pepish2" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" version="1.1">
<object class="Category" table="category" extends="xPDOObject">
<field key="category_id" dbtype="smallint" precision="4" phptype="integer" null="false" index="pk" generated="native" />
<field key="name" dbtype="varchar" precision="64" phptype="string" null="false" />
<field key="name_alt" dbtype="varchar" precision="128" phptype="string" null="false" />
<field key="parent_id" dbtype="smallint" precision="4" phptype="integer" null="true" />
<field key="view" dbtype="smallint" precision="2" phptype="integer" null="false" default="1" />
<index alias="PRIMARY" name="PRIMARY" primary="true" unique="true" type="BTREE" >
<column key="category_id" length="" collation="A" null="false" />
</index>
</object>
<object class="Galerie" table="galerie" extends="xPDOObject">
<field key="galerie_id" dbtype="int" precision="10" phptype="integer" null="false" index="pk" generated="native" />
<field key="title" dbtype="varchar" precision="48" phptype="string" null="false" />
<field key="name_cz" dbtype="varchar" precision="64" phptype="string" null="false" />
<field key="name_lat" dbtype="varchar" precision="64" phptype="string" null="false" />
<field key="kategorie" dbtype="smallint" precision="4" phptype="integer" null="false" />
<field key="kde" dbtype="varchar" precision="64" phptype="string" null="false" />
<field key="kdy" dbtype="date" phptype="date" null="true" />
<field key="upload_date_time" dbtype="timestamp" phptype="timestamp" null="false" default="CURRENT_TIMESTAMP" />
<field key="copyright" dbtype="varchar" precision="32" phptype="string" null="false" />
<field key="permission" dbtype="smallint" precision="2" phptype="integer" null="false" />
<field key="display" dbtype="smallint" precision="2" phptype="integer" null="false" />
<field key="short_text" dbtype="mediumtext" phptype="string" null="true" />
<field key="picture_name" dbtype="varchar" precision="48" phptype="string" null="true" />
<field key="thumbs_name" dbtype="varchar" precision="48" phptype="string" null="true" />
<field key="path_large" dbtype="varchar" precision="64" phptype="string" null="true" />
<field key="path_thumbs" dbtype="varchar" precision="64" phptype="string" null="true" />
<index alias="PRIMARY" name="PRIMARY" primary="true" unique="true" type="BTREE" >
<column key="galerie_id" length="" collation="A" null="false" />
</index>
</object>
</model>
Any idea ??
