Codice PHP:
            function getCarrelli($idCostruttore=0$idTipologia=0$idAlimentazione=0)
                {
                    global 
$db
                    global 
$dividi;
                    
                    
$sql="    SELECT     idCarrello,
                                    costruttore,
                                    modello,
                                    alimentazione,
                                    tipologia,
                                    portata,
                                    baricentro,
                                    montante,
                                    altezza_montante_chiuso,
                                    anno_costruzione,
                                    altezza_sollevamento,
                                    alzata_libera,
                                    ingombro_minimo,
                                    lunghezza_forche,
                                    peso_vuoto,
                                    ore_lavoro,
                                    batteria,
                                    tensione_batteria,
                                    capacita_batteria,
                                    caricabatteria,
                                    caricabatteria_voltaggio,
                                    gommatura,
                                    matricola,
                                    testo as note,
                                    immagine
                            FROM carrelli
                            LEFT JOIN archivi_costruttori
                            USING(idCostruttore)
                            LEFT JOIN archivi_alimentazioni
                            USING(idAlimentazione)
                            LEFT JOIN archivi_tipologie
                            USING(idTipologia)
                            LEFT JOIN archivi_montanti
                            USING(idMontante)
                            LEFT JOIN archivi_gommature
                            USING(idGommatura)
                            LEFT JOIN testi
                            USING(idTesto)
                            LEFT JOIN immagini
                            USING(idImmagine)"
.$this->createQuery($idCostruttore$idTipologia$idAlimentazione);
                    
                    
$sql.="ORDER BY costruttore, modello";
rigainciriminata->        $xLimit $dividi->dividiPag($sql, isset($_GET['p']) ? (int)$_GET['p'] : 15);
                    
$sql.=" LIMIT ".$xLimit[0].",".$xLimit[1];
                            
                    return 
$db->get_results($sql);
                }