DB Error: syntax error
DB_Error Object
(
    [error_message_prefix] => 
    [mode] => 1
    [level] => 1024
    [code] => -2
    [message] => DB Error: syntax error
    [userinfo] => 
										SELECT 
											variants.id AS var_id, 
											variants.pic_1, 
											variants.product_id, 
											variants.refno
								FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id)
							  WHERE products.id =  AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0  AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1')  AND products.number_of_layers = '0'
							  ORDER BY variants.pos
								   [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked'' at line 7]
    [backtrace] => Array
        (
            [0] => Array
                (
                    [file] => /var/www/toproset.dk/pear/DB.php
                    [line] => 748
                    [function] => PEAR_Error
                    [class] => PEAR_Error
                    [object] => DB_Error Object
 *RECURSION*
                    [type] => ->
                    [args] => Array
                        (
                            [0] => DB Error: syntax error
                            [1] => -2
                            [2] => 1
                            [3] => 1024
                            [4] => 
										SELECT 
											variants.id AS var_id, 
											variants.pic_1, 
											variants.product_id, 
											variants.refno
								FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id)
							  WHERE products.id =  AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0  AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1')  AND products.number_of_layers = '0'
							  ORDER BY variants.pos
								   [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked'' at line 7]
                        )

                )

            [1] => Array
                (
                    [file] => /var/www/toproset.dk/pear/PEAR.php
                    [line] => 541
                    [function] => DB_Error
                    [class] => DB_Error
                    [object] => DB_Error Object
 *RECURSION*
                    [type] => ->
                    [args] => Array
                        (
                            [0] => -2
                            [1] => 1
                            [2] => 1024
                            [3] => 
										SELECT 
											variants.id AS var_id, 
											variants.pic_1, 
											variants.product_id, 
											variants.refno
								FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id)
							  WHERE products.id =  AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0  AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1')  AND products.number_of_layers = '0'
							  ORDER BY variants.pos
								   [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked'' at line 7]
                        )

                )

            [2] => Array
                (
                    [file] => /var/www/toproset.dk/pear/DB/common.php
                    [line] => 500
                    [function] => raiseError
                    [class] => PEAR
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #13
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                )

                            [prepare_types] => Array
                                (
                                )

                            [num_rows] => Array
                                (
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => toproset2011
                            [features] => Array
                                (
                                    [prepare] => 
                                    [pconnect] => 1
                                    [transactions] => 1
                                    [limit] => alter
                                )

                            [errorcode_map] => Array
                                (
                                    [1004] => -15
                                    [1005] => -15
                                    [1006] => -15
                                    [1007] => -5
                                    [1008] => -17
                                    [1022] => -5
                                    [1046] => -14
                                    [1048] => -3
                                    [1050] => -5
                                    [1051] => -18
                                    [1054] => -19
                                    [1062] => -5
                                    [1064] => -2
                                    [1100] => -21
                                    [1136] => -22
                                    [1146] => -18
                                    [1216] => -3
                                    [1217] => -3
                                )

                            [prepared_queries] => 
                            [prepare_maxstmt] => 0
                            [last_query] => 
										SELECT 
											variants.id AS var_id, 
											variants.pic_1, 
											variants.product_id, 
											variants.refno
								FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id)
							  WHERE products.id =  AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0  AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1')  AND products.number_of_layers = '0'
							  ORDER BY variants.pos
								  
                            [fetchmode_object_class] => stdClass
                            [options] => Array
                                (
                                    [persistent] => 
                                    [ssl] => 
                                    [debug] => 0
                                    [seqname_format] => %s_seq
                                    [autofree] => 
                                    [portability] => 0
                                    [optimize] => performance
                                )

                            [dbh] => 
                            [_debug] => 
                            [_default_error_mode] => 
                            [_default_error_options] => 
                            [_default_error_handler] => 
                            [_error_class] => DB_Error
                            [_expected_errors] => Array
                                (
                                )

                            [dsn] => Array
                                (
                                    [phptype] => mysql
                                    [dbsyntax] => mysql
                                    [username] => toproset
                                    [password] => Top2011Roset
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => toproset2011
                                )

                        )

                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
                            [1] => -2
                            [2] => 
                            [3] => 
                            [4] => 
										SELECT 
											variants.id AS var_id, 
											variants.pic_1, 
											variants.product_id, 
											variants.refno
								FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id)
							  WHERE products.id =  AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0  AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1')  AND products.number_of_layers = '0'
							  ORDER BY variants.pos
								   [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked'' at line 7]
                            [5] => DB_Error
                            [6] => 1
                        )

                )

            [3] => Array
                (
                    [file] => /var/www/toproset.dk/pear/DB/mysql.php
                    [line] => 776
                    [function] => raiseError
                    [class] => DB_common
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #13
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                )

                            [prepare_types] => Array
                                (
                                )

                            [num_rows] => Array
                                (
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => toproset2011
                            [features] => Array
                                (
                                    [prepare] => 
                                    [pconnect] => 1
                                    [transactions] => 1
                                    [limit] => alter
                                )

                            [errorcode_map] => Array
                                (
                                    [1004] => -15
                                    [1005] => -15
                                    [1006] => -15
                                    [1007] => -5
                                    [1008] => -17
                                    [1022] => -5
                                    [1046] => -14
                                    [1048] => -3
                                    [1050] => -5
                                    [1051] => -18
                                    [1054] => -19
                                    [1062] => -5
                                    [1064] => -2
                                    [1100] => -21
                                    [1136] => -22
                                    [1146] => -18
                                    [1216] => -3
                                    [1217] => -3
                                )

                            [prepared_queries] => 
                            [prepare_maxstmt] => 0
                            [last_query] => 
										SELECT 
											variants.id AS var_id, 
											variants.pic_1, 
											variants.product_id, 
											variants.refno
								FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id)
							  WHERE products.id =  AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0  AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1')  AND products.number_of_layers = '0'
							  ORDER BY variants.pos
								  
                            [fetchmode_object_class] => stdClass
                            [options] => Array
                                (
                                    [persistent] => 
                                    [ssl] => 
                                    [debug] => 0
                                    [seqname_format] => %s_seq
                                    [autofree] => 
                                    [portability] => 0
                                    [optimize] => performance
                                )

                            [dbh] => 
                            [_debug] => 
                            [_default_error_mode] => 
                            [_default_error_options] => 
                            [_default_error_handler] => 
                            [_error_class] => DB_Error
                            [_expected_errors] => Array
                                (
                                )

                            [dsn] => Array
                                (
                                    [phptype] => mysql
                                    [dbsyntax] => mysql
                                    [username] => toproset
                                    [password] => Top2011Roset
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => toproset2011
                                )

                        )

                    [type] => ->
                    [args] => Array
                        (
                            [0] => -2
                            [1] => 
                            [2] => 
                            [3] => 
                            [4] => 1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked'' at line 7
                        )

                )

            [4] => Array
                (
                    [file] => /var/www/toproset.dk/pear/DB/mysql.php
                    [line] => 228
                    [function] => mysqlRaiseError
                    [class] => DB_mysql
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #13
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                )

                            [prepare_types] => Array
                                (
                                )

                            [num_rows] => Array
                                (
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => toproset2011
                            [features] => Array
                                (
                                    [prepare] => 
                                    [pconnect] => 1
                                    [transactions] => 1
                                    [limit] => alter
                                )

                            [errorcode_map] => Array
                                (
                                    [1004] => -15
                                    [1005] => -15
                                    [1006] => -15
                                    [1007] => -5
                                    [1008] => -17
                                    [1022] => -5
                                    [1046] => -14
                                    [1048] => -3
                                    [1050] => -5
                                    [1051] => -18
                                    [1054] => -19
                                    [1062] => -5
                                    [1064] => -2
                                    [1100] => -21
                                    [1136] => -22
                                    [1146] => -18
                                    [1216] => -3
                                    [1217] => -3
                                )

                            [prepared_queries] => 
                            [prepare_maxstmt] => 0
                            [last_query] => 
										SELECT 
											variants.id AS var_id, 
											variants.pic_1, 
											variants.product_id, 
											variants.refno
								FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id)
							  WHERE products.id =  AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0  AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1')  AND products.number_of_layers = '0'
							  ORDER BY variants.pos
								  
                            [fetchmode_object_class] => stdClass
                            [options] => Array
                                (
                                    [persistent] => 
                                    [ssl] => 
                                    [debug] => 0
                                    [seqname_format] => %s_seq
                                    [autofree] => 
                                    [portability] => 0
                                    [optimize] => performance
                                )

                            [dbh] => 
                            [_debug] => 
                            [_default_error_mode] => 
                            [_default_error_options] => 
                            [_default_error_handler] => 
                            [_error_class] => DB_Error
                            [_expected_errors] => Array
                                (
                                )

                            [dsn] => Array
                                (
                                    [phptype] => mysql
                                    [dbsyntax] => mysql
                                    [username] => toproset
                                    [password] => Top2011Roset
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => toproset2011
                                )

                        )

                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [5] => Array
                (
                    [file] => /var/www/toproset.dk/pear/DB/common.php
                    [line] => 1146
                    [function] => simpleQuery
                    [class] => DB_mysql
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #13
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                )

                            [prepare_types] => Array
                                (
                                )

                            [num_rows] => Array
                                (
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => toproset2011
                            [features] => Array
                                (
                                    [prepare] => 
                                    [pconnect] => 1
                                    [transactions] => 1
                                    [limit] => alter
                                )

                            [errorcode_map] => Array
                                (
                                    [1004] => -15
                                    [1005] => -15
                                    [1006] => -15
                                    [1007] => -5
                                    [1008] => -17
                                    [1022] => -5
                                    [1046] => -14
                                    [1048] => -3
                                    [1050] => -5
                                    [1051] => -18
                                    [1054] => -19
                                    [1062] => -5
                                    [1064] => -2
                                    [1100] => -21
                                    [1136] => -22
                                    [1146] => -18
                                    [1216] => -3
                                    [1217] => -3
                                )

                            [prepared_queries] => 
                            [prepare_maxstmt] => 0
                            [last_query] => 
										SELECT 
											variants.id AS var_id, 
											variants.pic_1, 
											variants.product_id, 
											variants.refno
								FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id)
							  WHERE products.id =  AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0  AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1')  AND products.number_of_layers = '0'
							  ORDER BY variants.pos
								  
                            [fetchmode_object_class] => stdClass
                            [options] => Array
                                (
                                    [persistent] => 
                                    [ssl] => 
                                    [debug] => 0
                                    [seqname_format] => %s_seq
                                    [autofree] => 
                                    [portability] => 0
                                    [optimize] => performance
                                )

                            [dbh] => 
                            [_debug] => 
                            [_default_error_mode] => 
                            [_default_error_options] => 
                            [_default_error_handler] => 
                            [_error_class] => DB_Error
                            [_expected_errors] => Array
                                (
                                )

                            [dsn] => Array
                                (
                                    [phptype] => mysql
                                    [dbsyntax] => mysql
                                    [username] => toproset
                                    [password] => Top2011Roset
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => toproset2011
                                )

                        )

                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
										SELECT 
											variants.id AS var_id, 
											variants.pic_1, 
											variants.product_id, 
											variants.refno
								FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id)
							  WHERE products.id =  AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0  AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1')  AND products.number_of_layers = '0'
							  ORDER BY variants.pos
								  
                        )

                )

            [6] => Array
                (
                    [file] => /var/www/toproset.dk/pear/DB/common.php
                    [line] => 1596
                    [function] => query
                    [class] => DB_common
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #13
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                )

                            [prepare_types] => Array
                                (
                                )

                            [num_rows] => Array
                                (
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => toproset2011
                            [features] => Array
                                (
                                    [prepare] => 
                                    [pconnect] => 1
                                    [transactions] => 1
                                    [limit] => alter
                                )

                            [errorcode_map] => Array
                                (
                                    [1004] => -15
                                    [1005] => -15
                                    [1006] => -15
                                    [1007] => -5
                                    [1008] => -17
                                    [1022] => -5
                                    [1046] => -14
                                    [1048] => -3
                                    [1050] => -5
                                    [1051] => -18
                                    [1054] => -19
                                    [1062] => -5
                                    [1064] => -2
                                    [1100] => -21
                                    [1136] => -22
                                    [1146] => -18
                                    [1216] => -3
                                    [1217] => -3
                                )

                            [prepared_queries] => 
                            [prepare_maxstmt] => 0
                            [last_query] => 
										SELECT 
											variants.id AS var_id, 
											variants.pic_1, 
											variants.product_id, 
											variants.refno
								FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id)
							  WHERE products.id =  AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0  AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1')  AND products.number_of_layers = '0'
							  ORDER BY variants.pos
								  
                            [fetchmode_object_class] => stdClass
                            [options] => Array
                                (
                                    [persistent] => 
                                    [ssl] => 
                                    [debug] => 0
                                    [seqname_format] => %s_seq
                                    [autofree] => 
                                    [portability] => 0
                                    [optimize] => performance
                                )

                            [dbh] => 
                            [_debug] => 
                            [_default_error_mode] => 
                            [_default_error_options] => 
                            [_default_error_handler] => 
                            [_error_class] => DB_Error
                            [_expected_errors] => Array
                                (
                                )

                            [dsn] => Array
                                (
                                    [phptype] => mysql
                                    [dbsyntax] => mysql
                                    [username] => toproset
                                    [password] => Top2011Roset
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => toproset2011
                                )

                        )

                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
										SELECT 
											variants.id AS var_id, 
											variants.pic_1, 
											variants.product_id, 
											variants.refno
								FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id)
							  WHERE products.id =  AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0  AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1')  AND products.number_of_layers = '0'
							  ORDER BY variants.pos
								  
                        )

                )

            [7] => Array
                (
                    [file] => /var/www/toproset.dk/productSingle.php
                    [line] => 149
                    [function] => getAll
                    [class] => DB_common
                    [object] => DB_mysql Object
                        (
                            [connection] => Resource id #13
                            [phptype] => mysql
                            [dbsyntax] => mysql
                            [prepare_tokens] => Array
                                (
                                )

                            [prepare_types] => Array
                                (
                                )

                            [num_rows] => Array
                                (
                                )

                            [transaction_opcount] => 0
                            [autocommit] => 1
                            [fetchmode] => 2
                            [_db] => toproset2011
                            [features] => Array
                                (
                                    [prepare] => 
                                    [pconnect] => 1
                                    [transactions] => 1
                                    [limit] => alter
                                )

                            [errorcode_map] => Array
                                (
                                    [1004] => -15
                                    [1005] => -15
                                    [1006] => -15
                                    [1007] => -5
                                    [1008] => -17
                                    [1022] => -5
                                    [1046] => -14
                                    [1048] => -3
                                    [1050] => -5
                                    [1051] => -18
                                    [1054] => -19
                                    [1062] => -5
                                    [1064] => -2
                                    [1100] => -21
                                    [1136] => -22
                                    [1146] => -18
                                    [1216] => -3
                                    [1217] => -3
                                )

                            [prepared_queries] => 
                            [prepare_maxstmt] => 0
                            [last_query] => 
										SELECT 
											variants.id AS var_id, 
											variants.pic_1, 
											variants.product_id, 
											variants.refno
								FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id)
							  WHERE products.id =  AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0  AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1')  AND products.number_of_layers = '0'
							  ORDER BY variants.pos
								  
                            [fetchmode_object_class] => stdClass
                            [options] => Array
                                (
                                    [persistent] => 
                                    [ssl] => 
                                    [debug] => 0
                                    [seqname_format] => %s_seq
                                    [autofree] => 
                                    [portability] => 0
                                    [optimize] => performance
                                )

                            [dbh] => 
                            [_debug] => 
                            [_default_error_mode] => 
                            [_default_error_options] => 
                            [_default_error_handler] => 
                            [_error_class] => DB_Error
                            [_expected_errors] => Array
                                (
                                )

                            [dsn] => Array
                                (
                                    [phptype] => mysql
                                    [dbsyntax] => mysql
                                    [username] => toproset
                                    [password] => Top2011Roset
                                    [protocol] => tcp
                                    [hostspec] => localhost
                                    [port] => 
                                    [socket] => 
                                    [database] => toproset2011
                                )

                        )

                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
										SELECT 
											variants.id AS var_id, 
											variants.pic_1, 
											variants.product_id, 
											variants.refno
								FROM toproset_products AS products RIGHT JOIN toproset_variants AS variants on (variants.product_id = products.id) RIGHT JOIN toproset_variant_to_category AS varcattbl ON (variants.id = varcattbl.variant_id)
							  WHERE products.id =  AND products.edate = 0 AND products.active = '1' AND variants.active = 'checked' AND varcattbl.category_id = 9 AND variants.edate = 0  AND products.id IN (SELECT product_id FROM toproset_product_to_category WHERE category_id = '1')  AND products.number_of_layers = '0'
							  ORDER BY variants.pos
								  
                        )

                )

        )

    [callback] => 
)